I really need help with this. The instructions are linked and I need your help to insert and answer all the questions into the Microsoft Excel File I provided.

profilejoey123
Daryn_Leung_HW1.xlsx
Home>Business & Finance homework help>Accounting homework help>I really need help with this. The instructions are linked and I need your help to insert and answer all the questions into the Microsoft Excel File I provided.

A. Sales Records

ProdID Price Salesperson SaleMonth Region UnitsSold SubTotal Discount DiscountAmount OrderTotal
A 55 Charlene March Midwest 28 1540 0% 0 1540
A 55 Jae April Midwest 18 990 0% 0 990
A 55 Jae April Midwest 18 990 0% 0 990
A 55 Jason June Midwest 6 330 0% 0 330
A 55 John December Midwest 6 330 10% 33 297
A 55 Julio January Midwest 14 770 0% 0 770
A 55 Julio September Midwest 18 990 0% 0 990
A 55 Peter April Midwest 30 1650 0% 0 1650
A 55 Peter May Midwest 12 660 0% 0 660
A 55 Peter January Midwest 16 880 0% 0 880
A 55 Peter October Midwest 6 330 0% 0 330
A 55 Samuel February Midwest 12 660 0% 0 660
A 55 Vivian June Midwest 14 770 0% 0 770
A 55 Vivian April Midwest 6 330 0% 0 330
A 55 Vivian August Midwest 6 330 0% 0 330
A 55 Damon January Midwest 14 770 0% 0 770
A 55 Hong January Midwest 6 330 0% 0 330
A 55 Jae July Midwest 4 220 0% 0 220
A 55 Jason November Midwest 20 1100 0% 0 1100
A 55 Julio April Midwest 14 770 0% 0 770
A 55 Julio December Midwest 8 440 10% 44 396
A 55 Julio March Midwest 8 440 0% 0 440
A 55 Peter August Midwest 12 660 0% 0 660
A 55 Samuel November Midwest 6 330 0% 0 330
A 55 Vivian October Midwest 6 330 0% 0 330
A 55 Vivian February Midwest 16 880 0% 0 880
A 55 Charlene March Midwest 4 220 0% 0 220
A 55 Damon December Midwest 16 880 10% 88 792
A 55 Damon January Midwest 4 220 0% 0 220
A 55 Damon September Midwest 6 330 0% 0 330
A 55 Hong January Midwest 10 550 0% 0 550
A 55 Hong July Midwest 14 770 0% 0 770
A 55 Hong November Midwest 18 990 0% 0 990
A 55 Jason August Midwest 6 330 0% 0 330
A 55 John May Midwest 14 770 0% 0 770
A 55 John August Midwest 18 990 0% 0 990
A 55 John March Midwest 18 990 0% 0 990
A 55 Peter April Midwest 16 880 0% 0 880
A 55 Peter December Midwest 12 660 10% 66 594
A 55 Peter February Midwest 14 770 0% 0 770
A 55 Samuel May Midwest 2 110 0% 0 110
A 55 Vivian May Midwest 20 1100 0% 0 1100
A 55 Vivian March Midwest 18 990 0% 0 990
A 55 Hong June Midwest 14 770 0% 0 770
A 55 Hong September Midwest 2 110 0% 0 110
A 55 Charlene April Midwest 18 990 0% 0 990
A 55 Charlene September Midwest 14 770 0% 0 770
A 55 Damon March Midwest 8 440 0% 0 440
A 55 Hong July Midwest 18 990 0% 0 990
A 55 Hong September Midwest 8 440 0% 0 440
A 55 Jae November Midwest 18 990 0% 0 990
A 55 Jae February Midwest 8 440 0% 0 440
A 55 John July Midwest 14 770 0% 0 770
A 55 John April Midwest 6 330 0% 0 330
A 55 Julio November Midwest 16 880 0% 0 880
A 55 Samuel November Midwest 2 110 0% 0 110
A 55 Samuel October Midwest 18 990 0% 0 990
A 55 Vivian September Midwest 10 550 0% 0 550
A 55 Vivian May Midwest 16 880 0% 0 880
A 55 Charlene May Midwest 6 330 0% 0 330
A 55 Damon May Midwest 20 1100 0% 0 1100
A 55 Hong December Midwest 16 880 10% 88 792
A 55 Jae September Midwest 18 990 0% 0 990
A 55 Jae November Midwest 12 660 0% 0 660
A 55 Jason January Midwest 16 880 0% 0 880
A 55 Jason March Midwest 8 440 0% 0 440
A 55 John March Midwest 20 1100 0% 0 1100
A 55 John November Midwest 2 110 0% 0 110
A 55 Julio June Midwest 8 440 0% 0 440
A 55 Julio February Midwest 12 660 0% 0 660
A 55 Julio July Midwest 8 440 0% 0 440
A 55 Peter October Midwest 6 330 0% 0 330
A 55 Samuel June Midwest 8 440 0% 0 440
A 55 Vivian January Midwest 16 880 0% 0 880
A 55 Charlene March East 6 330 0% 0 330
A 55 Hong March East 40 2200 0% 0 2200
A 55 Jae June East 14 770 0% 0 770
A 55 Jae October East 4 220 0% 0 220
A 55 Jason November East 20 1100 0% 0 1100
A 55 Jason August East 8 440 0% 0 440
A 55 Jason June East 6 330 0% 0 330
A 55 John September East 16 880 0% 0 880
A 55 John October East 2 110 0% 0 110
A 55 Peter February East 10 550 0% 0 550
A 55 Vivian July East 6 330 0% 0 330
A 55 Hong October East 14 770 0% 0 770
A 55 Hong January East 8 440 0% 0 440
A 55 Jason April East 8 440 0% 0 440
A 55 Jason March East 14 770 0% 0 770
A 55 Julio March East 10 550 0% 0 550
A 55 Julio May East 8 440 0% 0 440
A 55 Peter December East 6 330 10% 33 297
A 55 Charlene October East 8 440 0% 0 440
A 55 Damon December East 16 880 10% 88 792
A 55 Hong June East 6 330 0% 0 330
A 55 Jae November East 16 880 0% 0 880
A 55 Jae January East 10 550 0% 0 550
A 55 Jae July East 10 550 0% 0 550
A 55 Jason February East 10 550 0% 0 550
A 55 Jason August East 4 220 0% 0 220
A 55 John January East 12 660 0% 0 660
A 55 John May East 14 770 0% 0 770
A 55 John December East 16 880 10% 88 792
A 55 Peter May East 12 660 0% 0 660
A 55 Peter May East 12 660 0% 0 660
A 55 Samuel August East 12 660 0% 0 660
A 55 Samuel April East 6 330 0% 0 330
A 55 Vivian February East 4 220 0% 0 220
A 55 Charlene November East 10 550 0% 0 550
A 55 Charlene October East 12 660 0% 0 660
A 55 Hong September East 12 660 0% 0 660
A 55 Hong January East 20 1100 0% 0 1100
A 55 Jae January East 16 880 0% 0 880
A 55 Jason October East 8 440 0% 0 440
A 55 John May East 14 770 0% 0 770
A 55 Hong May East 6 330 0% 0 330
A 55 Hong May East 8 440 0% 0 440
A 55 Hong January East 8 440 0% 0 440
A 55 John February East 18 990 0% 0 990
A 55 John July East 12 660 0% 0 660
A 55 Vivian January East 6 330 0% 0 330
A 55 Vivian April East 2 110 0% 0 110
A 55 Charlene February East 8 440 0% 0 440
A 55 Hong November East 16 880 0% 0 880
A 55 Jason October East 14 770 0% 0 770
A 55 John July East 10 550 0% 0 550
A 55 Samuel August East 12 660 0% 0 660
A 55 Samuel September East 8 440 0% 0 440
A 55 Charlene June East 18 990 0% 0 990
A 55 Charlene August East 6 330 0% 0 330
A 55 Damon November East 16 880 0% 0 880
A 55 Damon January East 20 1100 0% 0 1100
A 55 Jason May East 10 550 0% 0 550
A 55 John April East 4 220 0% 0 220
A 55 John February East 6 330 0% 0 330
A 55 Julio April East 12 660 0% 0 660
A 55 Julio January East 4 220 0% 0 220
A 55 Peter December East 6 330 10% 33 297
A 55 Vivian February East 12 660 0% 0 660
A 55 Vivian December East 6 330 10% 33 297
A 55 Vivian August East 18 990 0% 0 990
A 55 Charlene January West 20 1100 8% 88 1012
A 55 Charlene March West 14 770 8% 61.6 708.4
A 55 Charlene June West 18 990 8% 79.2 910.8
A 55 Charlene August West 12 660 8% 52.8 607.2
A 55 Jae November West 8 440 8% 35.2 404.8
A 55 Jason March West 18 990 8% 79.2 910.8
A 55 Jason October West 14 770 8% 61.6 708.4
A 55 Jason February West 2 110 8% 8.8 101.2
A 55 Jason May West 18 990 8% 79.2 910.8
A 55 Julio November West 14 770 8% 61.6 708.4
A 55 Julio October West 2 110 8% 8.8 101.2
A 55 Julio January West 8 440 8% 35.2 404.8
A 55 Peter April West 12 660 8% 52.8 607.2
A 55 Samuel February West 30 1650 8% 132 1518
A 55 Vivian June West 14 770 8% 61.6 708.4
A 55 Vivian February West 14 770 8% 61.6 708.4
A 55 Charlene January West 14 770 8% 61.6 708.4
A 55 Charlene April West 6 330 8% 26.4 303.6
A 55 Charlene February West 6 330 8% 26.4 303.6
A 55 Damon September West 4 220 8% 17.6 202.4
A 55 Damon May West 16 880 8% 70.4 809.6
A 55 Damon September West 20 1100 8% 88 1012
A 55 Hong March West 14 770 8% 61.6 708.4
A 55 Jae September West 4 220 8% 17.6 202.4
A 55 Jae September West 6 330 8% 26.4 303.6
A 55 Jason June West 18 990 8% 79.2 910.8
A 55 Julio November West 8 440 8% 35.2 404.8
A 55 Julio September West 14 770 8% 61.6 708.4
A 55 Peter February West 12 660 8% 52.8 607.2
A 55 Samuel May West 18 990 8% 79.2 910.8
A 55 Vivian February West 18 990 8% 79.2 910.8
A 55 Charlene August West 16 880 8% 70.4 809.6
A 55 Damon October West 18 990 8% 79.2 910.8
A 55 Hong July West 8 440 8% 35.2 404.8
A 55 Hong December West 2 110 8% 8.8 101.2
A 55 Jae January West 4 220 8% 17.6 202.4
A 55 John July West 2 110 8% 8.8 101.2
A 55 John December West 6 330 8% 26.4 303.6
A 55 Julio September West 8 440 8% 35.2 404.8
A 55 Julio August West 18 990 8% 79.2 910.8
A 55 Peter January West 8 440 8% 35.2 404.8
A 55 Peter April West 6 330 8% 26.4 303.6
A 55 Peter March West 18 990 8% 79.2 910.8
A 55 Peter November West 8 440 8% 35.2 404.8
A 55 Samuel January West 10 550 8% 44 506
A 55 Samuel January West 8 440 8% 35.2 404.8
A 55 Hong December West 14 770 8% 61.6 708.4
A 55 Jae December West 16 880 8% 70.4 809.6
A 55 Jason May West 18 990 8% 79.2 910.8
A 55 John April West 6 330 8% 26.4 303.6
A 55 Julio January West 6 330 8% 26.4 303.6
A 55 Julio November West 2 110 8% 8.8 101.2
A 55 Peter April West 14 770 8% 61.6 708.4
A 55 Vivian February West 6 330 8% 26.4 303.6
A 55 Hong March West 20 1100 8% 88 1012
A 55 Hong May West 4 220 8% 17.6 202.4
A 55 Hong April West 14 770 8% 61.6 708.4
A 55 Jae December West 8 440 8% 35.2 404.8
A 55 Jae December West 4 220 8% 17.6 202.4
A 55 Jason May West 14 770 8% 61.6 708.4
A 55 Jason July West 16 880 8% 70.4 809.6
A 55 Julio September West 8 440 8% 35.2 404.8
A 55 Peter February West 20 1100 8% 88 1012
A 55 Vivian April West 6 330 8% 26.4 303.6
A 55 Vivian October West 18 990 8% 79.2 910.8
A 55 Charlene May South 8 440 0% 0 440
A 55 Charlene December South 6 330 10% 33 297
A 55 Damon March South 18 990 0% 0 990
A 55 Jae October South 4 220 0% 0 220
A 55 Jae December South 18 990 10% 99 891
A 55 Jason November South 4 220 0% 0 220
A 55 John June South 6 330 0% 0 330
A 55 Julio June South 34 1870 0% 0 1870
A 55 Julio November South 16 880 0% 0 880
A 55 Samuel January South 14 770 0% 0 770
A 55 Vivian August South 14 770 0% 0 770
A 55 Vivian April South 8 440 0% 0 440
A 55 Charlene August South 6 330 0% 0 330
A 55 Charlene January South 10 550 0% 0 550
A 55 Damon August South 12 660 0% 0 660
A 55 Hong March South 18 990 0% 0 990
A 55 Hong June South 6 330 0% 0 330
A 55 Hong April South 6 330 0% 0 330
A 55 Jae April South 6 330 0% 0 330
A 55 Jae August South 10 550 0% 0 550
A 55 Jason April South 16 880 0% 0 880
A 55 John April South 16 880 0% 0 880
A 55 Julio September South 18 990 0% 0 990
A 55 Peter August South 12 660 0% 0 660
A 55 Vivian April South 16 880 0% 0 880
A 55 Charlene January South 6 330 0% 0 330
A 55 Damon December South 8 440 10% 44 396
A 55 Hong November South 18 990 0% 0 990
A 55 Hong September South 18 990 0% 0 990
A 55 Jae February South 8 440 0% 0 440
A 55 John July South 2 110 0% 0 110
A 55 Julio November South 2 110 0% 0 110
A 55 Julio December South 4 220 10% 22 198
A 55 Julio March South 10 550 0% 0 550
A 55 Samuel May South 14 770 0% 0 770
A 55 Damon July South 18 990 0% 0 990
A 55 Damon February South 4 220 0% 0 220
A 55 Damon February South 10 550 0% 0 550
A 55 Damon August South 18 990 0% 0 990
A 55 Hong October South 6 330 0% 0 330
A 55 Jae February South 10 550 0% 0 550
A 55 Jae June South 12 660 0% 0 660
A 55 Jason November South 8 440 0% 0 440
A 55 Jason October South 6 330 0% 0 330
A 55 Jason December South 16 880 10% 88 792
A 55 Julio March South 18 990 0% 0 990
A 55 Samuel June South 18 990 0% 0 990
A 55 Vivian November South 4 220 0% 0 220
A 55 Charlene May South 8 440 0% 0 440
A 55 Charlene February South 8 440 0% 0 440
A 55 Damon December South 14 770 10% 77 693
A 55 Hong September South 16 880 0% 0 880
A 55 Hong June South 20 1100 0% 0 1100
A 55 Jae February South 27 1485 0% 0 1485
B 45 Charlene August Midwest 20 900 0% 0 900
B 45 Charlene January Midwest 28 1260 0% 0 1260
B 45 Charlene June Midwest 12 540 0% 0 540
B 45 Damon December Midwest 36 1620 10% 162 1458
B 45 Hong January Midwest 20 900 0% 0 900
B 45 Jason December Midwest 24 1080 10% 108 972
B 45 John October Midwest 12 540 0% 0 540
B 45 John February Midwest 32 1440 0% 0 1440
B 45 Peter February Midwest 28 1260 0% 0 1260
B 45 Hong October Midwest 32 1440 0% 0 1440
B 45 Jason September Midwest 12 540 0% 0 540
B 45 Jason June Midwest 12 540 0% 0 540
B 45 John March Midwest 16 720 0% 0 720
B 45 Julio July Midwest 28 1260 0% 0 1260
B 45 Julio February Midwest 16 720 0% 0 720
B 45 Julio February Midwest 40 1800 0% 0 1800
B 45 Peter April Midwest 32 1440 0% 0 1440
B 45 Peter May Midwest 8 360 0% 0 360
B 45 Peter March Midwest 8 360 0% 0 360
B 45 Peter September Midwest 12 540 0% 0 540
B 45 Samuel March Midwest 40 1800 0% 0 1800
B 45 Samuel March Midwest 4 180 0% 0 180
B 45 Samuel September Midwest 24 1080 0% 0 1080
B 45 Samuel June Midwest 16 720 0% 0 720
B 45 Vivian September Midwest 40 1800 0% 0 1800
B 45 Charlene July Midwest 24 1080 0% 0 1080
B 45 Charlene September Midwest 20 900 0% 0 900
B 45 Damon December Midwest 28 1260 10% 126 1134
B 45 Damon January Midwest 14 630 0% 0 630
B 45 Hong May Midwest 26 1170 0% 0 1170
B 45 Jason April Midwest 28 1260 0% 0 1260
B 45 Jason July Midwest 40 1800 0% 0 1800
B 45 Jason July Midwest 36 1620 0% 0 1620
B 45 Jason June Midwest 40 1800 0% 0 1800
B 45 John January Midwest 36 1620 0% 0 1620
B 45 John August Midwest 28 1260 0% 0 1260
B 45 Julio December Midwest 28 1260 10% 126 1134
B 45 Samuel August Midwest 36 1620 0% 0 1620
B 45 Samuel December Midwest 24 1080 10% 108 972
B 45 Damon April Midwest 21 945 0% 0 945
B 45 Hong July Midwest 12 540 0% 0 540
B 45 Jae August Midwest 18 810 0% 0 810
B 45 Jae June Midwest 18 810 0% 0 810
B 45 Jason May Midwest 21 945 0% 0 945
B 45 Jason May Midwest 3 135 0% 0 135
B 45 John June Midwest 24 1080 0% 0 1080
B 45 John April Midwest 30 1350 0% 0 1350
B 45 John December Midwest 30 1350 10% 135 1215
B 45 Julio August Midwest 21 945 0% 0 945
B 45 Julio June Midwest 12 540 0% 0 540
B 45 Peter June Midwest 3 135 0% 0 135
B 45 Samuel November Midwest 21 945 0% 0 945
B 45 Vivian February Midwest 9 405 0% 0 405
B 45 Hong February East 40 1800 0% 0 1800
B 45 Jae January East 36 1620 0% 0 1620
B 45 Jae November East 16 720 0% 0 720
B 45 Jason May East 20 900 0% 0 900
B 45 Jason January East 36 1620 0% 0 1620
B 45 Jason September East 32 1440 0% 0 1440
B 45 John June East 40 1800 0% 0 1800
B 45 Julio August East 28 1260 0% 0 1260
B 45 Peter September East 8 360 0% 0 360
B 45 Samuel March East 16 720 0% 0 720
B 45 Vivian August East 40 1800 0% 0 1800
B 45 Charlene December East 16 720 10% 72 648
B 45 Hong July East 16 720 0% 0 720
B 45 Jae January East 8 360 0% 0 360
B 45 Jae August East 16 720 0% 0 720
B 45 Jae October East 24 1080 0% 0 1080
B 45 Jason May East 36 1620 0% 0 1620
B 45 Jason January East 24 1080 0% 0 1080
B 45 John February East 12 540 0% 0 540
B 45 Julio April East 16 720 0% 0 720
B 45 Peter February East 28 1260 0% 0 1260
B 45 Samuel June East 8 360 0% 0 360
B 45 Vivian August East 36 1620 0% 0 1620
B 45 Charlene February East 28 1260 0% 0 1260
B 45 Damon February East 8 360 0% 0 360
B 45 Hong July East 24 1080 0% 0 1080
B 45 Hong August East 12 540 0% 0 540
B 45 Hong November East 36 1620 0% 0 1620
B 45 Jae November East 36 1620 0% 0 1620
B 45 Jason May East 36 1620 0% 0 1620
B 45 John July East 28 1260 0% 0 1260
B 45 Julio April East 28 1260 0% 0 1260
B 45 Peter October East 32 1440 0% 0 1440
B 45 Peter July East 24 1080 0% 0 1080
B 45 Peter December East 28 1260 10% 126 1134
B 45 Peter March East 40 1800 0% 0 1800
B 45 Samuel May East 12 540 0% 0 540
B 45 Samuel December East 12 540 10% 54 486
B 45 Vivian April East 12 540 0% 0 540
B 45 Charlene December East 24 1080 10% 108 972
B 45 Damon September East 24 1080 0% 0 1080
B 45 Damon May East 9 405 0% 0 405
B 45 Damon August East 24 1080 0% 0 1080
B 45 Hong December East 15 675 10% 67.5 607.5
B 45 Hong September East 18 810 0% 0 810
B 45 Jae January East 21 945 0% 0 945
B 45 John August East 27 1215 0% 0 1215
B 45 John January East 3 135 0% 0 135
B 45 John February East 30 1350 0% 0 1350
B 45 John February East 27 1215 0% 0 1215
B 45 John December East 3 135 10% 13.5 121.5
B 45 Julio August East 24 1080 0% 0 1080
B 45 Julio June East 9 405 0% 0 405
B 45 Vivian January East 15 675 0% 0 675
B 45 Vivian March East 9 405 0% 0 405
B 45 Charlene November West 12 540 8% 43.2 496.8
B 45 Damon February West 12 540 8% 43.2 496.8
B 45 Damon April West 20 900 8% 72 828
B 45 Damon July West 40 1800 8% 144 1656
B 45 Damon August West 4 180 8% 14.4 165.6
B 45 Hong October West 20 900 8% 72 828
B 45 Jae May West 12 540 8% 43.2 496.8
B 45 Jae December West 32 1440 8% 115.2 1324.8
B 45 Jason September West 36 1620 8% 129.6 1490.4
B 45 John July West 40 1800 8% 144 1656
B 45 John December West 4 180 8% 14.4 165.6
B 45 Julio November West 24 1080 8% 86.4 993.6
B 45 Julio February West 12 540 8% 43.2 496.8
B 45 Peter October West 4 180 8% 14.4 165.6
B 45 Samuel November West 12 540 8% 43.2 496.8
B 45 Vivian July West 28 1260 8% 100.8 1159.2
B 45 Charlene July West 16 720 8% 57.6 662.4
B 45 Charlene November West 8 360 8% 28.8 331.2
B 45 Damon June West 32 1440 8% 115.2 1324.8
B 45 Jae February West 28 1260 8% 100.8 1159.2
B 45 Jae April West 32 1440 8% 115.2 1324.8
B 45 Jae March West 16 720 8% 57.6 662.4
B 45 Jae June West 40 1800 8% 144 1656
B 45 Jason October West 24 1080 8% 86.4 993.6
B 45 Jason September West 40 1800 8% 144 1656
B 45 Jason December West 16 720 8% 57.6 662.4
B 45 John June West 12 540 8% 43.2 496.8
B 45 Julio May West 8 360 8% 28.8 331.2
B 45 Julio February West 8 360 8% 28.8 331.2
B 45 Peter September West 8 360 8% 28.8 331.2
B 45 Samuel January West 32 1440 8% 115.2 1324.8
B 45 Vivian March West 12 540 8% 43.2 496.8
B 45 Charlene August West 15 675 8% 54 621
B 45 Damon March West 3 135 8% 10.8 124.2
B 45 Hong October West 9 405 8% 32.4 372.6
B 45 Jae April West 9 405 8% 32.4 372.6
B 45 Jason October West 18 810 8% 64.8 745.2
B 45 Jason May West 12 540 8% 43.2 496.8
B 45 Julio September West 21 945 8% 75.6 869.4
B 45 Peter April West 3 135 8% 10.8 124.2
B 45 Peter December West 24 1080 8% 86.4 993.6
B 45 Samuel August West 15 675 8% 54 621
B 45 Samuel January West 15 675 8% 54 621
B 45 Vivian July West 18 810 8% 64.8 745.2
B 45 Vivian September West 30 1350 8% 108 1242
B 45 Charlene January West 21 945 8% 75.6 869.4
B 45 Charlene November West 15 675 8% 54 621
B 45 Charlene May West 18 810 8% 64.8 745.2
B 45 Hong January West 12 540 8% 43.2 496.8
B 45 Jason August West 24 1080 8% 86.4 993.6
B 45 Jason June West 18 810 8% 64.8 745.2
B 45 John October West 21 945 8% 75.6 869.4
B 45 Julio October West 24 1080 8% 86.4 993.6
B 45 Julio October West 6 270 8% 21.6 248.4
B 45 Samuel April West 18 810 8% 64.8 745.2
B 45 Vivian July West 15 675 8% 54 621
B 45 Charlene August West 30 1350 8% 108 1242
B 45 Charlene June West 24 1080 8% 86.4 993.6
B 45 Damon October West 3 135 8% 10.8 124.2
B 45 Jae November West 18 810 8% 64.8 745.2
B 45 Jae October West 18 810 8% 64.8 745.2
B 45 Jae January West 12 540 8% 43.2 496.8
B 45 Jason November West 9 405 8% 32.4 372.6
B 45 John August West 3 135 8% 10.8 124.2
B 45 Julio October West 3 135 8% 10.8 124.2
B 45 Peter June West 27 1215 8% 97.2 1117.8
B 45 Samuel May West 18 810 8% 64.8 745.2
B 45 Vivian March West 27 1215 8% 97.2 1117.8
B 45 Charlene April South 20 900 0% 0 900
B 45 Charlene January South 12 540 0% 0 540
B 45 Damon July South 24 1080 0% 0 1080
B 45 Damon August South 8 360 0% 0 360
B 45 Damon October South 8 360 0% 0 360
B 45 Hong November South 28 1260 0% 0 1260
B 45 Jae July South 8 360 0% 0 360
B 45 Julio October South 24 1080 0% 0 1080
B 45 Julio August South 28 1260 0% 0 1260
B 45 Samuel August South 4 180 0% 0 180
B 45 Charlene June South 40 1800 0% 0 1800
B 45 Damon June South 32 1440 0% 0 1440
B 45 Damon April South 12 540 0% 0 540
B 45 Hong September South 28 1260 0% 0 1260
B 45 Jae September South 4 180 0% 0 180
B 45 Jae August South 20 900 0% 0 900
B 45 Jason December South 40 1800 10% 180 1620
B 45 Julio June South 32 1440 0% 0 1440
B 45 Peter December South 28 1260 10% 126 1134
B 45 Peter March South 20 900 0% 0 900
B 45 Vivian June South 4 180 0% 0 180
B 45 Vivian March South 24 1080 0% 0 1080
B 45 Charlene April South 9 405 0% 0 405
B 45 Charlene January South 9 405 0% 0 405
B 45 Charlene August South 9 405 0% 0 405
B 45 Damon March South 18 810 0% 0 810
B 45 Damon September South 30 1350 0% 0 1350
B 45 Hong October South 15 675 0% 0 675
B 45 Hong January South 6 270 0% 0 270
B 45 Jae October South 18 810 0% 0 810
B 45 Jae March South 21 945 0% 0 945
B 45 John August South 9 405 0% 0 405
B 45 John March South 9 405 0% 0 405
B 45 Julio June South 24 1080 0% 0 1080
B 45 Peter May South 18 810 0% 0 810
B 45 Samuel January South 6 270 0% 0 270
B 45 Jae March South 18 810 0% 0 810
B 45 Jae May South 18 810 0% 0 810
B 45 John March South 6 270 0% 0 270
B 45 John March South 3 135 0% 0 135
B 45 Julio July South 21 945 0% 0 945
B 45 Julio July South 12 540 0% 0 540
B 45 Samuel May South 30 1350 0% 0 1350
B 45 Charlene August South 21 945 0% 0 945
B 45 Damon June South 12 540 0% 0 540
B 45 Jae December South 15 675 10% 67.5 607.5
B 45 John June South 18 810 0% 0 810
B 45 Julio September South 3 135 0% 0 135
B 45 Vivian October South 21 945 0% 0 945
C 33 Damon December Midwest 12 396 10% 39.6 356.4
C 33 Hong September Midwest 24 792 0% 0 792
C 33 Jason September Midwest 3 99 0% 0 99
C 33 John March Midwest 24 792 0% 0 792
C 33 John July Midwest 3 99 0% 0 99
C 33 Peter August Midwest 9 297 0% 0 297
C 33 Vivian November Midwest 27 891 0% 0 891
C 33 Vivian November Midwest 21 693 0% 0 693
C 33 Vivian March Midwest 9 297 0% 0 297
C 33 Jason November Midwest 24 792 0% 0 792
C 33 Jason September Midwest 27 891 0% 0 891
C 33 John March Midwest 12 396 0% 0 396
C 33 John January Midwest 27 891 0% 0 891
C 33 John March Midwest 3 99 0% 0 99
C 33 John March Midwest 6 198 0% 0 198
C 33 John August Midwest 3 99 0% 0 99
C 33 Peter October Midwest 15 495 0% 0 495
C 33 Vivian September Midwest 12 396 0% 0 396
C 33 Vivian April Midwest 6 198 0% 0 198
C 33 Vivian April Midwest 6 198 0% 0 198
C 33 Vivian October Midwest 15 495 0% 0 495
C 33 Vivian October Midwest 42 1386 0% 0 1386
C 33 Vivian December Midwest 21 693 10% 69.3 623.7
C 33 Hong February Midwest 8 264 0% 0 264
C 33 Jae August Midwest 27 891 0% 0 891
C 33 Peter May Midwest 30 990 0% 0 990
C 33 Samuel February Midwest 18 594 0% 0 594
C 33 Samuel June Midwest 21 693 0% 0 693
C 33 Charlene November East 30 990 0% 0 990
C 33 Charlene January East 9 297 0% 0 297
C 33 Charlene December East 27 891 10% 89.1 801.9
C 33 Charlene August East 12 396 0% 0 396
C 33 Damon August East 6 198 0% 0 198
C 33 Damon March East 27 891 0% 0 891
C 33 Hong August East 15 495 0% 0 495
C 33 Hong June East 27 891 0% 0 891
C 33 Jason August East 3 99 0% 0 99
C 33 John July East 21 693 0% 0 693
C 33 John January East 30 990 0% 0 990
C 33 Samuel December East 30 990 10% 99 891
C 33 Charlene August East 24 792 0% 0 792
C 33 Damon August East 32 1056 0% 0 1056
C 33 Jae August East 16 528 0% 0 528
C 33 Jae December East 36 1188 10% 118.8 1069.2
C 33 Jason December East 40 1320 10% 132 1188
C 33 John August East 16 528 0% 0 528
C 33 Julio July East 28 924 0% 0 924
C 33 Peter March East 16 528 0% 0 528
C 33 Samuel August East 12 396 0% 0 396
C 33 Charlene March West 24 792 8% 63.36 728.64
C 33 Damon February West 18 594 8% 47.52 546.48
C 33 Damon September West 12 396 8% 31.68 364.32
C 33 Hong March West 12 396 8% 31.68 364.32
C 33 Jason April West 21 693 8% 55.44 637.56
C 33 Jason July West 24 792 8% 63.36 728.64
C 33 John September West 27 891 8% 71.28 819.72
C 33 John February West 27 891 8% 71.28 819.72
C 33 Julio November West 12 396 8% 31.68 364.32
C 33 Charlene May West 36 1188 8% 95.04 1092.96
C 33 Charlene October West 24 792 8% 63.36 728.64
C 33 Jae June West 20 660 8% 52.8 607.2
C 33 Jae May West 16 528 8% 42.24 485.76
C 33 Jason May West 36 1188 8% 95.04 1092.96
C 33 John June West 8 264 8% 21.12 242.88
C 33 Julio November West 20 660 8% 52.8 607.2
C 33 Julio April West 24 792 8% 63.36 728.64
C 33 Peter July West 20 660 8% 52.8 607.2
C 33 Peter February West 24 792 8% 63.36 728.64
C 33 Peter January West 40 1320 8% 105.6 1214.4
C 33 Samuel November West 20 660 8% 52.8 607.2
C 33 Samuel August West 40 1320 8% 105.6 1214.4
C 33 Samuel July West 4 132 8% 10.56 121.44
C 33 Damon August West 3 99 8% 7.92 91.08
C 33 Hong February West 21 693 8% 55.44 637.56
C 33 Jae June West 9 297 8% 23.76 273.24
C 33 Jason September West 27 891 8% 71.28 819.72
C 33 Charlene June South 24 792 0% 0 792
C 33 Charlene April South 12 396 0% 0 396
C 33 Charlene December South 3 99 10% 9.9 89.1
C 33 Damon February South 30 990 0% 0 990
C 33 Hong January South 21 693 0% 0 693
C 33 Hong March South 12 396 0% 0 396
C 33 Jae July South 27 891 0% 0 891
C 33 Jae June South 27 891 0% 0 891
C 33 Jae February South 21 693 0% 0 693
C 33 John January South 18 594 0% 0 594
C 33 John October South 15 495 0% 0 495
C 33 Peter March South 21 693 0% 0 693
C 33 Peter November South 15 495 0% 0 495
C 33 Peter November South 6 198 0% 0 198
C 33 Samuel September South 21 693 0% 0 693
C 33 Samuel January South 18 594 0% 0 594
C 33 Charlene April South 22 726 0% 0 726
C 33 Charlene March South 3 99 0% 0 99
C 33 Charlene May South 21 693 0% 0 693
C 33 Damon November South 22 726 0% 0 726
C 33 Hong July South 24 792 0% 0 792
C 33 Hong February South 21 693 0% 0 693
C 33 Jason May South 12 396 0% 0 396
C 33 Jason April South 18 594 0% 0 594
C 33 Jason September South 40 1320 0% 0 1320
C 33 John August South 28 924 0% 0 924
C 33 Peter April South 8 264 0% 0 264
C 33 Charlene December South 12 396 10% 39.6 356.4
C 33 Charlene January South 24 792 0% 0 792
C 33 Charlene December South 24 792 10% 79.2 712.8
C 33 Charlene July South 30 990 0% 0 990
C 33 Hong October South 21 693 0% 0 693
C 33 Jae June South 30 990 0% 0 990
C 33 Jae January South 21 693 0% 0 693
C 33 John July South 18 594 0% 0 594
C 33 John December South 27 891 10% 89.1 801.9
C 33 Peter April South 9 297 0% 0 297
C 33 Peter November South 27 891 0% 0 891
C 33 Peter May South 27 891 0% 0 891
C 33 Vivian July South 24 792 0% 0 792
C 33 Vivian August South 15 495 0% 0 495

