Ask Question
18 November, 17:23

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. Prepare a production budget for the months of April, May, and June.

+2
Answers (1)
  1. 18 November, 17:30
    0
    Instructions are below.

    Explanation:

    Giving the following information:

    Sales:

    April = 500

    May = 580

    June = 540

    July = 620

    Finished goods inventory on April 1 is 190 units

    Desired ending inventory = 25% next month sales.

    To calculate the production for each month, we need to use the following formula:

    Production = sales + desired ending inventory - beginning inventory

    April:

    Sales = 500

    Desire ending inventory = (580*0.25) = 145

    Beginning inventory = (190)

    Total production = 455 units

    May:

    Sales = 580

    Desire ending inventory = (540*0.25) = 135

    Beginning inventory = (145)

    Total production = 570 units

    June:

    Sales = 540

    Desire ending inventory = (620*0.25) = 155

    Beginning inventory = (135)

    Total production = 560 units
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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 ...” 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