Question

Best Bikes produces bicycles and buys brakes from a supplier in Japan. The brake set for...

Best Bikes produces bicycles and buys brakes from a supplier in Japan. The brake set for one bicycle costs $125, and it is $35 to process the order with the supplier. The company consistently sells 50 bicycles a week (for 52 weeks of the year) and holds an average of 1 week of brake sets in inventory to cover the constant lead time from Japan. The company uses a holding/carrying rate of 25%.

1. What is the average inventory carrying/holding cost for the brakes?

2. What is the EOQ for the brakes?

3. What is the ROP for the brakes?

4. What is the total annual inventory cost for the brakes?

Homework Answers

Answer #1

Given are following details :

Annual demand of brakes = D = 50 / week x 52 weeks = 2600

Order processing cost = Co = $35

Annual unit holding cost = Ch = 25% of $125 = $31.25

Economic Order Quantity ( EOQ )

= Square root ( 2 x Co x D / Ch )

= square root ( 2 x 35 x 2600 / 31.25 )

= 76.31 ( 76 rounded to nearest whole number)

AVERAGE ANNUAL INVENTORY COST = $31.25 PER UNIT

ECONOMIC ORDER QUANTITY = 76

Reorder point ( ROP ) for the brakes

= Average weekly demand x Lead time ( 1 week)

= 50 x 1

= 50

Total annual inventory carrying cost

= Annual unit holding cost x Average inventory

= Ch x EOQ/ 2

= 31.25 x 76/ 2

= $1187.50

REORDER POINT = 50

ANNUAL INVENTORY CARRYING COST = $1187.50

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Chris Froome is a purchasing agent for a firm that sells components for high-performance bicycles. One...
Chris Froome is a purchasing agent for a firm that sells components for high-performance bicycles. One of the most popular components is the TDF bicycle frame which has an annual demand of 1,750 units. The cost of each frame is $675 and the inventory carrying cost is estimated to be 18% of the cost of each frame. Chris has made a study of the costs involved in placing an order for any of the frames the firm stocks, and he...
Solve in ExcelQM Barbara Bright is the purchasing agent for West Valve Company. West Valve sells...
Solve in ExcelQM Barbara Bright is the purchasing agent for West Valve Company. West Valve sells industrial valves and fluid control devices. One of the most popular valves is the Western, which has an annual demand of 4,000 units. The cost of each valve is $90, and the inventory carrying cost is estimated to be 10% of the cost of each valve. Barbara has made a study of the costs involved in placing an order for any of the valves...
Speedy Bicycle Company (SBC) is a wholesale distributor of a wide variety of bicycles and bicycle...
Speedy Bicycle Company (SBC) is a wholesale distributor of a wide variety of bicycles and bicycle parts. The most popular model is the Dragonfly, which sells for $170. All manufacturing is done at a plant in China, and shipment takes a month (30 days) from the time an order is placed. The estimated order cost is $75, including customs clearance. SBC’s cost per bicycle is 65% of retail price, and inventory carrying cost is 11% per year of SBC’s cost....
Sharon Ltd has in the past ordered raw material T in quantities of 3,000 units which...
Sharon Ltd has in the past ordered raw material T in quantities of 3,000 units which is half a year’s supply. Management has instructed you, an inventory cost consultant, to advise them as to the most desired order quantities. The factory closes for 4 weeks annual leave per annum. You are given the following data: Inventory usage rate: 125 per week, Lead time: 3 weeks Unit price: $1.50, Annual requirement: 6,000 units Order cost: $9.00 per order, Carrying cost: $0.30...
Charles cycles produces bicycles and cycles, set up cost when switching production from one to other...
Charles cycles produces bicycles and cycles, set up cost when switching production from one to other is $1000. on average, retail customers order 150 tricycles per day(consider 250 day year). the daily production rate for tricycles is 600 units. unit cost of a tricycle is $60 and the company has determined inventory carrying cost to be 15%. what is production order quantity?
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from...
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every five weeks. Data for both products are as follows:   ITEM TEGDIW WIDGET   Annual demand 13,000 6,000   Holding cost (% of item cost)...
Operations Management: Supply and Ordering question BACKGROUND UPD Manufacturing produces a range of healthcare appliance for...
Operations Management: Supply and Ordering question BACKGROUND UPD Manufacturing produces a range of healthcare appliance for hospital as well as for home use. The company has experienced a steady demand for its products, which are highly regarded in the healthcare field. Recently the company has undertaken a review of its inventory ordering procedures as part of a larger effort to reduce costs. One of the company’s products is a blood pressure testing kit. UPD manufactures all of the components for...
Please read the following case of UPD Manufacturing and write the required report. UPD Manufacturing produces...
Please read the following case of UPD Manufacturing and write the required report. UPD Manufacturing produces a range of healthcare appliance for hospital as well as for home use. The company has experienced a steady demand for its products, which are highly regarded in the healthcare field. Recently the company has undertaken a review of its inventory ordering procedures as part of a larger effort to reduce costs. One of the company’s products is a blood pressure testing kit. UPD...
Sarah’s Organic Soap Company makes organic liquid soap. One of the raw materials for her soaps...
Sarah’s Organic Soap Company makes organic liquid soap. One of the raw materials for her soaps is organic palm oil. She needs 500 kgs of palm oil per day on average. The supplier charges a $55 delivery fee per order (which is independent of the order size) and $5.5 per kg. Sarah’s annual holding cost is 15%. Assume she operates and sells 5 days per week, 52 weeks per year. a.If Sarah wants to minimize her annual ordering and inventory...
Bob Sean, manager at Ikea is responsible for managing the inventory of computer desks. Bob isn't...
Bob Sean, manager at Ikea is responsible for managing the inventory of computer desks. Bob isn't talkative about his inventory, but you have managed to extract the following information from him: It costs $35 to place an order. Each computer desk costs $31.33. Annual per unit holding cost is 30% of item value. Average daily demand is 100 writing desks. Standard deviation of demand during lead time is 51.96. Lead time to receive a computer desk from a supplier is...