SC_EX365_2021_CT1c_SandipKhatri_2

Author: Note: Shelly C

New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Sandip Khatri Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the website. Cashman Excel 365/2021 | Module 1: SAM Critical Thinking Project 1c

New Era Medical Budget Summary - Pennsylvania Center Number of sale Profit and Loss Summary Quarter 1 Quarter 2 Quarter 3 Year to Date Revenue 1,003,500 1,007,750 1,100,150 3,111,400 Gross profit 125,500 130,500 132,500 388,500 Gross margin 12.5% 12.9% 12.0% 12.5% Regional Sales Quarter 1 Quarter 2 Quarter 3 Year to Date Northeast 215,225 251,325 230,137 696,687 Southeast 376,517 338,575 384,550 1,099,642 Central 95,605 100,345 115,228 311,178 West 316,153 317,505 370,235 1,003,893 Total 1,003,500 1,007,750 1,100,150 3,111,400 Revenue per salesperson 83,625 83,979 91,679 259,283 Expenses Quarter 1 Quarter 2 Quarter 3 Year to Date General expenses 82,090 85,587 85,600 253,277 Operating profit/loss 20,415 25,689 28,880 74,984 Operating margin 2.0% 2.5% 2.6% 2.4%

espeople: 12 Target Variance 4,200,000 (1,088,600) 520,000 (131,500) 12.5% 0.0% AA Target Variance 925,000 (228,313) 1,200,000 (100,358) 325,000 (13,822) 1,050,000 (46,107) 3,500,000 (388,600) 250,000 Target Variance 330,000 (76,723) 110,000 (35,016) 2.5% -0.1% 22.39% 35.34% 10.00% 32.26% Total Year-to-Date Sales by Region