Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. Lonnie wants to combine the profit and loss data for 2022 from each of the three Lewellen offices. In cell E6, enter a formula

9. Lonnie wants to combine the profit and loss data for 2022 from each of the three Lewellen offices. In cell E6, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell C6 in the Charlotte:Milwaukee worksheets. Copy the formula from cell E6 to cell E7, the range E9:E11, the range E13:E15, and the range E17:E19. In the range E17:E19, copy the formula and number formatting only.

image text in transcribedI need help with what the formula is supposed to look like. Thanks!

Profit and Loss Statement For the year 2022 Stated in 000s Category Total 2021 Total Budget Total 2022 % Change from Budget $ 579,075 $ 583,888 -100.0% Revenue Cost of sales 162,890 165,135 -100.0% Payroll Salaries 143,000 143,500 -100.0% Benefits 69,780 72,526 -100.0% Taxes 38,025 38,635 -100.0% Operating Expenses Sales and marketing 50,046 50,250 -100.0% General and administrative 64,128 65,655 -100.0% 41,754 41,750 -100.0% Other operating Summary Gross profit 416,185 418,753 -100.0% Total expenses 406,733 412,316 -100.0% Net profit $ 9,452 $ 6,437 -100.0% Prepared by Lonnie Holtsman Profit and Loss Statement For the year 2022 Stated in 000s Category Total 2021 Total Budget Total 2022 % Change from Budget $ 579,075 $ 583,888 -100.0% Revenue Cost of sales 162,890 165,135 -100.0% Payroll Salaries 143,000 143,500 -100.0% Benefits 69,780 72,526 -100.0% Taxes 38,025 38,635 -100.0% Operating Expenses Sales and marketing 50,046 50,250 -100.0% General and administrative 64,128 65,655 -100.0% 41,754 41,750 -100.0% Other operating Summary Gross profit 416,185 418,753 -100.0% Total expenses 406,733 412,316 -100.0% Net profit $ 9,452 $ 6,437 -100.0% Prepared by Lonnie Holtsman

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance And Public Policy

Authors: Jonathan Gruber

2nd Edition

0716766310, 9780716766315

More Books

Students also viewed these Finance questions

Question

=+2. Are you happy to pay a price premium for CSR products?

Answered: 1 week ago