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

Please help with the below excel worksheet. The instruction are listed 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!