Fresco Inc. manufactures sour pops annually which requires 0.4 kilograms of raw material. The company produces and sells 1,600, 000 sour pops annually. The cost to place a single order is $60 per hour which takes four (4) hours on average. The annual carrying cost of inventory is 4% per annum and currently, the company orders twenty (20) times per year. A major supplier has offered some incentives for bulk purchases and as the junior cost accountant you were asked to provide your professional opinion on the optimal order size. A 3% discount would be given if the entity doubles its current lot size. A further 2% would be given if the entity increased its order by two and a half times the current lot size. The material is currently bought from its supplier for $120 per kilogram. Required: (a) Calculate the Economic Order Quantity (EOQ). (b) Calculate the total cost based on the EOQ. (c) Calculate the total cost for each alternate order quantities, including the current policy. (d) What is the optimal order quantity and why?

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
Question

Fresco Inc. manufactures sour pops annually which requires 0.4 kilograms of raw material. The company produces and sells 1,600, 000 sour pops annually. The cost to place a single order is $60 per hour which takes four (4) hours on average. The annual carrying cost of inventory is 4% per annum and currently, the company orders twenty (20) times per year. A major supplier has offered some incentives for bulk purchases and as the junior cost accountant you were asked to provide your professional opinion on the optimal order size. A 3% discount would be given if the entity doubles its current lot size. A further 2% would be given if the entity increased its order by two and a half times the current lot size. The material is currently bought from its supplier for $120 per kilogram. Required: (a) Calculate the Economic Order Quantity (EOQ). (b) Calculate the total cost based on the EOQ. (c) Calculate the total cost for each alternate order quantities, including the current policy. (d) What is the optimal order quantity and why?

Expert Solution
steps

Step by step

Solved in 5 steps with 7 images

Blurred answer
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.