Preview

Fhe Service

Good Essays
Open Document
Open Document
640 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Fhe Service
OPR1010 Operations Management (Winter 2010)
In-class Assignment 2: Forecasting

Directions:
( We will check the answers during the supplemental session on Feb. 18.
(Participation points will be considered for volunteers.
(This is not a take-home assignment. You do not have to turn in the answers.
(Use MS-Excel for Questions 1 through 4.

Q-1. The Polish General's Pizza Parlor is a small restaurant catering to patrons with a taste for European Pizza. One of its specialties is Polish Prize pizza. The manager must forecast weekly demand for these special pizzas so that he can order pizza shells weekly. Recently, demand has been as follows:

|Week |1 |2 |3 |4 |5 |6 |
|Pizzas |50 |65 |52 |56 |55 |60 |

(a) Forecast the demand for pizza for Week 4, 5, and 6 using a naïve method.
(b) Forecast the demand for pizza for Week 4, 5, and 6 using the simple moving average method with n = 3.
(c) Repeat the forecast for Week 4, 5, and 6 by using the weighted moving average method with n = 3 and weights of 0.50, 0.30, and 0.20 with 0.50 applying to the most recent demand.
(d) Calculate the MAD and MSE for each method.

Q-2. The monthly demand for units manufactured by the Ace Rocket Company has been as follows.

|Month |May |Jun. |
|1 |$2.70 |760 |
|2 |$3.50 |510 |
|3 |$2.00 |980 |
|4 |$4.20 |250 |
|5 |$3.10 |320 |
|6 |$4.05 |480 |
|Total |$19.55 |3300 |
|Average |$3.258 |550 |

Q-3. Chicken Palace periodically offers carryout five-piece

You May Also Find These Documents Helpful

  • Good Essays

    Using the forecast model for pasta shown in Exhibit 5, what is your forecast of the demand for pizza?…

    • 495 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Wk3 Johnson chapquestions

    • 334 Words
    • 2 Pages

    Q. 1 - In drawing up a sales budget for a casual Italian restaurant, what percentage of weekly sales should be forecasted for Friday and Saturday evenings? 43% should be forecast for those 2 evenings as they are the busiest nights and you should have a higher sales volume then.…

    • 334 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Ll Beans

    • 832 Words
    • 4 Pages

    2. Use the provided Excel file that contains demand and forecast data for a collection of items.…

    • 832 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    bugmenot

    • 800 Words
    • 3 Pages

    Using the forecast model for pasta shown in Exhibit 5, what is your forecast of the demand for pizza? 
Hints:…

    • 800 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The given data used for the forecast is the Carlson sales data for 48 months. We used the trend and seasonal method. Bellow the techniques are given to estimate the seasonal method.…

    • 476 Words
    • 51 Pages
    Satisfactory Essays
  • Good Essays

    Level Operations

    • 448 Words
    • 2 Pages

    Stephanie has determined the best production quantity per cycle for each day of the week (Figure 2). Figure 3 forecasts the quantity demanded versus the quantity supplied over the five week time frame.…

    • 448 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    We first predict the annual demand for the year 1972 based on trend for 4 months of 1972 based on corresponding months of 1971.…

    • 1410 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    Forecasting

    • 623 Words
    • 17 Pages

    c. Use the linear trend developed in part (b) to prepare a forecast sale in year 8.…

    • 623 Words
    • 17 Pages
    Satisfactory Essays
  • Powerful Essays

    Activity 3

    • 806 Words
    • 4 Pages

    By observing the MAD in part (d), it can be observed that the value is the smallest among the 3 methods, hence I will choose the trend line as the forecast predicted is more accurate. Moreover the demand for the future can also be seen.…

    • 806 Words
    • 4 Pages
    Powerful Essays
  • Better Essays

    Dominoes Analysis

    • 645 Words
    • 3 Pages

    Dominoes’ Pizza is considering entering the marketplace in my community of Middleburg, NC. Middleburg is a small town in Vance County, North Carolina located near the Virginia line. In this paper we are going to create a demand analysis and forecast possible success for Dominoes opening a location in Middleburg, NC. We are also going to go over the demographics and other independent variables such as price of pizza, price of soda and other things offered by the company and how it influences the decision of putting a Dominoes pizza in such a location. Based on the forecasted demands, I will determine whether or not Dominoes should consider opening a restaurant in Middleburg, NC.…

    • 645 Words
    • 3 Pages
    Better Essays
  • Satisfactory Essays

    Using the sample data: The Demand for Pizza, (shown below) I will conduct a demand analysis and forecast for pizza. Through this analysis, I make a decision whether Domino’s should establish a presence in the community depicted in the sample data. The sample data included one dependent variable (Y) Quantity demanded and three independent variables (X1) price of pizza (X2) Tuition (X3) Price of Soft drinks and (4) Location 1 for urban and 0 for otherwise. This data included 30 observations.…

    • 1393 Words
    • 6 Pages
    Satisfactory Essays
  • Better Essays

    Thuearth

    • 1028 Words
    • 5 Pages

    *2.- Usando el modelo de presupuesto del Ex*hibit 5, estime la demanda para la pizza. (Tips: use los datos de la Tabla B y del Exhibit 7, ojo con las diferencias entre los consumidores y no consumidores de Pasta Cucina…

    • 1028 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    A firm uses simple exponential smoothing with [pic] to forecast demand. The forecast for the week of January 1 was 500 units whereas the actual demand turned out to be 450 units. Calculate the demand forecast for the week of January 8.…

    • 841 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Nahmias Chapter 2

    • 1516 Words
    • 7 Pages

    One-step-ahead Month July August September October November December Forecast 205.50 225.25 241.50 250.25 249.00 240.25 Two-step-ahead Forecast 149.75 205.50 225.25 241.50 250.25 249.00 Demand 223 286 212 275 188 312 MAD = e1 -17.50 -60.75 29.50 -24.75 61.00 -71.75 44.2 e2 -73.25 -80.50 13.25 -33.50 62.25 -63.00 54.3…

    • 1516 Words
    • 7 Pages
    Satisfactory Essays
  • Satisfactory Essays

    2. Using the Fitter sales forecast for July through December that you created in Exercise 1, develop a spreadsheet for sales and operations planning for those same months. Use the format of the spreadsheet discussed in class. The number of working days for each month is shown in below. Assume that you have to maintain inventory of 100 from July to December.…

    • 254 Words
    • 1 Page
    Satisfactory Essays