Whit the assistance of the manufacturing group, the product design team has prepared another worksheet that list the labor cost involved in manufacturing the TZEdge shoe.

Description : Production Rate Unit $/Hour

Delivery of Boxes to Product line 14 boxes/hr 11

Cutting of Leather 20 shoes/hr 20.50

Attachment of Appliques 30 appliques/hr 10

Sewing of Logos to Leather 16.5 pieces/hr 16.0

Assembly of Leather & Sole 10 shoes/hr 16

Assembly of Arch Support 18.5 shoes/hr 10.89

Each Shoe - Manufacturing Tasks: Quantity /Shoe Unit Total Cost

Delivery of Boxes to Product line . 25 boxes/shoe #DIV/0!

Cutting of Leather 1 shoe 1

Attachment of Appliques 6 appliques/shoe 2

Assembly of Leather & Sole 1.00 shoe 0.96969697

Assembly of Arch Support 1.00 shoe 0.0050

Total Labor #DIV/0!

1- Adjust the column widths, as necessary, so that all the information is fully displayed.

2- Format the values in the Production Rate and $/Hour columns with the Comma Style. Format cell D2 with a dollar sing aligned at the left of the cell.

3- Address the error message in cell B10.

4- Correct the formula in cell D10 so that it accurately calculates the cost of delivering boxes for one shoe.

5- Check the formulas for the other manufacturing tasks to ensure they are written correctly and that the worksheet can be easily update later if any inputs change. The inputs are the Production Rate, Units, $/Hour,and Quantity/Shoe.

6- Format range D10:D15 so that the values align on the decimal point and display two decimal place for all the values in column D. Include a dollar sign in cells D10 and D15.

7- Format cells D10:D14 with Comma Style with two decimal places.

8- The labor cost of sewing logos onto the leather was accidentally omitted from the manufacturing tasks. There are two logos per shoe that need to be sewn on, Insert a new row just below the row containing the Attachment of Appliques, and complete the data inputs and outputs to calculate the labor cost of sewing these logos.

9- Adjust the Total Labor cost accordingly.

10- Add the title TZEdge Labor Analysis at the top of the worksheet.