Dave's Auto Supply custom mixes paint for its customers. The shop performs a weekly inventory count of the main colors used for mixing paint. Average weekly demandi Standard deviation of demand Desired service probability Current Inventory Lead time 17 gallons 6 gallons/week 98% Amount of white paint 35 gallons 1 week Determine the amount of white paint that should be ordered using the above information: (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "2" value to 2 decimal places and final answer to the nearest whole number.) gallons

Dave's Auto Supply custom mixes paint for its customers. The shop performs a weekly inventory count of the main colors used for mixing paint. Average weekly demandi Standard deviation of demand Desired service probability Current Inventory Lead time 17 gallons 6 gallons/week 98% Amount of white paint 35 gallons 1 week Determine the amount of white paint that should be ordered using the above information: (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "2" value to 2 decimal places and final answer to the nearest whole number.) gallons

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

A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year. CertifiedSupplier OrderSize (Q) Price per Unit (P) OversightCostper Unit (O) TransportCost perUnit (Ct) Order Cost(Co) Cost to StoreOne UnitOne Year (Ch) Order LeadTime inDays (L) New Albany Mfg. 59,000 $11.74 $0.00 $0.37 $255 $1.70 51 LaPlaya Mfg. 118,000 $11.08 $0.42 $0.87 $290 $1.35 99 Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 1,180,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar. Order quantity: 59,000 units 118,000 units Total procurement cost: $ $ Total management oversight…
True Blue says that annual margin for each of its loyalty program members averages $366.60. These customers order an average of 3.3 times per year, and contribution margin as percent of revenue averages 25% for these customers. Given these numbers, calculate average order size in retail dollars for True Blue's loyalty program members. Rounding: penny. Your Answer: Answer
A store has collected the following information on one of its products:Demand = 4,500 units/year Standard deviation of weekly demand = 12 units Ordering costs = $40/order Holding costs = $3/unit/year Cycle-service level = 90% (z for 90% = 1.28) Lead-time = 2 weeks Number of weeks per year = 52 weeks a. If a firm uses the continuous review system to control the inventory, what would be the order quantity and reorder point?
A large bakery buys flour in 25-pound bags. The bakery uses an average of 1,215 bags a year. Preparing an order and receiving a shipment of flour involves a cost of $10 per order. Annual carrying costs are $75 per bag. a. Determine the economic order quantity. (Round your final answer to the nearest whole number.) Economic order quantity bags b. What is the average number of bags on hand? (Round your final answer to the nearest whole number.) Average number of bags c. How many orders per year will there be? (Round your final answer to the nearest whole number.) Number of orders per year d. Compute the total cost of ordering and carrying flour. (Round your final answer to the nearest whole number. Omit the "$" sign in your response.) Total cost $ e. If annual holding costs were to increase by $9 per bag, how much would that affect the minimum total annual cost? (Round your intermediate calculations to 2 decimal places and final…
It has been theoretically and empirically generalized that Recency is always the most important factor for classification of customers in RFM analysis. True False
Please explain me in brief about Pros and Cons of Re-Order Point Control and Re-Order Cycle Control Inventory control Systems.
Wholemark is an Internet order business that sells one popular New Year's greeting card. The cost of the paper on which the card is printed is $0.10 per card, and the cost of printing is $0.42 per card. The company receives $2.40 per card sold. Since the cards have the current year printed on them, unsold cards have no salvage value. Based on past data, the number of customers from Los Angeles is normally distributed with a mean of 2,500 and a standard deviation of 600. What is the optimal production quantity for the card for Los Angeles, if Wholemark only makes a one-time production for this area? Round to the nearest integer.
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 112, 500 units per year, an ordering cost of $3 per order, and carrying costs of $1.20 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory?
UA Hamburger Hamlet (UAHH) places a daily order for its high-volume items (hamburger patties, buns, milk, and so on). UAHH counts its current inventory on-hand once per day and phones in its order for delivery 24 hours later. Average daily demand 600 Standard deviation of demand 100 Desired service probability 99% Hamburger inventory 800 Determine the number of hamburgers UAHH should order for the above conditions. Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 3 decimal places and final answer to the nearest whole number.
A sporting goods company has a distribution center that maintains inventory of fishing rods. The fishing rods have the following demand, lead time, and cost characteristics: Average demand = 130 units per day, with a standard deviation of 12 units Average lead time = 12 days with a standard deviation of 1 day 250 days per year in the business year Unit cost = $28 Desired service level = 97.5% Ordering cost $53 Inventory carrying cost = 25% a. What is the standard deviation of demand during lead time? b. How many fishing rods should the distribution center carry to provide the desired service level? c. What is the EOQ? d. What is the average cycle stock?
In an ABC system based on revenue, C items individually make the lowest annual revenue contribution. TRUE FALSE
The following particulars were collected for the year 2015 from Need LLCMonthly demand -2,000 unitsCost of placing an order RO 225.Annual carrying cost per unit 8%Purchase price of input unit RO 350Minimum usage 30 units per weekMaximum usage 50 units per weekRe-order period 6 to 8 weeks.For emergency purchase 4 weeks Required:(a) Re-order quantity(b) Re-order level(c) Minimum level(d) Maximum level(e) Average Stock Level(f) Danger level