can anyone complete this ASAP or by tomorrowDocumentation Shelly Cashman Excel 2019 | Module 1: SAM Project 1a

can anyone complete this ASAP or by tomorrow

Documentation

Shelly Cashman Excel 2019 | Module 1: SAM Project 1a
New Era Medical
COMPLETE A BUDGET SUMMARY WORKSHEET
Author:Theresa Cobb
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.

Budget Summary

New Era Medical
Budget Summary – Pennsylvania Centersalespeople:12
Profit and Loss SummaryQuarter 1Year to DateTargetVariance
Revenue1,003,5001,007,7501,100,1503,111,4004,200,000
Gross profit125,500130,500132,500388,500520,000(131,500)
Gross margin12.5%-12.5%
Regional SalesQuarter 1Quarter 2Quarter 3Year to DateTargetVariance
Northeast215,225251,325230,137
Southeast376,517338,575384,5501,200,000
Central95,605100,345115,228325,000
West316,153317,505370,2351,050,000
Total1,003,5001,007,7501,100,150– 02,575,000
Revenue per salesperson12250,000
ExpensesQuarter 1Quarter 2Quarter 3Year to DateTargetVariance
General expenses82,09085,58785,600253,277330,000(76,723)
Operating profit/loss20,41525,68928,88074,984110,000(35,016)
Operating margin2.5%-2.5%

image1.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions