Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5. Northcutt Bikes purchases two types of wheels for their roadracing bikes: a regular version and a deluxe version. The table below has demand information

5. Northcutt Bikes purchases two types of wheels for their roadracing bikes: a regular version and a deluxe version. The table below has demand information for the past year for each style of wheel, as well as combined figures. a. Calculate the EOQ for each wheel type. b. Calculate the ROP for each wheel type. c. For each wheel type, calculate the total yearly holding and ordering cost, as well as total item cost.
Regular Deluxe Combined
Month wheels wheels demand EOQ- Reg EOQ-Del
jan 208 481 689 45.60702 69.35416
feb 153 316 469 39.11521 56.21388
March 238 553 791 48.78524 74.36397
april 296 648 944 54.40588 80.49845
may 292 228 520 54.03702 47.74935
june 322 527 849 56.74504 72.59477
july 102 605 707 31.93744 77.78175
aug 211 510 721 45.93474 71.41428
sept 286 538 824 53.47897 73.34848
oct 193 590 753 43.93177 76.81146
nov 186 657 843 43.12772 81.05554
dec 129 582 711 35.91657 76.28892
std dev 72.1 122.8 129.2
monthly
Other important information:
Yearly holding cost 20% of item cost
Ordering cost $200 per order
Service level 95%
Leadtime 0.5 months
Item costs
Deluxe Wheels $40 each
Regular Wheels $35 each

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Sampling An Introduction

Authors: Dan M. Guy, D. R. Carmichael, O. Ray Whittington

5th Edition

047137590X, 978-0471375906

More Books

Students also viewed these Accounting questions

Question

Why is the Moon described as a "silent planet"?

Answered: 1 week ago

Question

2. Describe how technology can impact intercultural interaction.

Answered: 1 week ago