Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance Services

Authors: Timothy Louwers, Allen Blay, David Sinason, Jerry Strawser, Jay Thibodeau

7th edition

978-1259573286, 1259573281, 978-1260152166

Students also viewed these Accounting questions

Question

What approach(es) to psychotherapy do you prefer?

Answered: 1 week ago