View the step-by-step solution to:

# Find economic production quantity by using Excel simulation. Table-2 = 1000 units/year = 4000 units/year F= 0.25 c= \$400 K= \$20 Instructions:

Find economic production quantity by using Excel simulation.
Table-2
λ= 1000 units/year
ψ= 4000 units/year
F= 0.25
c= \$400
K= \$20
Instructions:
 Step 1 - Create a column for quantity, production cost, holding cost and setup (ordering)
cost using the given parameters in Table-2.
 Step 2 - Assign 1 to quantity and calculate production cost, holding cost and setup
(ordering) cost
 Step 3 - Increase quantity with an increment of one unit. Calculate production cost,
holding cost and setup (ordering) cost.
 Step 4 - Repeat step 3 as much as you need![Hint: Pay attention to your demand level

Sign up to view the entire interaction

#### Top Answer

Here is the answer... View the full answer

Inventory Production Order Quantity Model
Inventory: Cost vs Quantit y Data
Demand rate, D
Setup cost, S
Holding cost, H
Daily production rate, p
Daily demand rate, d
Unit price, P 1000
20
25.00%...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents
• ### -

Question & Answers

Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

Ask a Question
Ask a homework question - tutors are online