| 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) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
