Question: 4 analysis based on the data given below : excel functions to be applied. Order ID Product Category Product Sales Quantity Discount Profit Shipping Cost

4 analysis based on the data given below : excel functions to be applied.

Order ID Product Category Product Sales Quantity Discount Profit Shipping Cost
AU-2015-1 Auto & Accessories Car Media Players 140.00 2.00 0.05 46.00 4.60
AU-2015-2 Auto & Accessories Car Speakers 211.00 3.00 0.03 112.01 11.20
AU-2015-3 Auto & Accessories Car Body Covers 117.00 5.00 0.01 31.15 3.12
AU-2015-4 Auto & Accessories Car & Bike Care 118.00 2.00 0.05 26.20 2.62
AU-2015-5 Auto & Accessories Tyre 250.00 1.00 0.04 160.00 16.00
AU-2015-6 Auto & Accessories Bike Tyres 72.00 3.00 0.04 24.00 2.40
AU-2015-7 Auto & Accessories Car Mat 54.00 1.00 0.05 54.00 5.40
AU-2015-8 Auto & Accessories Car Seat Covers 114.00 5.00 0.02 22.60 2.26
AU-2015-9 Auto & Accessories Car Pillow & Neck Rest 231.00 5.00 0.03 116.35 11.64
AU-2015-10 Auto & Accessories Car Media Players 140.00 2.00 0.02 54.40 5.44
AU-2015-11 Auto & Accessories Car Speakers 211.00 4.00 0.01 122.56 12.26
AU-2015-12 Auto & Accessories Car Body Covers 117.00 4.00 0.04 18.28 1.83
AU-2015-13 Auto & Accessories Car & Bike Care 118.00 1.00 0.02 35.64 3.56
AU-2015-14 Auto & Accessories Tyre 250.00 3.00 0.04 140.00 14.00
AU-2015-15 Auto & Accessories Bike Tyres 72.00 4.00 0.01 18.00 1.80
AU-2015-16 Auto & Accessories Car Mat 54.00 2.00 0.01 27.00 2.70
AU-2015-17 Auto & Accessories Car Seat Covers 114.00 2.00 0.05 22.60 2.26
AU-2015-18 Auto & Accessories Car Pillow & Neck Rest 231.00 5.00 0.05 93.25 9.33
AU-2015-19 Auto & Accessories Car Media Players 140.00 2.00 0.05 46.00 4.60
AU-2015-20 Auto & Accessories Car Speakers 211.00 2.00 0.02 122.56 12.26
AU-2015-21 Auto & Accessories Car Body Covers 117.00 5.00 0.01 31.15 3.12
AU-2015-22 Auto & Accessories Car & Bike Care 118.00 2.00 0.03 30.92 3.09
AU-2015-23 Auto & Accessories Tyre 250.00 4.00 0.02 150.00 15.00
AU-2015-24 Auto & Accessories Bike Tyres 72.00 4.00 0.02 18.00 1.80
AU-2015-25 Auto & Accessories Car Mat 54.00 1.00 0.05 54.00 5.40
AU-2015-26 Auto & Accessories Car Seat Covers 114.00 4.00 0.02 24.88 2.49
AU-2015-27 Auto & Accessories Car Pillow & Neck Rest 231.00 1.00 0.03 144.07 14.41
AU-2015-28 Auto & Accessories Car Media Players 140.00 1.00 0.03 55.80 5.58
AU-2015-29 Auto & Accessories Car Speakers 211.00 3.00 0.03 112.01 11.20
AU-2015-30 Auto & Accessories Car Body Covers 117.00 1.00 0.02 34.66 3.47
AU-2015-31 Auto & Accessories Car & Bike Care 118.00 3.00 0.03 27.38 2.74
AU-2015-32 Auto & Accessories Tyre 250.00 1.00 0.02 165.00 16.50
AU-2015-33 Auto & Accessories Bike Tyres 72.00 4.00 0.05 18.00 1.80
AU-2015-34 Auto & Accessories Car Mat 54.00 4.00 0.05 13.50 1.35
AU-2015-35 Auto & Accessories Car Seat Covers 114.00 4.00 0.01 29.44 2.94
AU-2015-36 Auto & Accessories Car Pillow & Neck Rest 231.00 2.00 0.05 127.90 12.79
AU-2015-37 Auto & Accessories Car Media Players 140.00 5.00 0.04 32.00 3.20
AU-2015-38 Auto & Accessories Car Speakers 211.00 4.00 0.01 122.56 12.26
AU-2015-39 Auto & Accessories Car Body Covers 117.00 1.00 0.04 32.32 3.23
AU-2015-40 Auto & Accessories Car & Bike Care 118.00 5.00 0.04 14.40 1.44
AU-2015-41 Auto & Accessories Tyre 250.00 5.00 0.03 132.50 13.25
AU-2015-42 Auto & Accessories Bike Tyres 72.00 5.00 0.02 14.40 1.44
AU-2015-43 Auto & Accessories Car Mat 54.00 5.00 0.01 10.80 1.08
AU-2015-44 Auto & Accessories Car Seat Covers 114.00 4.00 0.04 15.76 1.58
AU-2015-45 Auto & Accessories Car Pillow & Neck Rest 231.00 4.00 0.04 114.04 11.40
AU-2015-46 Auto & Accessories Car Media Players 140.00 2.00 0.05 46.00 4.60
AU-2015-47 Auto & Accessories Car Speakers 211.00 1.00 0.01 128.89 12.89
AU-2015-48 Auto & Accessories Car Body Covers 117.00 4.00 0.05 13.60 1.36
AU-2015-49 Auto & Accessories Car & Bike Care 118.00 5.00 0.04 14.40 1.44
AU-2015-50 Auto & Accessories Tyre 250.00 2.00 0.01 165.00 16.50
AU-2015-51 Auto & Accessories Bike Tyres 72.00 2.00 0.01 36.00 3.60
AU-2015-52 Auto & Accessories Car Mat 54.00 5.00 0.03 10.80 1.08
AU-2015-53 Auto & Accessories Car Seat Covers 114.00 4.00 0.05 11.20 1.12
AU-2015-54 Auto & Accessories Car Pillow & Neck Rest 231.00 2.00 0.04 132.52 13.25
AU-2015-55 Auto & Accessories Car Media Players 140.00 2.00 0.03 51.60 5.16
AU-2015-56 Auto & Accessories Car Speakers 211.00 1.00 0.01 128.89 12.89
AU-2015-57 Auto & Accessories Car Body Covers 117.00 4.00 0.02 27.64 2.76
AU-2015-58 Auto & Accessories Car & Bike Care 118.00 3.00 0.05 20.30 2.03
AU-2015-59 Auto & Accessories Tyre 250.00 1.00 0.04 160.00 16.00
AU-2015-60 Auto & Accessories Bike Tyres 72.00 2.00 0.03 36.00 3.60
AU-2015-61 Auto & Accessories Car Mat 54.00 5.00 0.01 10.80 1.08
AU-2015-62 Auto & Accessories Car Seat Covers 114.00 3.00 0.01 30.58 3.06
AU-2015-63 Auto & Accessories Car Pillow & Neck Rest 231.00 5.00 0.02 127.90 12.79
AU-2015-64 Auto & Accessories Car Media Players 140.00 1.00 0.05 53.00 5.30
AU-2015-65 Auto & Accessories Car Speakers 211.00 2.00 0.05 109.90 10.99
AU-2015-66 Auto & Accessories Car Body Covers 117.00 1.00 0.02 34.66 3.47
AU-2015-67 Auto & Accessories Car & Bike Care 118.00 1.00 0.01 36.82 3.68
AU-2015-68 Auto & Accessories Tyre 250.00 1.00 0.01 167.50 16.75
AU-2015-69 Auto & Accessories Bike Tyres 72.00 1.00 0.02 72.00 7.20
AU-2015-70 Auto & Accessories Car Mat 54.00 1.00 0.03 54.00 5.40
AU-2015-71 Auto & Accessories Car Seat Covers 114.00 4.00 0.03 20.32 2.03
AU-2015-72 Auto & Accessories Car Pillow & Neck Rest 231.00 3.00 0.05 116.35 11.64
AU-2015-73 Auto & Accessories Car Media Players 140.00 4.00 0.05 32.00 3.20
AU-2015-74 Auto & Accessories Car Speakers 211.00 5.00 0.01 120.45 12.05
AU-2015-75 Auto & Accessories Car Body Covers 117.00 4.00 0.01 32.32 3.23
AU-2015-76 Auto & Accessories Car & Bike Care 118.00 1.00 0.01 36.82 3.68
AU-2015-77 Auto & Accessories Tyre 250.00 4.00 0.03 140.00 14.00
AU-2015-78 Auto & Accessories Bike Tyres 72.00 4.00 0.04 18.00 1.80
AU-2015-79 Auto & Accessories Car Mat 54.00 5.00 0.03 10.80 1.08
AU-2015-80 Auto & Accessories Car Seat Covers 114.00 1.00 0.05 28.30 2.83
AU-2015-81 Auto & Accessories Car Pillow & Neck Rest 231.00 1.00 0.03 144.07 14.41
AU-2015-82 Auto & Accessories Car Media Players 140.00 1.00 0.01 58.60 5.86
AU-2015-83 Auto & Accessories Car Speakers 211.00 5.00 0.03 99.35 9.94
AU-2015-84 Auto & Accessories Car Body Covers 117.00 3.00 0.02 29.98 3.00
AU-2015-85 Auto & Accessories Car & Bike Care 118.00 2.00 0.04 28.56 2.86
AU-2015-86 Auto & Accessories Tyre 250.00 4.00 0.05 120.00 12.00
AU-2015-87 Auto & Accessories Bike Tyres 72.00 2.00 0.02 36.00 3.60
AU-2015-88 Auto & Accessories Car Mat 54.00 2.00 0.03 27.00 2.70
AU-2015-89 Auto & Accessories Car Seat Covers 114.00 2.00 0.04 24.88 2.49
AU-2015-90 Auto & Accessories Car Pillow & Neck Rest 231.00 5.00 0.04 104.80 10.48
AU-2015-91 Auto & Accessories Car Media Players 140.00 1.00 0.04 54.40 5.44
AU-2015-92 Auto & Accessories Car Speakers 211.00 3.00 0.01 124.67 12.47
AU-2015-93 Auto & Accessories Car Body Covers 117.00 2.00 0.02 32.32 3.23
AU-2015-94 Auto & Accessories Car & Bike Care 118.00 4.00 0.04 19.12 1.91
AU-2015-95 Auto & Accessories Tyre 250.00 4.00 0.03 140.00 14.00
AU-2015-96 Auto & Accessories Bike Tyres 72.00 2.00 0.01 36.00 3.60
AU-2015-97 Auto & Accessories Car Mat 54.00 5.00 0.02 10.80 1.08
AU-2015-98 Auto & Accessories Car Seat Covers 114.00 3.00 0.04 20.32 2.03
AU-2015-99 Auto & Accessories Car Pillow & Neck Rest 231.00 2.00 0.02 141.76 14.18
AU-2015-100 Auto & Accessories Car Media Players 140.00 1.00 0.01 58.60 5.86
AU-2015-101 Auto & Accessories Car Speakers 211.00 5.00 0.03 99.35 9.94
AU-2015-102 Auto & Accessories Car Body Covers 117.00 3.00 0.03 26.47 2.65
AU-2015-103 Auto & Accessories Car & Bike Care 118.00 5.00 0.04 14.40 1.44
AU-2015-104 Auto & Accessories Tyre 250.00 3.00 0.05 132.50 13.25
AU-2015-105 Auto & Accessories Bike Tyres 72.00 4.00 0.03 18.00 1.80
AU-2015-106 Auto & Accessories Car Mat 54.00 5.00 0.01 10.80 1.08
AU-2015-107 Auto & Accessories Car Seat Covers 114.00 2.00 0.02 29.44 2.94
AU-2015-108 Auto & Accessories Car Pillow & Neck Rest 231.00 3.00 0.02 137.14 13.71
AU-2015-109 Auto & Accessories Car Media Players 140.00 4.00 0.03 43.20 4.32
AU-2015-110 Auto & Accessories Car Speakers 211.00 3.00 0.05 99.35 9.94
AU-2015-111 Auto & Accessories Car Body Covers 117.00 5.00 0.05 7.75 0.78
AU-2015-112 Auto & Accessories Car & Bike Care 118.00 3.00 0.01 34.46 3.45
AU-2015-113 Auto & Accessories Tyre 250.00 5.00 0.01 157.50 15.75
AU-2015-114 Auto & Accessories Bike Tyres 72.00 2.00 0.03 36.00 3.60
AU-2015-115 Auto & Accessories Car Mat 54.00 4.00 0.02 13.50 1.35
AU-2015-116 Auto & Accessories Car Seat Covers 114.00 5.00 0.05 5.50 0.55
AU-2015-117 Auto & Accessories Car Pillow & Neck Rest 231.00 4.00 0.02 132.52 13.25
AU-2015-118 Auto & Accessories Car Media Players 140.00 1.00 0.04 54.40 5.44
AU-2015-119 Auto & Accessories Car Speakers 211.00 3.00 0.04 105.68 10.57
AU-2015-120 Auto & Accessories Car Body Covers 117.00 5.00 0.01 31.15 3.12
AU-2015-121 Auto & Accessories Car & Bike Care 118.00 5.00 0.03 20.30 2.03
AU-2015-122 Auto & Accessories Tyre 250.00 4.00 0.05 120.00 12.00
AU-2015-123 Auto & Accessories Bike Tyres 72.00 4.00 0.03 18.00 1.80
AU-2015-124 Auto & Accessories Car Mat 54.00 1.00 0.01 54.00 5.40
AU-2015-125 Auto & Accessories Car Seat Covers 114.00 3.00 0.02 27.16 2.72
AU-2015-126 Auto & Accessories Car Pillow & Neck Rest 231.00 1.00 0.01 148.69 14.87
AU-2015-127 Auto & Accessories Car Media Players 140.00 1.00 0.01 58.60 5.86
AU-2015-128 Auto & Accessories Car Speakers 211.00 3.00 0.01 124.67 12.47
AU-2015-129 Auto & Accessories Car Body Covers 117.00 5.00 0.04 13.60 1.36
AU-2015-130 Auto & Accessories Car & Bike Care 118.00 5.00 0.02 26.20 2.62
AU-2015-131 Auto & Accessories Tyre 250.00 3.00 0.02 155.00 15.50
AU-2015-132 Auto & Accessories Bike Tyres 72.00 5.00 0.05 14.40 1.44
AU-2015-133 Auto & Accessories Car Mat 54.00 1.00 0.02 54.00 5.40
AU-2015-134 Auto & Accessories Car Seat Covers 114.00 5.00 0.05 5.50 0.55
AU-2015-135 Auto & Accessories Car Pillow & Neck Rest 231.00 2.00 0.02 141.76 14.18
AU-2015-136 Auto & Accessories Car Media Players 140.00 1.00 0.03 55.80 5.58
AU-2015-137 Auto & Accessories Car Speakers 211.00 4.00 0.02 114.12 11.41
AU-2015-138 Auto & Accessories Car Body Covers 117.00 5.00 0.04 13.60 1.36
AU-2015-139 Auto & Accessories Car & Bike Care 118.00 5.00 0.04 14.40 1.44
AU-2015-140 Auto & Accessories Tyre 250.00 4.00 0.05 120.00 12.00
AU-2015-141 Auto & Accessories Bike Tyres 72.00 5.00 0.05 14.40 1.44
AU-2015-142 Auto & Accessories Car Mat 54.00 5.00 0.03 10.80 1.08
AU-2015-143 Auto & Accessories Car Seat Covers 114.00 4.00 0.05 11.20 1.12
AU-2015-144 Auto & Accessories Car Pillow & Neck Rest 231.00 1.00 0.05 139.45 13.95
AU-2015-145 Auto & Accessories Car Media Players 140.00 5.00 0.01 53.00 5.30
AU-2015-146 Auto & Accessories Car Speakers 211.00 5.00 0.04 88.80 8.88
AU-2015-147 Auto & Accessories Car Body Covers 117.00 1.00 0.02 34.66 3.47
AU-2015-148 Auto & Accessories Car & Bike Care 118.00 5.00 0.05 8.50 0.85
AU-2015-149 Auto & Accessories Tyre 250.00 1.00 0.04 160.00 16.00
AU-2015-150 Auto & Accessories Bike Tyres 72.00 3.00 0.02 24.00 2.40
AU-2015-151 Auto & Accessories Car Mat 54.00 4.00 0.05 13.50 1.35
AU-2015-152 Auto & Accessories Car Seat Covers 114.00 4.00 0.04 15.76 1.58
AU-2015-153 Auto & Accessories Car Pillow & Neck Rest 231.00 1.00 0.03 144.07 14.41
AU-2015-154 Auto & Accessories Car Media Players 140.00 1.00 0.01 58.60 5.86
154

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Marketing Questions!

