OPER2045 – Master Planning Fall 2018.
Added on - 19 Sep 2019
OPER2045 – Master Planning Fall 2018Assignment # 1 (KH)– 12.5% of Final GradeA-CAT Corp.: Forecasting – Ivey CaseThis case analysis is to be prepared in teams of 2-3. Please sign yourteam up in class. Go through the process of a case prep to start. Thatwill help you with the analysis of the case.Your case analysis needs to cover the following questions:1.Research the electrical appliances industry in India. (1 pagemaximum) Pay particular attention to the market segment that A-CAT Corp. competes in. What significance does this analysis haveon the forecasting process that A-CAT Corp. should use? Pleasedocument references in report.2.Plot the data and describe what you see. What does it mean andhow would you use the information from the plot to help youdevelop a forecast.Look at both yearly and monthly data.3.Create at least 3 forecast models, using 2 or more combinedquantitative forecasting techniques for the demand over the next12 months. Put each model in a separate worksheet. Correlationshould be considered. Based on the historical data provided,determine which one has the least amount of error. Can we assumethat will be the best forecast? Why not?4.Recommend what forecasting process A-CAT Corp. should be using.What forecasting techniques should they use? Who should beinvolved in forecasting? How will they monitor the forecast goingforward? What external information should be used? The finalforecast recommendation model including adjustment forqualitative data should be in a separate worksheet.Report Format:A word document and excel file are required.A team contract, you choose format is dueby week of October 1 atend of lab class.This team contract should at a minimum includeperformance expected from each team member including progressivediscipline (a basis for positive or negative reinforcement), a projectplan- when meeting, what discussing, preparation required, yourcontact information, and all team members must sign. On previousassignments there were a few issues and most of you have suggestedon your lessons learned that you should not procrastinate. The projectplan may help you follow through on your lessons learned if you followit. There are more detailed instructions on eConestoga.Word Document-Hardcopy hand in requiredand electronic copy indropbox.This is all I require-not written case analysis.Include a title page with project name, student names and ID,professor name and date submittedExecutive Summary