Use data from first two excel sheet to answer 3 excel sheet 2 2018 Projected Pro
ID: 2581376 • Letter: U
Question
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 searchExplanation / Answer
Allocation of Overhead (Amount in $)
400
(40,000*0.01)
2,000
(80,000*0.025)
91,667
(550,000*400/2,400)
458,333
(550,000*2,000/2,400)
125,000
(750,000*5,600/33,600)
625,000
(750,000*28,000/33,600)
Thus the answers to the questions are mentioned as follows :-
The amount of variable facilities OH assigned to P1 = $22,000 (from point 3 in the table)
The amount of variable facilities OH assigned to P2 = $110,000 (from point 3 in the table)
The amount of variable personnel OH assigned to P1 = $123,200 (from point 6 in the table)
The amount of variable personnel OH assigned to P2 = $616,000 (from point 6 in the table)
The amount of Fixed facilities OH assigned to P1 = $91,667 (from point 7 in the table)
The amount of Fixed facilities OH assigned to P2 = $458,333 (from point 7 in the table)
The amount of Fixed personnel OH assigned to P1 = $125,000 (from point 8 in the table)
The amount of Fixed personnel OH assigned to P2 = $625,000 (from point 8 in the table)
The total amount of OH costs assigned to P1 = $361,867 (from point 9 in the table)
Particulars P1 P2 Total Amount 1) Machine Hours400
(40,000*0.01)
2,000
(80,000*0.025)
2,400 2) Variable Facilities cost per machine hour 55 55 55 3) Variable Facilities OH (1*2) 22,000 110,000 132,000 4) Labour Hours required 5,600 28,000 33,600 5) Variable personnel cost per labor hour 22 22 22 6) Variable Personnel OH (4*5) 123,200 616,000 739,200 7) Fixed Facilities OH (allocated on the basis of machine hours in the ratio of 400:2,000)91,667
(550,000*400/2,400)
458,333
(550,000*2,000/2,400)
550,000 8) Fixed Personnel OH (allocated on the basis of labor hours in the ratio of 5,600:28,000)125,000
(750,000*5,600/33,600)
625,000
(750,000*28,000/33,600)
750,000 9) Total Overheads assigned (3+6+7+8) 361,867 1,809,333 2,171,200Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.