Question: TASK-3 I have solved the equations but I dont know how to fill the table Tim John is the purchasing manager at the headquarters of
TASK-3 
I have solved the equations but I dont know how to fill the table
Tim John is the purchasing manager at the headquarters of a multinational fast food chain with a central inventory operation. Tim's fastest-moving inventory item has a demand of 30 units per day. The cost of each unit is $150, and the inventory carrying cost is $5 per unit per year. The average ordering cost is $70 per order. (It is a corporate operation, and there are 300 working days per year)
- What is the EOQ?
Given: Daily Demand d = 30 units
No. of working days N = 300 days
Annual Demand = D = d * N = 30 * 300 = 9000 units
Cost of each unit = P = $150
Carrying cost per unit per year = H = $5
Order cost = S = $70
Economic Ordering quantity = EOQ = = = 501.99 = 502 units
- What is the average inventory if the EOQ is used?
Average Inventory = Iavg = EOQ / 2 = 502 / 2 = 251 units
- What is the optimal number of orders per year?
Optimal Number of orders per year = D / EOQ = 9000 / 502 = 17.92 = 18 orders per year
- What is the optimal number of days in between any two orders?
Optimal number of days between order = N / Optimal Number of orders per year = 300 / 18 = 16.67 days
- What is the annual cost of ordering and holding inventory?
Annual Ordering cost = Optimal Number of orders per year * S = 18 * 70= $1260
- What is total inventory management cost?
Total inventory management cost = Annual Ordering cost + Annual Holding cost = 1260 +1255 = $2515
- What is total materials cost
Total materials cost = D * P = 9000 * 150 = $1,350,000
- What is the total annual inventory cost to be recorded in accounts?
Total annual inventory cost to be recorded in accounts = Total materials cost + Total inventory management cost = 1,350,000 + 2515 = $1,352,515
Prepare a Schedule of Orders (till the last order is received) if the first order was received on Jan 10, 2020.
| Order # | Date of order | Quantity of this order (Units) | Cumulative Quantity (till date) (Units) |
| 1 | Jan 10, 2020 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help