| Particular | Amount | Amount | Amount |
| Revenue | | | 37,208.08 |
| Profitability of inventory on hand: |
| Selling price: 9991 (15,000*4) | $60,000 |
| : 9992 (12,500*7) | $87,500 |
| : 9993 (8,000*12) | $96,000 |
| : 9994 (6,500*3) | $13,000 | $256,500 |
| Purchases: 9991 (15,000*2) | $30,000 |
| : 9992 (12,500*3.5) | $43,750 |
| : 9993 (8,000*7) | $56,000 |
| : 9994 (6,500*1) | $6,500 | ($136,250) | $120,250 |
| Gross profit | | | $157,458.08 |
| Less Expenses: |
| Fixed cost: Rent | $3,000 |
| :Insurance | $2,500 |
| : Utilities | $800 |
| : Managers | $6,000 | $12,300 |
| Variable cost: Materials | $745.66 |
| : Labor | $1,491.32 | $2,236.98 | ($14,537) |
| Net profit | | | $142,921.08 |
qFop
Profitabilityanalysis.xlsx
