Business plan and Excel workbook

I have 2 separate projects. Business plan must be at least 7 pages and I will attach the file that include all the info. also I will attach files for excel workbook requirements and supply list. and also there is a sample of Davinci OP Data
davinci_op_data_example___dist__2_.xlsx

hcmn415_excel_financial_workbook_v2__3_.docx

Don't use plagiarized sources. Get Your Custom Essay on
Business plan and Excel workbook
Just from $13/Page
Order Essay

hcmn415_exec_summ_reqs__2_.docx

hcmn415_supply_list__1_.xls

Unformatted Attachment Preview

Henson Research Hospital
DaVinci Operating Data
Fiscal Year Ending June 2017
Category
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
Jan-17
Feb-17
Mar-17
Apr-17
May-17
Jun-17
Total
DaVinci SS Cases
DaVinci DS Cases
DaVinci Surgical Cases
DaVinci Inpt Days Per Case
140
56
196
4.5
140
56
196
4.5
175
70
245
4.5
140
56
196
4.5
140
56
196
4.5
175
70
245
4.5
140
56
196
4.5
140
56
196
4.5
175
70
245
4.5
140
56
196
4.5
140
56
196
4.5
175
70
245
4.5
1,820
728
2,548
Total DaVinci Inpatient Days
882
882
1102.5
882
882
1102.5
882
882
1102.5
882
882
1102.5
11,466
Background Data
Single Surgeries (SS) Per Day
SS Days Per Week
SS Per Week
7
5
35
4-Wk
140
175
Dual Surgeries (DS) Per Day
DS Days Per Week
DS Per Week
14
1
14
56
70
Total Surgeries Per Week
49
Four-Week Month:
196
Five-Week Month:
245
5-Wk
HCMN415 (SP18) Excel Workbook Requirements
The daVinci Surgical System was purchased by your hospital. The financial analysis workbook
includes standard operating and financial data, as well as daVinci specific information. The data
listed below is to be used for the various calculations throughout the financial analysis
workbook, and referenced in the business plan portion of the project. There will be several
additional calculations that you must perform, to complete the workbook.
Name Your Workbook â?? begin with your last name, followed by the name of your
hospital/healthcare organization. (Henson â?? Henson Research Hospital).
Financial Analysis Workbook â?? MUST contain the following worksheets/tabs (names can be
abbreviated as needed):
1. Statement of Operations (Income Statement)
2. Balance Sheet
3. Statement of Cash Flows
4. Consolidated Operating Data
5. Consolidated Salary and Wage Calculations
6. Consolidated Revenue Calculations
7. Consolidated Expense Calculation
8. daVinci Operating Data
9. daVinci Salary and Wage Calculations
10. daVinci Revenue Calculations
11. daVinci Expense Calculations
12. daVinci Break-Even Analysis
13. Supply List (for VLOOKUP and Pivot Table)
14. Ratios Calculations
15. Performance Measurement Dashboard (Graphs and Visual Elements)
16. Financial Forecasts (Pro-Forma) (Combined Statements)
17. Notes (Not graded; Use as needed)
The financial statements and other worksheets must have the correct heading, containing the
following three elements:
– Organization Name (Henson Research Hospital)
– Title of Financial Statement (Statement of Operations)
– Time Period (ending) Represented (Fiscal Year Ending June 2017)
Statement of Operations (also called Income Statement): this is a summary statement for the
entire 12-month period (as opposed to monthly on the calculations worksheets). The data comes
from the revenue and expenses worksheets, as well as data provided below. For purposes of this
project, the data will be summarized quarterly using excel formulas (required).
Balance Sheet: this financial statement details the hospitals assets and liabilities. Use the
following data for this financial statementâ?¦see formatting examples in the textbook.
– Assets (resources owned): $8,000,000
– Liabilities (debts): $3,500,000
Statement of Cash Flows â?? this financial statement details the cash transactions of the hospitals
(inflows and outflows). Use the following data for this financial statement… see formatting
examples in the textbook.
– New equipment purchase: $2,000,000
– Salvage receipts (old equipment): $1,500,000
– Cash from patients: $100,000
– Interest: $10,000
– Taxes Paid: $0.00
– Fund raising/charity donations and receipts: $390,000
Consolidated Operating Data â?? includes the daVinci operating data (inpatient days) from the
appropriate worksheet. (Must be linked in using an excel formula). Expenses except daVinci
Operating data must fluctuate as follows:

