### Unlock document.

**1 million**more documents.

This document is partially blurred.

Unlock all pages and **1 million** more documents.

Get Access
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

Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.