Model 2: Production budget

You are required to prepare a production budget for 6 months ending 31 March 2010 for a factory producing four products from the following information:

Product

Estimated Stock on
30 September 2009
(Units)

Estimated Soles During
September 2009 to March 2010
(Units)

Desired Closing Stock
on 37 March 2010
(Units)

P

Q

R

S

3,500
4,500

5,000
6,500

12,500
16,500

20,000
23,500

4,500
5,500

4000
3,500