Question
A local bakery has requested your help in calculating their inventory costs for their ingredients. One such ingredient is sugar. Currently, they are using cane
A local bakery has requested your help in calculating their inventory costs for their ingredients. One such ingredient is sugar. Currently, they are using cane sugar and organic cane sugar in their recipes. The table below shows the demand parameters (assume that demand is normally distributed), the price per pound, and the supplier lead time for each type of sugar.
Sugar type | Average annual demand (pounds) | St deviation of annual demand | Price ($/pound) | Lead time from the supplier (weeks) |
Cane sugar | 500 | 40 | $1.3 | 1 |
Organic cane sugar | 180 | 35 | $3.1 | 2 |
Assume that each type of sugar is shipped from a different supplier and regardless of the type, the fixed order cost is $40. The annual holding cost per pound is 20% of the price of the item. Please assume that the target probability of no stock-out is 98%.
- Find the EOQ and the safety stock levels for each type of sugar.
- Recent marketing surveys revealed that customers do not differentiate between products made with regular versus organic sugar. Due to cost cutting efforts, the company decided to use regular sugar in all its recipes. You may assume that one pound of organic sugar will be replaced with one pound of regular sugar and total demand for sugar will not change.
What will be the new EOQ and safety stock levels for regular cane sugar?
- Compare the total annual cost of part (a) and (b) and determine how much money the company will save by switching to regular cane sugar. Note that you will need to include the annual procurement costs in your calculations.
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