Case Study # Assignment help#
We at Assignment Consultancy ( www.assignmentconsultancy.com ) strive to provide best customized help and consultancy related to various assignments, nearly in all fields at all level related to K10-12, Management, Engineering, Arts, Science, Commerce etc. If you need customized solution of below problem or any similar problem, Please contact us If you have any problem or need any help, you can contact us at support@assignmentconsultancy.com
We also accept bulk order and charge very less compare to other assignment help services. We also provide 50% discount in first order. So Hurry Now!
Forecasting
Forecasting impacts so many parts of business. It is used to set budgets, allocated resources, plan for the future, etc. There are many ways to forecast since there so many nuances to it. The forecasting we will look at this semester is based on the historical momentum of the data being forecasted, using various techniques like period-over-period growth, regression, etc. The assignment here is to apply the best technique to forecast a real business data set. The data is within the attachment.
Question
Analysis
a) Using regression as the procedure, produce the forecast of monthly sales for the next 12 months for Company #1
b) For the forecast in question a, show a graph of the historical and forecasted sales in one graph
c) For the forecast in question a, which month in the forecasted period is expected to have the highest volume of sales and which month is expected to have the lowest volume of sales?
d) Using year-over-year change as the procedure, produce the forecast of monthly sales for the next 12 months for Company #1
e) For the forecast in question d, show a graph of the historical and forecasted sales in one graph
f) For the forecast in question d, which month in the forecasted period is expected to have the highest volume of sales and which month is expected to have the lowest volume of sales?
g) Using regression as the procedure, produce the forecast of weekly sales for the next 52 weeks for Company #2
h) For the forecast in question g, show a graph of the historical and forecasted sales in one graph?
i) For the forecast in question g, which week in the forecasted period is expected to have the highest volume of sales and which week is expected to have the lowest volume of sales?
j) Using year-over-year change as the procedure, produce the forecast of weekly sales for the next 52 weeks for Company #2
k) For the forecast in question j, show a graph of the historical and forecasted sales in one graph
l) For the forecast in question j, which week in the forecasted period is expected to have the highest volume of sales and which week is expected to have the lowest volume of sales?
General
m) Which of the two Company #1 forecasts "look" good to you? Why or why not?
n) Which of the two Company #2 forecasts "look" good to you? Why or why not?
o) What are the implications to a business if the forecast is too high?
p) What are the implications to a business if the forecast is too low?
q) Give three examples of of data that cannot be forecasted and why.
This assignment requires you forecast the historical data, replicating the appropriate trends, seasonalities, week-over-week variability, etc. Please refer to the chapter and materials on Forecasting for the procedures to do.
Forecasting impacts so many parts of business. It is used to set budgets, allocated resources, plan for the future, etc. There are many ways to forecast since there so many nuances to it. The forecasting we will look at this semester is based on the historical momentum of the data being forecasted, using various techniques like period-over-period growth, regression, etc. The assignment here is to apply the best technique to forecast a real business data set. The data is within the attachment.
Question
Analysis
a) Using regression as the procedure, produce the forecast of monthly sales for the next 12 months for Company #1
b) For the forecast in question a, show a graph of the historical and forecasted sales in one graph
c) For the forecast in question a, which month in the forecasted period is expected to have the highest volume of sales and which month is expected to have the lowest volume of sales?
d) Using year-over-year change as the procedure, produce the forecast of monthly sales for the next 12 months for Company #1
e) For the forecast in question d, show a graph of the historical and forecasted sales in one graph
f) For the forecast in question d, which month in the forecasted period is expected to have the highest volume of sales and which month is expected to have the lowest volume of sales?
g) Using regression as the procedure, produce the forecast of weekly sales for the next 52 weeks for Company #2
h) For the forecast in question g, show a graph of the historical and forecasted sales in one graph?
i) For the forecast in question g, which week in the forecasted period is expected to have the highest volume of sales and which week is expected to have the lowest volume of sales?
j) Using year-over-year change as the procedure, produce the forecast of weekly sales for the next 52 weeks for Company #2
k) For the forecast in question j, show a graph of the historical and forecasted sales in one graph
l) For the forecast in question j, which week in the forecasted period is expected to have the highest volume of sales and which week is expected to have the lowest volume of sales?
General
m) Which of the two Company #1 forecasts "look" good to you? Why or why not?
n) Which of the two Company #2 forecasts "look" good to you? Why or why not?
o) What are the implications to a business if the forecast is too high?
p) What are the implications to a business if the forecast is too low?
q) Give three examples of of data that cannot be forecasted and why.
This assignment requires you forecast the historical data, replicating the appropriate trends, seasonalities, week-over-week variability, etc. Please refer to the chapter and materials on Forecasting for the procedures to do.
Comments
Post a Comment