Reference no: EM132490552

"You are the administrator of the medical - surgical department at Health. Review the transcripts from the budget meeting and recent voicemails from your CFO and, using the available information and resources, develop an operating budget for your department.

use excel sheets Excel spreadsheet

Question 1: Provides the revenue and expenses through the current month of the current year.

Question 2: Estimates the revenue and expenses for the rest of the current fiscal year based on the assumptions provided in the transcript documents.

Question 3: Prepares a budget for the next fiscal year.

Monthly Fixed Costs

Utilities                                                     $590
Health/Wellness Staff                                $2,500
Arts/Crafts Staff                                       $2,000
Supplies                                                    $800
Fitness Equipment Maintenance Contract         $200

Variable Costs

Monthly Lunch Cost                                                   $25
Monthly Breakfast Cost                                               $15
Add the total fixed costs =                                        $6,090

1. Average charge per client = Monthly Membership Fee = $125
2. Average variable cost per client = Monthly Breakfast and Lunch Costs = $40