There are 3 things to consider to help you gather the information needed: target you audience, determine the purpose and stand o
1 answer:
You might be interested in
Answer:
MAD: 10.04, 11.53
MAPSE: 10% , 12%
MSE : 146.33, 178.72
Bias : -0.56 , -0.96
3-week moving average method is better
Explanation:
i ) Evaluate MAD ( average of absolute errors )
using 3 week moving average
= 10.04
using simple exponential smoothing
= 11.53
ii) MAPSE ( average of absolute percentage error )
using 3 week moving average
= 10%
using simple exponential smoothing
= 12%
iii) MSE ( average of Squared Errors )
3 week MV = 146.33 , Simple exponential smoothing = 178.72.
iv) Bias
3 week MV = -5/9 = -0.56, Simple exponential smoothing = -8.69/9 = -0.96.
v) TS ( Total error / MAD )
3 week MV = -5 / 10.04 = -0.49 ,
simple exponential smoothing = -8.69 / 11.53 = -0.75
b) I prefer 3-week moving average based on the values of MAD , MAPE, MSE, bias and TS which shows that there is a better estimate when using the 3 -weeks moving average.
Attached below is the Tabular calculations of the required parameters for the question
Answer:
Compute the increase or decrease that closing Store 3 should cause in: a. Total monthly sales for Drexel-Hall stores.
- total monthly sales should decrease from $1,800,000 to $1,380,000 = a $420,000 reduction
b. The monthly responsibility margin of Stores 1 and 2.
- store 1 responsibility margin increased from 10% to 12.55% (2.55% increase)
- store 2 responsibility margin increased from 9% to 13.69% (4.69% increase)
c. The company’s monthly income from operations.
- increased from $72,000 to $140,200 ($70,200 increase)
Explanation:
Store Store Total
1 2
Sales $660,000 $720,000 $1,380,000
Variable costs $409,200 $453,600 $862,800
Contribution margin $250,800 $266,400 $517,200
Controllable fixed costs $120,000 $102,000 $222,000
Performance margin $130,800 $164,600 $292,200
Committed fixed costs $48,000 $66,000 $114,000
Store responsibility margin $82,800 $98,600 $178,200
Common fixed costs $38,000
Income from operations $140,200
