? EXCEL ASSIGNMENT - Summer 2021 OMGT 3123 - Ch. 9 Forecasting Problem Below is tabled historical
Fantastic news! We've Found the answer you've been seeking!
Question:
?
Transcribed Image Text:
EXCEL ASSIGNMENT - Summer 2021 OMGT 3123 - Ch. 9 Forecasting Problem Below is tabled historical information for Widget Sales. Read the assignment completely before starting. TABLE 1. Historical Sales of Widgets During the last 12 months Month 1 2 3 4 5 6 7 8 9 10 11 12 Sales 1550 1540 1570 1600 1580 1610 1630 1600 1640 1680 1630 1680 Assignment: For the widget sales data given above, your boss wants you to compare the following models using the Mean Absolute Deviation (MAD) measure of error: 1. Exponential Smoothing model for an alpha of 0.35 and a Month 1 forecast of 1550 widgets. 2. Two-period Moving Average model (start Forecast and Absolute Deviation with Month 3). On sheet 1 of the file build an appropriate table in Excel that includes period, actual demand, forecasts and Absolute Deviation columns for calculating MAD for the two models. Use one decimal place on all calculated numbers. In each case, be sure to calculate the MAD and make a forecast for Month 13. Also make sure there are equations behind all calculated numbers in the spreadsheet. Develop one graph for the two models of Widgets versus Month comparing actual demand to forecast demand. Make sure the graph is placed on a separate sheet (i.c., page 2). Include appropriate title for the Graph using 14-point font size on all text. On the vertical axis make sure the maximum is set to a value of 1700 and the minimum value to 1500. On the horizontal axis make sure time increments are 1 month. Use the Line Chart (you can exclude the Month column). Report to your boss in a text box just below the Table on sheet 1: 1. Your full name. 2. The model that is best for the MAD measure and the corresponding Month 13 forecast. 3. Without doing any calculations, recommend a model (based on the visual result of the graph) that you think may give a better forecast than the models you have been asked to study. Explain why you think this. EXCEL ASSIGNMENT - Summer 2021 OMGT 3123 - Ch. 9 Forecasting Problem Below is tabled historical information for Widget Sales. Read the assignment completely before starting. TABLE 1. Historical Sales of Widgets During the last 12 months Month 1 2 3 4 5 6 7 8 9 10 11 12 Sales 1550 1540 1570 1600 1580 1610 1630 1600 1640 1680 1630 1680 Assignment: For the widget sales data given above, your boss wants you to compare the following models using the Mean Absolute Deviation (MAD) measure of error: 1. Exponential Smoothing model for an alpha of 0.35 and a Month 1 forecast of 1550 widgets. 2. Two-period Moving Average model (start Forecast and Absolute Deviation with Month 3). On sheet 1 of the file build an appropriate table in Excel that includes period, actual demand, forecasts and Absolute Deviation columns for calculating MAD for the two models. Use one decimal place on all calculated numbers. In each case, be sure to calculate the MAD and make a forecast for Month 13. Also make sure there are equations behind all calculated numbers in the spreadsheet. Develop one graph for the two models of Widgets versus Month comparing actual demand to forecast demand. Make sure the graph is placed on a separate sheet (i.c., page 2). Include appropriate title for the Graph using 14-point font size on all text. On the vertical axis make sure the maximum is set to a value of 1700 and the minimum value to 1500. On the horizontal axis make sure time increments are 1 month. Use the Line Chart (you can exclude the Month column). Report to your boss in a text box just below the Table on sheet 1: 1. Your full name. 2. The model that is best for the MAD measure and the corresponding Month 13 forecast. 3. Without doing any calculations, recommend a model (based on the visual result of the graph) that you think may give a better forecast than the models you have been asked to study. Explain why you think this.
Expert Answer:
Answer rating: 100% (QA)
Important Please note that we cannot include the Excel sheet in the answer column therefore I am inc... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
2 3 4 5 3. Item Value 15 30 40 20 25 Weight 2 4 6 8 10 Considering the above table contains the items along with their profit and weight. Now, your task is to calculate the maximum profit for...
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 ARASIN22227 17 18 19 20 21 23 24 25 26 1) (2) Sales Price per unit Variable Cost per unit Contribution per unit Contribution Margin Ratio Break Even Point Sales...
-
According to Dr. Grant, creatives are people who ________. A. Are procrastinators B. Act on multiple ideas C. Plan out each detail D. Are highly confident with no doubts about their success
-
Listed below are the net sales for a San Franciscoarea mail-order retailer for the years 2003 to 2012. Use the mean sales for the earliest three years to determine a base and then find the index for...
-
What are time three primary financial statements with which we communicate financial accounting- information?
-
The following scenarios describe situations faced by hypothetical companies that currently have a centralized organization structure. As you review each of the scenarios, provide your opinion as to...
-
Marwick's Pianos, Inc., purchases pianos from a large manufacturer and sells them at the retail level. The pianos cost, on the average, $2,450 each from the manufacturer. Marwick's Pianos, Inc.,...
-
On January 1, 2024, the general ledger of Dynamite Fireworks includes the following account balances: Accounts Cash Debit $24,900 Credit Accounts Receivable 6,300 Supplies 4,200 Land 61,000 Accounts...
-
On January 1. Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year 500,000 15 7% Required: 1) Calculate the bond selling price given the...
-
1. The income statements for Road Inc. and Runner Inc. for the year ended December 31, 2021, are attached. Road Inc. acquired 60% of the shares of Runner Inc. on the date that Runner Inc. was...
-
7. A toy car of mass 10 kg initially moves with a speed of 2 m/s. How much work must be done on the car to increase its speed to 8 m/s?
-
Complete the following problems. a. Express the area A of the cross-section cut from the ellipsoid x 16 25 = 1 by the plane z = d as a function of d. (The area of an ellipse with semiaxes a and b is...
-
. Create a WPA form that will allow USF students to enter their personal data. Create an interface to collect a first name, last name. Your program will assign the student a U number and will display...
-
Do managers from all functional areas of the firm contribute input to the information system?
-
Linda is 40 years old, expect to retire in 25 years at age 65, and then live for 15 more years until age of 80. Her current income is $40,000 and she doesn't have any additional assets. If her target...
-
Consider the six data points given in the table below. 1.5 1.9 6 Xi Yi 1 2 2 E = 0.005 2.3 10 2.6 30 3 47 In this problem, your task is to find the least squares regression line for this data. (a)...
-
Velshi Printers has contracts to complete weekly supplements required by fortysix customers. For the year 2018, manufacturing overhead cost estimates total $600,000 for an annual production capacity...
-
Patty Bayan is a single taxpayer living at 543 Space Drive, Houston, TX 77099. Her Social Security number is 466-33-1234. For 2012, Patty has no dependents, and her W-2 from her job at a local...
-
Mallory Corporation has a calendar year-end. The corporation has paid estimated payments of $10,000 during 2012 but still owes an additional $5,000 for its 2012 tax year. a. When is the 2012 tax...
-
Fisafolia Corporation has gross income from operations of $220,000 and operating expenses of $160,000 for 2012. The corporation also has $20,000 in dividends from publicly traded domestic...
-
Using Snell's law (i.e., \(n_{o} r_{o} \cos \theta_{0}=n_{1} r_{1} \cos \theta_{1}\) ), show that \[ \left(\sin \left(\frac{\theta_{1}}{2}ight)ight)^{2}=\frac{r_{o}}{2 r_{1}}\left[2\left(\sin...
-
Derive an asymptotic form for \(\Gamma_{h}\) and \(\Gamma_{v}\) when the grazing angle is very small.
-
Deficits and fiscal consolidation As seen in the following table, the 2008 financial crisis left the United States with an enormous federal budget deficit in 2009. There was a substantial fiscal...
Study smarter with the SolutionInn App