WEEK4BLOG.xlsx
Sheet1
| | 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% |
Classof2021
