Using the Economic Order Quantity formula, what is the optimal order size that minimises total cost (in Litres of food colouring per order)? a. 1265 litres b. 736 litres c. 1067446 litres d. 26 litres e. 1033 litres Question 2 Using the Economic Order Quantity formula and the data provided above, how many orders will have to be made in a single year? The choices below are all rounded to the nearest integer. a. 18 orders b. 15 orders c. 519 orders d. 13 orders e. 79 orders Question 3 Using the Economic Order Quantity and the data provided above, how much will need be the total annual cost? Hint: account for (i) the price paid for every litre throughout the year purchased from the supplier, (ii) holding cost of your average inventory, and (iii) the ordering cost for all the orders throughout the year. a. $87732 b. $11778 c. $25269 d. $82360 e. $81843

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
Question 1 The Jelly Bean operation holds an inventory of food colouring which used to colour the jelly beans. The jelly bean operation is interested in calculating the optimal ordering strategy for food colouring. Suppose the annual forecast for the necessary food colouring during a normal year of operation is 13491 litres per year. Furthermore, suppose the holding cost per litre of paint is $11.4 and every time the jelly bean operation issues an order to their supplier, a charge of $451 is added to the invoice as an ordering cost. The supplier charges $5.63 per litre of food colouring. Using the Economic Order Quantity formula, what is the optimal order size that minimises total cost (in Litres of food colouring per order)? a. 1265 litres b. 736 litres c. 1067446 litres d. 26 litres e. 1033 litres Question 2 Using the Economic Order Quantity formula and the data provided above, how many orders will have to be made in a single year? The choices below are all rounded to the nearest integer. a. 18 orders b. 15 orders c. 519 orders d. 13 orders e. 79 orders Question 3 Using the Economic Order Quantity and the data provided above, how much will need be the total annual cost? Hint: account for (i) the price paid for every litre throughout the year purchased from the supplier, (ii) holding cost of your average inventory, and (iii) the ordering cost for all the orders throughout the year. a. $87732 b. $11778 c. $25269 d. $82360 e. $81843
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 6 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.