3, OM Text Chapter 2, p.65 REVISED PROBLEM - JULY 12, 2017 DATA: Input Week Output Labor Amt Matls # 1 30,000 6 450.0 2 33,600 7 470.0 3 32,200 7 460.0 4 35,400 8 480.0 Materials = $6.00 per pound (#) Labor = 8 hours/day @ 5 days/wk @ $12 per hour Overhead = 1.50 times the weekly labor cost MULTI FACTOR ANALYSIS WITH LABOR, MATERIALS AND OVERHEAD: LABOR MATERIALS OVHD Total Ratio Rankings # Week Output Amt Crew hrs Rate Cost Amt Rate Cost Cost Cost Out/Input Labor Matls Multi 1 0 0 2 0 0 3 0 0 4 0 0 Tot = 0.0 0.00 0.00 Avg= 0.0 0.0 0.0 Analysis: SINGLE FACTOR ANALYSIS WITH LABOR: Week Output Crew Labor Cost Ratio / Amt Ratio / $1 Input Rank # 1 0 0 $0.00 #DIV/0! #DIV/0! 2 0 0 $0.00 #DIV/0! #DIV/0! 3 0 0 $0.00 #DIV/0! #DIV/0! 4 0 0 $0.00 #DIV/0! #DIV/0! Tot = 0.0 0.0 $0.00 Avg= 0.0 0.0 $0.00 Analysis: SINGLE FACTOR ANALYSIS WITH MATERIALS: Week Output Matls Amt Matls Cost Ratio / Amt Ratio / $1 Input Rank # 1 0 0.00 $0.00 #DIV/0! #DIV/0! 2 0 0.00 $0.00 #DIV/0! #DIV/0! 3 0 0.00 $0.00 #DIV/0! #DIV/0! 4 0 0.00 $0.00 #DIV/0! #DIV/0! Tot = 0.0 0.00 $0.00 Avg= 0.0 0.00 $0.00 Analysis