Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MESTIVI B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 The following are to be completed in the Cost Overview sheet: This sheet

 D EF Overhead and Staff Costs AN Weekend Extra: 0.45 Annual $34,800.00 Weekend Rate Temporary Staff Temp Chef Wait Staff Gen

MESTIVI B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 The following are to be completed in the Cost Overview sheet: This sheet contains cost information. B6 contains the cost for the monthly rent. In C6 enter a calculation that will use the value in B6 to calculate the annual rent. Copy the formula down to C10. In B11 calculate the total monthly Indirect Costs. Copy the formula across to C11. In C14 calculate the annual cost of Electricity and Gas. Copy the formula down to C16. In B17 calculate the total cost for Services and Utilities. Copy the formula across to C17. Supplied costs have been estimated for the year. In B20 calculate the monthly costs for cleaning equipment. Copy the formula down to B22. In B23 calculate the total monthly cost for Supplies. Copy the formula across to C23. In B25 calculate the total month costs. Copy the formula across to B26. Widen column G so it is a similar width to the other columns. Apply the Percentage number format to the value in G5. If necessary adjust to show no decimal places. Staff earn an extra percentage for working on weekends. Use the rate in G5 to calculate the weekend rate for a Temp Chef. Your calculation must use appropriate referencing so that the formula can be copied down. If the rate in G5 changes, the weekend salaries must update accordingly. 10 1 1 1 1 1 1 1 1 1 1 U U U UUU U U 2 GAWN 3 Overhead and Staff Costs 5 Indirect Costs 6 Rent 7 Wages for permanent staff 8 Insurance 9 Advertising 10 Kitchen Equipment 11 Total 12 13 Services and Utilities 14 Electriricty and Gas 15 Internet and Phone 16 POS Fees 17 Total 18 19 Supplies 20 Cleaning Equipment 21 General Kitchen Supplies 22 Stationery and Office Suppies 23 Total Monthly $2,900.00 $4,500.00 $230.00 $115.00 $115.00 Monthly $155.00 $60.00 $35.00 Monthly 24 25 TOTAL OVERHEADS 26 27 Days worked in a year (estimate): 240 28 Overheads on a job are calculated as a percetage of these days 29 C Annual $34,800.00 Annual Annual $900.00 $2,300.00 $475.00 D E Temporary Staff Temp Chef Wait Staff General Help Cleaning Staff F Weekend Extra: Standard Rate 60.24 59.49 31.66 21.27 (2 0.45 Weekend Rate

Step by Step Solution

3.43 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

2 3456 5 Indirect Costs 6 Rent 7 Wages for permanent staff 8 Insurance 9 Advertising 10 ... 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

Operations And Supply Chain Management

Authors: F. Robert Jacobs, Richard Chase

14th Edition

978-0077824921, 78024021, 9780077823344, 007782492X, 77823346, 978-0078024023

More Books

Students also viewed these Mathematics questions

Question

What is meant by the term decision analysis?

Answered: 1 week ago

Question

Explain all drawbacks of the application procedure.

Answered: 1 week ago

Question

Determine Leading or Lagging Power Factor in Python.

Answered: 1 week ago

Question

Which of the following scenarios illustrates an order winner?

Answered: 1 week ago