Answered step by step
Verified Expert Solution
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
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started