Mathematics Chapter 12 Homework Problem 12-15 Total Holding Cost Total Ordering Cost Total

Type Homework Help
Pages 4
Words 336
Authors Barry Render, Jr. Ralph M. Stair, Nagraj Balakrishnan

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Problem 12-15 (a)
Inventory EOQ Model
Input Data
Demand rate, D 150000
Results
Economic order quantity, Q* 38729.83
Maximum inventory 38729.83
Problem 12-15 (b)
Inventory EOQ Model
Input Data
Demand rate, D 150000
Results
Economic order quantity, Q* 38729.83
Maximum inventory 38729.83
Problem 12-15 (c)
Inventory EOQ Model Inventory EOQ Model
Input Data Input Data
Demand rate, D 150000 Demand rate, D 150000
Ordering cost, Co\$30.00 Ordering cost, Co\$30.00
Results Results
Economic order quantity, Q* 38729.83 Economic order quantity, Q* 75000.00
(Type in 150,000/2=75,000 in cell F12)
Maximum inventory 38729.83 Maximum inventory 75000.00
Problem 12-15 (d)
Inventory EOQ Model Inventory EOQ Model Inventory EOQ Model
Input Data Input Data Input Data
Demand rate, D 150000 Demand rate, D 150000 Demand rate, D 150000
Results Results Results
Economic order quantity, Q* 44721.36 Economic order quantity, Q* 50000.00 Economic order quantity, Q* 54772.26
Maximum inventory 44721.36 Maximum inventory 50000.00 Maximum inventory 54772.26

Trusted by Thousands ofStudents

Here are what students say about us.