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.
- ACFI3004 Australian Taxation Assignment: Residency & 2025 Income Assessment for Heny and Joceline
- PESTEL Analysis Assignment 2: Fitness Studio Expansion into Thailand & Vietnam
- CSIT213 E-Commerce System Assignment 1: Java OOP Implementation Without Collections for Manual Array Management
- A2369C cGMP Compliance Assignment: CAPA Report on Audit Non-Conformities in Pharma Quality Management (PQM)
- E2419C Health Logistics Assignment: Cold Chain & Dangerous Goods Management in Pharma Supply Chain
- AVET104 Fundamentals of Biology Assignment: The Story of Signals, Energy & Expression Inside the Cell
- Workplace Health & Safety Review: Risk Assessments 1 and Accident Data Analysis
- Sensible Risk Assessment 2 Report: Personal Reflection on Workplace Report and Future Growth
- ACLP M1P TAE Written Assignment: Applying Skills Framework, Assessment Planning & Instructional Design for Learner-Centric Education
- EGH222 Employee Sick Days Prediction Assignment: Regression Model Using Demographic and Lifestyle Data
UP TO 15 % DISCOUNT