nent Due Sunday by 11:59pm Points 25 Submitting a file upload Available until Aug 30 at 11:59pm 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. Next Previous 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 29-1, a three-year retail pharmacy profitability analysis, is the primary document. It is supported by Exhibit 29-2, the retail pharmacy proposal assumptions. The profitability analysis is further supported by Exhibit 29-3, 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) (5303,400) $49.789 Departmental expense (3 months) Total Working Capital Required 5-49,789 Wewe updated our The controller also noticed on Exhibit 29-4 that the cost of renovations to the building is estimated at Aa prt se delete home > 11 + The controller also noticed on Exhibit 29 4 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. 05 Exhibit 29-1 Sample General Hospital 3-Year Retail Pharmacy Profitability Analysis Year 1 Year 2 Year 3 Rox 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 $03.24 539,668 603,243 676,799 GM% 20.99 22.4% 23.99 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 We've updated our reac Give it a try it 14.400 17,280 1.280 20,736 Aa w 02 liji bet se delete nome 8 20 + 961727/d6/1084/16/6/2/200:29.8 ... 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 We've updated our read al Give it a try her Aa 50 x w + fo Ins prt sc delete home end & + 101204061/27/ch/G/1081/4/16/6/2/260:71.7 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, Exhibit 29-2 Sample General Hospital Retail Pharmacy Proposal Assumptions Prescriptions 1. Annual Prescription Estimates-Rate of Growth/Capture Per Day Annual We've updated out Give it by Aa 50 07 lyje 59781284061727/cf/6/1081/4/18@0:50.0 . Exhibit 29-2 Sample General Hospital Retail Pharmacy Proposal Assumptions Prescriptions 1. Per Day Annual Annual Prescription Estimates Rate of Growth/Capture Year 1 225 55,350 Year 2 2.0% 230 56,457 Year 3 3.0% 236 58,151 2 Average Net Revenue per Prescription-Yearly Increases Year 1 $ 46.75 Year 2 2.096 $ 47.69 Year 3 2.0% $ 48.64 3. Bad Debt Percentage 1.0% Average Cost per Prescription-Yearly Increases Year 1 $ 37.00 We ve updated our Give it a Vrona 70 ** Aa 02 ligo prt sc delete home 1284061727/6/6/1081/4/20/6/2/200:38.5 Year 1 $ 37.00 Year 2 3.0% $38.11 Year 3 3.0% $39.25 5. Inflation Rates Per 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 We've updated ou Give iti 5 w lyje Budget Assumptions For This E x Search Textbook Solutions Ch /cfi/6/1081/4/20/6/2260:74,1 Memorial Hermann-Remote x Centricity Time and Attendax + Total 179,789 Year 2 Year 3 Gross Margin 603,243 676,799 Net Income before Taxes 287,676 Year 2 Beginning Cash Balance 73.597 Net Cash Activity 73,597 303.010 360.884 Ending Cash Balance 73.597 376.60 737,490 Courtesy of Resource Group, Ltd, Dallas, Texas we've updated out to A Aa nent Due Sunday by 11:59pm Points 25 Submitting a file upload Available until Aug 30 at 11:59pm 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. Next Previous 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 29-1, a three-year retail pharmacy profitability analysis, is the primary document. It is supported by Exhibit 29-2, the retail pharmacy proposal assumptions. The profitability analysis is further supported by Exhibit 29-3, 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) (5303,400) $49.789 Departmental expense (3 months) Total Working Capital Required 5-49,789 Wewe updated our The controller also noticed on Exhibit 29-4 that the cost of renovations to the building is estimated at Aa prt se delete home > 11 + The controller also noticed on Exhibit 29 4 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. 05 Exhibit 29-1 Sample General Hospital 3-Year Retail Pharmacy Profitability Analysis Year 1 Year 2 Year 3 Rox 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 $03.24 539,668 603,243 676,799 GM% 20.99 22.4% 23.99 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 We've updated our reac Give it a try it 14.400 17,280 1.280 20,736 Aa w 02 liji bet se delete nome 8 20 + 961727/d6/1084/16/6/2/200:29.8 ... 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 We've updated our read al Give it a try her Aa 50 x w + fo Ins prt sc delete home end & + 101204061/27/ch/G/1081/4/16/6/2/260:71.7 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, Exhibit 29-2 Sample General Hospital Retail Pharmacy Proposal Assumptions Prescriptions 1. Annual Prescription Estimates-Rate of Growth/Capture Per Day Annual We've updated out Give it by Aa 50 07 lyje 59781284061727/cf/6/1081/4/18@0:50.0 . Exhibit 29-2 Sample General Hospital Retail Pharmacy Proposal Assumptions Prescriptions 1. Per Day Annual Annual Prescription Estimates Rate of Growth/Capture Year 1 225 55,350 Year 2 2.0% 230 56,457 Year 3 3.0% 236 58,151 2 Average Net Revenue per Prescription-Yearly Increases Year 1 $ 46.75 Year 2 2.096 $ 47.69 Year 3 2.0% $ 48.64 3. Bad Debt Percentage 1.0% Average Cost per Prescription-Yearly Increases Year 1 $ 37.00 We ve updated our Give it a Vrona 70 ** Aa 02 ligo prt sc delete home 1284061727/6/6/1081/4/20/6/2/200:38.5 Year 1 $ 37.00 Year 2 3.0% $38.11 Year 3 3.0% $39.25 5. Inflation Rates Per 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 We've updated ou Give iti 5 w lyje Budget Assumptions For This E x Search Textbook Solutions Ch /cfi/6/1081/4/20/6/2260:74,1 Memorial Hermann-Remote x Centricity Time and Attendax + Total 179,789 Year 2 Year 3 Gross Margin 603,243 676,799 Net Income before Taxes 287,676 Year 2 Beginning Cash Balance 73.597 Net Cash Activity 73,597 303.010 360.884 Ending Cash Balance 73.597 376.60 737,490 Courtesy of Resource Group, Ltd, Dallas, Texas we've updated out to A Aa