Details of the spreadsheet are as follows:
(A) Labor-intensive assembly method
(1) Direct materials (8 helicopters times $40,000 per helicopter): $320,000
(2) Direct-assembly labor (9,826 hours times $30 per hour): 294,780
(3) Indirect manufacturing costs
Equipment related (9,826 hours times $12 per hour): 117,912
Materials-handling related (0.50 times $320,000): 160,000
(4) Total assembly costs: $892,692
(B) Machine-intensive assembly method
(1) Direct materials (8 helicopters times $36,000 per helicopter): $288,000
(2) Direct-assembly labor (5,258 hours times $30 per hour): 157,740
(3) Indirect manufacturing costs
Equipment related (5,258 hours times $45 per hour): 236,610
Materials-handling related (0.50 times $288,000): 144,000
(4) Total assembly costs: $826,350.