Question: Part One: Using Excel You have been asked to summarize the ICU's budget for the next upcoming four months (Month1, Month2, Month3 & Month4) using
Part One: Using Excel You have been asked to summarize the ICU's budget for the next upcoming four months (Month1, Month2, Month3 & Month4) using Excel. You have the following information: Nursing Salaries: The salaries remained constant for the first two months, but increased by 4 percent for each consecutive month. Also, you have been asked to calculate the minimum, maximum, and average salary for each month. Nursing Staff Base Salary per month Butler $6,000.00 Cox $5,500.00 Frances $6,250.00 Lopez $7,500.00 Okafor $5,000.00 Zinsou $7,000.00 Pharmacy: The cost of pharmacy was $24,500 for the first month. It increased by 3.5 percent for each consecutive month. Housekeeping: The cost of housekeeping was $2880 per month. The cost remained constant across the four-month period. Medical Supplies: The cost for medical supplies was $210,000 for the first month. The cost increased by 7 percent for the second; 7.5 percent for the third; and remained constant for the four month. Office Supplies: The cost of office supplies for the first and second month was $35,000, but increase 8 percent for the third month and fourth month. Utilities: The cost for utilities remained constant for the first three months at $32,000, but then, increased 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
