| Income | ||||||||||||
| Calculation | Explanatory Notes | Category | Product/Service | Formula | Calculation | Explanatory Notes | ||||||
| $ 3,43,200.00 | Income | Government allocated funds | 4x4x5x52x90 | $ 3,74,400.00 | ||||||||
| $ 1,66,400.00 | Revenue from service pay | 4 x 4 x 5 x 52 x 80 | $ 3,32,800.00 | |||||||||
| $ 1,24,800.00 | Medicine sales | 6 x 5 x 5 x 52 x 45 | $ 3,51,000.00 | |||||||||
| $ 95,160.00 | TOTAL INCOME | Insert total amount here -> | $ 10,58,200.00 | |||||||||
| $ 7,29,560.00 | ||||||||||||
| $ 12,480.00 | Break Even Calculation | |||||||||||
| $ 6,240.00 | TOTAL INCOME | $ 10,58,200.00 | ||||||||||
| $ 6,240.00 | minus TOTAL COSTS PER YEAR | $ 10,58,200.00 | ||||||||||
| $ 7,800.00 | Profit / Loss ($) | 0 | ||||||||||
| $ 32,760.00 | ||||||||||||
| $ 26,520.00 | If the Profit/Loss row is NEGATIVE, your service is LOSING MONEY. Increase your income. | |||||||||||
| $ 10,660.00 | ||||||||||||
| Pediatric Center | ||||||||||||
| Expenses | Income | |||||||||||
| Category | Item/Costs | Formula for getting the original values | ORIGINAL VALUES | Adjusted values as per the -10% | Category | Product/Service | Formula | Calculation | Explanatory Notes | |||
| Staffing | Physicians | 3 x 55 x 8 x 5x 52 | $ 3,43,200.00 | $ 3,08,880.00 | Income | Government allocated funds | 4x4x5x52x90 | $ 3,74,400.00 | ||||
| Nurses | 2x 40 x 8 x 5 x 52 | $ 1,66,400.00 | $ 1,49,760.00 | Revenue from service pay | 4 x 4 x 5 x 52 x 80 | $ 3,32,800.00 | ||||||
| Adminstrative staff | 2 x 30 x 8 x 5 x 52 | $ 1,24,800.00 | $ 1,12,320.00 | Medicine Sales | 6 x 5 x 5 x 52 x 45 | $ 3,51,000.00 | ||||||
| Oncosts | total cost of staff above x 15% | $ 95,160.00 | $ 85,644.00 | TOTAL INCOME | Insert total amount here -> | $ 10,58,200.00 | ||||||
| TOTAL STAFFING | Insert total amount here -> | $ 7,29,560.00 | $ 6,56,604.00 | |||||||||
| Consumables | Baby Scales | 4x 3 x 4 x 5 (per week) x 52 | $ 11,232.00 | $ 10,108.80 | Break Even Calculation | |||||||
| Baby thermometers | 4 x 2 x 3 x 5 x 52 | $ 5,616.00 | $ 5,054.40 | TOTAL INCOME | $ 10,58,200.00 | |||||||
| Blood pressure monitors | 3 x 2 x 4 x 5 x 52 | $ 5,616.00 | $ 5,054.40 | minus TOTAL COSTS PER YEAR | $ 9,48,459.60 | |||||||
| Diaper Scales | 2 x 3 x 5 x 5 x 52 | $ 7,020.00 | $ 6,318.00 | Profit / Loss | 109740.4 | |||||||
| TOTAL CONSUMABLES | Insert total amount here -> | $ 29,484.00 | $ 26,535.60 | |||||||||
| Utilities | Electricity | 500×52 | $ 26,000.00 | $ 23,400.00 | If the Profit/Loss row is NEGATIVE, your service is LOSING MONEY. Increase your income. | |||||||
| Internet | 200×52 | $ 10,400.00 | $ 9,360.00 | |||||||||
| Water | 300×52 | $ 15,600.00 | $ 14,040.00 | |||||||||
| TOTAL UTILITIES | Insert total amount here -> | $ 52,000.00 | $ 46,800.00 | |||||||||
| Administration | Security system | 300x 52 | $ 15,600.00 | $ 14,040.00 | ||||||||
| Insurance | 400 x 52 | $ 20,800.00 | $ 18,720.00 | |||||||||
| Repair and maintenance | 200×52 | $ 10,400.00 | $ 9,360.00 | |||||||||
| Building Rent | 3000 x 52 | $ 1,56,000.00 | $ 1,40,400.00 | |||||||||
| TOTAL Administration | Insert total amount here -> | $ 2,02,800.00 | $ 1,82,520.00 | |||||||||
| Depreciation | Depreciation | 200000x 20% | $ – | |||||||||
| TOTAL DEPRECIATION | Insert total amount here -> | $ 40,000.00 | $ 36,000.00 | |||||||||
| TOTAL COSTS PER YEAR | Total of each of the five section totals | $10,53,844 | $ 9,48,459.60 | |||||||||
| To achieve the 10% profit, one should either reduce the cost of production by 10% while keeping the income constant or increase income by 10% while keeping the cost of production constant following the fact that the initial budget provides the breakeven point. For the case above, I attained the ten percent profit by reducing the cost of production by 10% while keeping the income constant. To make the work easy, I used the F function to place formular 90%*C4 at D4 where by the value in C4 represents the original cost whereas D column represents the adjusted values after the calculations. after inplacing the formular, I tabed the enter-tab to allow the resultant answer to desplay in cell D4. i then pressed-in the mouse at the bottom-right conner of the cell D4 and scrolled down to cell D25 in order to calculate the values of the remaining cells. Under the contigency plan, there is a likelyhood that the desired funding might be below the optimum level. Therefore, in such a case, two solutions are fundamental in order to meed the desired 10% profi. Firstly, the budget can be adjusted such that the income is inrease by a relevant percentage through change in the unit price of the services offered in the health center. Secondly, the bought items can be used as a security for loans to cater for the absent capital. |
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
