Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Managerial Accounting

Authors: Mowen, Hansen, Heitger

3rd Edition

324660138, 978-0324660135

More Books

Students also viewed these Accounting questions