AAA Janet's Bouquets stocks fresh-cut flower bouquets on a weekly basis that sell for $60 each and have a purchase cost of $30 perdozen. Unsold week-old bouquets are reduced in price to $20 each and are always completely sold without affecting the currentweek's demand for fresh-cut bouquets. Janet, the owner of the flower shop, estimates weekly demand characteristics for fresh-cutbouquets as follows:Demand(bouquets)7580859095Demand Probability0.10.20.30.30.1Required:How many bouquets should Janet's Bouquets order each week to maximize net income? Support your decision by preparing anappropriate payoff table.Janet's Bouquets should purchasebouqets

5 demand states are possible-75,80,85,90,95Similarly we can have 5 order quantities=75,80,85,90,95

Answered: Janet's Bouquets stocks fresh-cut…

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

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Your firm uses a periodic review system for all SKUs classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUs classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item’s current characteristics are:Demand 1D2 = 15,080 units/yearOrdering cost 1S2 = $125.00/orderHolding cost 1H2 = $3.00/unit/yearLead time 1L2 = 5 weeksCycle@service level = 95 percentDemand is normally distributed, with a standard deviation of weekly demand of 64 units.a. Calculate the item’s EOQ.b. Use the EOQ to define the parameters of an appropriate continuous review and periodic review system for this item.c. Which system requires more safety stock and by how much?
Weekly demand for Lego at a Wal-Mart store is normally distributed with a mean of 2,500 boxes and a standard deviation of 500. Demand is assumed to be stationary and the mean demand is used as forecast. Each order costs Wal-Mart $145 and holding cost per box per year is estimated at $1.5. Lead time is 2 weeks and the store manager has decided to review inventory every 4 weeks. (Assume a periodic review policy) a. What is safety stock requirement for a service level of 90%? b. What is the order-up-to level? c. What is the total annual variable cost?
John buys goat milk at a cost of $5 per gallon from a local dairy and sells it for $8 per gallon in its store. The dairy will buy back any milk that is unsold at the end of the day for $2 per gallon. Each day John must determine how many gallons to order. Past sales have ranged between 15 and 18 gallons per day, according to the following demand pattern.Demand:15161718Number of days demand occurred:2486Assume that demand will be within this range in future.(a) What are the possible actions and states?(b) Determine the daily profit (rewards) and show on a reward table.(c) Using each of the following criteria, determine John’s best action.- Maximin- Maximax- Expected value(d) Construct the regret (opportunity cost) matrix and using minimax regret criteria determine John’s best action.
Your firm uses a periodic review system for all SKUS classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUS classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item's current characteristics are: Demand (D) = 15,080 units/year Ordering cost (S) = $125.00/order Holding cost (H) = $3.00/unit/year Lead time (L) = 5 weeks Cycle service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 64 units. -Calculate the item's EOQ. - Use the EOQ to define the parameters of an appropriate continuous review and periodie review system for this item. -Which system requires more safety stock and by how much? -How do you think each system can affect your procurement procedures/methods?
Your firm uses a periodic review system for all SKUS classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUS classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item's current characteristics are: Demand (D) = 15,080 units/year Ordering cost (S) = $125.00/order Holding cost (H) = $3.00/unit/year Lead time (L) = 5 weeks Cycle service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 64 units. 1- How do you think each system can affect your procurement procedures/methods?
Thinking tools service assembles customized personal computers from generic parts. Formed and operated by part-time Svci students paulette cruz and maureen luis, the company has had steady growth since it started. The company assembles computers mostly at night, using part time students. Paulette and Maureen purchase generic computer parts in volume at a discount from a variety of sources whenever they see a good deal. Thus, they need a good forecast of demand for their computers so that they will know how many parts to purchase and stock. They have compiled demand data for the last 12 months as reported below A. Use exponential smoothing with smoothing parameter a=0.2 to compute the demand forecast for january (period 13) B. Use exponential smoothing with smoothing parameter a=0.5 to compute the demand forecast for january (period 13). C. Paulette believes that there is an upward trend in the demand, the initial forecast is 37 and the trend over this period is 0 units. Use…
Daily demand for fresh cauliflower in the ZZ-Warehouse store follows normal distribution with mean 100 cartons and s.d. 20 cartons. The ZZ-Warehouse buys at a cost of $50.00 per carton, sells it for $70.00 per carton. Unsold cartons are sold for $20.00 per carton. Cost of shortage = 70-50 = 20; cost of excess = 50-20 = 30; Ratio using (20.1), the service level = (20/(20+30))= 0.4 What is the optimal order quantity, using the single period – continuous demand model? a. 105 b. 95 c. 110 d. 100 e. 80
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.30 a copy. You sell a copy of San Pedro Times for $1.10. Daily demand is distributed normally with mean = 265 and standard deviation = 53. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) Optimal order quantity b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) Probability
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day’s paper for $0.50 a copy. You sell a copy of San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.)
9 Cindy’s favorite product in the store is the carrot cookie. Healthy Goods started selling carrot cookies just a few months ago, and they have not kept track of the sell out data. Cindy has been chatting with a few of the cashiers to get a sense of the overall demand for carrot cookies. The cashiers told her the store usually sells around 100 carrot cookies per week, although during the best selling week they can recall 204 carrot cookies were sold, and during a bad week only 49 cookies were sold. If they plan to have 85 cookies in inventory every week, what would be the probability of not fulfilling all the weekly demand?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS