MESTIVI B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 The following are to be...

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

2 3456 5 Indirect Costs 6 Rent 7 Wages for permanent staff 8 Insurance 9 Advertising 10 ... View the full answer