Question

Question 13 (3 points) A company has a sales forecast for the following five months as shown in the table. If they have a beginning inventory of 225 units, what amount should be produced under a level plan in order for them to have an ending inventory of zero units at the end of the five month period? Month Forecast 825 600 650 550 475 anua Febru March A) 595 units per month 580 units per month 575 units per month D) 585 units per month

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

Total sales forecast of five months = 825+600+650+550+475 = 3100 units

Net sales forecast = Total sales forecast - beginning inventory = 3100-225 = 2875

Level production quantity = 2875/5 = 575 units per month

ANSWER: C) 575 units per month

Add a comment
Know the answer?
Add Answer to:
Question 13 (3 points) A company has a sales forecast for the following five months as...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • please show work A company has a sales forecast for the following five months as shown in the table. If they have a...

    please show work A company has a sales forecast for the following five months as shown in the table. If they have a beginning inventory of 225 units, what amount should be produced under a level plan in order for them to have an ending inventory of zero units at the end of the five-month period? Month Forecast January 825 February 600 March April May 650 550 475 A. 595 units per month B. 575 units per month C. 580...

  • Question 3 What is the ending inventory level for April in the production plan shown in...

    Question 3 What is the ending inventory level for April in the production plan shown in the table? All entries in the table are in terms of sales units. Regular Overtime Ending Month Forecast Production Production 300 500 300 325 400 25 25 A) 100 Units B) 125 Units C) 150 Units D) 75 Units Question 4: A company has a sales forecast for the following five months as shown in the table. If they have a beginning inventory of...

  • Ruiz Co provides the following sales forecast for the next four months. Sales (units) April 550...

    Ruiz Co provides the following sales forecast for the next four months. Sales (units) April 550 May 630 June 580 July 670 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 220 units. Prepare a production budget for the months of April, May, and June. + RUIZ CO. Production Budget For April, May, and June April Next month's budgeted sales (units) 630...

  • 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) 550 630 580 670 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 110 units. Prepare a production budget for the months of April, May, and June. UINUATIV Wants to end each month with ending finished goods inventory equal to 209 goods inventory on...

  • 5.00 points Hospitable Co. provides the following sales forecast for the next four months: April May...

    5.00 points Hospitable Co. provides the following sales forecast for the next four months: April May June July 500 580 540 620 Sales (units) The company wants to end each month with ending finished goods inventory equal to 25% of next month's sales. Finished goods inventory on April 1 is 190 units. Assume July's budgeted production is 540 units. Prepare a production budget for the months of April, May, and June HOSPITABLE CO. Production Budget For April, May, and June...

  • Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 500...

    Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 500 May 580 June 540 July 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. RUIZ CO. Production Budget For April, May, and June April Next month's budgeted sales (units) 580 Ratio...

  • Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 500...

    Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 500 May 580 June 540 July 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. RUIZ CO. Production Budget For April, May, and June April Next month's budgeted sales (units) 580 Ratio...

  • Required information Ruit Co provides the following sales forecast for the next four months Sales unita) April 350...

    Required information Ruit Co provides the following sales forecast for the next four months Sales unita) April 350 May 630 June 580 July 670 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 165 units. Assume July's budgeted production is 580 units. In addition, each finished unit requires four pounds (lbs) of raw materials and the company wants to end each month...

  • Check my work Ruiz Co. provides the following sales forecast for the next four months. Sales...

    Check my work Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 500 May 580 June 540 July 620 0.66 points 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. eBook Prepare a production budget for the months of April, May, and June. Hint Print References RUIZ CO. Production Budget For April, May, and...

  • Hospitable Co. provides the following sales forecast for the next four months: April May June July...

    Hospitable 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 sales. Finished goods inventory on April 1 is 190 units. Assume July’s budgeted production is 540 units. Prepare a production budget for the months of April, May, and June. HOSPITABLE CO. Production Budget For April, May, and June April Next...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT