BUS 225
RandyF1234
BUS225CostRevenueandProfit.xlsxBus225 Cost Revenue,and Profit
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual Numbers | |
| Labor | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 4,200.00 | 4,200.00 | 3,150.00 | 3,150.00 | 3,150.00 | 3,150.00 | 3,150.00 | 3,150.00 | |
| Materials | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | |
| Overhead (30%) | $5,520.00 | $5,520.00 | $5,520.00 | $5,520.00 | $4,260.00 | $4,260.00 | $3,945.00 | $3,945.00 | $3,945.00 | $3,945.00 | $3,945.00 | $3,945.00 | |
| Profit (Goal 25%) | $4,600.00 | $4,600.00 | $4,600.00 | $4,600.00 | $3,550.00 | $3,550.00 | $3,287.50 | $3,287.50 | $3,287.50 | $3,287.50 | $3,287.50 | $3,287.50 | |
| Number of Units Produced | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | |
| Sold Units | 20,000.00 | 30,000.00 | 90,000.00 | 50,000.00 | 30,000.00 | 90,000.00 | 90,000.00 | 100,000.00 | 120,000.00 | 120,000.00 | 120,000.00 | 120,000.00 | |
| Unit Price | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | |
| Total Revenue | $5,000.00 | $7,500.00 | $22,500.00 | $12,500.00 | $7,500.00 | $22,500.00 | $22,500.00 | $25,000.00 | $30,000.00 | $30,000.00 | $30,000.00 | $30,000.00 | |
| Labor and Materials | 18,400.00 | 18,400.00 | 18,400.00 | 18,400.00 | 14,200.00 | 14,200.00 | 13,150.00 | 13,150.00 | 13,150.00 | 13,150.00 | 13,150.00 | 13,150.00 | |
| Profit Goal | $4,600.00 | $4,600.00 | $4,600.00 | $4,600.00 | $3,550.00 | $3,550.00 | $3,287.50 | $3,287.50 | $3,287.50 | $3,287.50 | $3,287.50 | $3,287.50 | |
| Overhead | $5,520.00 | $5,520.00 | $5,520.00 | $5,520.00 | $4,260.00 | $4,260.00 | $3,945.00 | $3,945.00 | $3,945.00 | $3,945.00 | $3,945.00 | $3,945.00 | |
| Target Revenue | 28,520.00 | 28,520.00 | 28,520.00 | 28,520.00 | 22,010.00 | 22,010.00 | 20,382.50 | 20,382.50 | 20,382.50 | 20,382.50 | 20,382.50 | 20,382.50 | |
| -23,520.00 | -21,020.00 | -6,020.00 | -16,020.00 | -14,510.00 | $490.00 | 2,117.50 | 4,617.50 | 9,617.50 | 9,617.50 | 9,617.50 | 9,617.50 | ||
| Cost of Goods | 23,920.00 | 23,920.00 | 23,920.00 | 23,920.00 | 18,460.00 | 18,460.00 | 17,095.00 | 17,095.00 | 17,095.00 | 17,095.00 | 17,095.00 | 17,095.00 | 235,170.00 |
| Total Revenue | $5,000.00 | $7,500.00 | $22,500.00 | $12,500.00 | $7,500.00 | $22,500.00 | $22,500.00 | $25,000.00 | $30,000.00 | $30,000.00 | $30,000.00 | $30,000.00 | $245,000.00 |
| Profit | -18,920.00 | -16,420.00 | -1,420.00 | -11,420.00 | -10,960.00 | 4,040.00 | 5,405.00 | 7,905.00 | 12,905.00 | 12,905.00 | 12,905.00 | 12,905.00 | 9,830.00 |
| Percent Profit | 4.18% | ||||||||||||
1
2
3
4
5
6
7
8
9
A
B
C
Jan
Feb
Labor
8,400.00
8,400.00
Materials
$10,000.00
$10,000.00
Overhead (30%)
$5,520.00
$5,520.00
Profit (Goal 25%)
$4,600.00
$4,600.00
Number of Units Produced
100,000.00
100,000.00
Sold Units
20,000.00
30,000.00
Unit Price
$0.25
$0.25
Total Revenue
$5,000.00
$7,500.00
