University | Singapore University of Social Science (SUSS) |
Subject | LOG307: Optimisation and Simulation for Decision-Making |
LOG307: Optimisation and Simulation for Decision-Making Assignment, SUSS, Singapore Inventory holding cost is one of the highest costs a company incurs and Therefore, companies always try to reduce inventory costs
Inventory holding cost is one of the highest costs a company incurs. Therefore, companies always try to reduce inventory costs by implementing appropriate strategies. One such company is Pepsico Foodservice. Pepsico is trying to control inventory costs for one of its products: Lay’s chips. The weekly cost of holding one carton of chips is $25.
Based on the past data, it was estimated that the weekly demand for Lay’s chips averaged 120 units, with a standard deviation of 25 units. If the demand for the chips is more than the items on hand, customers would choose to buy a different brand of chips. The production facility at Batam can change its production to 3 quantities only – 100, 120, and 150 cartons per week. But changing the production quantity is expensive; it costs $3,000 to change the production quantity. The company is trying to evaluate the impact of the following production policies:
- Produce a quantity of 150 units next week if the on-hand inventory this week is less than 20 units (OHL)
- Produce a quantity of 100 units next week if the on-hand inventory this week is more than 80 units (OHH)
- Continue with the present production quantity otherwise There are 75 cartons of chips in the store currently, and the production quantity is 120.
QUESTION
(a) Based on the above policy, construct a simulation model for one year (52 weeks) for the production of chips. Determine the total cost. Show the change in inventory and production quantity over the weeks. (20 marks)
(b) Run the model developed in part for 500 iterations to estimate the average yearly cost for different values of OHH, ranging from 30 to 80, in multiples of 10. Analyze what value of OHH provides the minimum cost on average. Calculate other summary statistics to have a better idea of the best value.
(c) Suggest any other production policies that might be useful to investigate.
Buy Custom Answer of This Assessment & Raise Your Grades
Seeking Online Assignment Help? Try MY Assignment Help SG! Score high grades on your LOG307: Optimization and Simulation for Decision-Making Assignment at Singapore University of Social Science (SUSS). Get professional assistance and expert guidance to tackle complex optimization and simulation problems. Our Do My Assignment service ensures timely delivery and top-notch quality solutions. Ace your assignment with confidence and ease.
- Imagine that you are currently working for a precision medicine startup: Machine Learning Paper Review in Precision Medicine, Written Assignment 1, NUS, Singapore
- Go Business offers PSG solutions for enterprises in Singapore: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Design an ontology based on- Accidents can be categorised as chemical, electrical, fire, kinetic or liquid: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Project Control Monitoring, Assignment, HU, Singapore: Deliberate Project MONITORING AND CONTROL or PMC Identification
- DSM500: Final Project Report, Coursework 2, UOL, Singapore
- DSM080: Financial Markets, Assignment, UOL, Singapore: A grapefruit juice futures contract is for 15,000 pounds of frozen grapefruit juice
- DSM080: Financial Markets, Assignment, UOL, Singapore: The share price of a certain stock today is $42.50, and five-month European style call options with a strike price of $45 currently sell for $4.25.
- DSM080: Financial Markets, Assignment, UOL, Singapore: A trader who is working in the gold markets is able to borrow money at the interest rate of 7% per annum
- DSM080 Financial Markets, Assignment, UOL, Singapore: A dollar-based American corporation has decided that it will have to pay 6 million UK pounds in three months
- Principle of Finance Assignment, UCD, Singapore: National Gaming Inc. (National) operates the weekly lottery in the country
UP TO 15 % DISCOUNT