Question

In: Operations Management

The S&H Mercantile in Luther is the only game in town for a number of items...

The S&H Mercantile in Luther is the only game in town for a number of items and tries valiantly to use only the storage space needed to display items since there is no stock room in the back of the store. One popular item, a 16-ounce can of dehydrated water, takes up 20 square inches of shelf space. The shelf space available for this item measures five feet by four feet. The store manager would like to order a quantity that can fill the shelf space without stacking and without needing to store cans elsewhere in the store. The amount ordered should all be on display once the S&H runs out and ideally would arrive just as the last can is purchased.

A. Suppose the annual demand is 8,000 units and the cost per can is $3 with a holding cost of 10%. What is the required order cost per lot?

B. Drought conditions spike demand during the summer to an annualized rate of 27,000 cans per year and the price rises to $12 per can with a holding cost of 20%. What is the required order cost per lot?

Solutions

Expert Solution

Ans A)

Given area of shelf space = 5 Ft * 4 Ft = 20 Sq. Ft

Let us covert it to Sq. inch

1 Ft = 12 Inches

Therefore

Area of shelf space = 20 *12 * 12 = 2880 Sq. in

1 can of water takes 20 Sq inch of shelf space

Therefore no. of cans that the shelf space can hold = 2880 / 20 = 144 Cans

Now SH wants to store exact amount of shelf space without needing to store cans somewhere elseand hence this 144 cans becomes EOQ (Economic order Qty.)

Now we know EOQ = (2KD) / h ----Eq. 1

EOQ = 144

K = Fixed ordering cost = ?

D = Annual demand = 8000

h = Holding cost = ?

C = Cost per can = $ 3

i = 10 % (Carrying cost as percentage of Unit cost)

h = i * C

h = 10 % * $ 3

h = $ 0.3

Substituting above in Eq. 1 and solve for K

EOQ = (2KD) / h

144 = (2 * K * 8000) / 0.3

Squaring both sides we get

20736 = (16000 * K ) / 0.3

20736 * 0.3 = 16000 * K

K = 6220.8 /16000

K = $ 0.388 = Ordering cost per order

Ans B)

Now here EOQ remains same = 144

But other parameters change

K = Fixed ordering cost = ?

D = Annual demand = 27000

h = Holding cost = ?

C = Cost per can = $ 12

i = 20 % (Carrying cost as percentage of Unit cost)  

h = i * C

h = 20 % * $ 12

h = $ 2.4

Substituting above in Eq. 1 and solve for K

EOQ = ​​​​​​​(2KD) / h

144 = (2 * K * 27000) / 2.4

Squaring both sides we get

20736 = ( 54000 * K ) / 2.4

20736 * 2.4 = 54000 * K

K = 49766.4 /54000

K = $ 0.9216 = Ordering cost per order

P.S --Kindly give thumbs up --This will motivate me to provide more and more quality answers!


Related Solutions

1. Hardware (H) and Software (S) are produced in Home and Foreign, and the only input...
1. Hardware (H) and Software (S) are produced in Home and Foreign, and the only input factor is Labour (L). Home is endowed with 800 units of Labour and Foreign with 400 units. Labour productivity is as summarised in the following table: Hardware softeware Home 1/10 1/30 Foreign 1/40 1/20 1.Do either country have an absolute advantage and comparative advantage? If yes, for which good/goods? 2.Draw the Production Possibility curve and Indifference curve for both countries in Autarky. 3.Which goods...
Java program by using array only. II. The NumberTile Game (Unchanged) Number tiles are squares with...
Java program by using array only. II. The NumberTile Game (Unchanged) Number tiles are squares with a number from 1 to 9 at each side. A “board” for the game is a sequence of number tiles satisfying this property:       The right side of each tile (except the last) = the left side of the next tile on the board There are 2 players in the game, both of which are the computer. Each player starts with a "hand" of...
The number of snowplows needed by a town is given by s(p)=0.5p−0.01p^2. snowplows where p is...
The number of snowplows needed by a town is given by s(p)=0.5p−0.01p^2. snowplows where p is the population (in thousands). The projected population of the town t years from now is p(t)=150(1+12e^−0.02t)^-1 thousand people. (a) Write the model for the rate-of-change of the number of snowplows needed t years from now. (b) What will be the rate-of-change of the number of snowplows needed five years from now?
Use the table for the​ question(s) below. Luther Industries had sales of​ $980 million and a...
Use the table for the​ question(s) below. Luther Industries had sales of​ $980 million and a cost of goods sold of​ $560 million in 2006.  A simplified balance sheet for the firm appears​ below: Luther Industries Balance Sheet As of December​ 31, 2006 ​ (millions of​ dollars) Assets Liabilities and Equity Cash 25 Accounts payable 60 Accounts receivable 85 Notes payable 425 Inventory 90 Accruals 45 Total current assets 200 Total current liabilities 530 Net​ plant, property, and equipment 6100...
Use a table to find the inverse Laplace transform h(t) of H(s). H(s) = 40s /((s2...
Use a table to find the inverse Laplace transform h(t) of H(s). H(s) = 40s /((s2 + 4)(s + 1)) for s > 0 h(t) = for t > 0
Order the following bonds according to polarity: H-H; S-H; F-H; O-H; Cl-H For each of the...
Order the following bonds according to polarity: H-H; S-H; F-H; O-H; Cl-H For each of the following molecules show the direction of the bond polarities: HCl; Cl2; SO3; CH4; H2S
delta S= 614 delta H = 3934.55 Discuss the values of delta H and delta S...
delta S= 614 delta H = 3934.55 Discuss the values of delta H and delta S determined for Zn(s) I Zn^2+ (aq) II Pb^2+ (aq) I Pb(s) (analysis V. 1-2) in terms of a. Whether the reaction is endothermic or exothermic
The game of Nim. This is a well-known game with a number of variants. The following...
The game of Nim. This is a well-known game with a number of variants. The following variant has an interesting winning strategy. Two players alternately take marbles from a pile. In each move, a player chooses how many marbles to take. The player must take at least one but at most half of the marbles. Then the other player takes a turn. The player who takes the last marble loses. Write a program in which the computer plays against a...
I only spend time hiking (H) and sleeping (S). For every hour I hike I need...
I only spend time hiking (H) and sleeping (S). For every hour I hike I need three hours of sleep or that time hiking gives me no pleasure. Extra sleep (additional to that) doesn’t make me any happier. 1) Graph 2+ indifference curves 2) Write an equation that could represent the utility function 3) For that utility function, what is the marginal utility for each good? 4) What is the MRS? Do these preferences represent diminishing MRS?
Assume the health production function is h = 365 − 1/H, where h is the number...
Assume the health production function is h = 365 − 1/H, where h is the number of healthy days a person has in each year and H is the person’s health capital. Assume this person earns a wage of $100/day, and the marginal cost of health investment π = 25 and is constant over time. The annual interest rate is 5 percent, and health capital depreciates at a rate of 35 percent per annum. Find the optimal level of health...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT