Question

Quest Question 1 Given the following data: D = 60.825 units per year. S=5120 persetup. P = 55 per unit and I25% per year, EOQ
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Question: For the given data, calculate annual costs of holding and setup following EOQ behavior.

Answer:

Given that:

Annual Demand (D) = 60825

Setup cost (S) = 120

Unit Cost (P) = 5

Holding Cost (H) = 25% x 5 = 1.25

Current Order (EOQ) = 3113

Annual Setup Cost (ASC) is given by:

ASC = (D / EOQ) x S

Therefore:

ASC = (60825 / 3113) x 120

ASC = 2344.68358497

ASC = 2344.68

Annual Holding Cost is given by:

AHC = (EOQ / 2) x H

Therefore:

AHC = (3113 / 2) x 1.25

AHC = 1945.625

AHC = 1945.63

Total Annual Cost is given by:

Total Annual Cost of Holding and Setup = ASC + AHC

Therefore:

Total Annual Cost of Holding and Setup = 2344.68 + 1945.63

Total Annual Cost of Holding and Setup = 4290.31

Add a comment
Know the answer?
Add Answer to:
Quest Question 1 Given the following data: D = 60.825 units per year. S=5120 persetup. P...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Question 24 Given the following data: D-64,302 units per year, S5120 per schip. P.35 per unit,...

    Question 24 Given the following data: D-64,302 units per year, S5120 per schip. P.35 per unit, and/ 25% per year, 100-3,444 units Calculate annual costs of holding and setup followin annual demand setup cost product price holding cost as of price current order quantity Excel Acce 64,302 units per year $120 per setup $5 per unit 25% 3.444 units per order

  • Given the following data: D = 46,741 units per year, S = $120 per setup, P...

    Given the following data: D = 46,741 units per year, S = $120 per setup, P = $5 per unit, and H= 3.82 per year, Quantity ordered per order is 161 units. Using the Quantity ordered per order provided, calculate annual costs of holding and setup. annual demand 46,741 setup cost $120 $5 product price (per unit) holding cost current order quantity 3.82 161 Excel Access

  • QUESTION 31 Given the following data: D 45,620 units per year, S - $120 per setup,...

    QUESTION 31 Given the following data: D 45,620 units per year, S - $120 per setup, P-$5 per unit, and He 4.92 per year, Quantity ordered per order is 270 units. Using the Quantity ordered per order provided, calculate annual costs of holding and setup annual demand 45,629 $120 $5 setup cost product price (per unit) holding cost current order quantity 4.92 279 Excel Access

  • QUESTION 32 Given the following data: D. 29,363 units per year, S - $120 per setup....

    QUESTION 32 Given the following data: D. 29,363 units per year, S - $120 per setup. P - $5 per unit, and - 3.8 per year, Quantity ordered per order is 415 units. Using the Quantity ordered per order provided, calculate annual costs of holding and setup annual demand setup cost product price (per unit) holding cost current order quantity 29,363 $120 $5 3.8 415 Excel Access

  • Gomawing 45 per ye5120 PS Quantity ordered per order provided 5120 15 annua demand setup cost...

    Gomawing 45 per ye5120 PS Quantity ordered per order provided 5120 15 annua demand setup cost product price per unit holding cost current order quantity Excel Access 279

  • The cost accounting department has asked you to check their EoQ figures. You have been given...

    The cost accounting department has asked you to check their EoQ figures. You have been given the following data: demand is 16,728 units per quarter, S = $120 per setup, P = $5 per unit, and I = 25% per unit per year, 600-3,017 units. Calculate total annual inventory costs including setup, holding and product cost. Excel Access QUESTION 33 The graph below plots two different types of cost as a function of the order quantity in the EOQ model....

  • Transparent Processing System QUESTION 9 A product has a demand of 414 units per month. Ordering...

    Transparent Processing System QUESTION 9 A product has a demand of 414 units per month. Ordering cost is $20, and holding cost is $4 per unit per year. The EOQ model is appropriate. The total management cost (holding and setup costs only) for this product will be per year. demand 414 per month order cost $20 per order holding cost $4 per unit per year Excel Access

  • QUESTION 1 The cost accounting department has asked you to check their EOQ figures. You have...

    QUESTION 1 The cost accounting department has asked you to check their EOQ figures. You have been given the following data: demand is 17,991 units per quarter, S = $120 per setup, P-$5 per unit, and I = 25% per unit per year, EOQ=3,303 units. Calculate total annual inventory costs including setup, holding and product cost. Excel Access

  • The cost accounting department has asked you to check their EOQ figures. You have been given...

    The cost accounting department has asked you to check their EOQ figures. You have been given the following data: demand is 15,307 units per quarter, 5 = $120 per setup, P = $5 per unit, and I = 25% per unit per year, EOQ= 3,176 units. Calculate total annual inventor costs including setup, holding and product cost. Excel Access

  • A product has a demand of 436 units per month. Ordering cost is $20, and holding...

    A product has a demand of 436 units per month. Ordering cost is $20, and holding cost is $4 per unit per year. The EOQ model is appropriate. The total management cost (holding and setup costs only) for this product will be per year. demand 436 per month order cost $20 per order holding cost $4 per unit per year Excel Access QUESTION 29 A drone company builds its own motors, which are then put into each drone. While the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT