Problem 20-39 (Algo)CU, Incorporated (CUI), produces copper contacts that it uses in switches and relays. CUI needs to determine the order quantity, Q, tomeet the annual demand at the lowest cost. The price of copper depends on the quantity ordered. Here are price-break and otherdata for the problem:Price of copperAnnual demandHolding costOrdering cost$0.82 per pound up to 2,999 pounds0.81 per pound for orders between 3,000 and 5,999 pounds$0.79 per pound for orders 6,000 pounds or greater48,000 pounds per year30 percent per unit per year of the price of the copper30Which quantity should be ordered?Quantitypounds

Step 1:Therefore the quantity should be ordered is 6000 pounds.

Answered: Problem 20-39 (Algo) CU, Incorporated…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 14P

See similar textbooks

Similar questions

Problem 20-39 (Algo) CU, Incorporated (CUI), produces copper contacts that it uses in switches and relays. CUI needs to determine the order quantity, Q, to meet the annual demand at the lowest cost. The price of copper depends on the quantity ordered. Here are price-break and other data for the problem: Price of copper $ 0.84 per pound up to 2,499 pounds $ 0.83 per pound for orders between 2,500 and 4,999 pounds $ 0.81 per pound for orders 5,000 pounds or greater Annual demand 54,000 pounds per year Holding cost 25 percent per unit per year of the price of the copper Ordering cost $ 30 Which quantity should be ordered? Quantity_____________pounds
Exercise 2: The demand per year (D) for product X is 12,100 units. The costs of placing an order (S) are $4.50. The unit cost (C) of the item is $25.00. The maintenance cost (H) per unit per year is 30% of the item's cost. 1. Use the economic order quantity (EOQ) model to determine: *Optimal quantity to order* The expected number of orders*Optimal time between orders*The total annual cost of maintaining that optimal amountNOTE: Show calculations of how you arrived at each amount 2. Answer, what are the potential benefits of using EOQ analysis for inventory management? How can you help businesses strike a balance between inventory holding costs and ordering costs?
Problem 20-40 (Algo) In the past, Taylor Industries has used a fixed−time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs are forcing Taylor Industries to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such as shortage costs. Here is a random sample of 20 of Taylor's items. ITEMNUMBER ANNUALUSAGE ITEMNUMBER ANNUALUSAGE 1 $ 1,600 11 $ 13,200 2 12,200 12 700 3 2,300 13 42,400 4 50,500 14 10,100 5 11,600 15 1,300 6 900 16 10,400 7 2,100 17 4,100 8 11,200 18 61,600 9 5,200 19 3,600 10 15,200 20 3,000 a. Classify each item in inventory using an ABC plan.
The demand for a clothing brand is shown in the table below. The cost per order is about $4000. Cost of each unit of clothing = $5. Carrying cost percentage = 25% per item per 5 months. The analysis period = 5 month duration. Month Demand 1 400 2 300 3 200 4 400 5 500 a. Using this data, compute the solutions using the Lot for Lot and Periodic Order Quantity heuristics? Which of these heuristics would perform better and why? b. Assuming that the demand follows a normal distribution with the mean and variance from the data given above, determine the optimal order should be greater or lesser than the single period EOQ model.
The Olde Town Microbrewery makes Townside beer,which it bottles and sells in its adjoining restaurant and bythe case. It costs $1700 to set up, brew, and bottle a batchof the beer. The annual cost to store the beer in inventory is$1.25 per bottle. The annual demand for the beer is 21,000bottles and the brewery has the capacity to produce 30,000bottles annually.a. Determine the optimal order quantity, total annual inventory cost, the number of production runs per year, andthe maximum inventory level.b. If the microbrewery has only enough storage space tohold a maximum of 2500 bottles of beer in inventory,how will that affect total inventory costs?
A mail-order house uses 17,460 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity __________ boxes b. Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order _____________ per year
The store wants to determine the Economic Order Size (EOQ) and Total Inventory Cost for this brand of carpet given an estimated annual demand of 10,000 yards of carpet, an annual carrying cost of P 37.50 per yard, and an ordering cost of P 7,500.00. The store would also like to know the number of orders that will be made annually and the time between orders (i.e., the order cycle), given that the store is open every day except 52 Sundays, Philippine Independence Day, New Year, and Christmas Day (which are assumed to fall not on Sundays) A. Using the computed optimal order size or EOQ, determine the optimum Total Cost. C. Determine the Order Cycle Time
A mail-order house uses 16,870 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of BoxesPrice per Box1,000 to 1,999$1.25 2,000 to 4,9991.20 5,000 to 9,9991.15 10,000 or more1.10 a.Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity5000 boxes b.Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order per year
The maintenance department of a large hospital uses 816 cases of liquid cleaner annually. Ordering costs are $12, carrying costs are $4 per case per year, and the new price schedule indicates that orders of less than 50 cases will cost $20 per case, 50 to 79 cases will cost $18 per case, 80 to 99 cases will cost $17 per case, and larger orders will cost $16 per case. Determine the optimal order quantity and the total cost
2.)Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 If the owner of Birka Styles & Co is an optimist, how many lots should the manager order?
2.)Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 A)If the owner of Birka Styles & Co is an optimist, how many lots should the manager order? B)If the owner of Birka Styles & Co is a pessimist, how many lots should the manager order? C)The owner wants to use minimax regret. How many lots should the manager order?
The Soon Company is a multinational company that purchases one of its crucial components from a supplier who offers quantity discounts to encourage larger order quantities. The supply chain manager of the company wants to determine the optimal order quantity to minimize the total annual inventory cost. The company’s annual demand forecast for the item is 850 units, the order cost is $10 per order, and the annual holding rate is 41 percent. The price schedule for the item is: Order Quantity Price per Unit ($) 1–150 6.00 151–350 5.50 351 and above 5.00 The first break point is 151 units and the second is 351 units. The spreadsheet is below and perform the required analysis Optimal Order Quantity with Quantity Discounts Annual Demand Forecast 850 Order cost per order $10.00 Annual holding rate 41% Order Quantity Price per unit 1 150 $6.00 151 350 $5.50 351 1.00E+99 $5.00 Feasible? EOQ at the highest…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS