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?
Why should SPC have a cycle inventory? SPC buys polystyrene resin from a supplier in 1000-pound...
Why should SPC have a cycle inventory? SPC buys polystyrene resin from a supplier in 1000-pound units, and each unit costs $20.00, and the percent holding cost is 10%. The fixed shipping cost per order is $300. If we assume that 1000 pounds of resin yields 1000 pounds of clear plastic, what are the following values for clear plastic: What are the following values for clear plastic: Lot size per shipment to minimalize total cost Economic order quantity Number of...
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)...
MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at...
MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at a rate of 125 bottles a month on the average. The store buys this wine from WSCo at $5 a bottle, and a required lead-time of 1.5 weeks. Ordering cost per order for MARGI is $14, and annual holding rate is 22%. Management is worried about daily variations of the demand, thus has decided to increase the EOQ order size by a lot. Would...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT