H7 F H Excel Assignment - Trimester 2-2021 The instructions below explain what calculation is required for each cell. 1 2 3 4 5 1 6 2 3 8 9 1 2 Section A - The following questions are to be answered on the Direct Material Sheet Calculate the cost of material per unit of job (Multiply Cost per unit of material to Material needed per unit of Job for each job) Calculate Total Job cost (Multiply number of units to total DM cost per unit of each job in row 18 Calculate the Total Direct Material Cost Section - The following questions are to be answered on the Direct Labour Sheet Calculate Labour cost before Super-column E (Multiply Working hours to Direct labour rate per hour consider absolute referencing Calculate super cost column F(Multiply super rate to labour cost before super). Consider applying absolute referencing-Use "Round function to have no decimal points) Calculate Total Direct Labour cost (Column G) Using "SUMIFS function, calculate each job Direct Labour Cost Column) Cell Kil: calculate Total Direct Labour Cost Using "COUNTIFS" function, calculate each Number of labours involved (Column L) Section The following questions are to be answered on the MOK Sheet 10 11 12 13 3 4 5 5 15 A 11 D H Unit Job Number Number of units Material Code IPVC MET WOD Kilogram Kilograni SYD100 Cost per unit of material $26.86 547.89 $140,16 SYD202 5 6 2 8 9 10 11 12 + Meter SYD206 MEL300 MEL208 36,800 29,440 18.400 55,200 14.720 Cost of material per unit of job MET (Kel WOD (Meter) PVC (K) Total Job cost Total Material needed per unit of Job Job Number PVC WOD MET (K KA (Meter SYD100 78 157 48 SYD202 110 269 96 SYD206 157 134 36 MEL300 125 202 120 MEL20B 179 168 Total Direct Material Cost: Section A Duet Hatut Sedio MON