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

8437470.xlsx

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%...

Sign up to view the full answer

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