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% | ||||||