Q:

ACCORDING TO CHEGG POLICIES WE CAN'T SHARE EXCEL FILE IF ANY EXPERT WANT EXCELL FILE THEN SEND ME THEIR EMAIL ON COMMENT Question-4 Marks [10] You have to create a Sales dashboard (1 pager snapshot...

Q:

ACC 700 Milestone Three Guidelines and Rubric The third milestone ThisistheproblemthatIneedhelpwithbutMilestoneOne. ACC 700 Final Project Guidelines and Rubric Overview As the final step in your...

Q:

ACC 700 Milestone Three Guidelines and Rubric The third milestone ThisistheproblemthatIneedhelpwithbutMilestoneOne. ACC 700 Final Project Guidelines and Rubric Overview As the final step in your...

Q:

ACC 700 Milestone Three Guidelines and Rubric The third milestone ThisistheproblemthatIneedhelpwithbutMilestoneOne. ACC 700 Final Project Guidelines and Rubric Overview As the final step in your...

Q:

Hi, could you please help me solve this? Thank you so much. Chester, Inc. Trial Balances for years ending December 31, 2013, 2014, and 2015 Account Description Cash on Hand Regular Checking Account...

Q:

this dataset contains sales data from a department store. Available information includes: Order ID, Order Date, Shipping method, Customer ID, Customer Segment, City, State, Region, Category of item...

