Blog

Why is the mission statement of a company important for Operations Management?

Please create a chart with the demand data. Based on your observation, which other forecasting method would also be optimal for this forecast?

EXHIBIT 6 The data in the file Midterm_Exhibit 6_DATA.xlsm presents the demand and forecast for a specific product (in number of units). Please use this data to calculate the answers to the following questions. DO NOT ADD COLUMNS OR ROWS IN THE EXCEL FILE. Important: When clicking on the link, if the file does not open you will find it in the “download” section of your browser (bottom left of the page) and you can open it from there. If it still does not open, make sure that you are not editing a formula in another Excel file (this sometimes prevents you from opening a new file). Please note that this file is protected against saving. Do not close this file until you submit the exam, otherwise you may loose its content. In case you inadvertently closed the file, please download it again.

EXHIBIT 5 In this exhibit, you will have to analyze a short news story and describe it with concepts we learned in the course.

BEFORE SUBMITTING Please: Make sure that you answered all questions Close all your Excel files. After the exam, please delete all exam files from your computer Click the “Submit Quiz” button I will manually check all responses, and post the grades towards the end of next week.

You have a time series with past demand data over 10 periods, and you observe a developing positive trend. Which of the following methods will result in the most adaptive forecast?

Please write the correct formula you should type in Excel to calculate the trend factor for 2020 using an exponential smoothing with trend forecast method (the formula needs to be entered in a way that allows to calculate the forecasts for the other months as well). All references refer to the cells in the file you downloaded for this exhibit.

An intern in the production department calculated different measures of forecast accuracy, and forgot to properly label the results. Which of the following answers can you identify as being WRONG?

What is the MAD of this forecast? Please provide your answer rounded to the closest whole number.

Please forecast the demand for Week 30 using a weighted moving average forecast, based on the data and parameters indicated in the Excel file. Round your answer to the closest whole number.