Description Please review!! Before you agree to work on assignment You must an ABOVE average understanding of Excel(formulate input to obtain the correct output). The EXCEL template is attached is must be used to get the desired results. *** Please review Entire post to save us both the trouble*** *** I have had two tutor FAIL to complete the assignment. Please have a understanding of Excel before you accept this assignment!!*** Purpose of Assignment The purpose of this assignment is for students to learn how to apply Operations Forecasting. Assignment Steps Resources: Microsoft® Excel® (Template provided) Select a business operations dataset from the internet, which can be used for forecasting what the results may be at a future state (monthly [for two years], quarterly [for five years], annually [for 20 years]. (See example in the Template). Use caution in using the template, as some of the cells contain formatted functions for performing calculations. You should only need to enter data into Column A and B only. Review the template and the associated data. This should give you an idea of the types of data you will require, and what the results columns reveal. You are required to provide an APA formatted reference to the location of the source data (Do Not just enter the Web Link). The returned work from previous week’s work, should give you some insight as to what an APA reference should look like. Develop a run over a given period, upper limit and lower limit as to confidence in the forecast using Microsoft® Excel®.Template Compare and contrast each quadrant of the forecast. Evaluate the impact this forecast would have on the firm from a financial metrics standpoint, by writing a 300-word report in which you describe your forecasting project and what it means in terms of favorable or unfavorable forecast and why or why not.. Format your assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. Please review!! Professor explenation “1) It says use the Excel template. And it also says: “by writing a 300-word report in which you describe your forecasting project” – my question here is do we use the Microsoft Word to for the 300-word report after we simulated the forecasting in the Excel? YES. Do we submit the Excel as well or just the Microsoft word document? YES. 2) In the Excel template the date in the column A is from A4 till A 60. Do we also enter our data from A4 to A60? This is a bit subjective, as it is based on what option you selected from the list (monthly [for two years {24 rows}], quarterly [for five years {20 rows}], annually [for 20 years {20 rows}]). How much data do we need to input to create a forecast? Presented above as number of rows. 3) So, if we will input data in columns A and B, the rest of the columns will calculate automatically? YES. And will the chart then readjust based on the data that each of us input in the column A and B? YES. 4) In the homework it says: “Compare and contrast each quadrant of the forecast.” Can you please clarify where the quadrants are? For the Monthly, there will be two quadrants (12 months and 12 months); Quarterly there will be five quadrants (5 – one month periods); and Annually, there will be two quadrants (one 10 year and 10 ten year) Or what do you consider quadrants? Above explained. 5) Is this template used in real life to forecast operations? This “exact” template may or may not be used, but the concept and means of arriving at the answers is used in forecasting a future state (usually based on a “time” factor). How is this template used in a real business? It would be helpful to know the application of this template in real life. As the data, which is currently used in the template, are real life airline passenger forecasting.
Recent Comments