Question: Please help with the below excel worksheet. The instruction are listed below and the Excel worksheet is also attached BELOW Shelly Cashman Excel 2019 |
Please help with the below excel worksheet. The instruction are listed below and the Excel worksheet is also attached BELOW

Shelly Cashman Excel 2019 | Module 1: SAM Project 1a New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Author: Nakita Engers 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. a new copy of Budget Summary - Pennsylvania Center 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 Regional Sales Northeast Southeast Central West Total Revenue per salesperson Quarter 1 Quarter 2 Quarter 3 Year to Date 215,225 251,325 230,137 696,687 376,517 338,575 384,550 1,099,642 95,605 100,345 115,228 311,178 316,153 317,505 370,235 1,003,893 1,003,500 1,007,750 1,100,150 3,111,400 12 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 New Era Medical 12 Target 4,200,000 520,000 12.5% Variance Target Variance (131,500) -12.5% 1,200,000 325,000 1,050,000 2,575,000 250,000 Target 330,000 110,000 2.5% Variance (76,723) (35,016) -2.5%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
