logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Vincent AlexanderEnglish
(5/5)

675 Answers

Hire Me
expert
Maurice FrancePsychology
(4/5)

731 Answers

Hire Me
expert
Ivan BlankBusiness
(5/5)

954 Answers

Hire Me
expert
Elmer BaurData mining
(5/5)

739 Answers

Hire Me
Operations Research
(5/5)

Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA.

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Case Study- Furnmart Inc.

 

Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA.

 

The company does not have the financial resources to hold high levels of inventory, and therefore manufactures its furniture per sale orders. This strategy causes long delivery times (4-5 weeks) and other operational inefficiencies, including the cancellation of sales orders by their most loyal customers. Other furniture manufacturers, mainly from the USA have started penetrating into the GTA market, and the business future for Furnmart looks bleak.

 

John Smart the founder and CEO, decided to change the corporate strategy and to manufacture products for stock. In that way its delivery times will decrease to less than one week, and the company will be able to keep their market share and even increase it.

In order to minimize stock (inventory) levels and their very high financial cost, Smart asked the Operations Manager- Dave Butcher, to develop a forecasting method that will achieve this goal.

 

You just got your business degree from Humber, and on Monday afternoon you were assigned the job of developing a forecasting method.

 

It was decided to develop a prototype forecast, with only one product, and then to develop forecasting methods for all the other products of the company, if the prototype was successful.

 

Dave Butcher gave you the actual demand for one of the products- Single Computer Desk (SCD), which was as follows:

 

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year

47 45 49 48 52 50 51 54 55 56 60 63 2019

50 51 52 54 56 57 56 59 55 55 65 81 2020

54 56 58 57 61 62 63 65 67 67 69 75 2021

 

He asked you to prepare a report for his Wednesday morning meeting with John Smart. You should investigate three forecasting methods- Simple Moving Average, Weighted Moving Average and Exponential Smoothing. Then, test each of them on the actual demand of years 2019/2020/2021.

The more successful method will be used for the real forecasting in year 2022. Dave added that he had heard vaguely about a method (“they did not teach it when I was a student”), which uses trend, seasonality and “some other staff”, and maybe you should look into it as well.

 

The report should include the following:

 

1. Cover Page (including name of participants who worked), Content Page, sequence of answers, clarity, neat and clear graphs and tables (Titles, axis description, numbers), and good English for the whole report. Graphs/charts should be computer generated. (5 marks)

 

2. Executive Summary- One page of main findings, conclusions and recommendations. Use short sentences and figures to point out all your main findings, conclusions and recommendations. (5 marks)

 

3. Draw a graph of the actual demand of the SCD for years 2019/2020/2021. (5 marks)

 

4. Calculate a 3-months simple moving average, for each possible month of years 2019/2020/2021. Calculate the MAD, MSE and MAPE for this method. In addition to the formulas in the computer, show one manual calculation of a forecast of this method, for any month you choose (10 marks)

 

5. Calculate a 3-months weighted moving average with weighting of 5, 3, 2, for each possible month of year 2019/2020/2021. (5 for last month, 3 for the month before last, 2 for two months before last). Calculate the MAD, MSE and MAPE for this method. Show one manual calculation of a forecast of this method, for any month you choose. (15 marks)

 

6. Using the exponential smoothing method with α = 0.8, calculate the forecast for each possible month of year 2019/2020/2021. Calculate the MAD, MSE and MAPE for this method. Assume that the forecast for January 2019 was 50. Show one manual calculation of a forecast of this method, for any month you choose. (15 marks)

 

7. Draw a new graph, which includes the demand graph you did in Point 3 and three additional forecast graphs- one with the simple moving average figures (You calculated in Point 4), one with the weighted moving average figures (You calculated in Point 5) and one with exponential smoothing method (You calculated in Point 6). (10 marks)

 

8. Which method (SMA, WMA, EXM) is more suitable for the SCD, according to each forecast error (MAD, MSE and MAPE)? Explain. (10 marks)

 

9. Use trend and seasonality components of demand to develop a better forecast (than the methods you used so far in this assignment) for each month of 2022.

Follow the example we studied in class. Calculate: a) the average total % increase per year;

b) the average weight (%) of each month. (15 marks)

 

10. In order to prove that this method is superior, use it (the average total % increase per year and the average weight of each month) to forecast for each month of 2021, based on 2019/2020, compare to the actual figures of 2021, and calculate its MAD. (10 marks)

 

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

324 Experts Online