Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Kelvin is the store manager for a bicycle retailer store in Ion Orchard. Last year, the sales of the bicycles were stable and are shown
Kelvin is the store manager for a bicycle retailer store in Ion Orchard. Last year, the sales of the bicycles were stable and are shown in Table 1. To keep sufficient stock to satisfy customer demands, Kelvin places orders to the supplier when stock on hand falls below a certain level. The bicycles are kept at a rented warehouse in Tanjong Katong. It is estimated that the holding cost per unit is 30% of its purchase price of $200. The supplier charges a $100 transportation cost to deliver the bicycles to the warehouse. Kelvin is wondering how many bicycles he should order from the supplier to minimise the inventory cost. (a) Determine the best order quantity he should be ordering from the supplier. (10 marks) (b) In your own words, discuss the reasons for using the method in part (a) to determine the best order quantity. What are the assumptions for the method? (10 marks) (c) How much will the total inventory cost change (in percentage) if Kelvin decides to order (X+1)% more or (X+1)% less than the best quantity of bicycles? What can you infer based on the findings? Note: X represents the last digit of your PI number; if your PI number is B1234567, X =7 (15 marks) (d) How often should Kelvin place orders with the supplier? (7 marks) (e) What should be the reorder level, ROL, if the replenishment lead time is 2 months? (8 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started