Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Production Budget Aqua-Pro Inc. produces submersible water pumps for ponds and distors. The unit sales for selected months of the year are as follows: Unit

image text in transcribed
image text in transcribed
image text in transcribed
Production Budget Aqua-Pro Inc. produces submersible water pumps for ponds and distors. The unit sales for selected months of the year are as follows: Unit Sales April 207,000 May 253,000 June 230,000 July 276,000 Company policy requires that ending inventories for each month be 20% 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 20,000. This information has been collected in the Microsoft Excel Online fide. Open the spreadsheet, perform the required analysis, and input your answers in the questions below, TA Open spreadsheet 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 Q2 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 Q2 Sales 207,000 253,000 230,000 690,000 Desired ending inventory S0,000 46,000 55,200 189,750 X Total 270,250 X 310,500 x needs 299,000 X 879,750 X Lees 20,000 63,250 X Beginning Inventory 57,500 X 161,750 X Units produced 249,250 X 247,250 X 241,500 x 738,000 X Tamilies Oh My W Consider units to be sold and desired levels of beginning and ending inventory. Production Budget Aqua-Pro Inc. produces submersible water pumps for ponds and disterns. The unit sales for selected months of the year are as follows: Unit Sales April 207.000 253,000 May June 230,000 July 276,000 Company policy requires that ending Inventories for each month be 20% 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 20,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perfor the required analysis, your answers in the questions below Open spreadsheet Required: Prepare a production budget for the second quarter of the year. Show 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 92

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Padhukas Students Handbook On Auditing And Assurance Including Multiple Choice Questions For CA Inter

Authors: CA G. Sekar, CA B Saravana Prasath

18th Edition

9390303087, 978-9390303083

More Books

Students also viewed these Accounting questions

Question

6. Compare and contrast immune neglect and the focusing illusion.

Answered: 1 week ago