Cherry owns a fruit stand at the corner of Espana Street and N. Reyes Street. She buys ripe bananas every day for P20 per hundred and sells them for P50. At the end of the day, all unsold ripe bananas must be used for household consumption. Pas demand has been 500 bananas on 40 days, 600 on 60 days, 700 on 60 days and 800 on 40 days. Using the EV concept, find the optimal daily stock action

Cherry owns a fruit stand at the corner of Espana Street and N. Reyes Street. She buys ripe bananas every day for P20 per hundred and sells them for P50. At the end of the day, all unsold ripe bananas must be used for household consumption. Pas demand has been 500 bananas on 40 days, 600 on 60 days, 700 on 60 days and 800 on 40 days. Using the EV concept, find the optimal daily stock action

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Helen needs 1159 kgs of chicken per day on average to make enchiladas for her store. The supplier charges a $67 delivery fee per order (which is independent of the order size) and $3.90 per kg. Helen’s annual holding cost is 20%. Assume 52 weeks per year and 7 days per week. If Helen wants to minimize inventory holding and ordering costs, how much chicken should she purchase with each order (in kgs)? Provide your answer as an integer value.Use Econimic Order Quantity formula. The answer is 8,513. Not sure how to get there.
Skinner’s Fish Market buys fresh Boston bluefish daily for $4.10 per pound and sells it for $5.60 per pound. At the end of each business day, any remaining bluefish is sold to a producer of cat food for $1.60 per pound. Daily demand can be approximated by a uniform distribution between 180 and 350 pounds. The optimal order quantity is pounds (round your response to the nearest integer).
Geox Ltd buys shoes from a supplier in Italy and sells them on to retailers in Australia. Geox Ltd currently uses an EOQ model to determine the number of shoes to send to order. The annual demand for shoes is approximately 45,600. The ordering cost is $55 per order. The annual cost of physically storing shoes is $8.75 per unit. The insurance on the inventory (shoes) cost is $4.25 per unit. The opportunity cost (annual ROI 25% x $30) is $7.50 per unit. The accountant of Geox Ltd, Richard Branson, recently attended a seminar on Just-in-Time (JIT) and is considering how the ideas of JIT differ from traditional techniques like EOQ and how they may help to manage inventory more efficiently. REQUIRED: A) Use the EOQ model to determine the optimal number of shoes per order. (show calculations) B) If it takes two weeks to receive an order, at what point should Geox Ltd reorder shoes? (show calculations) C) Geox Ltd has determined that demand may vary from the average by up to 25%. To handle…
The Western Jeans Company purchases denim from Cumberlend Texille Mills. The Westen Jeuns Company uses 35,000 yards of denim per yenr to make jeans. The cost of ordering denim Tron the textile company is $500 per order. It costs Western $0.35 per yard nnnually to hold a yard of denim in Inventory. Determine the optimal number of yards of denim the Western leans Company should order, the minimum total annual inventory cost, the optimal umber of ueden per yeur, and the optimal time between orders.
A Mercedes dealer must pay $20,000 for each car purchased. The annual holding cost is estimated to be 25% of the dollar value of inventory. The dealer sells an average of 500 cars per year. He considers the lawsuit to be behind schedule but estimates that if he is short on one car in one year he will lose $20,000 worth of future profits. Each time the dealer places an order for automobiles, the ordering cost adds up to $10,000. Determine the distributor's optimal ordering policy. What is the maximum deficit that will occur? What is the total annual cost?
Weekly demand for printers at a store is normally distributed with a mean of 250 and a standard deviation of 96. The store manager continuously monitors inventory and currently orders 14400 printers each time the inventory drops to 1,000printers. The supply lead time is normally distributed with a mean of 2 weeks and a standard deviation of 1.5 weeks. a.How much safety inventory should this store carry if it wants to provide a CSL of 95%? b.How does the required safety inventory change as the standard deviation of lead time is reduced from 1.5 weeks to zero in intervals of 0.5 weeks? c.What fill rate does the store achieve?
A Mercedes dealer pays $40,000 for each car purchased (wholesale price). The annual holding cost is estimated to be 30% of the dollar value of inventory. The dealer sells an average of 1200 cars per year. They believe that demand is backlogged but estimate that if they are short one car for one year, the loss in future profits is about 10% of the wholesale price. Each time the dealer places an order for cars, ordering costs amount to $1600. Assume there are 360 work days per year. Question: If the Mercedes dealer wants to limit backorders so that they occur 20% of the time, what is the maximum number of backorders that should be allowed (assuming the optimal order quantity doesn't change)?
A Mercedes dealer must pay $20,000 for each carpurchased. The annual holding cost is estimated to be 25%of the dollar value of inventory. The dealer sells an averageof 500 cars per year. He believes that demand is backloggedbut estimates that if he is short one car for one year he willlose $20,000 worth of future profits. Each time the dealerplaces an order for cars, ordering cost amounts to $10,000.Determine the Mercedes dealer’s optimal ordering policy.What is the maximum shortage that will occur?
Cynthia Knott’s oyster bar buys fresh Louisiana oysters for $5 per pound andsells them for $9 per pound. Any oysters not sold that day are sold to her cousin,who has a nearby grocery store, for $2 per pound. Cynthia believes that demandfollows the normal distribution, with a mean of 100 pounds and a standarddeviation of 15 pounds. How many pounds should she order each day?
AAA auto supply store sells snow tires which are ordered every Friday to meet next week's demand. The sales price for the most popular size is $50 per tire and its cost for AAA is $35. If too many tires are ordered AAA incurs an inventory carrying cost of $2 per tire. If AAA is out of stock, it forgoes the profits from missed sales. AAA has the option to order 100, 150, or 200 tires to meet next week's demand which can be either 100, 150, or 200 tires.Based on its historical demand distribution, assume that AAA Inc. has determined the followingprobability information: P(100) = 0.4, P(150) = 0.3, and P(200) = 0.3 e. Which alternative should be chosen based on the minimax regret criterion? f. Which alternative should be chosen using the expected monetary value (EMV) criterion? g. What is the expected value under perfect information (EVPI)? Show Work
AAA auto supply store sells snow tires which are ordered every Friday to meet next week's demand. The sales price for the most popular size is $50 per tire and its cost for AAA is $35. If too many tires are ordered AAA incurs an inventory carrying cost of $2 per tire. If AAA is out of stock, it forgoes the profits from missed sales. AAA has the option to order 100, 150, or 200 tires to meet next week's demand which can be either 100, 150, or 200 tires.Based on its historical demand distribution, assume that AAA Inc. has determined the followingprobability information: P(100) = 0.4, P(150) = 0.3, and P(200) = 0.3.a. Which alternative should be chosen based on the maximax criterion?b. Which alternative should be chosen based on the maximin criterion?c. Which alternative should be chosen based on the Lapalce criterion?d. Which alternative should be chosen based on criterion of realism with alpha = 0.7?e. Which alternative should be chosen based on the minimax regret criterion?f. Which…
The annual demand for a product is 15,200 units. The weekly demand is 292 units with a standard deviation of 80 units. The cost to place an order is $33.50, and the time from ordering to receipt is two weeks. The annual inventory carrying cost is $0.10 per unit. The reorder point is 730. Suppose the production manager is asked to reduce the safety stock of this item by 45 percent. If she does so, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round "z" value to 2 decimal places and final answer to 1 decimal place.) *The answer is not 28% or 42% or 58% or 71% or 86.6% or 90%