Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Please answer the following questions by looking at the Weekly Operating Report attached:

  1. Exclusive of payroll cost taxes and payroll cost benefits, what is the average hourly wage paid to hourly workers?
  2. Exclusive of payroll cost taxes and payroll cost benefits, what is the average hourly wage paid to salaried employees?
  3. 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?
  4. What is the benefit cost line 14?
  5. 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.7image text in transcribed
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

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

Financial Management Theory And Practice

Authors: Eugene F Brigham, Michael C Ehrhardt

11th Edition

0324259689, 9780324259681

More Books

Students also viewed these Finance questions

Question

Understand the reasons for engaging consultants

Answered: 1 week ago