Question

Please Help me !!! Bundaberg Glass Company is a distributor of car windscreens. The windscreens are...

Please Help me !!!

Bundaberg Glass Company is a distributor of car windscreens. The windscreens are manufactured in Japan and shipped to Bundaberg. The management is expecting an annual demand of 30 000 windscreens. The purchase price of each windscreen is $500. Currently, company orders 250 windscreens per order. According to the management, it takes two (2) weeks to receive a new order, and the company works a 6-day week for 50 weeks each year. Other costs associated with ordering and maintaining an inventory of these windscreens are given below:

• The cost incurred in the purchase order department for placing and processing 60 orders for the last year was $30 000 (including fixed costs of$6 000). Variable ordering costs tend to increase by 20% annually.

  • Insurance cost on inventory is 10% of purchase price of per windscreen.

  • Damage and shortage cost is $15 per windscreen.

  • Other inventory holding cost is $10 per windscreen.

    Required:
    (i) Determine the optimal order quantity for car windscreens using the economic order

    quantity (EOQ) model. Show your calculations. (Round the answer to the nearest whole number)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Annual Order/Demand - 30,000 units

Per Unit Cost - $250

Inventory Holding Cost/ Carrying Cot - $10

Ordering Cost - Consider only Variable Cost, Fixed cost in all the cases are same.

VARIABLE COST 60 ORDERS

$24000

VARIABLE COST 1 ORDERS =$24000*1/60
=400

Current Year Ordering Cost (Increase 20%) = $400*120/100 = $480

Economic Order Quantity = 2* Annual Demand * OrderingCost/CarryingCost

EOQ = V2 * 30000 * 480/10

EOQ = 1697 QTY PER ORDER

Add a comment
Know the answer?
Add Answer to:
Please Help me !!! Bundaberg Glass Company is a distributor of car windscreens. The windscreens are...
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
  • Bundaberg Glass Company is a distributor of car windscreens. The windscreens are manufactured in Japan and...

    Bundaberg Glass Company is a distributor of car windscreens. The windscreens are manufactured in Japan and shipped to Bundaberg. The management is expecting an annual demand of 30 000 windscreens. The purchase price of each windscreen is $500. Currently, company orders 250 windscreens per order. According to the management, it takes two (2) weeks to receive a new order, and the company works a 6-day week for 50 weeks each year. Other costs associated with ordering and maintaining an inventory...

  • EOQ

    Bundaberg Glass Company is a distributor of car windscreens. The windscreens are manufactured in Japan and shipped to Bundaberg. Management is expecting an annual demand of 10 800 windscreens. The purchase price of each windscreen is $400. Other costs associated with ordering and maintaining an inventory of these windscreens are shown below. §  The ordering costs incurred in the purchase order department for placing and processing orders for the past three years are shown below. Year                Orders placed and processed              Total processing...

  • The manager of a car wash received a revised price list from the vendor who supplies...

    The manager of a car wash received a revised price list from the vendor who supplies soap, and a promise of a shorter lead time for deliveries. Formerly the lead time was 4 days, but now the vendor promises a reduction of 25 percent in that time. Annual usage of soap is 5990 gallons. The car wash is open 360 days a year. Assume that daily usage is normal, and that it has a standard deviation of 4.0 gallons per...

  • CHAP 15 - Q13 DROPDOWN OPTIONS ARE BELOW THIS 13. Calculate economic ordering quantity (EOQ) Inventory...

    CHAP 15 - Q13 DROPDOWN OPTIONS ARE BELOW THIS 13. Calculate economic ordering quantity (EOQ) Inventory costs can be categorized as the costs incurred for holding the inventory, the costs of ordering and receiving the inventory, and the cost of running out of inventory. costs are the direct and indirect costs of keeping inventory on hand. The number of units in the optimal size order is called the economic ordering quantity (E0Q). Murphy Company purchases custom-made durable packing boxes to...

  • The manager of a car wash received a revised price list from the vendor who supplies soap, and a ...

    The manager of a car wash received a revised price list from the vendor who supplies soap, and a promise of a shorter lead time for deliveries. Formerly the lead time was 8 days, but now the vendor promises a reduction of 25 percent in that time. Annual usage of soap is 4650 gallons. The car wash is open 360 days a year. Assume that daily usage is normal, and that it has a standard deviation of 3.0 gallons per...

  • 3. Calculate the Economic Ordering Quantity (EOQ) model Aa Aa Inventory costs can be categorized as...

    3. Calculate the Economic Ordering Quantity (EOQ) model Aa Aa Inventory costs can be categorized as the costs associated with holding the inventory, ordering and receiving the inventory, or running out of the inventory. For example, costs are the direct and indirect costs of keeping inventory on hand. carrying ordering The number of units in the optimal size order is called the economic ordering quantity (EOQ). Jones Company purchases custom-made durable packing boxes to ship its equipment. Each year, Jones...

  • A fresh produce distributor uses 890 non-returnable packing crates a month, which it purchases at a...

    A fresh produce distributor uses 890 non-returnable packing crates a month, which it purchases at a cost of $6 each. The manager has assigned an annual holding cost of 35 percent of the purchase price per crate. Ordering cost is $35 per order. Currently the manager orders 890 crates at a time. How much could the firm save annually in ordering and holding costs by using the EOQ?

  • How can I solve this in Pom- QM? Please show how to solve it step by...

    How can I solve this in Pom- QM? Please show how to solve it step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the purchase...

  • The following data is provided by Cotton Tops, Inc a distributor of budget-priced, custom designed tee-shirts...

    The following data is provided by Cotton Tops, Inc a distributor of budget-priced, custom designed tee-shirts that it sells to concessionaires at various theme parks in the US. Use the following information to solve for the Economic Ordering Quantity (EOQ) and how many times a year should Cotton Tops, Inc place an order. The annual sale is 26,000 shirts per year Carrying costs are 25% of inventory value Purchase price per shirt is $4.92 Fixed cost per order is $1,000...

  • Could you help me solve this in excel please. Showing the formulas in the cells as...

    Could you help me solve this in excel please. Showing the formulas in the cells as well as the answers. Thanks so much. Will leave a like!! D21 ху fх A B с D E F G H J K L M N. O 10.8. The local fire department uses 10,000 alkaline flashlight batteries per year, which cost $4 each. The cost of ordering batteries is estimated to be $50. The current interest rate suggested by the city council is...

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
ADVERTISEMENT