Exercise 1 B: Level 1 - Labor Costs Objective: Correct errors in formulas and format With the assistance of the manufacturing group, the product design team has prepared another worksheet that lists the labor costs involved in manufacturing the TZEdge shoe. Figure 1.11 shows this worksheet. A B C D 1 Description Production Rate Unit $/Hour 2 Delivery of Boxes to Produc 14 boxes/hr 11 3 Cutting of Leather 20 shoes/hr 20.50 4 Attachment of Appliques 30 appliques/hr 10 5 Sewing of Logos to Leather 16.5 pieces/hr 16.0 6 Assembly of Leather & Sole 10 shoes/hr 16 7 Assembly of Arch Support 18.5 shoes/hr 10.89 Each Shoe - Manufacturing 1 Quantity /Shoe Unit Total Cost 10 Delivery of Boxes to Produc .25 boxes/shoe #DIV/0! 11 Cutting of Leather 1 shoe N P 12 Attachment of Appliques 6 appliques/shoe 13 Assembly of Leather & Sole 1.00 shoe 0.96969697 14 Assembly of Arch Support 1.00 shoe 0.0050 15 Total Labor #DIV/O! 16