SC_EX19_1a_SwatiLakhanpal_2

.xlsx

School

Northern Alberta Institute of Technology *

*We aren’t endorsed by this school

Course

1101

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

xlsx

Pages

5

Uploaded by CaptainSquirrel2284

Report
New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Author: Swati Lakhanpal Shelly Cashman Excel 2019 | Module 1: SAM Project 1a Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy the file from the SAM website.
y of
New Era Medical Budget Summary - Pennsylvania Center Number of sale Profit and Loss Summary Quarter 1 Quarter 2 Quarter 3 Year to Date Revenue 1,003,500 1,007,750 1,100,150 3,111,400 Gross profit 125,500 130,500 132,500 388,500 Gross margin 12.5% 12.9% 12.0% 12.5% Regional Sales Quarter 1 Quarter 2 Quarter 3 Year to Date Northeast 215,225 251,325 230,137 696,687 Southeast 376,517 338,575 384,550 1,099,642 Central 95,605 100,345 115,228 311,178 West 316,153 317,505 370,235 1,003,893 Total 1,003,500 1,007,750 1,100,150 3,111,400 Revenue per salesperson 83,625 83,979 91,679 259,283 Expenses Quarter 1 Quarter 2 Quarter 3 Year to Date General expenses 82,090 85,587 85,600 253,277 Operating profit/loss 20,415 25,689 28,880 74,984 Operating margin 2.0% 2.5% 2.6% 2.4%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help