Additional Question. The XYZ steel company must determine a policy for ordering coal to operate 15 converters. The ordering cost is $85/order and the cost of holding coal is 15% of the purchasing cost. The XYZ has a contract to obtain the coal for $14 per ton for the coming year. Each converter requires exactly 8 tons of coal per day to operate, and the firm operates 300 days per year. a. Determine the optimal quantity of coal to receive in each order. b. Determine the total inventory-related cost associated with the optimal ordering policy c. Optimal number of orders to place per year and number of operating days between orders, based on the optimal ordering. d. The XYZ is now considering to the following discount policy provided by supplier: Order Quantity (tons) 1,000 - 1,999 Price per ton $14 $12 $10 2,000 - 2,999 3000+ Please help the XYZ to determine the amount the firm should order.
Additional Question. The XYZ steel company must determine a policy for ordering coal to operate 15 converters. The ordering cost is $85/order and the cost of holding coal is 15% of the purchasing cost. The XYZ has a contract to obtain the coal for $14 per ton for the coming year. Each converter requires exactly 8 tons of coal per day to operate, and the firm operates 300 days per year. a. Determine the optimal quantity of coal to receive in each order. b. Determine the total inventory-related cost associated with the optimal ordering policy c. Optimal number of orders to place per year and number of operating days between orders, based on the optimal ordering. d. The XYZ is now considering to the following discount policy provided by supplier: Order Quantity (tons) 1,000 - 1,999 Price per ton $14 $12 $10 2,000 - 2,999 3000+ Please help the XYZ to determine the amount the firm should order.
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...
Related questions
Question

Transcribed Image Text:Additional Question. The XYZ steel company must determine a policy for ordering coal
to operate 15 converters. The ordering cost is $85/order and the cost of holding coal is
15% of the purchasing cost. The XYZ has a contract to obtain the coal for $14 per ton for
the coming year. Each converter requires exactly 8 tons of coal per day to operate, and
the firm operates 300 days per year.
a. Determine the optimal quantity of coal to receive in each order.
b. Determine the total inventory-related cost associated with the optimal
ordering policy
c. Optimal number of orders to place per year and number of operating days
between orders, based on the optimal ordering.
d. The XYZ is now considering to the following discount policy provided by
supplier:
Order Quantity (tons)
1,000 - 1,999
Price per ton
$14
$12
$10
2,000 - 2,999
3000+
Please help the XYZ to determine the amount the firm should order.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.