Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 of 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.

Part 1:

Based on the above policy, need 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.

Run the model developed in (part 1) for 500 iterations to estimate the average yearly cost for different values of OHH, ranging from 30 to 80, in multiples of 10. Analyse what value of OHH provides the minimum cost on average. Calculate other summary statistics to have a better idea of the best value. Any suggestion of production policies that might be useful to investigate?

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

International Marketing And Export Management

Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr

8th Edition

1292016922, 978-1292016924

More Books

Students also viewed these General Management questions

Question

In Problems 1130, solve each equation by factoring. x 2 - 9x = 0

Answered: 1 week ago

Question

Repeat Prob. 5101 for a power dissipation of 4 kW.

Answered: 1 week ago

Question

Differentiate the function. r(z) = 2-8 - 21/2 r'(z) =

Answered: 1 week ago