Q:

INTRODUCTION: In February 2015, Majdy I. was appointed as a Chief Executive Manager of the Manufacturing Company by Mamoun N., President. Majdy had wide executive experience in the manufacturing...

Q:

Hi I need help with this question please, Why did Mamoun company improve profitability during the period January 1 to June 30, 2015? How useful was the data in Exhibit 4 for the purpose of this...

Q:

Superior Manufacturing Company In February 2005, Herbert Waters was appointed general manager of the Superior Manufacturing Company by Paul Harvey, president. Waters, 56, had wide executive...

Q:

could any one help me with the four questiones? the four of them not only the second one !!!! Superior Manufacturing Company In February 2005, Herbert Waters was appointed general manager of the...

Q:

Warf Computers has decided to proceed with the manufacture and distribution of the virtual keyboard (VK) the company has developed. To undertake this venture, the company needs to obtain equipment...

Q:

Not all springs are made in a conventional way. Consider the special steel spring in the illustration. (a) Find the pitch, solid height, and number of active turns. (b) Find the spring rate. Assume...

Q:

Which of the following is an example of an anomaly? a . The discovery that stock prices follow a random walk. b . The discovery that returns to stock tend to be negative in periods of recessions. c ....

Q:

Respond to the following independent scenarios, under the provisions of the Contract Act, 1872: Case 1 Sajid Limited (SL), misrepresenting themselves to be the agents of Baber Motors (BM), persuaded...

Q:

=+ b. David is trying to get a large advance to write a textbook. He knows, but publishers dont, that he did poorly on the writing portion of the SAT.

Q:

=+ a. Rick has gotten a large advance to write a textbook. With the money in hand, he prefers

Q:

=+spending his time sailing rather than sitting in his offi ce working on the book.