Question: 3. Upon hearing that Ross White (see Problems 6-27 and 6-28) is considering producing the brackets in-house, the vendor has notified Ross that the purchase
3. Upon hearing that Ross White (see Problems 6-27 and 6-28) is considering producing the brackets in-house, the vendor has notified Ross that the purchase price would drop from $15 per bracket to $14.50 per bracket if Ross would purchase the brackets in lots of 1,000. Lead times, however, would increase to 3 days for this larger quantity. A) What is the total annual inventory cost plus purchase cost if Ross buys the brackets in lots of 1,000 at $14.50 each? B) If Ross does buy in lots of 1,000 brackets, what is the new ROP? C) Given the options of purchasing the brackets at $15 each, producing them in-house at $14.80, and taking advantage of the discount, what is your recommendation to Ross White?
Answer in EXCEL
PLEASE SHOW ALL THE FORMULAS USED WHEN ANSWERING THE QUESTION
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
