X AutoSave Off 8 BETA Gradable Excel_ Brief Exercise 9.3_ SUM, Subtract, Multiply, Cell Referencing 2 evalresponse p Search (Alt+Q) Ashley File Home Insert Page Layout Formulas Data Review View Help P Comments 8 Share 明閱 AutoSum O Fill - Liberation Sans - 12 - A A = = * Wrap Text Custom BIU- H $ - % 9 8 Paste A E Merge & Center - Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting Table Styles O Clear Filter Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis E10 JKL N A D FG N Q R TA Function: SUM; Formula: Subtract, Multiply; Cell Referencing Using Excel to Prepare a Production Budget Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Quarter 1 sales Paige Company Production Budget 10,000 14,000 15,000 18,000 Quarter 2 sales Quarter 3 sales For the Six Months Ending June 30, 2022 Quarter 4 sales Quarter 1 Quarter 2 Six Months Desired ending finished goods inventory based on next quarter's expected unit sales Unit selling price Expected unit sales 10,000 14,000 25% $ 70.00 Add: Desired ending finished goods units 3,500 3,750 7 Prepare a production budget by quarters for the first 6 months s of 2022. 13,500 17,750 Total required units Less: Beginning finished goods units 2,500 3,500 Required production units 11,000 14,250 25,250 Summary Enter Answer eady Accessibility: Investigate 100%
X AutoSave Off 8 BETA Gradable Excel_ Brief Exercise 9.3_ SUM, Subtract, Multiply, Cell Referencing 2 evalresponse p Search (Alt+Q) Ashley File Home Insert Page Layout Formulas Data Review View Help P Comments 8 Share 明閱 AutoSum O Fill - Liberation Sans - 12 - A A = = * Wrap Text Custom BIU- H $ - % 9 8 Paste A E Merge & Center - Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting Table Styles O Clear Filter Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis E10 JKL N A D FG N Q R TA Function: SUM; Formula: Subtract, Multiply; Cell Referencing Using Excel to Prepare a Production Budget Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Quarter 1 sales Paige Company Production Budget 10,000 14,000 15,000 18,000 Quarter 2 sales Quarter 3 sales For the Six Months Ending June 30, 2022 Quarter 4 sales Quarter 1 Quarter 2 Six Months Desired ending finished goods inventory based on next quarter's expected unit sales Unit selling price Expected unit sales 10,000 14,000 25% $ 70.00 Add: Desired ending finished goods units 3,500 3,750 7 Prepare a production budget by quarters for the first 6 months s of 2022. 13,500 17,750 Total required units Less: Beginning finished goods units 2,500 3,500 Required production units 11,000 14,250 25,250 Summary Enter Answer eady Accessibility: Investigate 100%
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please help me solve the red parts.
Transcribed Image Text:O Search (Alt+Q)
AutoSave
Off
BETA Gradable Excel_ Brief Exercise 9.3_ SUM, Subtract, Multiply, Cell Referencing_2_evalresponse -
Ashley
A
File
Home
Insert
Page Layout
Formulas
Data
Review
View Help
P Comments
A Share
E AutoSum
Liberation Sans
v 12
- A A
= =
ag wrap Text
Custom
Fill v
Paste
BIU V
A
= = = E E
E Merge & Center
$ • % 9 8 98
Conditional Format as
Cell
Insert Delete Format
Sort & Find &
Analyze
Formatting Table v Styles v
O Clear v
Filter v Select v
Data
Undo
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Analysis
E10
v:X v fx
C D
1 Function: SUM; Formula: Subtract, Multiply; Cell Referencing
A
В
E
F
G
H
J
K
L
N
P
R
S
T
2
3 Using Excel to Prepare a Production Budget
Student Work Area
4
PROBLEM
Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas
5 Paige Company estimates that following unit sales and desired
6 inventory level for the four quarters of the year ending
7 December 31, 2022.
with cell references to the Problem area or this work area as indicated. Use the SUM function
with cell referencing for totals.
8
Quarter 1 sales
10,000
Paige Company
Production Budget
For the Six Months Ending June 30, 2022
9
Quarter 2 sales
14,000
15,000
10
11
Quarter 3 sales
18,000
Quarter 1
10,000
12
Quarter 4 sales
Quarter 2
Six Months
Desired ending finished goods inventory
based on next quarter's expected unit sales
Unit selling price
13
Expected unit sales
14,000
14
25%
15
$ 70.00
Add: Desired ending finished goods units
3,500
3,750
16
17 Prepare a production budget by quarters for the first 6 months
18 of 2022.
Total required units
13,500
17,750
19
Less: Beginning finished goods units
2,500
3,500
20
21
Required production units
11,000
14,250
25,250
22
23
24
25
26
Summary
Enter Answer
Ready
* Accessibility: Investigate
100%
64°F
99+
6:26 PM
ENG
Cloudy
5/8/2022
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education