Please answer the following questions by looking at the Weekly Operating Report attached:
- Exclusive of payroll cost taxes and payroll cost benefits, what is the average hourly wage paid to hourly workers?
- Exclusive of payroll cost taxes and payroll cost benefits, what is the average hourly wage paid to salaried employees?
- If a 40 hour workweek is considered a FTE for both salaried and hourly employees, how many FTEs were needed for the department to function?
- What is the benefit cost line 14?
- If a 6% increase in cafeteria sales is projected for the next fiscal year, what would you project cafeteria sales to be for the annual budget? The meal count factor used forconverting all cash sales to meals is $1.7
36?res Week Ending: Cost Meal Budget Cost Actual 1,554 4,429 84 10,066 118 439 $ 3945.74 $12,494.86 $ 00.00 $ 2,343.98 LINE Category 1 Patient Days 2 Patient Meals 3 Non-Patient Meals 4 Free Meals 5 Cafeteria Meals 6 Special Functions 7 Vending Meals 8 Total Non-Patient Meals 9 Total All Meals 10 Payroll - Saloried 31 Payroll - Hourly 12 Payroll Adjustments 13 Payroll Cost - Taxes 14 Payroll Costs - Benefits (30%) 15 Total Payroll Coats 16 Food Costs 17 Meat/Seafood 18 Groceries 19 Fresh Frozen 20 Toe Cream 21 Coffee 22 Milk & Dairy 23 Bread & Bakery 24 Other 25 Total Food Cost 26 Supply Costs 27 Detergents 28 Paper 29 Office 30 Replacoments 31 Other 32 Total Supply Coat 33 Miscellaneous Costs 34 Insurance 35 Depreciation 36 Other 37 Total Misc. Cost 38 Total Operating Costs (Payroll, Food, Supply, Misc.) 39 Less Total Revenue (cafeteria, vending, sto. 40 Net Cost of Operation 41 Net Cost Per Pat. Day Total Hours Worked: Hourly Employees 43 Total Hours Worked: Salaried Employees 44 Total Hrs. Paid 45 Meals Produced Per Productive Labor Hour 46 Ovextince Hours Paid Purchasing Total Mout Groceries Fresh $ 4,747.17 $ 3,308.64 5 2,401.66 $ 906.98 $ 561.03 $87751 $978.21 $ 316.48 $616,20 $ 713.39 $ 138.69 $ 79.35 $ 175.00 $ 550.00 $ 18,383.75 1358 240 1598 27 Tee Coffee Chemicals Paper 36?res Week Ending: Cost Meal Budget Cost Actual 1,554 4,429 84 10,066 118 439 $ 3945.74 $12,494.86 $ 00.00 $ 2,343.98 LINE Category 1 Patient Days 2 Patient Meals 3 Non-Patient Meals 4 Free Meals 5 Cafeteria Meals 6 Special Functions 7 Vending Meals 8 Total Non-Patient Meals 9 Total All Meals 10 Payroll - Saloried 31 Payroll - Hourly 12 Payroll Adjustments 13 Payroll Cost - Taxes 14 Payroll Costs - Benefits (30%) 15 Total Payroll Coats 16 Food Costs 17 Meat/Seafood 18 Groceries 19 Fresh Frozen 20 Toe Cream 21 Coffee 22 Milk & Dairy 23 Bread & Bakery 24 Other 25 Total Food Cost 26 Supply Costs 27 Detergents 28 Paper 29 Office 30 Replacoments 31 Other 32 Total Supply Coat 33 Miscellaneous Costs 34 Insurance 35 Depreciation 36 Other 37 Total Misc. Cost 38 Total Operating Costs (Payroll, Food, Supply, Misc.) 39 Less Total Revenue (cafeteria, vending, sto. 40 Net Cost of Operation 41 Net Cost Per Pat. Day Total Hours Worked: Hourly Employees 43 Total Hours Worked: Salaried Employees 44 Total Hrs. Paid 45 Meals Produced Per Productive Labor Hour 46 Ovextince Hours Paid Purchasing Total Mout Groceries Fresh $ 4,747.17 $ 3,308.64 5 2,401.66 $ 906.98 $ 561.03 $87751 $978.21 $ 316.48 $616,20 $ 713.39 $ 138.69 $ 79.35 $ 175.00 $ 550.00 $ 18,383.75 1358 240 1598 27 Tee Coffee Chemicals Paper