Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Linear Algebra with Applications

Authors: Howard Anton, Chris Rorres

9th edition

471669598, 978-0471669593

More Books

Students also viewed these Mathematics questions

Question

2 What is a primary cause of bipolar disorder?

Answered: 1 week ago