# Planning An Operation Around Demand

1078 Words Feb 11th, 2016 5 Pages
In the Littlefield Project, our team utilized various methods learned in class and group analysis of the data in order to come up with the optimal solution. Through our analysis, as well as our trial and error, we learned several important lessons when planning an operation around demand. In order to outline how we came to learn those lessons, we will explore the simulation, how it played out, our reactions to it, and what worked as well as what did not.
To begin, we will cover our analysis of the data available. In order to estimate a general slope of demand, we needed to figure out the average demand recorded as of the first 50 days. Once that was determined, we had to analyze the data presented and make an educated estimate on how closely our future demand would relate and organize our supply chain according to that. We analyzed the first 50 days data by utilizing Excel’s statistics formulas such as AVERAGE and STDEV. Based on the calculation, the average demand as of day 50 was 2.88 jobs per day, or 172.8 kits, and standard deviation was 1.91 jobs per day. By looking at these figures, we could see that demand per day was very unpredictable. The standard deviation was almost as large as the average demand itself, meaning demand could be safely estimated anywhere between 0.97 and 4.79 jobs per day. Although we had a general idea of increasing demand, precise prediction was difficult; to counter this, we used a large range of data points to determine a better estimate of…