Ask Question
11 November, 05:34

The company wants to end each month with ending finished goods inventory equal to 25% of next month's forecasted sales. Finished goods inventory on April 1 is 190 units. Prepare a production budget for the months of April, May, and June.

+2
Answers (1)
  1. 11 November, 07:09
    0
    Complete Question:

    Ruiz Co. provides the following sales forecast for the next four months:

    April May June July

    Sales (units) 500 580 540 620

    The company wants to end each month with ending finished goods inventory equal to 25% of next month's forecasted sales. Finished goods inventory on April 1 is 190 units. Assume July's budgeted production is 540 units. In addition, each finished unit requires five pounds (lbs.) 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 663 pounds. Assume direct materials cost $4 per pound.

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

    Solution:

    Plan for production is the calculation or forecast of the number of units to be produced by the company to balance the expected revenue or plan inventory and stocks.

    Prepare the production Bud:

    Company R

    Production Budget

    For the months of April, May and June

    Particulars (In units) April May June

    Next month's budgeted sales (units) 580 540 620

    Ratio of inventory to future sales 25% 25% 25%

    Budgeted ending inventory (units) 145 135 155

    Budgeted unit sales for month 500 580 540

    Required units of available production 645 715 695

    Budgeted beginning inventory (units) (190) (145) (135)

    Units to be produced 455 570 560
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “The company wants to end each month with ending finished goods inventory equal to 25% of next month's forecasted sales. Finished goods ...” in 📘 Business if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers