Financial Analyst of Clothes Shoes and Jewellery Industry in United States | Assignment
5 Pages1819 Words362 Views
Added on 2019-09-18
Question 1"You are a financial analyst in a major company in the 'Clothes, shoes and jewerly' industry in the United States. Your boss has tasked you with producing a sales forecast for the next 12 months of the overall industry. Your forecast will become the input to plan internal resources. Your boss wants to ensure that the right amount of materials, cash and people is in place to satisfy, no more and no less, the projected sales. Therefore, accuracy is quite important.In the file attached, you will find data from April 2003 through Mar 2014. Your task is to produce a monthly forecast for April 2014 through March 2015 (12 next months). "You need to come up with the best possible forecast using the methods we learnt in class. You will need to input your forecast month by month in the last question of this quiz.In addition, there are six numeric questions you need to answer to assess your understanding of the different forecasting methods we learnt in class. It is important to note that myCourses randomly selects questions corresponding to different methods, regardless of whether that is the best method for the specific data set you have received.There is also one open-ended question about trend and seasonality.In other words, to achieve the highest possible grades in this quiz you need to:Accurately answer the numeric questions about R^2, RMSE, Seasonal Factors and Deseasonalized Sales for a given method. This method may or may not be the most accurate one for your industry.Answer the open ended question about trend and seasonality observed in your industry.Produce the most accurately possible sales forecast for the next 12 months using any method and adjustments you may wish to follow.How will you be evaluated?For the randomly selected set of six questions, there is one single correct answer and you will need to input accurately to earn marks.Each of the six questions is worth seven points.You need to answer an open ended question about your understanding of the trend and seasonality in your industry worth 15 points.You need to produce a usable forecast for your industry. Usable means that it makes sense because it follows the historical trend and seasonality accounting for unusual events, as well as any necessary manual adjustments. This is worth five points.Since we are aiming for accuracy, your forecast will be evaluated against the forecasts of your fellow classmates. The most accurate forecast will receive full marks (40 points), the least accurate forecast will receive zero marks and a ranking order for the forecasts in between will receive partial ranked marks.
The point above means that it is in your best interest for you to outperform your classmates. In other words, your helping of other classmates will have a negative impact in your score by design: the more accurate the forecast of a classmate of yours the less marks you will receive. And the more accurate your forecast compared to the class the more marks you will receive.Acknowledgement of your understanding of these instructions and confirmation of having access to the raw historical data of your industry grants you three points.Make sure you check the box that reads "I understand and accept my task..." to earn three points.Access your excel called Clothes shoes and jewerly Industry (1).xlsxThe next six questions are designed to probe your understanding of the different methods we learnt in class.You are required to perform calculations to answer the given questions. For example, if you receive a question about the error for the linear regression with dummies, you have to transform the data into monthly dummy variables, run the regression, and calculate the RMSE.You need to base your answers on the calculations using all 132 monthly sales figures. In other words, when running your regressions and moving averages for the next six questions, you are required to use all points given in your data set.Question 2What is the RMSE for the linear method? (Simple linear regression, no dummies)Round to zero decimal places. This is,input the value as an integer (whole number). Don't use comma or points to separate the thousands. See examples:If your resulting RMSE = 6,890.21, you enter 6890If your resulting RMSE = 17,219.83, you enter 17220If your resulting RMSE = 507.41, you enter 507Question 3What is the Adjusted R-Square of the linear model? (Simple linear regression, no dummies)Round to one decimal place and enter the value as percentage without the percentage sign. Use a period (or point) to separate the integer from the fraction, DO NOT USE comma. See examples:If your resulting Adj R-Square = 49.31%, you enter 49.3If your resulting Adj R-Square = 65.89%, you enter 65.9If your resulting Adj R-Square = 0.3213, you enter 32.1
Found this document preview useful?
SEMESTER 1 – END OF SEMESTER TEST 2019lg...
3112 IBA-WORKSHOP Case Analysis Preparation Formlg...