Instructions:

Using the template provided, develop a budget for a "company".The information you provide will be specific to your major (in my case anything Information Technology related).

158 X V A B C D E Budget Project 1 Section 1-Employee Costs W other support 4 Employee Costs Nurse Supervisor Nurses Dietician staff 5 Number 24 1 Hourly rate 55.00 45.00 20.00 10.00 Hours per week 40 40 40 30 3 Weeks per year 52 52 57 57 9 Total wages 343,200 2,246,400 41,600 62,400 10 11 Section 2-Other Costs 12 13 Other Departmental Costs 14 Food Services 2,000,000 15 Housekeeping 10,000 16 Laundry 10,000 17 Recreation 20,000 18 Total other departmental costs 2,040,000 19 Other Expenses 20 General and administrative 80,000 21 Fixed operating expenses (taxes, depr, etc) 100,000 22 Variable operating expenses (water, electric, supplies, etc 200,000 23 Total other expenses 380,000 24 Total Expenses 2,420,000 25 26 Section 3-Revenue 27 28 Suite Breakdown Studio One-bedroom 29 Number of Suites 70 30 30 31 Yearly Pricing: 32 Studio 45,000 33 One Bedroom 65,000 34 35 Section 4-Budgeted Income Statement 36 37 Assisting Living Facility 38 Budgeted Income Statement 39 For the Year Ended 40 41 Revenue: 42 Resident Revenue 5,100,000.00 43 Other Therapy Revenue 70,000.00 44 Total Revenue 5,170,000. 45 Wages expense: 46 Employee wages 2,693,600.00 47 Departmental expenses: 48 Food Services 2,000,000.00 49 Housekeeping 10,000.00 50 Laundry 10,000.00 51 Recreation 20,000.00 52 Total Departmental Expenses 2,040,000.00 53 Other Expenses: 54 General and Admin 80,000.00 55 Fixed Operating 100,000.00 56 Variable Operating 200,000.00 57 Therapy 30,000.00 58 Total Other Expenses 410,000.00 59 Total Expenses 5,143,600.00 60 Net Profit 26,400.00File Home Insert Page Layout Formulas Data Review View Help Calibri w 14 ab General Conditional Formatting B I U - AA $ ~ % " Format as Table ~ Paste A Cell Styles ~ Clipboard Font Alignment Number Styles i PRODUCT DEACTIVATED To keep using Excel without interruption, please reactivate now. Reactivate Al X V Budget Project A B C D E Budget Project note this is onlya template and you can add more rows and W N -+ Section 1-Employee Costs columns as needed Employee Costs Number Hourly rate Hours per week Weeks per year Total wages 10 11 Section 2-Other Costs 12 13 Other Departmental Costs 14 15 16 17 18 Total other departmental costs 19 Other Expenses 20 21 22 23 Total other expenses 24 Total Expenses 25 26 Section 3-Revenue 27 28 Revenue Breakdown 29 30 31 Yearly Pricing: 32 33 34 35 Section 4-Budgeted Income Statement 36 37 38 Budgeted Income Statement 39 For the Year Ended 40 41 Revenue: 42 43 44 Total Revenue 45 Wages expense: 46 47 Departmental expenses: 48 49 50 51 52 Total Departmental Expenses 53 Other Expenses: 54 55 56 57 58 Total Other Expenses 59 Total Expenses 60 Net Profit