Operations Forecasting for "Amazon.com" and Microsoft® Excel® (Template provided)

User Generated

qnebae88

Business Finance

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. The first 60 rows are "Historical Passenger Headcount" (Column "B") over a period of time (Column "A"), and the "Forecasted Passenger Headcount" (Column "C")--future "Potential" travelers.

6) I looked through the chapter 18 in our week 5, and I have not found a paragraph or something about favorable and unfavorable forecast. As per assignment: "what it means in terms of favorable or unfavorable forecast and why or why not..." Can you give us example(s) what favorable and/or unfavorable forecast is? "Favorable" would an increase in potential air travelers per the forecast number going "Up", and "Unfavorable" would an decrease in potential air travelers per the forecast number going "Down". I never foretasted anything in business, and it is difficult to implement the homework without some examples. The excel template is just a place to input the numbers, but it would be helpful to have some explanation on what quadrants are, favorable and unfavorable forecasting.

Excel Template instructions:

Columns "A" & "B", which will populate Column "C" with a forecasted value, based on the historical (Time-based) entries in "A" & "B".

  • Column "A" must use time type data entries: Days, Months, Years, Minutes, Seconds, Hours...Etc.
  • Column "B" must use Numerical data entries: Quantities Sold, Admissions, Monetary Amounts, Widgets Produced...Etc.

DO NOT make any changes to Cells in Column "C". I have taken the formula and incorporated it to calculate a future (forecast) for the historical "Time" and Numerical" data entered into Columns "A" & "B".

Forecasting will not show for Column "C", Cells C3 thru C14, as you will require more data points in Columns "A" & "B" than just the A3 thru A14, and B3 thru B14. However, the Template is set up to provide a forecast out to 8-years (as currently formated for monthly speeding ticket issued by law enforcement).

Notice Column "C" Cells C15 thru C38, shows "C15 - C26" as trending to higher numbers (more tickets issued); this could have multiple meanings. "C27 - C38" as trending to lower numbers (less tickets issued); this could have multiple meanings as well.

NOTE: "C39 - C98", the trend is definitely indicating decreasing numbers, but that is because there is no data entered in Column "B" for those corresponding forecasts.

Lastly, I am not interested in the Confidence Intervals, as this function is not working in earlier versions of MS Excel. So, use the data you have collected, enter into the appropriate cells in Columns "A" & "B"...DO NOT ENTER DATA INTO COLUMN "C".

The expectation is that you are able to present a compelling narrative from the Quantitative data, into a Qualitative understanding of what the forecast is presenting, and what a company might do to posture the business direction for success or minimizing failures as a result.

There should still be ample time to compete this assignment on time using the new revised Template attached.

I hope this helps

Once again if you do not know how to work excel, PLEASE DO NOT WASTE EITHER OF US.

Thank you for reading!! the assignment is do like yesterday!!😢 😓

Unformatted Attachment Preview

Date Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Speeding Tickets 44,539 39,800 55,918 44,973 47,100 49,595 49,702 55,066 53,191 53,249 32,971 63,074 65,466 65,361 55,958 53,139 63,380 63,612 55,824 63,771 63,356 53,490 43,659 43,167 33,810 64,970 64,780 52,610 53,200 53,326 43,129 39,178 37,663 35,589 36,024 44,163 Forecast 53,367 57,779 60,952 60,918 60,106 61,870 63,282 62,802 63,967 64,803 63,719 61,038 58,673 55,119 56,815 58,278 57,812 57,487 57,202 55,639 53,745 51,861 49,927 48,238 47,615 47,426 47,256 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 47,067 46,884 46,695 46,513 46,324 46,135 45,952 45,763 45,581 45,392 45,203 45,032 44,844 44,661 44,472 44,289 44,100 43,912 43,729 43,540 43,357 43,168 42,980 42,803 42,614 42,431 42,242 42,060 41,871 41,682 41,499 41,310 41,128 40,939 40,750 40,580 40,391 40,208 40,019 39,836 39,648 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 39,459 39,276 39,087 38,904 38,716 38,527 38,356 38,167 37,985 37,796 37,613 37,424 37,235 37,053 36,864 36,681 Operations Forecasting Grading Guide OPS/571 Version 8 Operations Management Copyright Copyright © 2017, 2016, 2013 by University of Phoenix. All rights reserved. University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries. Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation. Edited in accordance with University of Phoenix® editorial standards and practices. Operations Forecasting Grading Guide OPS/571 Version 8 Individual Assignment: Operations Forecasting Purpose of Assignment The purpose of this assignment is for students to learn how to apply Operations Forecasting. Resources Required Microsoft® Excel® Content Met Partially Met Not Met Total Available Total Earned 5 #/5 Partially Met Not Met Comments: Selected a business operations dataset from the internet or other sources which can be used for forecasting in the University Library. Developed a minimum of three quantitative forecasts using Microsoft® Excel®. Compared and contrasted each quantitative forecast developed. Chose the one forecast determined to be the best for the firm and be prepared to explain why you chose this. Evaluated the impact this forecast would have on the firm from a financial metrics standpoint. Developed a 700-word report describing your Forecasting Project including details on all the assignment steps. Writing Guidelines The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements. Intellectual property is recognized with in-text citations and a reference page. Paragraph and sentence transitions are present, logical, and maintain the flow throughout the paper. Sentences are complete, clear, and concise. Met Comments: 2 Operations Forecasting Grading Guide OPS/571 Version 8 Writing Guidelines Met Partially Met Not Met Total Available Total Earned 2 #/2 7 #/7 Rules of grammar and usage are followed including spelling and punctuation. Assignment Total Additional comments: # Comments: 3 Example 1: Test points in relation to how long students are studying? Begin with some historical data about test points (y =), and hours studied (x =). “x” “y” You want to calculate, how many points a student will get, who has studied for 8 hours. You can accomplish this with MS Excel’s forecast function. “x” equals 8, because you are looking for a value for 8 hours argument The known “y's” are the test points, which you already know (Column “C”) The known “x's” are the hours spent studying, which you also know (Column “B”) The Formula in this situation is =FORECAST(B11,C3:C10,B3:B10) Example below: Using the formula, one would arrive at a “Forecasted” value is 77. So, the “Value” 77 means, that based on historical values, a student who studies for “x” = “8” hours, will score “y” = “77” points on a given test.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Done and dusted, should you need help with any other project, please let me know

NIKE CUSTOMER SATISFACTION FORECAST

NIKE CUSTOMER SATISFACTION FORECAST
Student Name
Institutional Affiliations

1

2

NIKE CUSTOMER SATISFACTION FORECAST

Based on the information provided by the first 7 years from 2010 to 2017, Nike’s satisfaction can
be categorized by the information provided in the charts below. It helps in indicating the
necessary quotient of information as defined by the information in figure 1 below. Due to
competition in the market and different brands produced by different companies in the sports
apparel industry, Nike’s consumer satisfaction ranks averagely at 80%. To determine the future
growth and how the company will fair in...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags