Sam's Cat Hotel operates 50 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $12.00 per bag. The following information is available about these bags:> Demand = 95 bags/week> Order cost = $50.00/order> Annual holding cost = 20 percent of cost> Desired cycle-service level = 80 percent> Lead time =5 weeks (30 working days)> Standard deviation of weekly demand = 15 bags> Current on-hand inventory is 320 bags, with no open orders or backorders.a. Suppose that the weekly demand forecast of 95 bags is incorrect and actual demand averages only 75 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error?The costs will be $higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)

Given, Actual demand = 95 bags/ week Annual demand D = 95*50 = 4750 bags Order cost S = $50 Holding…

Answered: a. Suppose that the weekly demand…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Dalia, the office manager of a desktop publishing outfit, stocks replacement toner cartridges for laser printers. Demand for cartridges is approximately 30 per year and is quite variable (Le., can be represented using the Poisson distribution). Cartridges cost $100 each and require three weeks to obtain from the vendor. Dalia uses a (Q, r) approach to control stock levels (a). If Dalia wants to restrict replenishment orders to twice per year on average, what batch size Q should she use? If she wants to ensure a service level (i.e., probability of having the cartridge in stock when 2 out of 2 needed) of at least 98 percent, what reorder point r should she use? (Hint: Use Table 2.6.(b). If Dalia is willing to increase the number of replenishment orders per year to six, how do Q and r change? Explain the difference in r.
PS Garden Variety Flower Shop uses 930 clay pots a month. The pots are purchased at $3.90 each. Annual carrying costs per pot are estimated to be 10 percent of cost, and ordering costs are $10 per order. The manager has been using an order size of 2,000 flower pots. a. What additional annual cost is the shop incurring by staying with this order size? (Round your optimal order quantity to the nearest whole number. Round all other intermediate calculations and your final answer to 2 decimal places.) Additional annual cost b.Other than cost savings, what benefit would using the optimal order quantity yield (relative to the order size of 2,000)? (Use the rounded order quantity from Part a. Round your final answer to the nearest whole percent.) About % of the storage space would be needed. Check my
ECUR UMIC ORDER QUANTITY CALCULATIONS (2 QUESTIONS) Company uses 800 units of a product per year on a continuous basis. The product year and order costs of $300 per order. It takes 30 days to receive a shipment after an order is placed and the a safety stock of 5 days usage in inventory. has carrying costs of $50 A. Calculate the economic order quantity a. 98 B. Determine the reorder a. 150 days (3 CASH DISCOUNTS point. ONS) (Assume (EOQ). a 360-day year.) per unit per firm requires
*Note: "11102" has been attempted and is not the correct answer to this problem.
Chicago's Hard Rock Hotel distributes a mean of 1,000 bath towels per day to guests at the pool and in their rooms. This demand is normally distributed with a standard deviation of 95 towels per day, based on occupancy. The laundry firm that has the linen contract requires a 4-day lead time. The hotel expects a 98% service level to satisfy high guest expectations. Refer to the standard normal table for z-values. a) What is the reorder point? towels (round your response to the nearest whole number). towels (round your response to the nearest whole number). b) What is the safety stock? Z-Table Z 0.38 0.50 0.67 0.84 1.04 1.28 1.41 1.56 1.65 1.75 2.06 2.33 Pr(Z) 65 69 75 80 85 90 92 94 95 96 98 99
Problem 13-16 The McDonald's fast-food restaurant on campus sells an average of 4,800 quarter-pound hamburgers each week. Hamburger patties are resupplied twice a week, and on average the store has 465 pounds of hamburger in stock. Assume that the hamburger patties cost $3 a pound and there are 52 weeks in a year. a. What is the inventory turnover for the hamburger patties? (Round your answer to 2 decimal places.) Inventory turnover per year b. On average, how many days of supply are on hand? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Average days of supply
Epworth Co. predicts that it will use 360,000 gallons of material during the year. It anticipates that it will cost $72 to place each order. The annual carrying cost is $4 per gallon. a. Determine the most economical order quantity by using the EOQ formula. b. Determine the annual order and carrying costs at the EOQ point.
1. Michael Traci, the new inventory manager at Magyar Golf Supplies, is considering using the economic order quantity for controlling inventory. He wants you to apply the EOQ to a sample product, the Super-Z Wedge. The Super-Z Wedge has an average demand of 30 units/period with an ordering cost of $30/order. The cost of carrying a Super-Z Wedge in inventory is $2.00/unit/ period. No safety stock is carried for this item. a. Calculate the economic order quantity. b. Calculate the average cycle stock for this item using the order quantity in question a. c. Assuming there are 12 periods per year, calculate total cost per year.
es Garden Variety Flower Shop uses 930 clay pots a month. The pots are purchased at $3.90 each. Annual carrying costs per pot are estimated to be 10 percent of cost, and ordering costs are $10 per order. The manager has been using an order size of 2,000 flower pots. a.What additional annual cost is the shop incurring by staying with this order size? (Round your optimal order quantity to the nearest whole number. Round all other intermediate calculations and your final answer to 2 decimal places.) Additional annual cost b.Other than cost savings, what benefit would using the optimal order quantity yield (relative to the order size of 2,000)? (Use the rounded order quantity from Part a. Round your final answer to the nearest whole percent.) About % of the storage space would be needed. Check my
A local club is selling Christmas trees and deciding how many to stock for the month of December. Suppose that demand is normally distributed with a mean of 250 and standard deviation of 40, trees have no salvage value at the end of the month, trees cost $11, and trees sell for $47. What should the service level be? (Do not round intermediate calculations. Round answer to two decimal places.) O A. 0.34 OB. 0.23 O C. 0.77 O D. 0.84 O E. unable to determine given the above information
Average daily demand (d) 130 cases Demand Standard deviation (σd) 20 cases Service level 94.0% Service level alternative 86.0% Lead tme, LT 6 days 1. What is the standard deviation of demand during lead time? Round your answer to one decimal place. _______ cases 2. What is the required safety stock at a 94 percent service level? Round your answer to the nearest whole number. _______ cases 3. What is the reorder point? Round your answer to the nearest whole number. _______ cases 4.What is the required safety stock at a 86 percent service level? Round your answer to the nearest whole number. _______ cases 5. What is the safety stock reduction? Round your answer to the nearest whole number. _______ cases
Josie Gall's firm has developed the supply, demand, cost, and inventory data that follow. Supply Available Period 1 2 3 Regular Time 40 35 40 Overtime 15 15 15 Subcontract 10 10 10 Demand Forecast 30 units $100 $150 $200 $6 50 65 55 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month Assume that the initial inventory has no holding cost in the first period, and backorders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is (Enter your response as a whole number.)

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS