Managerial Accounting Problem

Production Budget - Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout Southeast Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the companys products. To keep production and sales moving smoothly, the company has the following inventory requirements:

1. The finished goods inventory on hand at the end of each month must equal 2,000 units of Supermix plus 25% of the next months sales. The finished goods inventory on June 30 is budgeted to be 12,750 units.
2. The company maintains no work in process inventories.

A monthly sales budget for Supermix for the third and fourth quarters of the year follows.

	Budgeted Unit Sales
July	61,000
August	66,000
September	76,000
October	56,000
November	46,000
December	36,000

Requirements:

1) Use excel and show work, identify how answers were found

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

3) Examine the Production Budget that you prepared in (2) above. Why will the company produce more units than it sells in July and August, and fewer units than it sells in September and October?