| Sales Example | |||||||
| Minimum Purchase | 151 | ||||||
| Storage Capacity | 755 | ||||||
| Unit Cost of storage | 1.51 | ||||||
| Unit Profit | 15.1 | ||||||
| Purchase Quantity | 377 | ||||||
| Reorder Level | 453 | ||||||
| Possible Unit Sales | Quanity on Hand | Actual Sales | Cost of Storage | Gross Profit | Net Profit | Purchase | |
| 302 | 500 | 302 | 755 | 4560.2 | 3805.2 | 0 | |
| 347 | 198 | 198 | 298.98 | 2989.8 | 2690.82 | 377 | |
| 181 | 377 | 181 | 569.27 | 2733.1 | 2163.83 | 377 | |
| 604 | 573 | 573 | 865.23 | 8652.3 | 7787.07 | 0 | |
| 528 | 0 | 0 | 0 | 0 | 0 | 377 | |
| 280 | 377 | 280 | 569.27 | 4228 | 3658.73 | 377 | |
| 282 | 474 | 282 | 715.74 | 4258.2 | 3542.46 | 0 | |
| 302 | 192 | 192 | 289.92 | 2899.2 | 2609.28 | 377 | |
| 377 | 377 | 377 | 569.27 | 5692.7 | 5123.43 | 377 | |
| 453 | 377 | 377 | 569.27 | 5692.7 | 5123.43 | 377 | |
| 528 | 377 | 377 | 569.27 | 5692.7 | 5123.43 | 377 | |
| 502 | 377 | 377 | 569.27 | 5692.7 | 5123.43 | 377 | |
| 226 | 377 | 226 | 569.27 | 3412.6 | 2843.33 | 377 | |
| 120 | 528 | 120 | 797.28 | 1812 | 1014.72 | 0 | |
| 238 | 408 | 238 | 616.08 | 3593.8 | 2977.72 | 377 | |
| 320 | 547 | 320 | 825.97 | 4832 | 4006.03 | 0 | |
| 347 | 227 | 227 | 342.77 | 3427.7 | 3084.93 | 377 | |
| 377 | 377 | 377 | 569.27 | 5692.7 | 5123.43 | 377 | |
| 407 | 377 | 377 | 569.27 | 5692.7 | 5123.43 | 377 | |
| 453 | 377 | 377 | 569.27 | 5692.7 | 5123.43 | 377 | |
| 271 | 377 | 271 | 569.27 | 4092.1 | 3522.83 | 377 | |
| 528 | 483 | 483 | 729.33 | 7293.3 | 6563.97 | 0 | |
| 604 | 0 | 0 | 0 | 0 | 0 | 377 | |
| 755 | 377 | 377 | 569.27 | 5692.7 | 5123.43 | 377 | |
| 6909 | $13,067.54 | $104,325.90 | $91,258.36 | 6786 | |||
| Key | |||||||
| Yellow values are given | |||||||
| Blue values are calculated | |||||||
| Red value can be manipulated. | |||||||
| Green Values are totals. | |||||||
This table was created by a free Excel macro written by Charles Balch.
Here's the code. It is care ware - it's yours for free if do something nice for anyone (anyone includes you).