| Q1 | Q2 | Q3 | Q4 | |||||||
| Sales in units | 10,000 | 12,000 | 14,000 | 16,000 | ||||||
| Desired finished goods in units | 3,000 | 3,500 | 4,000 | |||||||
| Total demand | 13,000 | 15,500 | 18,000 | |||||||
| Less beginning inventory | (2,500) | (3,000) | (3,500) | |||||||
| Finished production required | 10,500 | 12,500 | 14,500 | |||||||
| Raw material qty per unit of production | 4 | 4 | 4 | |||||||
| Raw material required for production | 42,000 | 50,000 | 58,000 | |||||||
| Desired raw material inventory in lbs. | 5,000 | 5,800 | ||||||||
| Total raw material required | 47,000 | 55,800 | ||||||||
| Beginning raw material inventory | (4,200) | (5,000) | ||||||||
| Raw material purchases required | 50,800 | |||||||||