Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Exercise 23 11 Your answer is partally correct. Try again Atianta Company is pre

ID: 2563227 • Letter: E

Question

Exercise 23 11 Your answer is partally correct. Try again Atianta Company is prepaning its manufacturing overhead budget for 2017. Relevant data consist of the fallowing Units to be produced [by quarters): 10,200, 12.100, 15,000, 16,700. Direct labor: T variabie overhead oosts per drect labor hour; indirect materials $0.90; indirect labor $1.30; and mainterance so.60. Fixed overhead costs per quarter: supervisory salaries $36,280; depreciation si8,600; and maintenance $15,000 me is 1.6 hours per unn Prepare the manufacturing overhead budget for the year, showing quarterly data (Round overhead rate to 2 decimal places, e.g. 1.25. List variable expenses before fixed expense.) LANTA COMPANY Overhead Budget Quarter All Righits Raserved. A Diisioe of lohe Wiley &.SansIc

Explanation / Answer

Indirect material cost

B:(unit*charges)

Maintenance charges

(C) : charges * units

Total variable cost

(D): (A+B+C)

Quarters Quarter 1 Quarter 2 Quarter 3 Quarter 4 Direct labour hrs 1.6 1.6 1.6 1.6 Direct labour charges 1.3 1.3 1.3 1.3 (A): unit* hrs* charges 21,216 25,168 31,200 34,736 Indirect material charges 0.9 0.9 0.9 0.9

Indirect material cost

B:(unit*charges)

9,180 10,890 13,500 15,030

Maintenance charges

(C) : charges * units

6,120 7,260 9,000 10,020

Total variable cost

(D): (A+B+C)

36,516 43,318 53,700 59,786 Fixed cost: Supervisory salary (E1) 36,280 36,280 36,280 36,280 Depreciation (E2) 18,600 18,600 18,600 18,600 Maintenance (E3) 15,000 15,000 15,000 15,000 Total fixed cost: (E: E1+E2+E3) 69,880 69,880 69,880 69,880 Total cost (D+E) 1,06,396 1,13,198 1,23,580 1,29,666