Question

Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months...

Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows:

Unit Sales
April 180,000
May 220,000
June 200,000
July 240,000

Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pumps is only 21,000.

Required:

Prepare a production budget for the second quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.

Aqua-pro Inc.
Production Budget
For the Second Quarter
April May June Total
Sales
Desired ending inventory
Total needs
Less: Beginning inventory
Units produced
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Sales ADD: desired Ending inventory Total Needed Less: Beginning inventory Units Needed to produce Aqua Pro Inc Production Bu

Add a comment
Know the answer?
Add Answer to:
Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months...

    Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April 180,000 May 220,000 June 200,000 July 240,000 Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pump is only 21,000. Required: Prepare a production budget for the second quarter of...

  • ABC Company produces water pumps. The unit sales for the first four months of the year...

    ABC Company produces water pumps. The unit sales for the first four months of the year for this product are as follows: Unit Sales: January 162,000 February 198,000 March 180,000 April 216,000 Company maintains ending inventory for each month at 25% of next month's sales. However, at the beginning of January, due to greater sales in December than anticipated, the beginning inventory for January is   18,900 Required: a) Compute the total number of units that should be produced for the...

  • Garden Space Novelties, Inc. budgeted the sales of their latest garden decoration as follows: Unit Sales...

    Garden Space Novelties, Inc. budgeted the sales of their latest garden decoration as follows: Unit Sales April.........................7,000 May..........................6,000 June.......................14,000 July.........................12,000 The desired ending inventory must equal 10% of the next month's sales. The inventory at the end of March was 2,000 units. Prepare a production budget for the second quarter by month and in total for the quarter.

  • ted Sites (2) - Suggested Sites (2) - Suggested Sites e Web Slice Gallery HW7 Sales...

    ted Sites (2) - Suggested Sites (2) - Suggested Sites e Web Slice Gallery HW7 Sales (units) April May 700 780 June 730 July 820 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 280 units. Prepare a production budget for the months of April, May, and June. efloor Print References May June 70820 780 RUIZ CO. Production Budget For April May,...

  • 1 Unit Sales April May 74,000 85,000 114,000 June July 92,000 The company is now in...

    1 Unit Sales April May 74,000 85,000 114,000 June July 92,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end- month inventory levels must equal 10 % of the following month's unit sales. The inventory at the end of March was 7,4000 units. Required: Prepare a production budget by month and in total, for the second quarter Down Under Products, Ltd., Production Budget April May June Quarter...

  • Zira Co. reports the following production budget for the next four months. April July 607 May June Production (units) 5...

    Zira Co. reports the following production budget for the next four months. April July 607 May June Production (units) 594 635 627 Each finished unit requires four pounds of raw materials and the company wants to end each month with raw materials inventory equal to 20% of next month's production needs. Beginning raw materials inventory for April was 475 pounds. Assume direct materials cost $4 per pound. Prepare a direct materials budget for April, May, and June. (Round your intermediate...

  • Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows...

    Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: April May Sales in Units 72,000 85,000 112,000 91,000 June July The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 20% of the following month's sales. The inventory at the end of March was 14,400 units. Required: Prepare a production budget for the...

  • Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows:...

    Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Unit Sales April 52,000 May 75,000 June 92,000 July 81,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 15% of the following month’s unit sales. The inventory at the end of March was 7,800 units. Unit Sales April 52,000 May 75,000 June...

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

    Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 560 May 640 June 590 July 680 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 112 units. Prepare a production budget for the months of April, May, and June. The company wants to end each month with ending finished goods inventory equal to 20% of next...

  • Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March...

    Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 28,000 April 30,000 May 27,500 June 26,000 Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $5 per unit and are paid for in the month after production. Labor cost is $9 per unit and is paid...

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