SC_EX19_1a_AnthonyCordero_2

xlsx

School

University of California, Los Angeles *

*We aren’t endorsed by this school

Course

111

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by UltraStraw13487

New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Author: Anthony Cordero 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

espeople: 12 Target Variance 4,200,000 1,088,600 520,000 (131,500) 12.5% 0.0% Target Variance 925,000 228,313 1,200,000 100,358 325,000 13,822 1,050,000 46,107 3,500,000 388,600 250,000 Target Variance 330,000 (76,723) 110,000 (35,016) 2.5% -0.1% 22% 35% 10% 32% Total Year to Date Sales by Region

n Northeast Southeast Central West

SC_EX19_1a_AnthonyCordero_2

Related Documents