Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tiger Mart is a small grocery store known for its cranberries. The HW1_TigerMart.xls file contains data from each quarter in the years 2006-2011 detailing the

image text in transcribed

Tiger Mart is a small grocery store known for its cranberries. The HW1_TigerMart.xls file contains data from each quarter in the years 2006-2011 detailing the pounds of cranberries sold by the store. In addition, the file also contains information on stores price and the price charged by a competitor. Analyze the data using Pivot functions and answer the following questions.

a) Ignoring the price, create a chart that displays the seasonality of cranberry sales over the quarters.

b) Ignoring the price, create a chart to determine if there is a trend in the sales over the years?

c) Determine the average sales per quarter, breaking it down based on whether your price was higher or lower than the competitors price. Hint: You can create additional fields using the given data.

**PLEASE SHOW YOUR PIVOT TABLES LAYOUT**

A B E F G H 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Year 2006 2006 2006 2006 2007 2007 2007 2007 2008 2008 2008 2008 2009 2009 2009 2009 2010 2010 2010 2010 2011 2011 2011 2011 Quarter Units 1 453.4041 2| 454.8513 3 523.9836 4 578.7019 1 608.5591 2 577.5938 3 571.9 4 660.0556 1 443.501 2 390.6668 3 429.6064 4788.3224 1 581.585 2 503.9166 3 499.7705 4|936.1867 1459.4822 2 470.638 3 349.4878 41 912.5367 1 400.3611 2 528.4768 3 605.8438 4 574.5326 Competitor Price 4.05 4.81 5.42 4.31 4.71 4.88 5.81 4.14 4.58 4.2 4.24 5.89 5.2 5 4.5 5.05 5.42 4.57 5.06 5.28 4.93 4.34 5.23 5.62 My Price 4.74 5.28 4.43 5.02 4.11 4.52 4.41 4.87 5.3 5.07 5.14 4.66 4.52 4.86 4.63 4.25 4.94 4.58 5.78 4.16 5.5 4.33 4.46 5.53

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Valuing Agile The Financial Management Of Agile Projects

Authors: Alan Moran

1st Edition

0117082880, 9780117082885

More Books

Students also viewed these Finance questions