Pearl Products Limited of Shenzhen, China, manufactures and distributes toys thr
ID: 2561739 • Letter: P
Question
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East As a. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company's products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermx 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 equal 4,000 units of Supermix plus 20% of the next month's sales. The finished goods Inventory on June 30 is budgeted to be 11,800 units. D. The raw materials inventory on hand at the end of each month must equal one-half of the following month's production needs for raw materials. The raw materla's Inventory on June 30 is budgeted to be 60,000 cc of solvent H300. C. 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 39,000 44, 000 July ugust September 54,000 October 34,000 November 24,000 December 14,000 Required: 1 Prepare a production budget for Supemix for the months July, August, September, and October 3. Prepare a direct materia s budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total. Complete this question by entering your answers in the tabs below Required Required Prepare a production budget for Supermix for the months July, August, September, and October Production Budget Jul Budgeted unit sales Total needs Required production in units Required1Explanation / Answer
Answer:
1
Production budget
Production Budget
July
August
September
Octomber
Budgeted Sales(units)
39000
44000
54000
34000
Add: Desired ending inventory
12800
14800
10800
8800
Total Needs
51800
58800
64800
42800
Less: beginning Inventory
=( closing Of the last month)
11800
12800
14800
10800
Required production
40000
46000
50000
32000
.Working notes for the answer:
Ending inventory calculation
July
August
September
Octomber
Supermix (A)
4000
4000
4000
4000
20% of the nest month invenory (B)
8800
10800
6800
4800
Total Ending inventory (A+B)
12800
14800
10800
8800
_____________________________________________
3
Direct material Budget
July
August
September
Third quarter
Required production in units
40000
46000
50000
136000
Material (H300) needed per unit
x 3 cc
x 3 cc
x 3 cc
Production needed in CC
120000
138000
150000
408000
Add: desired inventory cc
=50% of nes month production need
69000
75000
48000
48000
Total Material H300 needed
189000
213000
198000
456000
Less: Beginning Inventory cc
=( closing Of the last month)
60,000
69000
75000
60,000
Material (H300) purchased
129,000
144,000
123,000
396,000
Production Budget
July
August
September
Octomber
Budgeted Sales(units)
39000
44000
54000
34000
Add: Desired ending inventory
12800
14800
10800
8800
Total Needs
51800
58800
64800
42800
Less: beginning Inventory
=( closing Of the last month)
11800
12800
14800
10800
Required production
40000
46000
50000
32000
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.