can anyone complete this ASAP or by tomorrow Documentation 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 Center salespeople: 12
Profit and Loss Summary Quarter 1 Year to Date Target Variance
Revenue 1,003,500 1,007,750 1,100,150 3,111,400 4,200,000
Gross profit 125,500 130,500 132,500 388,500 520,000 (131,500)
Gross margin 12.5% -12.5%
Regional Sales Quarter 1 Quarter 2 Quarter 3 Year to Date Target Variance
Northeast 215,225 251,325 230,137
Southeast 376,517 338,575 384,550 1,200,000
Central 95,605 100,345 115,228 325,000
West 316,153 317,505 370,235 1,050,000
Total 1,003,500 1,007,750 1,100,150 – 0 2,575,000
Revenue per salesperson 12 250,000
Expenses Quarter 1 Quarter 2 Quarter 3 Year to Date Target Variance
General expenses 82,090 85,587 85,600 253,277 330,000 (76,723)
Operating profit/loss 20,415 25,689 28,880 74,984 110,000 (35,016)
Operating margin 2.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

System Analysis and Design Assignment 13,1 – Data Management

System Analysis and Design Assignment 13,1 – Data Management This is a required assignment, worth 20 points, and must be submitted by the due date. Review the Grading Rubric before completing this assignment. Research a scholarly paper on the impact of “Emerging Technologies on SAD” and reflect on only one

Capstone 2408906454 Design and Analysis of a Simple Computer System Objective:

Capstone 2408906454 Design and Analysis of a Simple Computer System Objective: Students will design, simulate, and analyze the architecture of a simplified computer system, applying concepts from Stephen D. Burd’s materials such as the CPU, memory hierarchy, I/O, and instruction set architecture (ISA). Components: 1. System Design: . CPU Design: