Use data from first two excel sheet to answer 3 excel sheet

2 2018 Projected Production standards Units per P1 Units per P2 Unit cost of i $60.00 $50.00 0.14 4 Direct labor hrs T1 5 Direct labor hrs T2 6 Machine hrs 7 Lbs of Z1 0.35 0.025 0.01 $2.50 $1.50 S0.60 Units of Z2 9 Feet of 23 10 11 P1 manufactures 40,000 in 2018 12 P2 manufactures 80,000 in 2018 5 6 5 13 14 15 16 Based on your answers provided in Part 1 determine the following amounts need to satisfy production goals for 2018 18 19 The total number of T1 labor hours required 20 21 The total number of T2 labor hours required 5600 28000 2400 440000 160000 560000 23 The total number of machine hours required 24 25 The total number of Ibs. of input Z1 required 26 27 The total number of units of input Z2 required 28 29 The total number of feet of input Z3 required 30 31 What is the budget for T1 direct labor (dolars) $336,000.00 33 |What is the budget for T2 direct labor (dollars)$1.400,000.00 $1,736,000.00 35 What is the totai labor budget (dollars)? 36 37 38 40 Instructions Part Part 2 Part 3 Sheet1 Part 4 Select destination and press ENTER or chadse Paste Type here to search