![budget workbook healthcare budget workbook healthcare](https://exceltemplates.net/wp-content/uploads/2013/02/Monthly-Budget-Planning-Spreadsheet-Excel-Template-624x397.jpg)
Average Cost per Prescription-Yearly IncreasesĮvaluate and discuss the results of your calculation as to what created the variances in revenue,Įxpenses, and excess of revenue over expenses. Average Net Revenue per Prescription-Yearly IncreasesĤ. Annual Prescription Estimates-Rate of Growth/CaptureĢ. Follow the formatting below ifĬhart for Sample General Hospital Retail Pharmacy Proposal Assumptionsġ. This worksheet is available as a Wordĭocument but you may submit it using a spreadsheet if you wish. Worksheet to the applicable assignment submission folder. PleaseĬomplete all columns using the instructions in the exercise as necessary. This is a worksheet for Budget Assignment, Part 1: Proposed Budget Assumptions. When the market study results came back positive, the boardĪpproved the project, and renovations are about to commence.īudget Assignment, Part 1: Proposed Budget Assumptions So how was the proposal received by the hospital’s board of trustees? They first asked for a small market study to test theĪmount of prescription sales projected within the proposal. In addition, the total capital expenditure is projected to be retrieved through operating The required capital is proposed to be obtained from hospital sources, and Straight-line basis over a useful life of 5 years. The building renovations areĭepreciated on a straight-line basis over a useful life of 15 years, whereas the equipment purchases are depreciated on a The controller also noticed on Exhibit 33-C–4 that the cost of renovations to the building is estimated at $80,000 andĮquipment purchases are estimated at $50,000 for a total –capital expenditure of $130,000. Thus, the working capital reconciled as follows: In essence, the vendors wereįinancing the drug purchases. He also explained that the cost of drugs purchased for the first 60ĭays was offset by these purchases’ accounts payable cycle, so the net effect was 0. That it represents 3 months of departmental expense. When the controller reviewed the exhibits, she asked how the working capital of $49,789 was derived. Hospital 3-Year Retail Pharmacy Profitability AnalysisĬourtesy of Resource Group, Ltd., Dallas, Texas.Įxhibit 33–C–2 Sample General Hospital Retail Pharmacy Proposal AssumptionsĮxhibit 33–C–3 Sample General Hospital Retail Pharmacy Proposal Year 1 Monthly Income Statement DetailĮxhibit 33–C–4 Sample General Hospital Retail Pharmacy Proposal Year 1 Monthly Cash Flow Detail and Finally, Exhibit 33-C–4 presents the supporting year 1 monthly cash flow detail and assumptions.Įxhibit 33–C–1 Sample General Hospital 3-Year Retail Pharmacy Profitability Analysis Exhibit 33–C–1 Sample General The profitability analysis is further supported by Exhibit 33-C–3, a year 1 monthly It is supported by Exhibit 33-C–2, the retail Exhibit 33-C–ġ, a three-year retail pharmacy profitability analysis, is the primary document. The CFO has prepared four exhibits, all of which appear at the end of this case study. If the proposal is accepted, this would generate a Preparing a proposal to add a retail pharmacy within the hospital itself. Hospital has been attempting to find new sources of badly needed revenue for the facility. The new chief financial officer (CFO) at Sample Sample General Hospital belongs to the Metropolis Health System.
![budget workbook healthcare budget workbook healthcare](https://i.ytimg.com/vi/Xwq1KmmHN9o/maxresdefault.jpg)
Appendix 33-C: Proposal to Add a Retail Pharmacy to a Hospital in the Metropolis Health System