Purchase Solution

Calculate Quantity Discount for Inventory and EOQ

Not what you're looking for?

Ask Custom Question

The inventory manager has typically ordered a quantity of 800 each time an order is needed for one of their popular tires to take advantage of the discount provided by the supplier and save the company money. The following discount schedule has just been received reflecting recent changes in the discount percentages. The manager still maintains that an order quantity of 800 will save the company the most money because of the quantity discount.

Order Quantity Discount Acquisition Cost
0-399 0% 79.95
400-799 5% 75.95
800+ 10% 71.95

Assume this tire is forecasted to have a constant demand of 1600 tires over the next year. They reported a total ordering cost of $45 and a total carrying cost of $15,542 for last year with a lot size of 800 and acquisition cost of $71.95. Consider their carrying cost for all items to be in the units of cost per dollar of acquisition cost per year.

Find EOQ and the total cost at EOQ.

Purchase this Solution
Solution Summary

Excel file contains calculations of Quantity Discount for Inventory and EOQ.

Purchase this Solution
Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

View More Free Quizzes
Related BrainMass Solutions

  • EOQ Model and Quantity Discount

    202342 EOQ Model and Quantity Discount Apply the EOQ model to the following quantity discount situation in which D=500 units per year, C0=$40, and the annual holding cost rate is 20%. What order quantity do you recommend?

  • Amount of inventory cost for the order quantity

    How much should the store order, and what will be the total amount inventory cost for the order quantity? In this we have to compare the Inventory costs of EOQ order and if the order size is 5000 yards. I.

  • Problems on ABC analysis for inventory control, EOQ

    Four problems on Supply Chain, ABC analysis for inventory control, EOQ (Economic Order Quantity).

  • Find Economic Order Quantity

    Then, for any discount, if the order quantity is too low to qualify for the discount, adjust the order quantity upward to the lowest quantity that qualifies for the discount.

  • Economic order quantity and annual costs

    We calculate the economic order quantity (EOQ) so as to minimize the total inventory carrying costs EOQ = Square root ((2Xannual requirementXorder cost)/carrying cost) Here annual requirement is 1,000 order cost is 10 carrying cost is $2 EOQ = Square

  • Determining EOQ and total costs at EOQ

    208578 What is Basic EOQ? What is TC at the EOQ? Calculate TC increase for 1000 units. Economic ordering quantity (EOQ) is a commonly used method for optimizing the inventory costs with ordering costs.

  • Description of Optimal Order Quantity

    The vendor has offered the bookstore the following volume discount schedule. Determine the bookstore's optimal order quantity given the above quantity discount information. First calculate economic order quantity EOQ = As??

  • Inventory problem: Quantity discount model

    98780 Inventory problem: Quantity discount model As inventory manager, you must decide on the order quantity for an item that has an annual demand of 2,000 units. Placing an order costs you $20 each time.

  • Inventory Quantity discount model:IPC

    This posting contains solution to following inventory problem on quantity discount model for IPC.

View More Related Solutions