Question: This is a worksheet for Budget Assignment, Part 1: Proposed Budget Assumptions. Please complete all columns using the instructions in the exercise as necessary. Submit
This is a worksheet for Budget Assignment, Part 1: Proposed Budget Assumptions. Please complete all columns using the instructions in the exercise as necessary. Submit your completed worksheet to the applicable assignment submission folder. This worksheet is available as a Word document but you may submit it using a spreadsheet if you wish. Follow the formatting below if you do choose to use a spreadsheet.
Chart for Sample General Hospital Retail Pharmacy Proposal Assumptions
Prescriptions
1. Annual Prescription EstimatesRate of Growth/Capture
|
| YR | % Chg | Per Day | Per Year |
| Year | 1 | --- | 225 | 55350 |
| Year | 2 | 2.00% | 230 | 56457 |
| Year | 3 | 3.00% | 236 | 58151 |
| Year | 4 | 3.50% | ? | ? |
2. Average Net Revenue per PrescriptionYearly Increases
|
| YR | % Chg | Per RX |
| Year | 1 | --- | $ 46.75 |
| Year | 2 | 2.00% | $ 47.69 |
| Year | 3 | 2.00% | $ 48.64 |
| Year | 4 | 3.00% | ? |
3. Bad Debt Percentage
Year 1-3: 1.00%
Year 4: 1.75%
4. Average Cost per PrescriptionYearly Increases
|
| YR | % Chg | Per RX |
| Year | 1 | --- | $ 37.00 |
| Year | 2 | 3.00% | $ 38.11 |
| Year | 3 | 3.00% | $ 39.25 |
| Year | 4 | 3.25% | ? |
5. Inflation RatesPer Years 1 to 3
| ITEM | Rates for Yrs 1-3 | Rates for Year 4 |
| Salary and Wages | 3.0% | 2.25% |
| Other Than Prescriptions | 2.0% | 2.50% |
| Benefits as a % of Salaries | 20.0% | 22.0% |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts