7C example

7C example - 30,000 Fixed costs Inspection, setup materials...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Assumptions One variable Data Table Total cost give Direct materials cost per unit 10.00 Direct manufacturing labor per unit 6.00 7,000 8,500 Variable manufacturing overhead per unit 3.00 304,000 247,000 275,500 Total Inspection, setup materials handling 20,000 Total Machine lease 34,000 Two variable Data Table on Average cos Total Allocated fixed plant admin. 60,000 Units produced 10,000 30.40 7,000 8,500 Lease cost 26,000 34.14 31.47 Analysis 30,000 34.71 31.94 Variable costs 34,000 35.29 32.41 Direct materials 100,000 38,000 35.86 32.88 Direct manufacturing labor 60,000 42,000 36.43 33.35 Variable manufacturing overhead
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 30,000 Fixed costs Inspection, setup materials handling 20,000 Machine lease 34,000 Allocated fixed plant admin 60,000 Total costs 304,000 Average Total cost per unit produced 30.40 Add note at bottome stating you used goal seek n Units Produced Units produced 10,000 11,500 13,000 14,500 15,000 304,000 332,500 361,000 389,500 399,000 st given Units Produced & Machine lease Units produced 10,000 11,500 13,000 14,500 15,000 29.60 28.22 27.15 26.31 26.07 30.00 28.57 27.46 26.59 26.33 30.40 28.91 27.77 26.86 26.60 30.80 29.26 28.08 27.14 26.87 31.20 29.61 28.38 27.41 27.13...
View Full Document

Page1 / 2

7C example - 30,000 Fixed costs Inspection, setup materials...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online