Short answer question Your friend is in the process of solving an EOQ problem with thefollowing stipulations: there is a minimum order level of 1,000 units and a maximum orderlevel of 5,000 units. Holding costs are 20% of a product's cost. The supplier also appliesan all-units discount where the first cost range occurs from 1,000 to 3,000 products and1.the second cost range occurs from 3,001 through 5,000 products. Let EOQ1 be the EOQdetermined for range 1 and EOQ2 be the EOQ determined for the second range. Withoutknowing the actual values of EOQ1 and EOQ2, the fixed order costs, or the production costs,please list out the 6 potential values that could be the optimal ordering policy in this situation.

given, minimum order level = 1000 units maximum order = 5000 units holding costs = 20%

Your friend is in the process of solving an EOQ problem with the following stipulations: there is a minimum order level of 1,000 units and a maximum order level of 5,000 units. Holding costs are 20% of a product's cost. The supplier also applies an all-units discount where the first cost range occurs from 1,000 to 3,000 products and the second cost range occurs from 3,001 through 5,000 products. Let EOQ1 be the EOQ determined for range 1 and EOQ2 be the EOQ determined for the second range. Without knowing the actual values of EOQ, and EOQ2, the fixed order costs, or the production cost nlease list out the 6 potential yalues that could be the optimal ordering policy in this situatio- 1.

Your friend is in the process of solving an EOQ problem with the following stipulations: there is a minimum order level of 1,000 units and a maximum order level of 5,000 units. Holding costs are 20% of a product's cost. The supplier also applies an all-units discount where the first cost range occurs from 1,000 to 3,000 products and the second cost range occurs from 3,001 through 5,000 products. Let EOQ1 be the EOQ determined for range 1 and EOQ2 be the EOQ determined for the second range. Without knowing the actual values of EOQ, and EOQ2, the fixed order costs, or the production cost nlease list out the 6 potential yalues that could be the optimal ordering policy in this situatio- 1.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

ACME Company is a big supplier that wants to make it difficult for new suppliers to take sales away from its important customer BAKER. Currently ACME sells BAKER 10,000 units yearly at a cost of $75.75 per unit. And BAKER is placing orders of EOQ. ACME wants BAKER to increase the size of its next order to 3500 units by offering a price discount. Ordering costs are $320 per order and holding cost is 20% of item value. What is the smallest discount (new discount price), that ACME needs to offer BAKER to make it economical to purchase 3500 units next time? O 68.13 O 66.65 O 70.35 74.05 O 71.83 0 0 0
If you are an engineer for an automobile company, the annual requirements for spare parts are 3600 units for the assembly section. The cost of each item is 14.5 RO and the ordering cost is 0.4 RO. Storage cost is 14 % of an item cost. Find a-i) Economic order quantity. a-ii) Optimum cost. b) In the above problem if the supplier is offering a discount of 12 % of the item cost, the storage cost will increase to 15 %. then, Find: b-i) Economic order quantity; ( b-ii) Optimum cost. (
We have demand for a product with 1500 units/month. The vendor offers quantity discounted method for purchasing as the table below: Order Quantity condition 1 - 299 price( USD) 10 >= 300 price 7 Ordering lead-time is 3 days. Ordering cost 10 $/ order, salary for ordering staff is 3$/ order. Monthly Warcehouse renting free is 5%, and interest rate is 7%. Salary for warehousing staff is 300$/ month. Please suggest the best ordering policy.
B). As an inventory manager, you must decide on the order quantity for an item. Its annual demand is 679 units. Ordering costs are $7 each time an order is placed, and the holding cost is 10% of the unit cost. Your supplier provided the following price schedule. Quantity Price per Unit 1 - 100 $5.65 101 - 350 $4.95 351 or more $4.55 What ordering-quantity policy do you recommend?
(a) Ignoring taxation, calculate the optimum order level of inventory over a one-year planning period using the EOQ model. (b) Estimate the level of safety inventory that should be carried by Toyzrfun Ltd. (c) If Toyzrfun Ltd were to be offered a quantity discount by its suppliers of 1% for orders of 30 000 units or more, evaluate whether it would be beneficial for the company to take advantage of the quantity discount. Assume for this calculation that no safety inventory is carried. (d) Estimate the expected total annual costs of inventory management if the EOQ had been (i) 50% higher, and (ii) 50% lower than its actual level. Comment upon the sensitivity of total annual costs to changes in the EOQ.
We have demand for a product with 1500 units/ month. The vendor offers. quantity discounted method for purchasing as the table below: Order Quantity condition Price (USD) 1+299 10 >300 7 Ordering lead-time is 3 days. Ordering cost 10 $/ order, salary for ordering staff is 3S/ order. Monthly Warehouse renting free is 5%, and interest rate is 7%. Salary for warehousing staff is 300$/month. Please suggest the best ordering policy. I
Your supplier gives you a quantity discount if you buy at least 500 units at a time, a price of $4.90. Your ordering cost is $30, and the interest rate is 22% of the unit cost. Annual demand is 2,000, so the EOQ is 334. Calculate the total costs (consisting of holding, ordering, and cost of goods), assuming that you buy at least enough to get the quantity discount.
The purchasing agent for a company that assembles and sells air-conditioning equipment in a Latin American country noted that the cost of compressors has increased significantly each time they have been reordered. The company uses an EOQ model to determine order size. What are the implications of this price escalation with respect to order size? What factors other than price must be taken into consideration?
2. Gursoy Mobile Homes has an annual demand of 10,000 units for a small refrigerator. The supplier sells the units for $100 in order quantities below 124 and for $95 in order quantities above 125 units. The order cost is $5, and the annual holding cost is 10% of unit value. a) In what quantities should the item be purchased with an all-units quantity discount? b) If an incremental quantity discount schedule is in effect, how many refrigerators should Gursoy order each time an order is placed? c) Compare the cost savings for parts a) and b) with respect to the original case without discount. Which schedule is better?
I am planning a Holiday Ornament to commemorate the christmas spirit. Forcasted demand for ornaments is normally distributed with a mean of 40,000 with a standard deviation of 15,000 units. The cost per ornament is $3 and are sold to people around the world for $10 each. All unsold ornaments are donated after the holidays without any text deductions for me. How many ornaments should I tell my supplier to produce? What's my expected profit? If the manufacturer were to discount the price to me to $2.75 if I ordered at least 80,000 units should I do it? Justify the answer with profit estimates. please use excel
A cable company needs to stock universal remote devices. They expect annual demand to be 1000 and ordering cost is $50. The annual holding cost is 25% of the unit price per unit. In addition, supplier has provided below price schedule. How much quantity would you order to minimize the cost? Show calculations to justify your answer. Quantity Unit Price 1-200 $15.00 201 - 399 $14.00
The purchasing agent for a company that assembles and sells air-conditioning eqpt in US has noted that the cost of compressors has increased significantly each time they have reordered. The company uses EOQ model to determine order size. What are the implications of this price escalation with respect to order size? What factors other than price must be taken into consideration?