Hi, I need help solving for the remaining values (cells highlighted red require input; white numerical cells are dynamic). Thank you.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Hi,

I need help solving for the remaining values (cells highlighted red require input; white numerical cells are dynamic).

Thank you.

Down Under Products, Limited, of Australia has budgeted sales of its popular boomerang for the next four months as follows:
April
May
June
July
Unit Sales
72,000
85,000
112,000
91,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 unit sales. The inventory at the end of March was 14,400 units.
Required:
Prepare a production budget by month and in total, for the second quarter.
> Answer is complete but not entirely correct.
Down Under Products, Limited,
Production Budget
April
72,000
Budgeted unit sales
Add: Desired units of ending finished goods inventory
Total needs
Less: Units of beginning finished goods inventory
Required production in units
72,000
72,000
X
X
May
85,000✔✓
85,000
85,000
X
X
June
112,000 ✓
X
112,000
112,000
X
Quarter
269,000
269,000
269,000
Transcribed Image Text:Down Under Products, Limited, of Australia has budgeted sales of its popular boomerang for the next four months as follows: April May June July Unit Sales 72,000 85,000 112,000 91,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 unit sales. The inventory at the end of March was 14,400 units. Required: Prepare a production budget by month and in total, for the second quarter. > Answer is complete but not entirely correct. Down Under Products, Limited, Production Budget April 72,000 Budgeted unit sales Add: Desired units of ending finished goods inventory Total needs Less: Units of beginning finished goods inventory Required production in units 72,000 72,000 X X May 85,000✔✓ 85,000 85,000 X X June 112,000 ✓ X 112,000 112,000 X Quarter 269,000 269,000 269,000
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Techniques of Time Value Of Money
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education