Chapter 6: Master Budget and Responsibility Accounting
Copyright © 2016 Pearson Canada Inc.
213
6-22 (30 min.) Sales and production budget.
1.
Selling Price Units Sold Total Revenue
l-litre bottles $0.50 6,240,000
a
$ 3,120,000
16-litre units 7.00 2,220,000
b
15,540,000
$18,660,000
a
520,000 12 months = 6,240,000
b
185,000 12 months = 2,220,000
2. Budgeted unit sales (1-litre bottles) 6,240,000
Add target ending finished goods inventory 976,000
Total requirements 7,216,000
Deduct beginning finished goods inventory 1,275,000
Units to be produced 5,941,000
3. Beginning Budgeted Target Budgeted inventory sales ending inventory production = 2,220,000 + 265,000 – 2,090,000
= 395,000 16-litre units
6-23 (15-20 min.) Budgeting revenue, cost of sales, and gross margin.
Whimsy Gifts
Budgeted Revenue
For the Quarter Ending December 31
Total
for the
October November December Quarter
Cash sales $14,000 $16,300 $21,100 $51,400
Credit card sales:
$ 9,800 0.96 9,408
$11,200 0.96 10,752
$15,800 0.96 15,168 35,328
Net sales 23,408 27,052 36,2 68 86,728
Cost of goods sold, at
40% of net sales 9,363
10,821 14,507 34,691
Gross margin $14,045 $16,231 $21,761 $52,037
Some students may think that a 60% gross margin is high. However, this gross margin is
before deducting many operating costs such as rent, advertising, and sales commissions.
+ – =