Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

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

Security And Loss Prevention An Introduction

Authors: Philip Purpura CPP Florence Darlington Technical College

7th Edition

0128117958, 9780128117958

More Books

Students also viewed these Accounting questions

Question

3. What obstacles interfere with eff ective listening?

Answered: 1 week ago