Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started