Mike’s Garage, a local automotive service and repair shop, uses oil filters at a fairly steady rate of 2,400 per year. Mike estimates that the cost of his time to make and process an order is about $50. It takes one month for the supplier to deliver the oil filters to the garage, and each one costs Mike $5. Mike uses an annual interest rate of 25 percent to compute his holding cost.a. Determine the optimal number of oil filters that Mike should purchase, and the optimal time between placement of orders.b. Determine the level of on-hand inventory at the time a reorder should be placed.c. Assuming that Mike uses an optimal inventory control policy for oil filters, what is the annual cost of holding and order setup for this item?

Mike’s Garage, a local automotive service and repair shop, uses oil filters at a fairly steady rate of 2,400 per year. Mike estimates that the cost of his time to make and process an order is about $50. It takes one month for the supplier to deliver the oil filters to the garage, and each one costs Mike $5. Mike uses an annual interest rate of 25 percent to compute his holding cost.a. Determine the optimal number of oil filters that Mike should purchase, and the optimal time between placement of orders.b. Determine the level of on-hand inventory at the time a reorder should be placed.c. Assuming that Mike uses an optimal inventory control policy for oil filters, what is the annual cost of holding and order setup for this item?

Name: Mike’s Garage, a local automotive service and repair shop, uses oil fi
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: Mike’s Garage, a local automotive service and repair shop, uses oil filters at a fairly steady rate of 2,400 per year. Mike estimates that the cost of his time to make and process an order is about $50. It takes one month for the supplier to deliver

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 13P

See similar textbooks

Similar questions

A local supermarket sells a popular brand of shampoo at a fairly steady rate of 380 bottles per month. The cost of each bottle to the supermarket is 45 cents, and the cost ofplacing an order has been estimated at $8.50. Assume that holding costs are based ona 25 percent annual interest rate. Stock-outs of the shampoo are not allowed.a. Determine the optimal lot size the supermarket should order and the time betweenplacements of orders for this product.
HAL Ltd. produces a line of high-capacity disk drives for computers. The housings for the drives are produced in Hamilton, Ontario at a rate of 250 housings per month, and shipped to the main plant in Toronto. The housings cost HAL $100 each to produce, and the setup cost for beginning a production run is $500. HAL uses the drive housings at a fairly steady rate of 1400 per year. Assume an annual interest rate of 25% for determining the holding cost. What is the optimal number of housings for HAL to produce in each production run? For the optimal production size, what proportion of each production cycle consists of uptime and what proportion consists of downtime? Assuming that HAL produces the optimal number of housings in each production run, what is the maximum on-hand inventory level of these housings? What is the annual cost of holding and setup?
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?
Parasol Systems sells motherboards for personal computers. For quantities upthrough 25, the firm charges $350 per board; for quantities between 26 and 50,it charges $315 for each board purchased beyond 25; and it charges $285 eachfor the additional quantities over 50. A large communications firm expects torequire these motherboards for the next 10 years at a rate of at least 140 peryear. Order setup costs are $30 and holding costs are based on an 18 percentannual interest rate. What should be the size of the standing order?
1. David and Beth Sheba run a health food store. Their top selling item is called Heavenly Kelp. The annual demand for this is 3200 units, and demand is constant throughout the year. The cost of placing an order is $100, while the holding cost per unit per year is $4. How many orders per year should be placed if they wish to minimize their total cost ? If you want to be eligible for partial credit, give an idea as to how you arrived at that number?
An electronics retailer sells laptops at a steady rate of 7,500 per quarter. It costs the manufacturer $350 tomake each laptop, and they charge $400/laptop to the retailer. The manufacturer produces the laptop at asteady rate that matches demand, and incurs a fixed cost of $2,800 to fulfill each retail order. Both theretailer and the manufacturer have an annual holding cost percentage of 20%. The retailer places 10orders with the laptop manufacturer each quarter (which it determined from an EOQ calculation). Whatare the retailer’s and manufacturer’s costs under this current setup, as well as the total supply chain cost?
An electronics retailer sells laptops at a steady rate of 7,500 per quarter. It costs the manufacturer $350 tomake each laptop, and they charge $400/laptop to the retailer. The manufacturer produces the laptop at asteady rate that matches demand, and incurs a fixed cost of $2,800 to fulfill each retail order. Both theretailer and the manufacturer have an annual holding cost percentage of 20%. The retailer places 10orders with the laptop manufacturer each quarter (which it determined from an EOQ calculation). Whatare the retailer’s and manufacturer’s costs under this current setup, as well as the total supply chain cost?What quantity discount should the manufacturer offer the retailer in order to minimize the total supplychain costs? Under this quantity discount, what are the new retailer and manufacturer costs? Does theretailer choose to use the quantity discount? PLEASE SHOW ALL CALUCALTIONS/EXCEL MODEL
ABC firm uses roughly 3,400 pounds of chemical dye a year. Currently, the firm purchases 300 pounds per order and pays P120.00 per pound. The supplier has just announced that orders of 1,000 pounds or more will be filled at a price of P80.00 per pound. The manufacturing firm incurs a cost of P4,000.00 each time it submits an order and assigns an annual holding cost of 17% of the purchase price per pound. a. Determine the order size that will minimize the total cost.b. If the supplier offered the discount at 1,500 pounds instead of 1,000 pounds, what order size would minimize total cost?
Consider the coffeehouse discussed below. Suppose that its setup cost for ordering was really only $15. Determine the error made in calculating the annual cost of holding and setup incurred as a result of its using the wrong value of K. (Note that this implies that its current order policy is suboptimal.) A specialty coffeehouse sells Colombian coffee at a fairly steady rate of 280 pounds annually. The beans are purchased from a local supplier for $2.40 per pound. The coffeehouse estimates that it costs $45 in paperwork and labor to place an order for the coffee, and holding costs are based on a 20 percent annual interest rate.
The Rahway, New Jersey, plant of Metalcase, a manufacturer of office furniture, produces metaldesks at a rate of 200 per month. Each desk requires 40 Phillips head metal screws purchasedfrom a supplier in North Carolina. The screws cost 3 cents each. Fixed delivery charges and costsof receiving and storing shipments of the screws amount to about $100 per shipment, independently of the size of the shipment. The firm uses a 25 percent interest rate to determineholding costs. Metalcase would like to establish a standing order with the supplier and is considering several alternatives. What standing order size should they use?
One of the products stocked at Weiss’s paint store, mentioned in Problem 14, is a certain type of highly volatile paint thinner that, due to chemical changes in the product,has a shelf life of exactly one year. Al Weiss purchases the paint thinner for $20 a galloncan and sells it for $50 a can. The supplier buys back cans not sold during the yearfor $8 for reprocessing. The demand for this thinner generally varies from 20 to 70cans a year. Al assumes a holding cost for unsold cans at a 30 percent annual interestrate.a. Assuming that all values of the demand from 20 to 70 are equally likely, what is theoptimal number of cans of paint thinner for Al to buy each year?b. More accurate analysis of the demand shows that a normal distribution gives abetter fit of the data. The distribution mean is identical to that used in part (a), andthe standard deviation estimator turns out to be 7. What policy do you nowobtain?
A manufacturing company produces furniture products. The company operates 300 working-day per year. It has orders for about 12,000 products per year. Its factory has the capability of producing 100 per day. Setting up the product production costs SR 50 The cost of each furniture product is SR 1 The holding cost is SR 0.10 per product per year. What is the optimal size of the production run?