July: start
Aug to Oct: decrease by 5% monthly
Nov to Jan: increase by 10% monthly
Feb to Apr: decrease by 7% monthly
May to Jun: increase by 15% monthly
Consolidated Salary and Wage â?? medical (non DaVinci) salary given for month one.
Remaining months of medical salaries must fluctuate with the percentage change of consolidated
operating data. DaVinci salaries must be linked in from the operating data worksheet.
– Med surg July salary: $1,750,000.
– Fringe Benefits: 33% of salaries
– Must contain medical (non â?? daVinci Labor), daVinci labor, and fringe.
Consolidated Revenue Calculations â?? Revenue is given for month one. Remaining months
must fluctuate with the percentage change of consolidated operating data. DaVinci revenue must
be linked in.
– July med-surg (non daVinci) revenue: $7,722,000
Consolidated Expense Calculations â?? med-surg expenses given for month one. Remaining
months must fluctuate with the percentage change of consolidated operating data. DaVinci
supplies must be linked in from daVinci data worksheet.
– Med surg July (non-salary) expenses:
Maintenance: $250,000
Utilities: $30,000
Transportation: $75,000
Non daVinci Supplies: from supplies worksheet
daVinci Operating Data â?? calculate the number of cases as done previously in class. That
number should link into the consolidated operating data worksheet. This data should be shown
monthly.
daVinci Revenue â?? revenue is $8,500 per case.
daVinci Expense â?? this worksheet should contain supply costs per case as well as the labor
calculations per case. This data must be shown monthly.
– Supply costs per daVinci case: $2,500
– Annual maintenance costs: $170,000
daVinci Break-Even Analysis â?? this must include all costs associated with the implementation
of the surgical system. Initial costs, all expenses, all revenues, etc. How many cases must be
performed to break-even?
HCMN415 Course Project: Business Plan and Financial Analysis Workbook
Course Project Outline â?? The course project MUST be in APA 6th edition format and contain
the following sections, with headings/sub-headings:
1.
2.
3.
4.
5.
6.
7.
8.
Cover Page
Table of Contents
Executive Summary
Marketing Plan
Organizational Plan
Financial Analysis Summary (based on your workbook)
Performance Measurement and Management Plan
References/Citations
Executive Summary â?? write this section of your business plan last. The executive summary
gives a high-level overview of your entire project, start to finish.
Marketing Plan â?? The marketing plan discusses the details of the daVinci system and how it
was implemented. For this section, concentrate on the 4Pâ??s of Marketing:
(1) Product: product details, life cycle information, etc.,
(2) Price: how much did the product cost to purchase, service agreements, etc.,
(3) Promotion: advertising strategies, public relations, etc., and
(4) Place: how will this help market share/placement, service to the community, etc.
Organizational Plan â?? What/who within the organization was affected by the implementation of
the daVinci Surgical Robot? Who was responsible for what?
(1) What departments will do what?
(2) What are the departmentsâ?? capabilities and capacities?
(3) Existing staff and workload?
(4) Hiring of more permanent staff?
(5) Contracting and temporary labor?
(6) Training?
(7) Compliance?
Financial Analysis Summary â?? The financial analysis section is a sound discussion of your
excel financial workbook. For this section, discuss the overall financial picture of the hospital
both before and after the implementation of the daVinci system. Key items to include in the
summary are (not limited to; add others as needed):
(1) Occupancy rate
(2) Average length of stay
(3) Operating margin: (total revenue â?? total expenses)/total revenue
(4) Average collection period, average daily sales
(5) Changes (Increases and decreases) in volume
(6) Changes (Increases and decreases) in revenue and expense
(7) Overall impact of the daVinci system
Performance Measurement and Management â?? In this section, you monitor the system
implementation and make some decisions on how you plan to proceed in the future. Things to
consider may include:
(1) Routine reports and/or benchmarking.
(2) Corrective actions/activities to keep things on task.
(3) Did the strategies that you implemented work? Yes or no, why or why not?
(4) Do have the resources to continue or try different alternatives?
(5) What would make things better in the future? How could things be changed to make
things run more smoothly?
(6) What recommendations or changes would you make for: human resources, capabilities,
capacity, leadership, patient focus, etc.?
References/Citations â?? as needed. MUST be in the appropriate APA format.
Additional Comments: My general comments, guidance, suggestionsâ?¦
At some point in your Healthcare Management career, you will be asked to step into a decisionmaking role. That decision may not involve a large scale equipment/process implementation
such as the daVinci surgical system, but it will surely impact you and other departments around
you. The goal of this project is to make you think strategically about all aspects of the decision
making process, and what elements are used in supporting that decision.
This project is worth 30% of your HCMN415 course grade (15% for the business plan and 15%
for the Excel financial analysis workbook). Please take this seriouslyâ?¦give this your best
effort!!!
The required format is APA 6th. Formatting is important, as well as the usual grammar,
punctuation and overall writing ability necessary for todayâ??s professional environment. Dot your
â??Iâ??sâ??, cross your â??Tâ??sâ?? and spell things correctlyâ?¦make it flow. The easiest way to catch things is
by using the â??spelling and grammar checkâ?? function on the review tab. It also helps to take a
break and look at things later with â??fresh eyesâ??.
Creativity is the name of the game here. The key question is â??what would you do?â?? if you had to
make these decisions. Google it, find scholarly articles, use your textbook, etc. to draft your
professional management position for this project. Have fun with itâ?¦ embrace the
numbersâ?¦looooove the numbersâ?º.
Dr. H.
mc sup billing
Vlookup!!!
1
2
3
4
5
6
7
Category
Syringe/Needle
Syringe/Needle
Syringe/Needle
Syringe/Needle
Syringe/Needle
Miscellaneous
Syringe/Needle
Infusion Supply
8
Diabetic Supply
9
Diabetic Supply
10
Diabetic Supply
11
Diabetic Supply
12
Infusion Supply
13
Infusion Supply
14
Urological Supply
15
Urological Supply
16
Urological Supply
17
Urological Supply
18
Urological Supply
19
Urological Supply
20
Urological Supply
21
Description
Syringe with needle, sterile, 1 ml or less,
Syringe with needle, sterile 2 ml
Syringe with needle, sterile 3 ml
Syringe with needle, sterile 5 ml or greater
Non-coring needle
Syringe, bulb type (infant nasal aspiraters, ear
and ulcer bulb syringes)
Needle, sterile, any size, each
Intravenous administration set (with or without
infusion pump), hypodermoclysis
administration set, connecting device, heparin
lock caps
Infusion set for external insulin pump, non
needle cannula type
Infusion set for external insulin pump, needle
type
Syringe with needle for external insulin pump,
sterile, 3cc
Normal, low and high calibrator solution /
chips
Disposable drug delivery system, flow rate of
50 ml or greater per hour
Disposable drug delivery system, flow rate of
less than 50 ml per hour
Insertion tray without drainage bag and
without catheter (accessories only)
Insertion tray without drainage bag with
indwelling catheter, foley type, two-way latex
with coating (teflon, silicone, silicone
elastomer or hydrophilic, etc.)
Insertion tray without drainage bag with
indwelling catheter, foley type, two-way, all
silicone
Insertion tray without drainage bag with
indwelling catheter, foley type, three-way, for
continuous irrigation
Insertion tray with drainage bag with
indwelling catheter, foley type, two-way latex
with coating (teflon, silicone, silicone
elastomer or hydrophilic, etc.)
Insertion tray with drainage bag with
indwelling catheter, foley type, two-way, all
silicone
Insertion tray with drainage bag with
indwelling catheter, foley type, three-way, for
continuous irrigation
Quantity
50
50
50
50
50
25
Price Per Unit
Total Price
$
$
$
$
$
$
1.75
1.75
1.75
1.75
1.75
0.99
$
$
$
$
$
$
87.50
87.50
87.50
87.50
87.50
24.75
50
250
$
$
1.75
5.75
$
$
87.50
1,437.50
30
$
20.95
$
628.50
30
$
20.95
$
628.50
30
$
20.95
$
628.50
30
$
20.95
$
628.50
30
$
35.99
$
1,079.70
30
$
35.99
$
1,079.70
200
$
14.99
$
2,998.00
200
$
14.99
$
2,998.00
200
$
14.99
$
2,998.00
200
$
14.99
$
2,998.00
200
$
14.99
$
2,998.00
200
$
14.99
$
2,998.00
200
$
14.99
$
2,998.00
56
76
40
121
92
70
7
73
89
128
Page 1 of 9
mc sup billing
Vlookup!!!
Category
Urological Supply
22
23
Urological Supply
Urological Supply
24
Urological Supply
25
Urological Supply
26
27
Ostomy Supply
Ostomy Supply
Description
Irrigation tray with bulb or piston syringe, any
purpose
Irrigation syringe, bulb or piston, each
Male external catheter with integral collection
chamber, any type, each
Female external urinary collection device;
meatal cup, each
Female external urinary collection device;
pouch, each
Ostomy faceplate, each
Skin barrier; solid 4″ x 4″ or equivalent, each
Quantity
200
Price Per Unit
Total Price
$
14.99
$
2,998.00
200
200
$
$
14.99
14.99
$
$
2,998.00
2,998.00
200
$
14.99
$
2,998.00
200
$
14.99
$
2,998.00
150
150
$
$
1.50
1.75
$
$
225.00
262.50
Ostomy clamp, any type, replacement only,
each
Adhesive, liquid or equal, any type
Ostomy vent, any type, each
Ostomy belt, each
Ostomy filter, any type, each
Ostomy skin barrier, liquid (spray/brush etc)
150
$
4.99
$
748.50
20
150
150
150
150
$
$
$
$
$
3.99
1.75
1.75
1.75
1.75
$
$
$
$
$
79.80
262.50
262.50
262.50
262.50
Ostomy skin barrier, powder
Ostomy pouch, drainable with faceplate
attached, plastic, each
Ostomy pouch, drainable with faceplate
attached, rubber, each
Tracheostoma filter, any type, any size, each
150
150
$
$
1.75
1.75
$
$
262.50
262.50
150
$
1.75
$
262.50
100
$
17.99
$
1,799.00
Moisture exchanger, disposable, for use
w/invasive mechanical ventilation
Tracheal suction catheter, closed system,
each
Tracheostomy, inner cannula
Tracheal suction catheter, any type other than
closed system, each
Tracheostomy care kit for new tracheostomy
100
$
17.99
$
1,799.00
100
$
17.99
$
1,799.00
100
100
$
$
17.99
17.99
$
$
1,799.00
1,799.00
100
$
17.99
$
1,799.00
Tracheostomy cleaning brush, each
Oropharyngeal suction catheter, each
Wound pouch, each
Alginate or other fiber gelling dressing, wound
cover, sterile, pad size 16 sq. in. or less, each
dressing
500
500
100
100
$
$
$
$
17.99
17.99
1.00
2.99
$
$
$
$
8,995.00
8,995.00
100.00
299.00
28
Ostomy Supply
29
30
31
32
33
34
35
Ostomy Supply
Ostomy Supply
Ostomy Supply
Ostomy Supply
Ostomy Supply
Ostomy Supply
Ostomy Supply
36
Ostomy Supply
37
Tracheostomy Supply
38
Tracheostomy Supply
39
Tracheostomy Supply
40
41
Tracheostomy Supply
Tracheostomy Supply
42
Tracheostomy Supply
43
44
45
46
47
Tracheostomy Supply
Tracheostomy Supply
Wound Care Supply
Wound Care Supply
Page 2 of 9
mc sup billing
Vlookup!!!
Category
Wound Care Supply
48
Wound Care Supply
49
Wound Care Supply
50
Wound Care Supply
51
Wound Care Supply
52
Wound Care Supply
53
Wound Care Supply
Description
Alginate or other fiber gelling dressing, wound
cover, sterile, pad size more than 16 sq. in.
but less than or equal to 48 sq. in., each
dressing
Alginate or other fiber gelling dressing, wound
filler, sterile
Composite dressing, sterile, pad size 16 sq.
in. or less, with any size adhesive border,
each dressing
Composite dressing, sterile, pad size more
than 16 sq. in. but less than or equal to 48 sq.
in., with any size adhesive border, each
dressing
Composite dressing, sterile, pad size more
than 48 sq. in., with any size adhesive border,
each dressing
Contact layer, sterile, 16 sq. in. or less, each
dressing
Contact layer, sterile, more than 16 sq. in. but
less than or equal to 48 sq. in., each dressing
Quantity
100
Price Per Unit
Total Price
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
Contact layer, sterile, more than 48 sq. in.,
each dressing
Foam dressing, wound cover, sterile, pad size
16 sq. in. or less, without adhesive border,
each dressing
Foam dressing, wound cover, sterile, pad size
more than 16 sq. in. but less than or equal to
48 sq. in., without adhesive border, each
dressing
Foam dressing, wound cover, sterile, pad size
more than 48 sq. in., without adhesive border,
each dressing
Foam dressing, wound cover, sterile, pad size
16 sq. in. or less, with any size adhesive
border, each dressing
Foam dressing, wound cover, sterile, pad size
more than 16 sq. in. but less than or equal to
48 sq. in., with any size adhesive border, each
dressing
Foam dressing, wound cover, sterile, pad size
more than 48 sq. in., with any size adhesive
border, each dressing
Foam dressing, wound filler, sterile, per gram
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
54
Wound Care Supply
55
Wound Care Supply
56
Wound Care Supply
57
Wound Care Supply
58
Wound Care Supply
59
Wound Care Supply
60
Wound Care Supply
61
Wound Care Supply
62
Page 3 of 9
mc sup billing
Vlookup!!!
Category
Wound Care Supply
63
Wound Care Supply
64
Wound Care Supply
65
Wound Care Supply
66
Wound Care Supply
67
Wound Care Supply
68
Wound Care Supply
69
Wound Care Supply
70
Wound Care Supply
71
Wound Care Supply
72
Wound Care Supply
73
Wound Care Supply
74
Wound Care Supply
75
Description
Gauze, non-impregnated, non-sterile, pad size
16 sq. in. or less, without adhesive border,
each dressing
Gauze, non-impregnated, non-sterile, pad size
more than 16 sq. in. but less than or equal to
48 sq. in., without adhesive border, each
dressing
Gauze, non-impregnated, non-sterile, pad size
more than 48 sq. in., without adhesive border,
each dressing
Gauze, non-impregnated, sterile, pad size 16
sq. in. or less, with any size adhesive border,
each dressing
Gauze, non-impregnated, sterile, pad size
more than 16 sq. in. but less than or equal to
48 sq. in., with any size adhesive border, each
dressing
Gauze, non-impregnated, sterile, pad size
more than 48 sq. in., with any size adhesive
border, each dressing
Gauze, impregnated with other than water,
normal saline, or hydrogel, sterile, pad size 16
sq. in. or less, without adhesive border, each
dressing
Gauze, impregnated with other than water,
normal saline, or hydrogel, sterile, pad size
more than 16 sq. in., but less than or equal to
48 sq. in., without adhesive border, each
dressing
Gauze, impregnated with other than water,
normal saline, or hydrogel, sterile, pad size
more than 48 sq. in., without adhesive border,
each dressing
Gauze, impregnated, water or normal saline,
sterile, pad size 16 sq. in. or less, without
adhesive border, each dressing
Gauze, impregnated, water or normal saline,
sterile, pad size more than 16 sq. in. but less
than or equal to 48 sq. in., without adhesive
border, each dressing
Gauze, impregnated, water or normal saline,
sterile, pad size more than 48 sq. in., without
adhesive border, each dressing
Gauze, impregnated, hydrogel, for direct
wound contact, sterile, pad size 16 sq. in. or
less, each dressing
Quantity
100
Price Per Unit
Total Price
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
100
$
2.99
$
299.00
Page 4 of 9
mc sup billing
Vlookup!!!
Category
Wound Care Suppl …
Purchase answer to see full
attachment

GradeAcers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

Order your essay today and save 15% with the discount code DISCOUNT15