The Fox West Chamber of Commerce (which includes Hortonville) has hired you as a consultant to help out its members While the Chamber liked your proposal for many reasons, the mainly hired you because of your expertise garnered in UWOs Award Winning Quantitative Analysis Class Members of the Chamber submit data to you along with a set of questions The following sections are but a few of the many requests for help you received Charlies Charlies, a drive in on the west side of Hortonville, is a community institution Originally an A W, Charlies has been there for nearly 50 years and is known for great food, and some of the best homemade root beer around The Mann family, owners of Charlies, submitted data on side order (appetizer) sales (number of orders) for 2017 by month What percent of sales in 2017 were from French Fries (2 points) Create a line graph that shows sales by month for each appetizer This is one graph with all the appetizers shown with their own line Months (in calendar order) should be on the horizontal axis and sales on the vertical axis Each month should only appear once on the horizontal axis Be sure to label the axes, and give the graph a title and a legend (5 points) If Charlies was going to sell two appetizers together as a combo, which would make the most sense and why Find two different ways to do an analysis that leads you to two different conclusions (5 points) For 2018, Charlies would like to discontinue one of the appetizers Which one would you suggest they discontinue, and why do you make that recommendation Find two different ways to do an analysis that leads you to two different conclusions (5 points) Appetizer Month Sales (Orders) French Fries April 8897 French Fries August 8424 French Fries October 8203 French Fries July 8446 French Fries May 8059 French Fries June 8290 French Fries September 8966 Cheese Curds July 1842 Cheese Curds June 1920 Cheese Curds October 1697 Cheese Curds April 1609 Cheese Curds September 1755 Cheese Curds May 1706 Cheese Curds August 2071 Chicken Strips July 749 Chicken Strips September 796 Chicken Strips October 619 Chicken Strips August 802 Chicken Strips May 634 Chicken Strips June 766 Chicken Strips April 869 Onion Rings July 6541 Onion Rings August 6365 Onion Rings May 6699 Onion Rings June 6626 Onion Rings April 7070 Onion Rings October 6123 Onion Rings September 6360 Corn Dogs July 5973 Corn Dogs June 6103 Corn Dogs May 6051 Corn Dogs August 6054 Corn Dogs October 6431 Corn Dogs September 6087 Corn Dogs April 5995

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 17, 2024

The Fox West Chamber of Commerce (which includes Hortonville) has hired you as a consultant to help out its members. While the Chamber liked your

The Fox West Chamber of Commerce (which includes Hortonville) has hired you as a consultant to help out its members. While the Chamber liked your proposal for many reasons, the mainly hired you because of your expertise garnered in UWOs Award Winning Quantitative Analysis Class. Members of the Chamber submit data to you along with a set of questions. The following sections are but a few of the many requests for help you received.

Charlies

Charlies, a drive in on the west side of Hortonville, is a community institution. Originally an A&W, Charlies has been there for nearly 50 years and is known for great food, and some of the best homemade root beer around. The Mann family, owners of Charlies, submitted data on side order (appetizer) sales (number of orders) for 2017 by month.

What percent of sales in 2017 were from French Fries? (2 points)

Create a line graph that shows sales by month for each appetizer. This is one graph with all the appetizers shown with their own line. Months (in calendar order) should be on the horizontal axis and sales on the vertical axis. Each month should only appear once on the horizontal axis. Be sure to label the axes, and give the graph a title and a legend (5 points)

If Charlies was going to sell two appetizers together as a combo, which would make the most sense and why? Find two different ways to do an analysis that leads you to two different conclusions (5 points)

For 2018, Charlies would like to discontinue one of the appetizers. Which one would you suggest they discontinue, and why do you make that recommendation? Find two different ways to do an analysis that leads you to two different conclusions (5 points)

Appetizer	Month	Sales (Orders)
French Fries	April	8897
French Fries	August	8424
French Fries	October	8203
French Fries	July	8446
French Fries	May	8059
French Fries	June	8290
French Fries	September	8966
Cheese Curds	July	1842
Cheese Curds	June	1920
Cheese Curds	October	1697
Cheese Curds	April	1609
Cheese Curds	September	1755
Cheese Curds	May	1706
Cheese Curds	August	2071
Chicken Strips	July	749
Chicken Strips	September	796
Chicken Strips	October	619
Chicken Strips	August	802
Chicken Strips	May	634
Chicken Strips	June	766
Chicken Strips	April	869
Onion Rings	July	6541
Onion Rings	August	6365
Onion Rings	May	6699
Onion Rings	June	6626
Onion Rings	April	7070
Onion Rings	October	6123
Onion Rings	September	6360
Corn Dogs	July	5973
Corn Dogs	June	6103
Corn Dogs	May	6051
Corn Dogs	August	6054
Corn Dogs	October	6431
Corn Dogs	September	6087
Corn Dogs	April	5995