Difference between revisions of "ANLY482 AY2017-18T2 Group10 Project Overview: Methodology"
| Line 54: | Line 54: | ||
<u><b>Seasonal Demand Analysis</b></u><br/> | <u><b>Seasonal Demand Analysis</b></u><br/> | ||
Like many businesses, the food and beverage industry is also subject to seasonal demand, meaning that consumers’ purchasing patterns fluctuate throughout the year and across years. Thus, this will be factored into consideration when developing the model. First, based on the data provided by XYZ Company, transaction counts can be plotted over time to determine the pattern of seasonality. Transaction counts are a more accurate gauge of consumption pattern as opposed to revenue due to the tiered pricing structure that XYZ Company practices (e.g. Adult, Child, Student/Senior Citizen), meaning that different combinations of customers could generate the same revenue as measured in dollars. Next, demand for each ingredient can be forecasted by studying past usage and using this historical data to predict future consumption patterns.<br/> | Like many businesses, the food and beverage industry is also subject to seasonal demand, meaning that consumers’ purchasing patterns fluctuate throughout the year and across years. Thus, this will be factored into consideration when developing the model. First, based on the data provided by XYZ Company, transaction counts can be plotted over time to determine the pattern of seasonality. Transaction counts are a more accurate gauge of consumption pattern as opposed to revenue due to the tiered pricing structure that XYZ Company practices (e.g. Adult, Child, Student/Senior Citizen), meaning that different combinations of customers could generate the same revenue as measured in dollars. Next, demand for each ingredient can be forecasted by studying past usage and using this historical data to predict future consumption patterns.<br/> | ||
| − | Second, after determining the type of seasonality (e.g. additive, multiplicative, etc.), a combination of forecasting methods will then be applied | + | Second, after determining the type of seasonality (e.g. additive, multiplicative, etc.), a combination of forecasting methods will then be applied. |
</div> | </div> | ||
Revision as of 15:47, 25 February 2018
Methodology
Based on information provided by XYZ Company, 2 of it’s 8 outlets are considered “hybrid” outlets. This means that these outlets are located next to a Hotpot outlet, and thus have a shared kitchen and resources. The implication of this is that inventory records are not clearly delineated between the two concepts. Hence, as advised by XYZ Company, these two outlets will be left out of the analyses performed, with reliance on the remaining six standalone outlets.
Next, as there has been a change in format of inventory data from October 2017, we will need to standardise the data for the preceding months. Afterwards, we will import the data into python to perform the necessary data cleaning and exploratory data analysis. After which, we will then begin to work on our model. Below is simple conceptual model of how the data will be used to produce the final optimal order quantity for an ingredient.
With this in mind, we have brainstormed several possible analytical methods that can be implemented to develop the model:
Descriptive Analysis
Pareto Analysis - also known as an 80-20 analysis, can be employed on the various items recorded in XYZ Company’s inventory. Given that there are over one hundred items listed, it would be impracticable to address each individual item during the course of this project. Thus, Pareto Analysis would allow us to prioritise which inventory items have greater impact on XYZ Company.
The 80-20 split will be determined using several criteria: (1) cost and (2) usage pattern. For cost, the various inventory items will be ranked based on the cost, meaning that the items that make up 80% of the purchasing cost will be prioritised. For usage pattern, the items that are used with greater frequency and recurrence will be prioritised.
Seasonal Demand Analysis
Like many businesses, the food and beverage industry is also subject to seasonal demand, meaning that consumers’ purchasing patterns fluctuate throughout the year and across years. Thus, this will be factored into consideration when developing the model. First, based on the data provided by XYZ Company, transaction counts can be plotted over time to determine the pattern of seasonality. Transaction counts are a more accurate gauge of consumption pattern as opposed to revenue due to the tiered pricing structure that XYZ Company practices (e.g. Adult, Child, Student/Senior Citizen), meaning that different combinations of customers could generate the same revenue as measured in dollars. Next, demand for each ingredient can be forecasted by studying past usage and using this historical data to predict future consumption patterns.
Second, after determining the type of seasonality (e.g. additive, multiplicative, etc.), a combination of forecasting methods will then be applied.
