## Description

Problem 1

An company uses 500 tons of steel per day. Suppose that the steel supplier offers the

company a price of $1490 per ton of steel if Q < 1200 tons; $1220 per ton if 1200 ≤

Q < 2400, and $1100 per ton if Q ≥ 2400. Each order incurs a fixed cost of $2250.

The annual holding cost rate, i, is 0.25. (You will need to divide 0.25 by 365 to get the

daily holding cost rate.) Calculate optimal order amount and total cost for the all-units

discount structure and the incremental discount structure.

Problem 2

Suppose there are demands for next 52 periods (demand.xlsx ). Each order palced to the

supplier incurs a fixed cost of $1100. One unit of product held in inventory for one period

incurs a holding cost of $2.40. Find the optimal order quantities in each period and the

optimal total cost.

There are three ways that you can solve the problem:

• Mixed integer linear Programming

• Dynamic programming

• Reformulation as a shortest path problem and use Dijkstra’s algorithm

You can utilize the codes posted on canvas and modify them to suit your need.

Submit

both code and result using at least one method, but you are welcome to submit all three.