Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Northeastern University Part I ALY-6050 Part I should be completed in both Excel and R. Note that it's natural to obtain different results depending
Northeastern University Part I ALY-6050 Part I should be completed in both Excel and R. Note that it's natural to obtain different results depending on the software. However, the two results obtained in Excel and R are not expected to differ significantly. As a consultant, your task is to develop and implement a decision model to help them arrive at the best decision. As a guide, consider the following 1. Define the data, uncontrollable inputs, model parameters, and the decision variables that influence the total inventory cost. 2. Develop mathematical functions that compute the annual ordering cost and annual holding cost based on average inventory held throughout the year and use them to develop a mathematical model for the total inventory cost. 3. Implement your model on an Excel spreadsheet. Then in an R script file. 4. Use data tables to find an approximate order quantity that results in the smallest total cost. 5. Plot the Total Cost versus the Order Quantity 6. Use the Excel Solver to verify your result of part 4 above; that is, find the order quantity which would yield a minimum total cost. 7. Conduct what-if analyses by using two-way tables in Excel to study the sensitivity of total cost to changes in the model parameters. 8. In the word document, explain your results and analyses to the vice president of operations. Part II This part should be completed in R. Assume that all problem parameters have the same values as those in part I, but that the annual demand has a triangular probability distribution between 13000 and 17000 units with a mode of 15000 units. 1. Perform a simulation consisting of 1000 occurrences and calculate the minimum total cost for each occurrence. Next, use the results of your simulation to: (0) (ii) (iii) Estimate the expected minimum total cost by constructing a 95% confidence interval for it and determine the probability distribution that best fits its distribution. Verify the validity of your choice. Estimate the expected order quantity by constructing a 95% confidence interval for it and determine the probability distribution that best fits its distribution. Verify the validity of your choice. Estimate the expected annual number of orders by constructing a 95% confidence interval for it and determine the probability distribution that best fits its distribution. Verify the validity of your choice. 2. In In the word document, explain your results and analyses to the vice president of operations.
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