Answered step by step
Verified Expert Solution
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.
I 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 HoltsmanStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started