Using exex Check the formulas for the other manufacturing tasks to ensure they are written correctly and that the worksheet can be easily updated later if any inputs change. The inputs are the Production Rate, Unit, $/Hour, and Quantity/Shoe. Check that the formula to summarize the labor costs is correct, and modify as needed.

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	######
Assembly of Arch Support	1.00	shoe	0.0050
Total Labor			#DIV/0!

Answer rating: 100% (QA)

Solution Question 5 Cli... View the full answer