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: a.Determine the EOQ using the equation method. b.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.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
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:

a.Determine the EOQ using the equation method.

b.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 part b and the answer of number 2 graph in details please

Expert Solution
steps

Step by step

Solved in 4 steps with 2 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,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.