Gamin Inc. produces various GPS devices with a wide assortment of different models for its customers. One item, RC1 is very popular. Keen of keeping its stock under control, a decision is taken to order only the optimum economic quantity, for this item, each time. You have the following information.     Annual demand (units) 115,200 Purchase price per unit $ 300 Carrying/Holding costs per unit $ 8 Cost per order $ 200 Required: Determine the EOQ using the equation method.  Fill the blanks in the following table using the above data.  No. of orders 1 10 20 30 90 120 Order size             Average stock             Carrying (Holding) costs               Order costs               Total costs                             Calculate the holding, ordering cost & their total cost at the EOQ level.  Plot the graph at the EOQ level showing the numbers  Garmin Inc. has been offered a 2 per cent discount on the cost if it places orders in quantities of 19,200. Discuss whether the company should accept the discount and place larger orders, show your workings.  i want the answer of all the parts of questions in detail

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter10: Introduction To Simulation Modeling
Section10.4: Simulation With Built-in Excel Tools
Problem 14P
icon
Related questions
icon
Concept explainers
Topic Video
Question

Gamin Inc. produces various GPS devices with a wide assortment of different models for its customers. One item, RC1 is very popular. Keen of keeping its stock under control, a decision is taken to order only the optimum economic quantity, for this item, each time. You have the following information.

 

 

Annual demand (units)

115,200

Purchase price per unit

$ 300

Carrying/Holding costs per unit

$ 8

Cost per order

$ 200

Required:

  1. Determine the EOQ using the equation method. 
  2. Fill the blanks in the following table using the above data. 

No. of orders

1

10

20

30

90

120

Order size

 

 

 

 

 

 

Average stock

 

 

 

 

 

 

Carrying (Holding) costs

 

 

 

 

 

 

 

Order costs

 

 

 

 

 

 

 

Total costs

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  1. Calculate the holding, ordering cost & their total cost at the EOQ level. 
  2. Plot the graph at the EOQ level showing the numbers 
  3. Garmin Inc. has been offered a 2 per cent discount on the cost if it places orders in quantities of 19,200. Discuss whether the company should accept the discount and place larger orders, show your workings. 

i want the answer of all the parts of questions in detail 

Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,