Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This assignment will help you calculate budget variances in Excel. Read the scenario and instructions below. Cost Center: 12312- Nursing Unit 3ICU 3ICU is an
This assignment will help you calculate budget variances in Excel. Read the scenario and instructions below. Cost Center: 12312- Nursing Unit 3ICU 3ICU is an eight-bed ICU. Due to some reorganization of ICUs, 3ICU will add four beds in January of FY16. The new ICU room rate for FY 16 will be $1750 (in FY15 it was $1600). The average occupancy/census of 3ICU is expected to be 82% in FY16 (It was also budgeted for 82% occupancy in FY 15, but ran over budget in occupancy/census). There will still only be one manager and you are not allowed to budget for temporary staff (agency). The manager is allowed to budget monies for magazine subscriptions and travel. You get to decide how much you think you will need for the subscriptions and travel. The unit purchased a FAX machine (they have enough toner for this year) in November 2015 that was not part of their original budget. The toner for the fax machine costs $12.00 per cartridge. Expected fax toner use is at least six toners per year. Add this to your FY 16 budget. Account Level Budgeter Get Well Health System ACCOUNT MODELING WORKsheet Cost Center: 12312 -Nursing 3ICU Budget
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started