A commercial bakery has recorded sales (in dozens) for three
products, as shown below:
Day | Blueberry Muffins | Cinnamon Buns | Cupcakes |
1 | 52 | 16 | 68 |
2 | 52 | 15 | 32 |
3 | 52 | 17 | 36 |
4 | 52 | 17 | 71 |
5 | 56 | 20 | 44 |
6 | 52 | 21 | 39 |
7 | 54 | 25 | 38 |
8 | 58 | 22 | 71 |
9 | 49 | 26 | 38 |
10 | 53 | 28 | 36 |
11 | 59 | 29 | 33 |
12 | 53 | 29 | 70 |
13 | 58 | 30 | 39 |
14 | 51 | 32 | 36 |
15 | 52 | 34 | 33 |
a. Predict orders for the following day for each of the
products using an appropriate naive method.
Blueberry Muffin | : The (select one) 1)basic naive, 2)seasonal-adjusted naive, 3)trend-adjusted naive forecast is _______ | |
Cinnamon Buns | : The (select one) 1)trend-adjusted naive 2)seasonal-adjusted naive 3)basic naive forecast is _________ | |
Cupcakes | : The (select one) 1)trend-adjusted naive 2)seasonal-adjusted naive 3) basic naive forecast is ________ | |
b. What should the use of sales data instead of
demand imply?
The use of sales data instead of demand implies that (select one) 1)sales 2) demand adequately reflect (Select one) 1)sales 2)demand . We are assuming that no stock-outs occurred because demand equals sales if there are no shortages.
a.
Blueberry Muffin = Basic naive and the forecast is 52 as the demand is stable
Cinnamon Buns = Trend adjusted Naive and the forecast is 34+2 = 36 (As we can see for last 2 periods demand has increased by 2)
Cupcakes = Seasonal adjusted Naive and the forecast is 70 (Demand peaks up every 4th day and next [pick would be at 16th day)
b.
The use of sales data instead of demand implies that sales adequately reflect demand . We are assuming that no stock-outs occurred because demand equals sales if there are no shortages.
A commercial bakery has recorded sales (in dozens) for three products, as shown below: Day Blueberry...
A commercial bakery has recorded sales (in dozens) for three products, as shown below: Day Blueberry Muffins Cinnamon Buns Cupcakes 1 30 17 46 2 33 16 12 3 32 18 16 4 32 18 49 5 35 21 22 6 32 22 17 7 31 24 14 8 38 22 51 9 29 25 18 10 33 26 18 11 38 26 11 12 32 27 54 13 39 29 17 14 32 33 14 15 37 35 12...
A commercial bakery has recorded sales (in dozens) for three products, as shown below Cinnamon Buns Cupcakes Day Blueberry Muffins 1E 14 12 2 31 16 16 33 16 4 31 48 22 21 5 39 23 16 6 30 12 7 32 23 36 22 4 8 17 29 24 19 10 32 24 10 11 38 25 12 31 2" 50 13 35 3C 18 14 33 31 15 15 34 33 13 a. Predict orders for the...
the answers that are filled in are correct. please determine which
naive method was used for the cinnamon buns and cupcakes. the
choices are: trend-adjusted naive, seasonal-adjusted naive or
basic naive. (the answer is
not basic naive for cinnamon buns and cupcakes, i tried and got the
wrong answer when i selected that option)
Problem 3-1 A commercial bakery has recorded sales in dozens) for three products, as shown below. Blueberry Muffins 52 Cinnamon Buns Cupcakes 58 a. Predict orders...
48 57 Amy Bakery has four shops in different area in a city. Monthly sales (in thousands of dollars) from a random of 24 months from each of the 4 shops given in Table 1. Table 1: Monthly sales (in thousands of dollars) North East South West 77 75 97 60 45 42 60 54 56 49 68 47 44 39 58 57 63 61 69 51 75 63 79 50 90 81 99 73 32 47 46 41 41...
A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were Day: 1 2 3 4 5 6 7 8 9 Number sold: 33 35 40 42 42 42 43 48 49 Day: 10 11 12 13 14 15 Number sold: 46 52 46 48 57 50 a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 48 for Day 8, an...
1. Forecast demand for Year 4.
a. Explain what technique you utilized to forecast your
demand.
b. Explain why you chose this technique over others.
Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...
Examples 1,2,3
1. Beyond Tea Inc. wants to forecast sales of its menthol green
tea. The company is considering either using a simple mean or a
three-period moving average to forecast monthly sales. Given sales
data for the past 10 months use both forecasting methods to
forecast periods 7 to 10 and then evaluate each. Which method
should they use? Use the selected method to make a forecast for
month 11. (Show all calculations .... Please read Examples1, 2, 3...
Problem #1: Consider the below matrix A, which you can copy and paste directly into Matlab. The matrix contains 3 columns. The first column consists of Test #1 marks, the second column is Test # 2 marks, and the third column is final exam marks for a large linear algebra course. Each row represents a particular student.A = [36 45 75 81 59 73 77 73 73 65 72 78 65 55 83 73 57 78 84 31 60 83...
Problem 4: Variables that may affect Grades The data set contains a random sample of STAT 250 Final Exam Scores out of 80 points. For each individual sampled, the time (in hours per week) that the student spent participating in a GMU club or sport and working for pay outside of GMU was recorded. Values of 0 indicate the students either does not participate in a club or sport or does not work a job for pay. The goal of...
Problem 1: Confidence Interval for Percentage of B’s. The data set “STAT 250 Final Exam Scores” contains a random sample of 269 STAT 250 students’ final exam scores (maximum of 80) collected over the past two years. Answer the following questions using this data set. a) What proportion of students in our sample earned B’s on the final exam? A letter grade of B is obtained with a score of between 64 and 71 inclusive. Hint: You can do this...