Turkey Legs Turkey legs are a popular food associated with outdoor food stands at carnivals, amusement...

Transcribed Image Text:

Turkey Legs Turkey legs are a popular food associated with outdoor food stands at carnivals, amusement parks, fairs, festivals, and other places in Arizona. The turkey legs are marinated in a high sodium rub and then roasted over an open fire. The sodium is not good for your health, but it is very tasty. Amelia Smith owns a small vending truck in Tucson AZ where she sells turkey legs and soft drinks. Although the business has been stable, she is apprehensive about the variation in sales for no apparent reason. She asks you as a quantitative methods student to help make a forecast for her turkey legs as well as soft drinks. In the file below you will find the data for historical sales of turkey legs and soft drinks over the last 20 days. Prepare a 6-10 page management report addressing the following: 1. Use methods of descriptive statistics to summarize the data. Use visual tools and Tableau to graphically display the data. Comment on the findings. 2. Construct the exponentially smoothed series for turkey legs and soft drinks using alpha=.2 and alpha =.8. 3. Calculate and explain MSE and MAD for each series. 4. Forecast sales of turkey legs and soft drinks for days 21 through 25 with the best fitting series. Support your forecasting method with scholarly sources. You can download the Turkey Legs data file here, or find it attached in the Module 7: Case Study 3 assignment folder. Please review the Case Study Instructions and Grading Criteria before doing/submitting your work. For the third case study, the emphasis in grading will be on the presentation and correctness of your findings. When writing your paper, you should become acquainted with APA formatting. A template is located here for your use APA Template. Additional information can be located in the Pima Online Library. New Turkey Legs Turkey legs are a popular food associated with outdoor food stands at carnivals, amusement parks, fairs, festivals, and other places in Arizona. The turkey legs are marinated in a high sodium rub and then roasted over an open fire. The sodium is not good for your health, but it is very tasty. Amelia Smith owns a small vending truck in Tucson AZ where she sells turkey legs and soft drinks. Although the business has been stable, she is apprehensive about the variation in sales for no apparent reason. She asks you as a quantitative methods student to help make a forecast for her turkey legs as well as soft drinks. In the file below you will find the data for historical sales of turkey legs and soft drinks over the last 20 days. Prepare a 6-10 page management report addressing the following: 1. Use methods of descriptive statistics to summarize the data. Use visual tools and Tableau to graphically display the data. Comment on the findings. 2. Construct the exponentially smoothed series for turkey legs and soft drinks using alpha=.2 and alpha =.8. 3. Calculate and explain MSE and MAD for each series. 4. Forecast sales of turkey legs and soft drinks for days 21 through 25 with the best fitting series. Support your forecasting method with scholarly sources. You can download the Turkey Legs data file here, or find it attached in the Module 7: Case Study 3 assignment folder. Please review the Case Study Instructions and Grading Criteria before doing/submitting your work. For the third case study, the emphasis in grading will be on the presentation and correctness of your findings. When writing your paper, you should become acquainted with APA formatting. A template is located here for your use APA Template. Additional information can be located in the Pima Online Library. New