B. Summary

Your name: Your name here!
Overall Percentage of Sale Increase in 2019 by Unit: 14% Last 3 digits of your Student id: 383
Section: DL2
2019 2020 2020 Forecast
Revenue Unit Sold Estimated Unit Sold Unit Price Unit Cost Revenue Costs of Good Sold
Product A 3009 3430 $55.00 $43.00 $188,664.30 $147,501.18
Product B 4500 5130 $45.00 $30.00 $230,850.00 $153,900.00
Product C 2300 2622 $33.00 $25.00 $86,526.00 $65,550.00
2020 Forecast:
Total Revenue $506,040.30
Total COGS $366,951.18
Gross Profit $139,089.12
Operating Expenses
Salaries $60,724.84
Advertising $20,241.61
Miscellaneous $5,060.40
Total Operating Expenses $86,026.85
Earnings Before Taxes $53,062.27
Taxes $13,265.57
Net Profit $39,796.70

C. Business Graph

Depict a 3-D Pie Chart Showing the Percentage of Each Product's Contribution to the Total Profitability (Based on Gross Profit, Not revenue)
Use the data in the "B. Summary" worksheet
2020 Profit in Dollar Amount
Product A $ 41,163.12
Product B $ 76,950.00
Product C $ 20,976.00
Place your pie chart below. Showing % in the pie

