Budgeted Selling Expenses Sales Commission Freight-out Total Selling Expenses Budgeted Administrative Expenses Office Rent Office Salaries Office Supplies Miscellaneous Expenses Total Administrative Expenses Total Selling & Admin. Expenses 7 ferer netrerer Sales Commission Freight-out Office Rent Office Salaries Office Supplies Miscellaneous Expenses 4/28/23 $ $ Healthy Living M Selling and Administra For the Year Ending December 31, 2021 $ 4,620,000 $ 3,239,000 $ 7,859,000 $ 1,600,000 1,000,000 $ 552,000 $ 700,000 $ 3,852,000 $ $ 11,711,000 $ Percentages 5% 10% 15% 7% 3% 4% 2022 - $ $ $ Yea 2023 otorcycles, Inc. tive Expense Budget 2021 and Five Year Projections ir $ $ $ 2024 - $ $ $ 2025 $ $ $ 2026 7 terer frea

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter12: Balanced Scorecard And Other Performance Measures
Section: Chapter Questions
Problem 2EB: For the following descriptions, state whether the cost is controllable or uncontrollable by...
icon
Related questions
Question
100%

Hi, please help :)

Use the appropriate mixed cell references and relative references to reflect the percentages in range A22:B27 to determine the projected expenses for each of the Budgeted Selling and Budgeted Administrative Expenses for the year of 2022.

5
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
A
Budgeted Selling Expenses
Sales Commission
Freight-out
Total Selling Expenses
Budgeted Administrative Expenses
Office Rent
Office Salaries
Office Supplies
Miscellaneous Expenses
Total Administrative Expenses
Total Selling & Admin. Expenses
Sales Commission
Freight-out
Office Rent
Office Salaries
Office Supplies
Miscellaneous Expenses
TO Header
4/28/23
B
$
$
$
2021
Healthy Living M
Selling and Administrat
For the Year Ending December 31,
4,620,000
3,239,000
7,859,000 $
1,600,000
1,000,000
552,000
700,000
$
$
$
$
$ 3,852,000 $
$ 11,711,000 $
Percentages
5%
10%
15%
7%
3%
4%
2022
$
$
D
$
Yea
2023
-
ir
otorcycles, Inc.
tive Expense Budget
2021 and Five Year Projections
$
$
E
$
2024
$
$
F
$
2025
-
-
$
$
$
G
2026
H
Transcribed Image Text:5 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 A Budgeted Selling Expenses Sales Commission Freight-out Total Selling Expenses Budgeted Administrative Expenses Office Rent Office Salaries Office Supplies Miscellaneous Expenses Total Administrative Expenses Total Selling & Admin. Expenses Sales Commission Freight-out Office Rent Office Salaries Office Supplies Miscellaneous Expenses TO Header 4/28/23 B $ $ $ 2021 Healthy Living M Selling and Administrat For the Year Ending December 31, 4,620,000 3,239,000 7,859,000 $ 1,600,000 1,000,000 552,000 700,000 $ $ $ $ $ 3,852,000 $ $ 11,711,000 $ Percentages 5% 10% 15% 7% 3% 4% 2022 $ $ D $ Yea 2023 - ir otorcycles, Inc. tive Expense Budget 2021 and Five Year Projections $ $ E $ 2024 $ $ F $ 2025 - - $ $ $ G 2026 H
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Determination of Tax Liability
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning