Question

In: Accounting

14 Kyoto, Inc. predicts the following sales in units for the coming four months: April May...

14 Kyoto, Inc. predicts the following sales in units for the coming four months:
April May June July
Sales in units.......... 240 280 300 240
Although each month's ending inventory of finished units should be 60% of the next month's sales, the March 31 finished goods inventory is only 100 units. A finished unit requires four pounds of raw material B. The March 31 raw materials inventory has 200 pounds of B. Each month's ending inventory of raw materials should be 30% of the following month's production needs. The budgeted purchases of pounds of raw material B during May should be:
A. 283 lb. B. 1134.4 lb C. 1,418 lb D. 1,460 lb E. 1,502 lb

Solutions

Expert Solution

Schedule of Production
For the month of May

Particulars

May

Budgeted sales unit

280

Add: Desired ending inventory (300*60%)

180

Total

460

Less: Beginning inventory (280*60%)

168

Production during May (units)

292

Schedule of budgeted purchases of raw materials
For the month of May

Particulars

May

Raw material required for Budgeted production(292*4 pounds)

1,168

Add: Desired ending inventory [(300+240*60%-180)*4*30%]

316.80

Total

1,484.80

Less: Beginning inventory (1168*30%)

(350.40)

Budgeted purchase (lb)

1,134.40

Option B. is correct answer.


Related Solutions

1.Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,900 units;...
1.Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,900 units; October, 4,900 units; November, 6,900 units; and December, 8,200 units. The company’s policy is to maintain finished goods inventory equal to 60% of the next month’s sales. At the end of August, the company had 2,700 finished units on hand. Prepare a production budget for each of the months of September, October, and November. 2.asper Company has sales on account and for cash. Specifically,...
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 690 770 720 810 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 207 units. Assume July's budgeted production is 720 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 690 770 720 810 The company wants to end each month with ending finished goods inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 276 units. Assume July's budgeted production is 720 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 620 700 650 740 The company wants to end each month with ending finished goods inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 248 units. Assume July's budgeted production is 650 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 680 760 710 800 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 136 units. Assume July's budgeted production is 710 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 570 650 600 690 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 171 units. Assume July's budgeted production is 600 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June July Sales (units) 600 680 630 720 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 180 units. Prepare a production budget for the months of April, May, and June. 2. Zira Co. reports the following production budget for the next four months. April May June...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 630 710 660 750 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 189 units. Assume July's budgeted production is 660 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
Wheat Inc. has forecast its sales for the coming months as follows: Standard Units Deluxe Units...
Wheat Inc. has forecast its sales for the coming months as follows: Standard Units Deluxe Units April 110 70 May 126 87 June 143 94 July 160 108 Wheat maintains finished goods inventory equal to 30% of the next month’s sales requirements. April 1 inventories were 33 standard units and 21 deluxe. Required: Prepare a production schedule for April through June. (Round your answers to the nearest whole number and use rounded values for your intermediate calculations.)
Claire Inc. predicts sales of 4,000 frames in May & 14,000 units in June. Target end...
Claire Inc. predicts sales of 4,000 frames in May & 14,000 units in June. Target end of month finished-goods inventory is 10% of next month’s sales. The company wants RM ending inventory to cover 20% of next month’s needs. The frames each require 2 pieces of trim to manufacture and each trim costs $3 per piece. The frames also require three hours of labor. The direct labor rate is $10 per hour. 1.) If June’s budgeted production = 6,000 frames....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT