D E F Overhead and Staff Costs AN Weekend Extra: 0.45 Annual $34,800.00 Weekend Rate Temporary Staff Temp Chef Wait Staff General Help Cleaning Staff Standard Rate 60.24 59.49 31.66 21.27 Annual 2 3 4 5 Indirect Costs Monthly 6 Rent $2,900.00 7 Wages for permanent staff $4,500.00 8 Insurance $230.00 9 Advertising $115.00 10 Kitchen Equipment $115.00 11 Total 12 13 Services and Utilities Monthly 14 Electriricty and Gas $155.00 15 Internet and Phone $60.00 16 POS Fees $35.00 17 Total 18 19 Supplies Monthly 20 Cleaning Equipment 21 General Kitchen Supplies 22 Stationery and Office Suppies 23 Total 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 Annual $900.00 $2,300.00 $475.00 10 1 B2 1 1 1 n 1 Section B The following are to be completed in the Cost Overview sheet: B1 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. B3 In C14 calculate the annual cost of Electricity and Gas. Copy the formula down to C16. B4 In B17 calculate the total cost for Services and Utilities. Copy the formula across to c17. B5 Supplied costs have been estimated for the year. In B20 calculate the monthly costs for cleaning equipment. Copy the formula down to B22. B6 In B23 calculate the total monthly cost for Supplies. Copy the formula across to C23. B7 In B25 calculate the total month costs. Copy the formula across to B26. B8 Widen column G so it is a similar width to the other columns. B9 Apply the Percentage number format to the value in G5. If necessary adjust to show no decimal places. B10 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. 1 1 DODO 1 1 1