View the step-by-step solution to:

# The problems should be done in a single Excel file showing all of your work. Best Bikes produces bicycles and buys brakes from a supplier in Japan....

Hello,

I need some help with the attached assignment regarding supply chain management calculations.  I need all 6 questions answered in an excel document with calculations provided, thanks!

The problems should be done in a single Excel file showing all of your work. 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 20%. 1. What is the average inventory carrying/holding cost for the brakes? (5 points) 2. What is the EOQ for the brakes? (10 points) 3. What is the ROP for the brakes? (5 points) 4. What is the total annual inventory cost for the brakes? (5 points) 5. What buying/purchasing strategy would be most appropriate for the brakes and why? (10 points) The information below shows products your company produces, their demand, cost and currently inventory levels. Product # Cost (\$) Annual Volume (units) Average Inventory (units) A246 \$1.00 22000 5600 B615 \$0.25 3500 120 C024 \$4.25 1468 348 L227 \$1.25 440 1200 N376 \$0.50 40000 800 P112 \$2.25 1600 352 R116 \$0.12 25000 2100 R221 \$12.00 410 80 T049 \$8.50 124 50 T519 \$26.00 10 300 6. Classify these products into A-B-C based on their volume and inventory levels. (10 points) Are the products stocked correctly and why or why not? (5 points)

Here is the explanation for... View the full answer

Question 1
1 a). Average lnventory Holding cost = 1 b. Brakes EOQ= 1 c. ROP for the brakes= 1 d. Annual inventory cost (brakes) = 1 e. Ordering strategy Question 2 a Question 2 b Average...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents