Question

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) 640 720 670 760


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 128 units.

Prepare a production budget for the months of April, May, and June.

RUIZ CO.
Production Budget
For April, May, and June
April May June
Next month's budgeted sales (units) 720 670 760
Ratio of inventory to future sales 20% 20% 20%
Budgeted ending inventory (units) 144 134 152
Budgeted unit sales for month 640 720 670
Required units of available production 784 854 822
Budgeted beginning inventory (units)
Units to be produced

Homework Answers

Answer #1

Let me know if u have any conerns.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for...
Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 610 690 640 730 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 122 units. Assume July's budgeted production is 640 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and...
Required information Use the following information for the Exercises below. Ruiz Co. provides the following sales...
Required information Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 650 730 680 770 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 130 units. Assume July's budgeted production is 680 units. In addition, each finished unit requires six pounds (lbs.) of raw...
Ramos Co. provides the following sales forecast and production budget for the next four months: April...
Ramos Co. provides the following sales forecast and production budget for the next four months: April May June July Sales (units) 670 750 700 770 Budgeted production (units) 610 740 710 710 The company plans for finished goods inventory of 290 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 20% of next month’s production needs. Beginning direct...
Tyler Co. Production Budget April, May and June April May June Next month’s budgeted sales (units)...
Tyler Co. Production Budget April, May and June April May June Next month’s budgeted sales (units) % % % 0 0 0 Units to be produced 0 0 0 Tyler Co. predicts the following unit sales for the next four months: April, 3,600 units; May, 4,700 units; June, 6,700 units; and July, 3,000 units. The company’s policy is to maintain finished goods inventory equal to 20% of the next month’s sales. At the end of March, the company had 700...
Ramos Co. provides the following sales forecast and production budget for the next four months. April...
Ramos Co. provides the following sales forecast and production budget for the next four months. April May June July Sales (units) 530 610 560 630 Budgeted production (units) 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 320 360 380 320 Each month's ending Finished Goods Inventory should be 40% of the next month's sales. March 31 Finished Goods inventory is 128 units. A finished unit requires 5 pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 280 pounds of B. Each month's ending Raw Materials Inventory...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 410 450 470 410 Each month's ending Finished Goods Inventory should be 30% of the next month's sales. March 31 Finished Goods inventory is 123 units. A finished unit requires 5 pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 260 pounds of B. Each month's ending Raw Materials Inventory...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in units 240 280 300 240 Each month's ending Finished Goods Inventory in units should be 40% of the next month's sales. March 31 Finished Goods inventory is 96 units. A finished unit requires five pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 200 pounds of direct material B. Each month's...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 420 460 480 420 Each month's ending Finished Goods Inventory should be 40% of the next month's sales. March 31 Finished Goods inventory is 168 units. A finished unit requires 5 pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 270 pounds of B. Each month's ending Raw Materials Inventory...
2. Zira Co. reports the following production budget for the next four months. April May June...
2. Zira Co. reports the following production budget for the next four months. April May June July Production (units) 656 710 688 668 Each finished unit requires six pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month’s production needs. Beginning raw materials inventory for April was 1,181 pounds. Assume direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your...