excel assignment

profilerfeliz12
NP_EX19_EOM5-1_RichardFeliz_1.xlsx
Home>Business & Finance homework help>Accounting homework help>excel assignment

Documentation

New Perspectives Excel 2019 | Module 5: End of Module Project 1
Lewellen Group
GENERATING REPORTS FROM MULTIPLE WORKBOOKS
Author: Richard Feliz
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Dashboard

Profit and Loss Statement
For the year 2022
Stated in 000s
Category Total 2021 Total Budget Total 2022 % Change from Budget
Revenue $ 583,888 -100.0% Links
Cost of sales 165,135 -100.0% Lewellen website
Payroll Contact Lewellen
Salaries 143,500 -100.0% Category list
Benefits 72,526 -100.0% Profit and loss statement 2021
Taxes 38,635 -100.0%
Operating Expenses
Sales and marketing 50,250 -100.0%
General and administrative 65,655 -100.0%
Other operating 41,750 -100.0%
Summary
Gross profit 418,753 -100.0%
Total expenses ERROR:#DIV/0!
Net profit $ 418,753 -100.0%
Prepared by Lonnie Holtsman
mailto:[email protected]

Charlotte

Profit and Loss Statement
For the year 2022
Stated in 000s
Category Total 2022 % Sales Charlotte Office
Revenue $ 196,900 Manager Ron Keller
Cost of sales 55,045 Location 225 E. Center St.
Payroll Charlotte, NC 28214
Salaries 46,667 Phone (704) 555-9801
Benefits 24,175
Taxes 13,030
Operating Expenses
Sales and marketing 17,950
General and administrative 22,035
Other operating 14,450
Summary
Gross profit 141,855
Total expenses 138,307
Net profit $ 3,548

Denver

Profit and Loss Statement
For the year 2022
Stated in 000s
Category Total 2022 % Sales Denver Office
Revenue $ 197,857 Manager Pilar Plata
Cost of sales 54,605 28% Location 1897 W. Clark Ave.
Payroll Denver, CO 80201
Salaries 47,028 24% Phone (720) 555-1424
Benefits 24,775 13%
Taxes 13,050 7%
Operating Expenses
Sales and marketing 18,455 9%
General and administrative 22,267 11%
Other operating 13,284 7%
Summary
Gross profit 143,252 72%
Total expenses 138,859 70%
Net profit $ 4,393 2%

Milwaukee

Profit and Loss Statement
For the year 2022
Stated in 000s
Category Total 2022 % Sales Milwaukee Office
Revenue $ 196,972 Manager Jum Nguyen
Cost of sales 54,003 27% Location 344 E. Wisconsin Ave.
Payroll Milwaukee, WI 53205
Salaries 46,750 24% Phone (414) 555-2166
Benefits 24,146 12%
Taxes 13,577 7%
Operating Expenses
Sales and marketing 17,182 9%
General and administrative 21,990 11%
Other operating 14,506 7%
Summary
Gross profit 142,969 73%
Total expenses 138,151 70%
Net profit $ 4,818 2%

Categories

Category Description
Revenue Income from consulting services, including service agreements
Cost of sales Total of all costs used to produce consulting services, including overhead and commissions
Salaries Amount paid to employees as salary before taxes and withholdings
Benefits Employee compensation in addition to salary, including Social Security and insurance
Taxes Payroll taxes paid on salaries
Sales and marketing Amount spent on sales and marketing efforts, including advertising and promotional materials
General and administrative Operation expenses such as rent and utilities
Other operating Other operating expenses such as equipment rental and contracted labor