Example 62(a). A manufacturing firm purchases 2000 units of a particular item per year at a unit cost of Rs 80. The ordering cost per order is Rs 50 and the inventory carrying cost is 25% of the value of the average inventory. Find the optimum order quantity and the minimum total cost. If the supplier offers a 5% discount for purchases in lots of 1000, should the offer be accepted?

Example 62(a). A manufacturing firm purchases 2000 units of a particular item per year at a unit cost of Rs 80. The ordering cost per order is Rs 50 and the inventory carrying cost is 25% of the value of the average inventory. Find the optimum order quantity and the minimum total cost. If the supplier offers a 5% discount for purchases in lots of 1000, should the offer be accepted?

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter23: Other Topics In Working Capital Management

Section: Chapter Questions

Problem 8MC

See similar textbooks

Similar questions

MM Co. expects total sales of P10,000. The price per unit is P5. The firm estimates an ordering cost of P7.50 per order, with an inventory cost of P0.70 per unit. What is the optimum order size? A. 147 units B. 207 units C. 327 units D. 463 units
1. Annual Demand is 450 units. The cost to place an order is $80 and holding cost is 25% per year of the cost of the item. The supplier has just submitted the following cost schedule to you. Quantity Price EOQ Feasible? 1 to 50 $60 51-100 $54 Over 100 $51 a) Calculate the EOQ for each Price. Determine which are feasible. Fill in above. ( b) Is the EOQ for the lowest unit price feasible? If not, compare total cost at all break quantities larger than the feasible EOQ. c) What decision would you make?
15. MM Co. expects total sales of P10,000. The price per unit is P5. The firm estimates an ordering cost of P7.50 per order, with an inventory cost of PO.70 per unit. What is the optimum order size? A. 147 units C. 327 units D. 463 units B. 207 units
K Suppose that a company offers quantity discounts. If up to 1,000 units are purchased, the unit price is $12; if more than 1,000 and up to 5,000 units are purchased, the unit price is $8.00; and if more than 5,000 units are purchased, the unit price is $7.50. Develop an Excel template using the VLOOKUP function to find the unit price associated with any order quantity and compute the total cost of the order. Complete the formulas in the spreadsheet below. Select the correct VLOOKUP function in cell C8 to find the unit price for the order quantity. (Type integers or decimals rounded to two decimal places as needed.) 1 2 3 5 6 7 8 6 A B C Purchase Quantity 1 to 1000 1001 to 5000 5001 or more Quantity Ordered Unit Price Total Cost 2400 D Unit Price $ $ $
Suppose consumers will purchase q units of a product at a price of 100/q+7 dollars per unit. What is the minimum number of units that must be sold in order that sales revenue be greater than $9000?
if the holding cost of an item is $0.15 per unit per day, the ordering cost is $200 per order, the purchasing cost per unit is $12 for any quantity less than 500 units, and $11 otherwise. The daily demand is 80 units. Find the economic order quantity?
Please help me. Thankyou.
4. Genesis Company is a wholesaler. It purchases 60,000 units of Product X per month for sale to retailers. The cost of placing an order is P100. The cost of holding one unit of inventory for one year is P4. Note: Kindly input your answer with comma. Example: 10,000 Required: a. Compute the economic order quantity. b. How many orders would be placed under the EOQ policy? c. Compute the annual ordering cost for the EOQ. d. Compute the annual carrying cost for the EOQ. e. Compute the total inventory-related cost at the EOQ.
Assume that Phoenix decides to accept the special order at a unit sales price that will add $400,000 per month to its oper-ating income. The unit price of the special order will be: a. $85. c. $55.b. $70. d. Some other amount.
Refer to the data in Required 6. Assume the outside supplier will accept an order of any size for the tubes at a price of $1.90 per box. How many boxes of tubes should Silven make? How many boxes of tubes should it buy from the outside supplier?
Q.1. An item sells for $25 a unit, but a 10% discount is offered for lots of 150 units or more. A company uses this item at the rate of 20 units per day. The setup cost for ordering a lot is $50, and the holding cost per unit per day is $.30. The lead time is 12 days. The same item can also be produced in house with its setup cost being $30 and production cost per unit being $20. Should the company purchase the item or produce it in-house?
A Company estimates that its carrying cost is 20% of the purchase price and its ordering cost at $40 per order. The estimated annual requirement is 10,000 units at a price of $200 per unit. What is the EOQ? * Your answer