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 Accessible 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
Items Produced Zero.00Zero Zero.00Zero 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
Day by 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 Yr DIS (NYSE)
This fall 2016 13.10% Three.13%
Q3 2016 -Four.38% 2.21%
Q2 2016 -1.50% 2.77%
Q1 2016 -5.49% Zero.63%
This fall 2015 Three.47% Three.51%
Q3 2015 -9.94% -9.31%
Q2 2015 eight.82% -Zero.86%
Q1 2015 11.37% Zero.55%
This fall 2014 7.14% 1.27%
Q3 2014 Three.83% -2.52%
Q2 2014 7.08% Four.29%
Q1 2014 Four.81% 1.23%
This fall 2013 19.93% eight.10%
Q3 2013 2.12% 5.58%
Q2 2013 11.18% Zero.06%
Q1 2013 14.07% 7.86%
This fall 2012 -Three.29% 2.33%
Q3 2012 7.78% 5.76%
Q2 2012 10.80% -Four.94%
Q1 2012 16.74% 9.76%
This fall 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 Yr (NYSE)
This fall 2016 Three.13% MAD =
Q3 2016 2.21%
Q2 2016 2.77%
Q1 2016 Zero.63%
This fall 2015 Three.51%
Q3 2015 -9.31%
Q2 2015 -Zero.86%
Q1 2015 Zero.55%
This fall 2014 1.27%
Q3 2014 -2.52%
Q2 2014 Four.29%
Q1 2014 1.23%
This fall 2013 eight.10%
Q3 2013 5.58%
Q2 2013 Zero.06%
Q1 2013 7.86%
This fall 2012 2.33%
Q3 2012 5.76%
Q2 2012 -Four.94%
Q1 2012 9.76%
This fall 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 Yr (NYSE) Forecast Forecast Error MAD =
This fall 2016 Three.13% Three.00%
Q3 2016 2.21%
Q2 2016 2.77%
Q1 2016 Zero.63%
This fall 2015 Three.51%
Q3 2015 -9.31%
Q2 2015 -Zero.86%
Q1 2015 Zero.55%
This fall 2014 1.27%
Q3 2014 -2.52%
Q2 2014 Four.29%
Q1 2014 1.23%
This fall 2013 eight.10%
Q3 2013 5.58%
Q2 2013 Zero.06%
Q1 2013 7.86%
This fall 2012 2.33%
Q3 2012 5.76%
Q2 2012 -Four.94%
Q1 2012 9.76%
This fall 2011 10.09%
Q3 2011 -18.36%
Q2 2011 -1.02%
Q1 2011 5.54%
Drawback 5
Day by 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 Yr DIS (NYSE) Intercept = Zero.0319078217
This fall 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 fall 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 fall 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 fall 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 fall 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 fall 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.30%

Published by

Medical

View all posts