Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A retailer store will make a decision on the inventory level to satisfy the demand in the next season. To ensure the inventory decision is
A retailer store will make a decision on the inventory level to satisfy the demand in the next season. To ensure the inventory decision is optimal, the firm must conduct a solid demand forecasting. In the first step, the retailer store management group collects the historical demand data, which is given in excel data file 1. Given the demand data in the past, how would you forecast the demand in the next season? Suppose the demand can take continuous values. In the second step, the firm management group realizes that the demand is not purely random, but instead depends on the firm's decision on the retail price. Hence, to precisely predict the future demand, it is better to use the price as one input to predict the output (demand) in order to put the impact of price into consideration. To improve the demand forecasting, the management group collects the data of prices corresponding to each historical demand data point. Please refer to the excel data file 2 for the detailed data of price/demand pairs. We know for the next season, the firm's decision on retail price is $10. How would you forecast the demand based on the new data set
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started