Question: Please show all steps and calculations so I can learn how to do it. Thanks Required information ABC Co. provides the following sales forecast for

Please show all steps and calculations so I can learn how to do it. Thanks Please show all steps and calculations so I can learn how to

Required information ABC Co. provides the following sales forecast for the next four months: July 750 May 710 June April 660 Sales (units) 630 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 materials inventory equal to 40 % of next month's production needs. Beginning raw materials inventory for April was 1,046 pounds. Assume direct materials cost $4 per pound. Prepare a production budget for the months of April, May, and June. . Production Budget For April, May, and June May April June Next month's budgeted sales (units) 710 660 750 Ratio of inventory to future sales 30% Budgeted ending inventory (units) Budgeted unit sales for month Required units of available production Budgeted beginning inventory (units) Units to be produced

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f