Case 1: Descriptive Summaries
Key Objective: You are tasked with identifying and discussing what makes a Crusty Pizza Company restaurant successful and, conversely, unsuccessful. Use:
- The data for the 60 stores in worksheet “Descriptive” to prepare your report.
- Summary tools of chapters 2 and 3 to perform the analysis and explore relationship between each variable and profit
- Up to 8 pages for the body of report, plus a cover page, and any appendixes.
Your guiding light and focus to plan the analysis and organize your report must be the Key Objective mentioned above. Use summaries that you believe best allow you to accomplish the task. In all comparisons, you must comment on your results and interpret findings as they pertain to the Key Objective.
Case 2: Quality Control Charting
Key Objective: You are tasked with analyzing data to create center-line, UCL, and LCL for c-charts, p-charts, charts, and R charts. You must also plot the data points and interpret patterns present in each chart to decide whether any assignable causes of variation are visible, and whether each process is in statistical control.
- Use the data in worksheet “Quality Control” to perform the analysis.
- You may use up to 8 pages for the body of your report, plus a cover page, and any appendixes.
- For the complaint data
- Develop a c-chart for each store (5 total)
- For the pizza weight data
- Develop a p-chart for each store (5 total)
- For the delivery time data
- Develop a x and r chart for each store (4 total charts)
Case 3: Forecasting with Time Series Analysis
Key Objective: Crusty Pizza Executives must forecast December sales for the 10 stores in worksheet “Time Series”.
- Use data in worksheet “Time Series”. Plot the data for each store.
- Develop a sales forecast for each of the 10 stores for the month of December, using:
- A three month moving average
- A 2- month weighted moving average, with weights of 0.7 on the most recent month and 0.3 on the older month.
- Exponential smoothing with an alpha value of 0.25. Assume February forecast is January’s actual.
- Compute measures of forecast accuracy to recommend the best forecasting technique to use for the data.
- Rank the 10 stores based on the forecasts you made with the technique that you determined (in the above step) to be the best forecasting method.
- You may use up to 8 pages for the body of report, plus a cover page, and any appendixes.
Do you need urgent help with this or a similar assignment? We got you. Simply place your order and leave the rest to our experts.