example- Please do not ask me to do it-

profileegymanny
example_advanced_accounting_.xls
Home>Business & Finance homework help>Accounting homework help>example- Please do not ask me to do it-

Sheet1

a.
Saving in variable marketing cost 4
loss of revenue 2
25-23
Net saving per unit 2
Total additional profit
10000*2 $20,000
Q1 Q2 Q3 Q1 Q2 Q3
Beginning inventory (units) 0 100 300 Beginning inventory (units) 0 J 1,100
Budgeted units to be produced 3,800 4,200 4,100 Budgeted units to be produced 20,000 20,000 20,000
Actual units produced 4,000 4,000 4100 Actual units produced 19,000 20,600 Q
Units sold 3900 4,000 4300 Units sold A 20,600 R
Variable manufacturing costs per unit produced $125 $125 $125 Variable manufacturing costs per unit produced $150 $150 $150
Variable marketing costs per unit sold $40 $40 $40 Variable marketing costs per unit sold $20 $20 $20
Fixed manufacturing costs $600,000 $600,000 $600,000 150 Budgeted fixed manufacturing costs $500,000 $500,000 $500,000
Fixed marketing costs $250,000 $250,000 $250,000 Fixed marketing costs $200,000 $200,000 $200,000
Selling price per unit $400 $400 $400 Selling price per unit $300 $300 $300
Variable costing operating income 66500 $90,000 160500 235 916500 1010500 Variable costing operating income B $1,978,000 S
Absorption costing operating income 81500 120000 $130,500 850000 160500 -15000 Absorption costing operating income C K $1,859,000
Variable costing beginning inventory 0 $12,500 37500 66500 45000 Variable costing beginning inventory ($) D $165,000 T
Absorption costing beginning inventory 0 27500 82500 15000 30000 Absorption costing beginning inventory ($) E L U
Variable costing ending inventory 12500 37500 $12,500 Variable costing ending inventory ($) F M $75,000
Absorption costing ending inventory 27500 82500 $27,500 Absorption costing ending inventory ($) G N $87,500
PVV 30000 -30000 0 PVV H O V
Allocated fixed manufacturing costs 570000 630000 $615,000 Allocated fixed manufacturing costs I P $480,000

Sheet2

Sheet3