I need to make a summary report and total cost per job using the numbers provided.

watu 10018 Add-ons Help Last edit was 2 days ago % 0,09 123- Default (Ca... - 11 BISA 100% ES A B C D E G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 ABC Company uses a job-costing system at its south Edmonton factory. The factory has two cost pools: Machining and Assembly. Its job-costing system has two direct cost categories (direct materials and direct manufacturing labour) and two manufacturing overhead cost pools (Machining and Assembly). The Machining pool allocates based on machine hours and assembly allocates on labour cost. There are 17 machines within the the machining department that all run concurrently 12 hours per day with routine maintenance cycles. There are four times as many machining within the assembly department. Machining Department manufacturing overhead includes maintenance hours on the machines and associated setup time per machine, one quarter the factory rent expense and supervisors and administrative salaries of $450,000 Assembly Department manufacturing overhead includes maintenance hours on the machines and associated setup time per machine, three-quarters the factory rent expense, quality inspectors and supervisors plus administrative salaries of $2,200,000. Rent is expected to be $3.000.000 in 2021. PREPARE A SUMMARY REPORT that shows the total cost per job and total to invoice the Customer, Customers are charged depending on the type of customer. ABC Company has three different price mark-ups. (R)egular: 25% markup (G)overnment: 22% markup 17 18 19 20 21 22 (Ninn.nrnfit12.5% markun Question - Jobs_data- Accounts Income_Statement - Machining Dept MA Default (Ca... fx BI GA Tuntis expuci WWW, WHITZULT. E F G H B 19 20 21 22 PREPARE A SUMMARY REPORT that shows the total cost per job and total to invoice the Customer. Customers are charged depending on the type of customer. ABC Company has three different price mark-ups: (R)egular: 25% markup (G)overnment: 22% markup (N)on-profit: 12.5% markup What is the actual gross margin (and gross margin percentage) for the year so far? 25 6 17 8 09 D Are there any concerns about the accuracy of the invoiced amounts? -2 DUE VIA EMAIL ON MONDAY MARCH 15TH AT 5PM 5 -6 -7 8 9 0 Marking Rubric 50%: Calculating the Invoiced total (i.e. cost plus markup) for each job. Expectations are to use Excel functions: (SUMIFS, XLOOKUP, SUMS, ROUND) 20%: Calculating the year-to-date gross margin and gross margin percentage 20%: Commentary on invoiced total accuracy. (Hint: there are two potential issues of concer) 10%: Accurately interpreting question information, clarity on presented solution (ie was it easy to follow) 2 3 + Question Jobs data Accounts Income Statement Machining F G H 1 J K Machine Hours Labour Hours Job Customer Type Machining Assembly Machining Assembly 432 R 2000 1000 1000 1500 438 R 1626 1900 1216 2628 445 R 656 1688 1370 1530 449 R 1970 1564 980 1520 454 N 1608 1717 1325 1002 461 R 882 1797 884 2578 468 R 1653 1860 1477 1699 472 R 1695 2249 1265 2870 479 N 2100 1652 1108 2882 480 R 1711 1022 1491 1086 487 R 1065 1369 639 1644 492 R 1031 1603 1217 2374 496 N 1470 1300 1445 1397 503 R 1766 1337 1395 2443 R 1006 1140 562 2069 511 G 1789 2484 1280 1001 517 R 1221 1142 1366 2041 521 R 175 97 592 125 522 G 1581 1927 1423 2236 529 R 871 1201 1445 1134 537 R 1790 1363 1432 1813 509 Accounts Income Statement Machining Dept ASS 75% Normal text A Arial 2 11 1.3. 1511 6 B 1 Job Amount Account 1610 BEP 490 1530 1520 492 492 1530 1610 $24118.00 $9.70400 $7,518.00 $5,995.00 $22.678.00 $1.032.00 $11.019.00 492 517 1630 479 1520 509 1630 480 1605 1630 454 521 1505 1610 897 32.226.00 $21.949.00 $141100 $4,505.00 $26.05000 $26.99400 $2.900.00 $2.528.00 320.115.00 $2.650.00 310.92.000 1610 1620 1620 TS 887 849 1510 1620 1510 503 522 537 1630 1505 1510 1520 422 511 272 TOTO $1.027.00 $7:118.00 21-10400 52 510.00 $21.9400 128 7200 3529900 17.996100 170.00 12 549.00 195100 193100 1620 1650 1536 EI 1 3 1 ELULU 7. 8.1 511 1520 34.804.00 $22.225.00 479 1605 492 1620 3277200 537 1610 503 1520 1510 $29.775.00 38,044.00 59.17200 479 462 1530 522 1620 1510 $7.195.00 32.875.00 $7222200 $947000 12212200 1520 479 1610 509 15.95500 522 1521100 110 502 16 122100 1 Arlal 04 + 13 1 . 1 509 1505 $10.878.00 1530 36,522.00 $21,860.00 509 1610 472 1520 1530 5a7 511 1510 490 1505 517 1505 $10.262.00 $10,2200 $9.619.00 $7.161.00 $9.280.00 $5.010.00 $11.916.00 $2.130.00 $6.545.00 $2.658.00 492 1505 1530 529 1620 461 1505 502 1630 1620 $2.631.00 $9.957.00 497 1505 1630 $2.296.00 490 1610 1630 $22.10500 $121800 3212400 $2.39200 $21.5.200 $22.058.00 433 1630 1805 1605 1510 18.54200 1530 00768 017 31 14230100 .. 2 Arial Normal text A? 75% 1.2 111 112:13 115.7:18:19 | 10 | 11 | 12 | 1510 522 492 1510 1630 521 12.71200 $6.628.00 $2.82700 32,586.00 $24,549.00 3126200 45 1620 487 1605 1630 432 1605 522 496 1605 1630 487 509 1620 422 DES 1610 1505 1605 509 529 522 1520 1530 1630 1610 $25,550.00 $22,342.00 31.547.00 $2.72100 $17.92100 $5.41200 128.525.00 38.816.00 $8.082.00 $8.142.00 $1.650.00 124,29200 350.00 SO 900 12.075.00 11.00 29.066.00 1122100 492 254 1620 1580 435 1620 200 656 1805 303 1590 Bio DOMETIC DOS DE 00 DOOR DORI DODACI A ? 75% Arial Normal text 2 2 11.12.3. 8 19:11 537 1630 $1,63400 $9.850.00 489 1520 fii 4 449 1530 492 1605 468 1630 1510 $2.71200 $20.085.00 $1,834.00 34967.00 $10.209.00 $8.032.00 487 521 1530 529 1530 487 1610 1530 472 461 $22.686.00 $11.199.00 $5.83200 1530 454 1605 $28. 572.00 $24.77200 537 1605 1630 1505 $1.29200 $8.09100 I 12.159 461 517 521 122100 12.51 DE 2100 Untitled document OO File Edit View Insert Format Tools Ad 75% Normal text 5 1:12:3 500 1505 $9.62400 461 1605 522 1610 1530 517 $24.999.00 $29,916.00 $7.688.00 34.068.00 $2 298.00 $11.250.00 517 1520 461 454 1620 1520 461 1610 496 1520 1605 1695 $21.985.00 39.969.00 $26,41400 329, 190 00 $2.522.00 521 639 503 1510 517 1620 454 1510 $25.210.00 32.397.00 12.275.00 18.70200 11.045.00 $9.995.00 230100 1510 1520 14.990.00 1420200 120g 2200 TELLO 100 1500 90% % .0 .00 123 A2 fx 1505 A c B 2 3 4 5 6 Accounts 1505 1510 1520 1530 1550 1605 1610 1620 1630 1650 Machining Machining Machining Machining Machining Assembly Assembly Assembly Assembly Assembly Wood Metals Brackets Pre-fabrications Manufacturing Labour Wood Metals Brackets Pre-fabrications Manufacturing Labour 7 9 10 11 12 13 14 Arial 90% % ._ .00 123- - fx | ABC COMPANY D B A ABC COMPANY COMPARATIVE INCOME STATEMENTS for the period ending Dec 31, 2022 Budget $ 25,000,000 Revenues - 8 9 10 11 Cost of Goods Sold: Direct materials Direct labour Manufacturing overhead 7,500,000 8,500,000 ??? 16,000,000 12 13 $ Gross Margin 9,000,000 36.096 15 15 20 File Edit View Insert 11 Arial 75% % . .00 123- Planned per machine hours fx A1:E1 G H c D Idle Time 115 105 105 60 98 Planned per machine hours Planning Production Maintenance Setup Hours Time Week # Run Hours 9 3 48 1 3 8 60 2 3 7 3 10 4 3 7 5 13 7 8 6 3 9 7 10 8 10 8 3 7 9 3 6 2 10 3 6 15 11 10 6 12 3 13 20 14 8 15 7 16 17 6 3 8 18 19 3 7 20 10 6 7 3 21 22 3 23 3 24 10 25 3 26 3 27 18 #88888888888888888888888 00000000 G Oh Oh Oh Oh 103 105 105 98 115 105 105 98 103 105 105 110 103 105 105 98 103 117 105 98 103 105 117 Labour Hours 1,632 2,040 2040 2,040 2,040 1,672 2,040 2,040 1,632 2,040 2,040 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 1,632 Labour Cost $57,120 $71,400 $71,400 $71,400 $71,400 $58,520 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 571,400 $57,120 Income St Question Accounts + Jobs data E 125 75% 1 A1:E1 fx Planned per machine hours D F H E G B 29 30 31 32 8 9 8 7 6 5 8 6 5 33 34 30 5 37 DO DO 40 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 48 60 60 60 60 48 60 60 60 60 48 60 60 60 60 48 60 60 60 48 60 60 60 60 60 117 98 103 105 105 110 103 105 105 98 115 105 105 98 103 117 105 98 103 117 105 98 103 105 105 158 1,632 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 2,040 8 7 5 7 5 6 6 6 5 5 4 B 4 6 8 $57,120 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $71,400 $0 49 40 10 3 10 + E Question Jol Explor Arial 75% % 0.00123- A1:E1 Planned per machine hours G H D Idle 2 NH Planned per machine hours Planning Production Maintenance Setup Hours Run Hours Time Week # 48 8 4 8 60 7 2 8 60 6 3 60 4 14 6 60 5 8 6 50 6 7 28 7 60 8 6 14 6 TD 8 60 9 48 8 7 12 10 60 7 8 11 60 8 4 12 60 14 7 13 60 8 7 14 60 8 6 15 60 8 6 16 48 14 5 12 17 60 8 6 18 60 8 4 19 60 8 7 20 60 14 6 21 60 8 7 22 48 8 7 23 60 8 7 24 60 14 4 25 60 8 7 26 60 8 5 Time 108 93 94 88 94 83 94 88 105 93 96 87 93 94 94 101 94 96 93 88 93 105 93 90 93 95 Labour Hours 3,264 4,080 4,080 4,080 4,080 3,344 4,080 4,080 3,264 4,080 4,080 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 Labour Cost $97,920 $122,400 $122,400 $122,400 $122,400 $100,320 $122,400 $122,400 $97.920 $122,400 $122,400 $122,400 $122,400 $122,400 $122,400 $97,920 122,400 $122,400 $122,400 $122,400 $122,400 $97.920 $122,400 $122,400 $122,400 $122,400 + Assembly Dept 8 Share Job Costing lab @ File Edit View Insert Format Data Tools Add 75% Arial Y % .0 .00 123- Planned per machine hours A1:E1 fx C D E F 8 0 A 29 30 8 14 8 8 31 12 4 7 4 4 6 5 5 4 6 5 7 35 48 60 60 60 60 48 60 60 60 60 48 60 60 60 60 48 60 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 40 8 14 8 8 8 14 8 8 8 14 8 8 8 14 8 8 B 14 11 108 87 96 96 94 101 95 96 94 89 105 94 93 87 93 108 94 89 93 107 96 87 96 94 95 150 3,264 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 4,080 1677746575474654 H $97920 $122,400 $122,400 $122,400 $122,400 $97.920 $122,400 $122,400 $122,400 $122,400 $97,920 $122,400 $122,400 $122,400 $122,400 $97,920 $122,400 $122,400 $122,400 $97.920 $122,400 $122,400 $122,400 $122.400 $122,400 $0 60 48 49 50 51 52 60 48 60 60 60 60 60 0 8 14 Arial A1:E1 fx Planned per machine hours 1 2 K M N a O 7 B 9 TO 11 12 13 14 10 17 18 19 21 22 23 24 26 29 watu 10018 Add-ons Help Last edit was 2 days ago % 0,09 123- Default (Ca... - 11 BISA 100% ES A B C D E G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 ABC Company uses a job-costing system at its south Edmonton factory. The factory has two cost pools: Machining and Assembly. Its job-costing system has two direct cost categories (direct materials and direct manufacturing labour) and two manufacturing overhead cost pools (Machining and Assembly). The Machining pool allocates based on machine hours and assembly allocates on labour cost. There are 17 machines within the the machining department that all run concurrently 12 hours per day with routine maintenance cycles. There are four times as many machining within the assembly department. Machining Department manufacturing overhead includes maintenance hours on the machines and associated setup time per machine, one quarter the factory rent expense and supervisors and administrative salaries of $450,000 Assembly Department manufacturing overhead includes maintenance hours on the machines and associated setup time per machine, three-quarters the factory rent expense, quality inspectors and supervisors plus administrative salaries of $2,200,000. Rent is expected to be $3.000.000 in 2021. PREPARE A SUMMARY REPORT that shows the total cost per job and total to invoice the Customer, Customers are charged depending on the type of customer. ABC Company has three different price mark-ups. (R)egular: 25% markup (G)overnment: 22% markup 17 18 19 20 21 22 (Ninn.nrnfit12.5% markun Question - Jobs_data- Accounts Income_Statement - Machining Dept MA Default (Ca... fx BI GA Tuntis expuci WWW, WHITZULT. E F G H B 19 20 21 22 PREPARE A SUMMARY REPORT that shows the total cost per job and total to invoice the Customer. Customers are charged depending on the type of customer. ABC Company has three different price mark-ups: (R)egular: 25% markup (G)overnment: 22% markup (N)on-profit: 12.5% markup What is the actual gross margin (and gross margin percentage) for the year so far? 25 6 17 8 09 D Are there any concerns about the accuracy of the invoiced amounts? -2 DUE VIA EMAIL ON MONDAY MARCH 15TH AT 5PM 5 -6 -7 8 9 0 Marking Rubric 50%: Calculating the Invoiced total (i.e. cost plus markup) for each job. Expectations are to use Excel functions: (SUMIFS, XLOOKUP, SUMS, ROUND) 20%: Calculating the year-to-date gross margin and gross margin percentage 20%: Commentary on invoiced total accuracy. (Hint: there are two potential issues of concer) 10%: Accurately interpreting question information, clarity on presented solution (ie was it easy to follow) 2 3 + Question Jobs data Accounts Income Statement Machining F G H 1 J K Machine Hours Labour Hours Job Customer Type Machining Assembly Machining Assembly 432 R 2000 1000 1000 1500 438 R 1626 1900 1216 2628 445 R 656 1688 1370 1530 449 R 1970 1564 980 1520 454 N 1608 1717 1325 1002 461 R 882 1797 884 2578 468 R 1653 1860 1477 1699 472 R 1695 2249 1265 2870 479 N 2100 1652 1108 2882 480 R 1711 1022 1491 1086 487 R 1065 1369 639 1644 492 R 1031 1603 1217 2374 496 N 1470 1300 1445 1397 503 R 1766 1337 1395 2443 R 1006 1140 562 2069 511 G 1789 2484 1280 1001 517 R 1221 1142 1366 2041 521 R 175 97 592 125 522 G 1581 1927 1423 2236 529 R 871 1201 1445 1134 537 R 1790 1363 1432 1813 509 Accounts Income Statement Machining Dept ASS 75% Normal text A Arial 2 11 1.3. 1511 6 B 1 Job Amount Account 1610 BEP 490 1530 1520 492 492 1530 1610 $24118.00 $9.70400 $7,518.00 $5,995.00 $22.678.00 $1.032.00 $11.019.00 492 517 1630 479 1520 509 1630 480 1605 1630 454 521 1505 1610 897 32.226.00 $21.949.00 $141100 $4,505.00 $26.05000 $26.99400 $2.900.00 $2.528.00 320.115.00 $2.650.00 310.92.000 1610 1620 1620 TS 887 849 1510 1620 1510 503 522 537 1630 1505 1510 1520 422 511 272 TOTO $1.027.00 $7:118.00 21-10400 52 510.00 $21.9400 128 7200 3529900 17.996100 170.00 12 549.00 195100 193100 1620 1650 1536 EI 1 3 1 ELULU 7. 8.1 511 1520 34.804.00 $22.225.00 479 1605 492 1620 3277200 537 1610 503 1520 1510 $29.775.00 38,044.00 59.17200 479 462 1530 522 1620 1510 $7.195.00 32.875.00 $7222200 $947000 12212200 1520 479 1610 509 15.95500 522 1521100 110 502 16 122100 1 Arlal 04 + 13 1 . 1 509 1505 $10.878.00 1530 36,522.00 $21,860.00 509 1610 472 1520 1530 5a7 511 1510 490 1505 517 1505 $10.262.00 $10,2200 $9.619.00 $7.161.00 $9.280.00 $5.010.00 $11.916.00 $2.130.00 $6.545.00 $2.658.00 492 1505 1530 529 1620 461 1505 502 1630 1620 $2.631.00 $9.957.00 497 1505 1630 $2.296.00 490 1610 1630 $22.10500 $121800 3212400 $2.39200 $21.5.200 $22.058.00 433 1630 1805 1605 1510 18.54200 1530 00768 017 31 14230100 .. 2 Arial Normal text A? 75% 1.2 111 112:13 115.7:18:19 | 10 | 11 | 12 | 1510 522 492 1510 1630 521 12.71200 $6.628.00 $2.82700 32,586.00 $24,549.00 3126200 45 1620 487 1605 1630 432 1605 522 496 1605 1630 487 509 1620 422 DES 1610 1505 1605 509 529 522 1520 1530 1630 1610 $25,550.00 $22,342.00 31.547.00 $2.72100 $17.92100 $5.41200 128.525.00 38.816.00 $8.082.00 $8.142.00 $1.650.00 124,29200 350.00 SO 900 12.075.00 11.00 29.066.00 1122100 492 254 1620 1580 435 1620 200 656 1805 303 1590 Bio DOMETIC DOS DE 00 DOOR DORI DODACI A ? 75% Arial Normal text 2 2 11.12.3. 8 19:11 537 1630 $1,63400 $9.850.00 489 1520 fii 4 449 1530 492 1605 468 1630 1510 $2.71200 $20.085.00 $1,834.00 34967.00 $10.209.00 $8.032.00 487 521 1530 529 1530 487 1610 1530 472 461 $22.686.00 $11.199.00 $5.83200 1530 454 1605 $28. 572.00 $24.77200 537 1605 1630 1505 $1.29200 $8.09100 I 12.159 461 517 521 122100 12.51 DE 2100 Untitled document OO File Edit View Insert Format Tools Ad 75% Normal text 5 1:12:3 500 1505 $9.62400 461 1605 522 1610 1530 517 $24.999.00 $29,916.00 $7.688.00 34.068.00 $2 298.00 $11.250.00 517 1520 461 454 1620 1520 461 1610 496 1520 1605 1695 $21.985.00 39.969.00 $26,41400 329, 190 00 $2.522.00 521 639 503 1510 517 1620 454 1510 $25.210.00 32.397.00 12.275.00 18.70200 11.045.00 $9.995.00 230100 1510 1520 14.990.00 1420200 120g 2200 TELLO 100 1500 90% % .0 .00 123 A2 fx 1505 A c B 2 3 4 5 6 Accounts 1505 1510 1520 1530 1550 1605 1610 1620 1630 1650 Machining Machining Machining Machining Machining Assembly Assembly Assembly Assembly Assembly Wood Metals Brackets Pre-fabrications Manufacturing Labour Wood Metals Brackets Pre-fabrications Manufacturing Labour 7 9 10 11 12 13 14 Arial 90% % ._ .00 123- - fx | ABC COMPANY D B A ABC COMPANY COMPARATIVE INCOME STATEMENTS for the period ending Dec 31, 2022 Budget $ 25,000,000 Revenues - 8 9 10 11 Cost of Goods Sold: Direct materials Direct labour Manufacturing overhead 7,500,000 8,500,000 ??? 16,000,000 12 13 $ Gross Margin 9,000,000 36.096 15 15 20 File Edit View Insert 11 Arial 75% % . .00 123- Planned per machine hours fx A1:E1 G H c D Idle Time 115 105 105 60 98 Planned per machine hours Planning Production Maintenance Setup Hours Time Week # Run Hours 9 3 48 1 3 8 60 2 3 7 3 10 4 3 7 5 13 7 8 6 3 9 7 10 8 10 8 3 7 9 3 6 2 10 3 6 15 11 10 6 12 3 13 20 14 8 15 7 16 17 6 3 8 18 19 3 7 20 10 6 7 3 21 22 3 23 3 24 10 25 3 26 3 27 18 #88888888888888888888888 00000000 G Oh Oh Oh Oh 103 105 105 98 115 105 105 98 103 105 105 110 103 105 105 98 103 117 105 98 103 105 117 Labour Hours 1,632 2,040 2040 2,040 2,040 1,672 2,040 2,040 1,632 2,040 2,040 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 1,632 Labour Cost $57,120 $71,400 $71,400 $71,400 $71,400 $58,520 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 571,400 $57,120 Income St Question Accounts + Jobs data E 125 75% 1 A1:E1 fx Planned per machine hours D F H E G B 29 30 31 32 8 9 8 7 6 5 8 6 5 33 34 30 5 37 DO DO 40 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 48 60 60 60 60 48 60 60 60 60 48 60 60 60 60 48 60 60 60 48 60 60 60 60 60 117 98 103 105 105 110 103 105 105 98 115 105 105 98 103 117 105 98 103 117 105 98 103 105 105 158 1,632 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 1,632 2,040 2,040 2,040 1,632 2,040 2,040 2,040 2,040 2,040 8 7 5 7 5 6 6 6 5 5 4 B 4 6 8 $57,120 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $57,120 $71,400 $71,400 $71,400 $71,400 $71,400 $0 49 40 10 3 10 + E Question Jol Explor Arial 75% % 0.00123- A1:E1 Planned per machine hours G H D Idle 2 NH Planned per machine hours Planning Production Maintenance Setup Hours Run Hours Time Week # 48 8 4 8 60 7 2 8 60 6 3 60 4 14 6 60 5 8 6 50 6 7 28 7 60 8 6 14 6 TD 8 60 9 48 8 7 12 10 60 7 8 11 60 8 4 12 60 14 7 13 60 8 7 14 60 8 6 15 60 8 6 16 48 14 5 12 17 60 8 6 18 60 8 4 19 60 8 7 20 60 14 6 21 60 8 7 22 48 8 7 23 60 8 7 24 60 14 4 25 60 8 7 26 60 8 5 Time 108 93 94 88 94 83 94 88 105 93 96 87 93 94 94 101 94 96 93 88 93 105 93 90 93 95 Labour Hours 3,264 4,080 4,080 4,080 4,080 3,344 4,080 4,080 3,264 4,080 4,080 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 Labour Cost $97,920 $122,400 $122,400 $122,400 $122,400 $100,320 $122,400 $122,400 $97.920 $122,400 $122,400 $122,400 $122,400 $122,400 $122,400 $97,920 122,400 $122,400 $122,400 $122,400 $122,400 $97.920 $122,400 $122,400 $122,400 $122,400 + Assembly Dept 8 Share Job Costing lab @ File Edit View Insert Format Data Tools Add 75% Arial Y % .0 .00 123- Planned per machine hours A1:E1 fx C D E F 8 0 A 29 30 8 14 8 8 31 12 4 7 4 4 6 5 5 4 6 5 7 35 48 60 60 60 60 48 60 60 60 60 48 60 60 60 60 48 60 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 40 8 14 8 8 8 14 8 8 8 14 8 8 8 14 8 8 B 14 11 108 87 96 96 94 101 95 96 94 89 105 94 93 87 93 108 94 89 93 107 96 87 96 94 95 150 3,264 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 3,264 4,080 4,080 4,080 3,264 4,080 4,080 4,080 4,080 4,080 1677746575474654 H $97920 $122,400 $122,400 $122,400 $122,400 $97.920 $122,400 $122,400 $122,400 $122,400 $97,920 $122,400 $122,400 $122,400 $122,400 $97,920 $122,400 $122,400 $122,400 $97.920 $122,400 $122,400 $122,400 $122.400 $122,400 $0 60 48 49 50 51 52 60 48 60 60 60 60 60 0 8 14 Arial A1:E1 fx Planned per machine hours 1 2 K M N a O 7 B 9 TO 11 12 13 14 10 17 18 19 21 22 23 24 26 29