Question

Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 25% of next month's sales in ending inventory. On January 1, it is expected that there will be 6,700 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month as well as for the quarter in total. Patrick Inc. Production Budget For the Coming Quarter January February March 1st Quarter Total Sales Desired ending inventory Total needs Less: Beginning inventory Units to be produced

Answer 1

Answer:

$135,010

Explanation:

Duration

January

February

March

Expected Sales

41,000

38,000

50,000

Add: Ending Inventory

(21%×38,000) 7,980

(21%×50,000) 10,500

(21%×51,000) 10,710

Less:Beginning Inventory

4,700

7,980

10,500

Units to be Produce

(7,980-4,700)+41,000=44,280

(10,500-7,980)+38,000=40,520

(10,710-10,500)+50,000= 50,210

Quarter in Total $135,010