1 2 INCOME STATEMENT 3 Net sales 15 BALANCE SHEET 16 ASSETS 17 Cash and marketable securities 18 Accounts receivable 19 Inventory 20 Current assets A Land, buildings, plant, and 21 equipment 22 Accumulated depreciation 23 Net fixed assets O AVERAGE(F19:G19)*B3 none of the answers is correct. =E18*B3 =E19*B24 B O AVERAGE(F19:G19)*B24 2020 $452,500 ? 2020 с $ VALUES 2019 $390,000 2019 $37,974 10,000 D E F PERCENT OF SALES 2019 2018 % AVERAGE $327 Close find bar 00.00% 2018 % AVERAGE $154,550 28.46% 6,000 2.20% 250,000 135,000 52.66% $297,974 $295,550 83.32% $250,000 $125,000 51.14% 64.10% 38.17% 50,000 25,000 10.23% 12.82% 7.63% $200,000 $100,000 40.91% 51.28% 30.53% 24 Total assets $497,974 $395,550 124.23% 127.69% 120.78% If you apply the percent of sales method to the balance sheet shown above, what is the formula in B19 to forecast the Inventory for 2020? 100.00% 2019 9.74% 2.56% 64.10% 76.40% G 2018 100.00% 2018 47.19% 1.83% 41.22% 90.24%

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)
22nd Edition
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:James A. Heintz, Robert W. Parry
Chapter15: Financial Statements And Year-end Accounting For A Merchandising Business
Section: Chapter Questions
Problem 4CE
icon
Related questions
Topic Video
Question
1
2 INCOME STATEMENT
3 Net sales
15 BALANCE SHEET
16 ASSETS
17 Cash and marketable securities
18 Accounts receivable
19 Inventory
20 Current assets
A
Land, buildings, plant, and
21 equipment
22 Accumulated depreciation
23 Net fixed assets
=AVERAGE(F19:G19)* B3
none of the answers is correct.
=E18*B3
O=E19*B24
B
O=AVERAGE(F19:G19)*B24
2020
$452,500
?
2020
с
$ VALUES
2019
$390,000
2019
D
E
$37,974 $154,550
10,000
6,000
250,000 135,000
$297,974 $295,550
$250,000 $125,000
F
PERCENT OF SALES
2019
100.00%
2019
2018 % AVERAGE
$327 Close find bar 0.00%
2018 % AVERAGE
28.46%
2.20%
52.66%
83.32%
51.14%
64.10%
38.17%
50,000
25,000
10.23%
12.82%
7.63%
$200,000 $100,000
40.91%
51.28%
30.53%
24 Total assets
$497,974 $395,550 124.23% 127.69% 120.78%
If you apply the percent of sales method to the balance sheet shown above, what is the formula in B19 to forecast the
Inventory for 2020?
9.74%
2.56%
64.10%
76.40%
G
2018
100.00%
2018
47.19%
1.83%
41.22%
90.24%
Transcribed Image Text:1 2 INCOME STATEMENT 3 Net sales 15 BALANCE SHEET 16 ASSETS 17 Cash and marketable securities 18 Accounts receivable 19 Inventory 20 Current assets A Land, buildings, plant, and 21 equipment 22 Accumulated depreciation 23 Net fixed assets =AVERAGE(F19:G19)* B3 none of the answers is correct. =E18*B3 O=E19*B24 B O=AVERAGE(F19:G19)*B24 2020 $452,500 ? 2020 с $ VALUES 2019 $390,000 2019 D E $37,974 $154,550 10,000 6,000 250,000 135,000 $297,974 $295,550 $250,000 $125,000 F PERCENT OF SALES 2019 100.00% 2019 2018 % AVERAGE $327 Close find bar 0.00% 2018 % AVERAGE 28.46% 2.20% 52.66% 83.32% 51.14% 64.10% 38.17% 50,000 25,000 10.23% 12.82% 7.63% $200,000 $100,000 40.91% 51.28% 30.53% 24 Total assets $497,974 $395,550 124.23% 127.69% 120.78% If you apply the percent of sales method to the balance sheet shown above, what is the formula in B19 to forecast the Inventory for 2020? 9.74% 2.56% 64.10% 76.40% G 2018 100.00% 2018 47.19% 1.83% 41.22% 90.24%
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning