Question

Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company’s products. The company is now planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements:
a.
The finished goods inventory on hand at the end of each month must be equal to 4,000 units of Supermix plus 25% of the next month’s sales. The finished goods inventory on June 30 is budgeted to be 21,250 units.

b.
The raw materials inventory on hand at the end of each month must be equal to one-half of the following month’s production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 88,000 cc of solvent H300.

c. The company maintains no work in process inventories.
A sales budget for Supermix for the last six months of the year follows.
Budgeted Sales
in Units
July 69,000
August 74,000
September 84,000
October 64,000
November 54,000
December 44,000

Required:

1.
Prepare a production budget for Supermix for the months July, August, September, and October.



2.
Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total.

Answer 1

Answer:

Pearl Products Limited of Shenzhen, China

Finished Goods Production Budget

For the months of     July      August    Sept      October   November     Dec

Units required to        51,750    55500    63,000   48,000    40,500   33,000

meet Sales budget

Desired Ending          22,500   37,600   20,000   17,500    15,000    *15,000*

Inventory

Total Units Req.         74,500    93,100    83,000   65,500    55,500   48,000

Less Estimated

Beg. Inventory            21,250     22,500    37,600    20,000  17,500    15,000

Planned Production   53,250    70,600     45,400  45,500  38,000  33,000

Explanation:

Working Notes:

Units required to meet Sales budget is calculated by multiplying 3/4 of the given months sales as 25 % of it is already included in that months opening inventory . For example July's unit required to meet sales budget would be 69,000 * 3/4= 51,750

Each month's beginning inventory is previous month's ending inventory

As no data for sales budget of January is given the desired ending inventory is taken on the basis of previous months desired inventory.

Pearl Products Limited of Shenzhen, China

Direct Materials Budget

For the months of     July      August    Sept      October   November     Dec

Units to Meet

Production Budget   159,750  211,800  136,200 136,500  114,000

Desired Ending         105,900  68,100    68,250   57,000    49,500

Inventory

Less Beginning

Inventory                   88,000   105,900   68,100    68,250    57,000

Direct Materials

Budget                     177,650     174,000   136,350   125,250  106,500

Explanation:

Working Notes:

Each finished goods units requires 3 units of direct material . The units to meet the production budget are estimated by multiplying them with 3. for example the July Production budget is 53,250 so it is multiplied with 3 to get the direct material required and 53,250 *3= 159,750