| Monthly Income and Statement |
|
|
|
|
|
|
| Artistic Furniture Corporation |
|
|
| Revenue |
|
|
Units |
Revenue |
Costs |
Profit |
|
Units Produced |
10 |
|
0 |
$ - |
$ 8,593 |
$ (8,593) |
|
Price Per Unit |
$ 2,050 |
|
2 |
$ 4,100 |
$ 11,320 |
$ (7,220) |
|
Total Revenue |
$
20,500 |
|
4 |
$ 8,200 |
$ 14,047 |
$ (5,847) |
|
|
6 |
$ 12,300 |
$ 16,774 |
$ (4,474) |
| Variable Costs (per unit) |
|
|
8 |
$ 16,400 |
$ 19,501 |
$ (3,101) |
|
Direct Labor |
$ 410 |
|
10 |
$ 20,500 |
$ 22,228 |
$ (1,728) |
|
Direct Material (wood, hardware) |
$ 615 |
|
12 |
$ 24,600 |
$ 24,955 |
$ (355) |
|
Direct Supplies |
$ 51 |
|
14 |
$ 28,700 |
$ 27,682 |
$ 1,018 |
|
Sales Commissions |
$
103 |
|
16 |
$ 32,800 |
$ 30,409 |
$ 2,391 |
|
Overhead |
$ 185 |
|
18 |
$ 36,900 |
$ 33,136 |
$ 3,764 |
|
Total Variable Costs (all units) |
$
13,635 |
|
20 |
$ 41,000 |
$ 35,863 |
$ 5,137 |
|
|
22 |
$ 45,100 |
$ 38,590 |
$ 6,510 |
| Contribution Margin |
|
|
24 |
$ 49,200 |
$ 41,317 |
$ 7,883 |
|
Contribution Margin |
$
6,865 |
|
26 |
$ 53,300 |
$ 44,044 |
$ 9,256 |
|
|
28 |
$ 57,400 |
$ 46,771 |
$ 10,629 |
| Fixed Costs |
|
|
30 |
$ 61,500 |
$ 49,498 |
$ 12,002 |
|
Rent |
$ 2,500 |
|
|
|
|
Utilities |
$ 3,280 |
|
|
Supplies |
$ 845 |
|
|
Equipment Leases |
$ 1,968 |
|
|
Total Fixed Costs |
$
8,593 |
|
|
|
| Profit |
|
|
|
Revenue |
$
20,500 |
|
|
Total Costs (fixed + variable) |
$
22,228 |
|
|
Net Income (profit) |
$
(1,728) |
|
|
|
|
|
|
|
|
|
|
