In I49 (selected in the first photo) calculate the labour cost for that labour type and quantity using the values in the Cost Overview sheet (second photo). (Ensure you apply weekend rates for Saturdays and Sundays. Your calculations must take this into account even if your data does not contain weekend dates as the dates could change.)

 

Transcribed Image Text:

149 448535833335SRFRAKKER285333353 46 47 49 51 16/8/20 50 17/8/20 56 57 59 60 61 62 63 64 66 68 70 71 73 67 SUMMARY 74 75 65 TOTAL OVERHEADS 69 TOTAL COST 76 77 78 79 80 AB 81 С 86 LABOUR COSTS Date 87 89 18/8/20 18/8/20 19/8/20 19/8/20 20/8/20 TOTAL LABOUR x ✓ fx D Temp Staff Temp Chef Temp Chef Temp Chef PRODUCTION OVERHEADS General Help Temp Chef Wait Staff General Help Cost Overview E Staff Number 1 2 2 2 2 3 2 Details/Description Prepare Ingredients Preparation and Cooking Cooking Set-up at venue Cooking and Plating Table Service Pack up and clean-up Client Database Menu JOB_4155 G Hours 5 B 8 4 6 6 4 H Day Sunday Monday Tuesday Tuesday Wednesday Wednesday Thursday Journals Days Quoted Price (before GST) $ Gross Profit Margin (%) + Cost Cost 12,050.00 149 448535833335SRFRAKKER285333353 46 47 49 51 16/8/20 50 17/8/20 56 57 59 60 61 62 63 64 66 68 70 71 73 67 SUMMARY 74 75 65 TOTAL OVERHEADS 69 TOTAL COST 76 77 78 79 80 AB 81 С 86 LABOUR COSTS Date 87 89 18/8/20 18/8/20 19/8/20 19/8/20 20/8/20 TOTAL LABOUR x ✓ fx D Temp Staff Temp Chef Temp Chef Temp Chef PRODUCTION OVERHEADS General Help Temp Chef Wait Staff General Help Cost Overview E Staff Number 1 2 2 2 2 3 2 Details/Description Prepare Ingredients Preparation and Cooking Cooking Set-up at venue Cooking and Plating Table Service Pack up and clean-up Client Database Menu JOB_4155 G Hours 5 B 8 4 6 6 4 H Day Sunday Monday Tuesday Tuesday Wednesday Wednesday Thursday Journals Days Quoted Price (before GST) $ Gross Profit Margin (%) + Cost Cost 12,050.00

Answer rating: 100% (QA)

Calculation of weekly cost for Temporary Labor Staff Temporary Staff To Prepare Ingradients For Pr... View the full answer