Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows:
Sales in Units
April 54,000
May 75,000
June 94,000
July 82,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 20% of the following month’s sales. The inventory at the end of March was 10,800 units. Required: Prepare a production budget for the second quarter; in your budget, show the number of units to be produced each month and for the quarter in total.
down under products Ltd.
prodcution budget
april may june other
budgeted unit sales
total needs
required production in units

Respuesta :

Answer:

Results are below.

Explanation:

Giving the following information:

Sales in Units

April 54,000

May 75,000

June 94,000

July 82,000

Desired ending inventory= 20% of the following month’s sales.

The inventory at the end of March was 10,800 units.

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

Production= sales + desired ending inventory - beginning inventory

April:

Sales= 54,000

Ending inventory= 75,000*0.2= 15,000

Beginning inventory= (10,800)

Total= 58,200 units

May:

Sales= 75,000

Ending inventory= 94,000*0.2= 18,800

Beginning inventory= (15,000)

Total= 78,800 units

June:

Sales= 94,000

Ending inventory= 82,000*0.2= 16,400

Beginning inventory= (18,800)

Total= 91,600 units

Total for the quarter= 228,600 units

In the above case, Sales in Units in the month of April is 54,000, in the month of May is 75,000, in the month of June is 94,000 and in the month of July is 82,000.

What is sales?

A sale is defined as a transaction between the parties in which the purchaser acquires goods, services, or assets in return for money. In some cases, other assets are pay off to a seller.

Computation of production:

According to the available information,

Desirable closing inventory= 20% of the following month’s sales.

The inventory at the end of March was 10,800 units.

To calculate the production in each month, the formula is:

[tex]\text{Production= Sales + Desired Ending Inventory - Beginning Inventory}[/tex]

Production in the month of April:

According to the given information,

Sales= 54,000

Ending inventory:

[tex]=75,000\times \dfrac{20}{100}\\= 15,000[/tex]

Beginning inventory= 10,800

Now, apply the given values in the above formula:

[tex]\text{Production= Sales + Desired Ending Inventory - Beginning Inventory}\\\\\text{Production} =54,000+15,000-10,800\\\\\text{Production}=58,200\text{Units}[/tex]

Production in the month of May:

Sales= 75,000

Ending inventory:

[tex]=94,000\times \frac{20}{100}\\\\= 18,800[/tex]

Beginning inventory= 15,000

Now, apply the given values in the above formula:

[tex]\text{Production= Sales + Desired Ending Inventory - Beginning Inventory}\\\\\text{Production} =75,000+18,800-15,000\\\\\text{Production}=78,800\text{Units}[/tex]

Production in the month of June:

Sales= 94,000

Ending inventory:

[tex]872,000\times\dfrac{20}{100}= 16,400[/tex]

Beginning inventory= 18,800

Now, apply the given values in the above formula:

[tex]\text{Production= Sales + Desired Ending Inventory - Beginning Inventory}\\\\\text{Production} =94,000+16,400-18,800\\\\\text{Production}=91,600\text{Units}[/tex]

Therefore, the Total for the quarter :

[tex]=\text{May's Production + June's Production+Juily's Production}\\\\=58,200+78,800+91,600 \text{Units}\\= 228,600 \text{Units}[/tex]

Learn more about sales, refer to:

https://brainly.com/question/16911495