SC_EX19_1a_ChristopherCaldwell_2.xlsx - Shelly Cashman Excel 2019 | Module 1 SAM Project 1a New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Author

SC_EX19_1a_ChristopherCaldwell_2.xlsx - Shelly Cashman...

This preview shows page 1 - 4 out of 4 pages.

New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Author: Christopher Caldwell 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.
Image of page 1

Subscribe to view the full document.

y of
Image of page 2
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
Image of page 3

Subscribe to view the full document.

Image of page 4

Unformatted text preview: 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 12 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% Regional Sales Analysis Average 259,283 Highest 384,550 Lowest 95,605 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%...
View Full Document

  • Summer '18
  • Kemp

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes