Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment (B): Assumptions Refer to the proposal to add a retail pharmacy mini-case study in Chapter 29 (pgs. 425 430). Identify how many of the

Assignment (B): Assumptions Refer to the proposal to add a retail pharmacy mini-case study in Chapter 29 (pgs. 425 430). Identify how many of the assumption items listed in the example for this week can be found in the retail pharmacy proposal worksheets. Upload your list for grading.

CHAPTER 29 Mini-Case Study 1: Proposal to Add a Retail Pharmacy to a Hospital in the Metropolis Health System

Sample General Hospital belongs to the Metropolis Health System. The new chief financial officer (CFO) at Sample Hospital has been attempting to find new sources of badly needed revenue for the facility. Consequently, the CFO is preparing a proposal to add a retail pharmacy within the hospital itself. If the proposal is accepted, this would generate a new revenue stream. The CFO has prepared four exhibits, all of which appear at the end of this case study. Exhibit 291, a three-year retail pharmacy profitability analysis, is the primary document. It is supported by Exhibit 292, the retail pharmacy proposal assumptions. The profitability analysis is further supported by Exhibit 293, a year 1 monthly income statement detail. Finally, Exhibit 294 presents the supporting year 1 monthly cash flow detail and assumptions.

When the controller reviewed the exhibits, she asked how the working capital of $49,789 was derived. The CFO explained that it represents 3 months of departmental expense. He also explained that the cost of drugs purchased for the first 60 days was offset by these purchases accounts payable cycle, so the net effect was 0. In essence, the vendors were financing the drug purchases. Thus, the working capital reconciled as follows:

Working Capital:

Cost of drugs (2 months)

$303,400

Vendor financing (accounts payable)

($303,400)

Departmental expense (3 months)

$49,789

Total Working Capital Required

$49,789

The controller also noticed on Exhibit 294 that the cost of renovations to the building is estimated at $80,000 and equipment purchases are estimated at $50,000 for a total capital expenditure of $130,000. The building renovations are depreciated on a straight-line basis over a useful life of 15 years, whereas the equipment purchases are depreciated on a straight-line basis over a useful life of 5 years. The required capital is proposed to be obtained from hospital sources, and no borrowing would be necessary. In addition, the total capital expenditure is projected to be retrieved through operating cash flows before the end of year 1.

Exhibit 291 Sample General Hospital 3-Year Retail Pharmacy Profitability Analysis

Year 1

Year 2

Year 3

Rx Sales

2,587,613

2,692,152

2,828,375

Cost of Goods Sold

2,047,950

2,088,909

2,151,576

Gross Margin

539,663

603,243

676,799

GM %

20.9%

22.4%

23.9%

EXPENSES

Salaries and Wages

192,000

197,760

203,693

Benefits

38,400

39,552

40,739

Materials and Supplies

12,000

14,400

17,280

Contract Services and Fees

14,400

17,280

20,736

Depreciation and Amortization

15,333

15,333

15,333

Interest

Provision for Bad Debts

25,876

26,922

28,284

Misc. Exp.

3,600

4,320

5,184

Total Expense

301,609

315,567

331,248

Net Income

238,053

287,676

345,550

Operating Margin

9.2%

10.7%

12.2%

Cash Flow

Year 1

Year 2

Year 3

Sources

Net Income

238,053

287,676

345,550

Depreciation

15,333

15,333

15,333

Borrowing

Total Sources

253,386

303,010

360,884

Uses

Capital Purchasing

130,000

Working Capital

49,789

Total Uses

179,789

Cash at Beginning of Period

73,597

376,607

Net Cash Activities

73,597

303,010

360,884

Cash at Ending of Period

73,597

376,607

737,490

Volume

Year 1

Year 2

Year 3

Number of Prescriptions Sold

55,350

56,457

58,151

Courtesy of Resource Group, Ltd., Dallas, Texas.

Exhibit 292 Sample General Hospital Retail Pharmacy Proposal Assumptions

Prescriptions

1.

Annual Prescription EstimatesRate of Growth/Capture

Per Day

Annual

Year 1

225

55,350

Year 2

2.0%

230

56,457

Year 3

3.0%

236

58,151

2.

Average Net Revenue per PrescriptionYearly Increases

Year 1

$ 46.75

Year 2

2.0%

$ 47.69

Year 3

2.0%

$ 48.64

3.

Bad Debt Percentage

1.0%

4.

Average Cost per PrescriptionYearly Increases

Year 1

$ 37.00

Year 2

3.0%

$ 38.11

Year 3

3.0%

$ 39.25

5.

Inflation RatesPer Year

Salary and Wages

3.0%

Other Than Prescriptions

2.0%

Benefits as a % of Salaries

20.0%

6.

Initial Capital Requirements

Building

80,000

Equipment

50,000

Working Capital

49,789

Total

179,789

Year 1

Year 2

Year 3

Gross Margin

539,663

603,243

676,799

Net Income before Taxes

238,053

287,676

345,550

Year 1

Year 2

Year 3

Beginning Cash Balance

73,597

376,607

Net Cash Activity

73,597

303,010

360,884

Ending Cash Balance

73,597

376,607

737,490

Courtesy of Resource Group, Ltd., Dallas, Texas.

image text in transcribed

Exhibit 293 Sample General Hospital Retail Pharmacy Proposal Year 1 Monthly Income Statement Detail

image text in transcribed

Exhibit 294 Sample General Hospital Retail Pharmacy Proposal Year 1 Monthly Cash Flow Detail and Assumptions

So how was the proposal received by the hospitals board of trustees? They first asked for a small market study to test the amount of prescription sales projected within the proposal. When the market study results came back positive, the board approved the project, and renovations are about to commence.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management And Cost Accounting

Authors: Charles T. Horngren, George Foster, Srikant M. Datar

3rd Edition

0273687514, 978-0273687511

More Books

Students also viewed these Accounting questions