Access Millions of academic & study documents

Sc Ex19 1a Luzaguilar 2

Content type
User Generated
Subject
Excel
Type
Homework
Showing Page:
1/5

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now
Unformatted Attachment Preview
Shelly Cashman Excel 2019 | Module 1: SAM Project 1a New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Author: Luz Aguilar 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. w copy of the New Era Medical Budget Summary - Pennsylvania Center Number of salespeople: Profit and Loss Summary Revenue Gross profit Gross margin Quarter 1 Quarter 2 Quarter 3 Year to Date 1,003,500 1,007,750 1,100,150 3,111,400 125,500 130,500 132,500 388,500 12.5% 12.9% 12.0% 12.5% Regional Sales Northeast Southeast Central West Total Revenue per salesperson Quarter 1 215,225 376,517 95,605 316,153 1,003,500 83,625 Expenses General expenses Operating profit/loss Operating margin Quarter 1 Quarter 2 Quarter 3 Year to Date 82,090 85,587 85,600 253,277 20,415 25,689 28,880 74,984 2.0% 2.5% 2.6% 2.4% Quarter 2 251,325 338,575 100,345 317,505 1,007,750 83,979 Quarter 3 230,137 384,550 115,228 370,235 1,100,150 91,679 Year to Date 696,687 1,099,642 311,178 1,003,893 3,111,400 259,283 er of salespeople: 12 Target 4,200,000 520,000 12.5% Variance (1,088,600) (131,500) 0.0% Target 925,000 1,200,000 325,000 1,050,000 3,500,000 250,000 Variance (228,313) (100,358) (13,822) (46,107) (388,600) Target 330,000 110,000 2.5% Variance (76,723) (35,016) -0.1% Total Year to Date Sales by Region 32% 10% 23% 35% Sales by Region Northeast Southeast Central West Name: Sc Ex19 1a Luzaguilar 2 Description: No ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4