Enter Gross Profit (Revenues - Costs of Goods Sold, using formula, not value) for Product A, B, and C in the yellow boxed region based on the data at the B. Summary worksheet!

2020 Profit in Dollar Amount

Product A Product B Product C 41163.119999999995 76950 20976

D. Pivot Table

Q: What are your three major findings from this pivot table?
Answer:
1.
2.
3.
(Add a title of your pivot table here)
(Place your pivot table in A11. )

E. Goal Seeking

(The target unit sold here might be different than what you had in B. Summary, which is alright.)
Target Unit Sold Unit Price Unit Cost Revenue Cost of Goods Sold
Product A 3762 $55.00 $43.00 $206,910.00 $161,766.00
Product B 4600 $45.00 $30.00 $207,000.00 $138,000.00
Product C 2847 $33.00 $25.00 $93,951.00 $71,175.00
Total Revenue $507,861.00
Total COGS $370,941.00
Total Gross Profit $136,920.00
Product B Units Sold
Goal 1: $150,000 Total Gross Profit
Goal 2: $200,000 Total Gross Profit

Enter your answers in the yellow boxed region!

F. Scenario Question

Analyzing the Product Pricing Mix using Scenario Manager
Perform the scenario analysis based on the data in the table below
(The target unit sold here might be different than what you had in B. Summary, which is alright.)
Target Unit Sold Unit Price Unit Cost Revenue Cost of Goods Sold
Product A 3673 $55.00 $43.00 $202,015.00 $157,939.00
Product B 5130 $45.00 $30.00 $230,850.00 $153,900.00
Product C 2622 $33.00 $25.00 $86,526.00 $65,550.00
Total Revenue $519,391.00
Total COGS $377,389.00
Total Gross Profit $142,002.00
Questions: which scenario will you choose for 2020? And why?
Answer: