Drawback 1
SOLVE THE FOLLOWING NON-LINEAR PROBLEM USING SOLVER
YOU HAVE TO INSERT THE FORMULAS IN GREEN CELLS
MARKETING COSTS ARE HIGHLIGHTED IN RED IN CELLS C20 AND D20
INSERT THE FORMULA FOR MARKETING COST IN CELL C19 AND D19
Drawback With Nonlinear Advertising and marketing Prices
Doorways (D) Home windows (W) Vary Identify Cells
Unit Revenue (Gross) $Four $6 DoorsProduced C12
Hours Hours GrossProfitFromSales H12
Hours Used Per Unit Produced Used Out there HoursAvailable G7:G9
Plant 1 1 Three <= eight HoursUsed E7:E9
Plant 2 5 2 <= 14 HoursUsedPerUnitProduced C7:D9
MarketingCost C14:D14
TotalMarketingCost H14
Doorways Home windows TotalProfit H16
Models Produced Zero.000 Zero.000 Gross Revenue from Gross sales UnitProfit C4:D4
UnitsProduced C12:D12
Advertising and marketing Value Complete Advertising and marketing Value WindowsProduced D12
D^Three 2*W^2
Complete Revenue
Drawback 2
Each day worth of Disney inventory and NYSE are given beneath
PLOT THE DATA POINTS ON A GRAPH, INSERT A TREND LINE AND FIND OUT THE EQUATION
y x
Dependent Unbiased
Quarter 12 months DIS (NYSE)
This autumn 2016 13.10% Three.13%
Q3 2016 -Four.38% 2.21%
Q2 2016 -1.50% 2.77%
Q1 2016 -5.49% Zero.63%
This autumn 2015 Three.47% Three.51%
Q3 2015 -9.94% -9.31%
Q2 2015 eight.82% -Zero.86%
Q1 2015 11.37% Zero.55%
This autumn 2014 7.14% 1.27%
Q3 2014 Three.83% -2.52%
Q2 2014 7.08% Four.29%
Q1 2014 Four.81% 1.23%
This autumn 2013 19.93% eight.10%
Q3 2013 2.12% 5.58%
Q2 2013 11.18% Zero.06%
Q1 2013 14.07% 7.86%
This autumn 2012 -Three.29% 2.33%
Q3 2012 7.78% 5.76%
Q2 2012 10.80% -Four.94%
Q1 2012 16.74% 9.76%
This autumn 2011 26.43% 10.09%
Q3 2011 -22.76% -18.36%
Q2 2011 -9.39% -1.02%
Q1 2011 14.87% 5.54%
Drawback Three
FIND OUT THE 5 DAY MOVING AVERAGE AND COMPLETE THE SPREADSHEET
Plug within the formulation in inexperienced cells
N=5
Transferring Common Forecasting
Unbiased Forecast Error
Quarter 12 months (NYSE)
This autumn 2016 Three.13% MAD =
Q3 2016 2.21%
Q2 2016 2.77%
Q1 2016 Zero.63%
This autumn 2015 Three.51%
Q3 2015 -9.31%
Q2 2015 -Zero.86%
Q1 2015 Zero.55%
This autumn 2014 1.27%
Q3 2014 -2.52%
Q2 2014 Four.29%
Q1 2014 1.23%
This autumn 2013 eight.10%
Q3 2013 5.58%
Q2 2013 Zero.06%
Q1 2013 7.86%
This autumn 2012 2.33%
Q3 2012 5.76%
Q2 2012 -Four.94%
Q1 2012 9.76%
This autumn 2011 10.09%
Q3 2011 -18.36%
Q2 2011 -1.02%
Q1 2011 5.54%
Drawback Four
Full the Exponential Forecast utilizing the system
Forecast = *(final worth) + (1 – )*Final Forecast
Plug within the formulation in inexperienced cells
Alpha ( ) = Zero.25
Quarter 12 months (NYSE) Forecast Forecast Error MAD =
This autumn 2016 Three.13% Three.00%
Q3 2016 2.21%
Q2 2016 2.77%
Q1 2016 Zero.63%
This autumn 2015 Three.51%
Q3 2015 -9.31%
Q2 2015 -Zero.86%
Q1 2015 Zero.55%
This autumn 2014 1.27%
Q3 2014 -2.52%
Q2 2014 Four.29%
Q1 2014 1.23%
This autumn 2013 eight.10%
Q3 2013 5.58%
Q2 2013 Zero.06%
Q1 2013 7.86%
This autumn 2012 2.33%
Q3 2012 5.76%
Q2 2012 -Four.94%
Q1 2012 9.76%
This autumn 2011 10.09%
Q3 2011 -18.36%
Q2 2011 -1.02%
Q1 2011 5.54%
Drawback 5
Each day worth of SP and NASDAQ for 2014 are given beneath
RUN A REGRESSION ANALYSIS, PLOT THE DATA ON A SCATTER GRAPH
FIND INTERCEPT AND SLOPE TO FORECAST
Plug within the formulation in inexperienced cells
y Unbiased y = + β*x
Dependent Variable variable (x) Forecast Forecast error
Quarter 12 months DIS (NYSE) Intercept = Zero.0319078217
This autumn 2016 13.10% Three.13% 7.36% -5.74% Slope = 1.3335857597 β
Q3 2016 -Four.38% 2.21% 6.14% 10.52%
Q2 2016 -1.50% 2.77% 6.88% eight.38%
Q1 2016 -5.49% Zero.63% Four.03% 9.52%
This autumn 2015 Three.47% Three.51% 7.87% Four.40%
Q3 2015 -9.94% -9.31% -9.22% Zero.72% MAD =
Q2 2015 eight.82% -Zero.86% 2.04% -6.77%
Q1 2015 11.37% Zero.55% Three.93% -7.44%
This autumn 2014 7.14% 1.27% Four.89% -2.25%
Q3 2014 Three.83% -2.52% -Zero.17% -Four.00%
Q2 2014 7.08% Four.29% eight.91% 1.83%
Q1 2014 Four.81% 1.23% Four.83% Zero.02%
This autumn 2013 19.93% eight.10% 13.99% -5.94%
Q3 2013 2.12% 5.58% 10.63% eight.51%
Q2 2013 11.18% Zero.06% Three.27% -7.91%
Q1 2013 14.07% 7.86% 13.67% -Zero.40%
This autumn 2012 -Three.29% 2.33% 6.30% 9.60%
Q3 2012 7.78% 5.76% 10.87% Three.08%
Q2 2012 10.80% -Four.94% -Three.39% -14.19%
Q1 2012 16.74% 9.76% 16.21% -Zero.53%
This autumn 2011 26.43% 10.09% 16.65% -9.78%
Q3 2011 -22.76% -18.36% -21.29% 1.46%
Q2 2011 -9.39% -1.02% 1.83% 11.22%
Q1 2011 14.87% 5.54% 10.57% -Four.Three

Published by

Medical

View all posts