M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 700 units per month.The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in thetable. Ordering cost is $45, and annual holding cost per unit is $4.Allen Mfg.Quantity1-499500-9991000+Baker Mfg.Unit Price$16.0015.5015.00Quantity1-399400-799800+Unit Price$16.1015.6015.10a) What is the economic order quantity if price is not a consideration? 435 units (round your response to the nearestwhole number).b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg.c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component?(round your responses to the nearest whole number).The optimal order quantity is ☐ with a total cost of $

a) Economic Order Quantity (EOQ) without regard to price:The formula for the EOQ is:EOQ = sqrt((2 *…

Answered: M. P. VanOyen Manufacturing has gone…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
HAL Ltd. produces a line of high-capacity disk drivers for mainframe computers. It canproduce the disk drive housings at the rate of 150 housings per month. The housing cost85$ each to produce and the setup cost for beginning of a production run is 700$. Assumethe annual interest rate of 28% for determining the holding cost and the demand is 720units per year.a) What is the optimal number of housing for HAL Ltd. to produce in each productionrun?b) Find the time between initiation of production runs, the time devoted to productionand the downtime each production cycle.c) Calculate the maximum level of inventory in the warehouse in this case.
A manufacturing firm has gone out on bid to procure a component. Expected demand is 700 units per month. The item can be purchased from either Vendor A or Vendor B. Their price lists are shown in the table. Ordering cost is $50, and annual holding cost per unit is 30% of the item’s value. Vendor A Vendor B Quantity Unit Price Quantity Unit Price 1-499 $16.00 1-399 $16.10 500-999 15.50 400-799 15.60 1000+ 15.00 800+ 15.10 Calculate the economic order quantity. From which vendor is the optimal order quantity and what is the total annual inventory cost?
Letherin Hides is a company that makes boots specifically targeting college students. Forecasts of sales for the next year are 200 in the summer, 450 in the fall, and 500 in the winter. Accessories that are used on the boots are purchased from a supplier for $31.66. The cost of capital is estimated to be 24% per year (or 6% per quarter); thus, the holding cost per item is 0.06(31.66)=$1.9 per quarter (rounded figure). Letherin Hides hires freelance art designers at part-time to craft designs during the summer, and they earn $6.00 per hour. In the fall, labor is more difficult to keep, and the owner must pay $6.50 per hour to retain qualified help. Because of the high demand for part-time help during the winter holiday season, labor rates are higher in the winter, and workers earn $7.75 per hour. Each boot design takes 2 hours to complete. How should production be planned over the three quarters to minimize the combined production and inventory holding costs? The table below provides…
M. P. VanOyen Manufacturing has gone out on bid fora regulator component. Expected demand is 700 units per month.The item can be purchased from either Allen Manufacturing orBaker Manufacturing. Their price lists are shown in the table.Ordering cost is $50, and annual holding cost per unit is $5.ALLEN MFG. BAKER MFG.QUANTITY UNIT PRICE QUANTITY UNIT PRICE1–499 $16.00 1–399 $16.10500–999 15.50 400–799 15.601,0001 15.00 8001 15.10a) What is the economic order quantity?b) Which supplier should be used? Why?c) What is the optimal order quantity and total annual cost ofordering, purchasing, and holding the component? PX
Dorothy’s pastries are freshly baked and sold at several spe-cialty shops throughout Perth. When they are a day old, theymust be sold at reduced prices. Daily demand is distributedas follows:Demand Probability50 0.25150 0.50200 0.25Each pastry sells for $1.00 and costs $0.60 to make. Each onenot sold at the end of the day can be sold the next day for$0.30 as day-old merchandise. How many pastries should bebaked each day?
Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, “That’s life.” On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolatecovered shrimp in some boxes so that “You never know what you’ll get.” Quarterly demand (in boxes of chocolates) for the last 3 years follows: Quarter Year 1 Year 2 Year 3 1 2 3 4 3,000 1,700 900 4,400 3,300 2,100 1,500 5,100 3,502 2,448 1,768 5,882 Total 10,000 12,000 13,600 a. Use intuition and judgment to estimate quarterly demand for the fourth year.b. If the expected sales for chocolates are 14,800 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. Are any of the quarterly forecasts different from what you thought you would get in part (a)?
A supermarket in Seattle must decide how many wedding cakes to prepare for the upcomingweekend. Cakes cost $33 each to make, and they sell for $60 each. At the very last hour of theday, any unsold boxes are reduced to “half-price”. Holding cost is negligible. Analysis of recentdemand resulted in the following table: Demand Probability 0 .15 1 .35 2 .30 3 .20 How many cakes should be prepared to maximize expected profit?
A company will begin stocking remote control devices. Expected monthly demand is 800 units. Thecontrollers can be purchased from either supplier A or supplier B. Their price lists are as follows:SUPPLIER A SUPPLIER BQuantity Unit Price Quantity Unit Price1–199 $14.00 1–149 $14.10200–499 13.80 150–349 13.90500 + 13.60 350 + 13.70 Ordering cost is $40 and annual holding cost is 25 percent of unit price per unit. Whichsupplier should be used and what order quantity is optimal if the intent is to minimize totalannual costs?
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 catering manager of La Vista Hotel, LisaFerguson, is disturbed by the amount of silverware she is losing every week. Last Friday night, when her crew tried to set up for a banquet for 500 people, they did not have enoughknives. She decides she needs to order some more silverware,but wants to take advantage of any quantity discounts hervendor will offer.For a small order (2,000 or fewer pieces), her vendorquotes a price of $1.80Ypiece.If she orders 2,001–5,000 pieces, the price drops to$1.60Ypiece. 5,001–10,000 pieces brings the price to$1.40Ypiece, and 10,001 and above reduces the price to $1.25.Lisa’s order costs are $200 per order, her annual holdingcosts are 5%, and the annual demand is 45,000 pieces. For thebest option:a) What is the optimal order quantity?b) What is the annual holding cost?c) What is the annual ordering (setup) cost?d) What are the annual costs of the silverware itself with anoptimal order quantity?e) What is the total annual cost, including ordering,…
XYZ company is determining the inventory policy for product A which has annual demand distributed as Normal (500, 120). The value of each item is $25. The fixed ordering cost per order is $200. The lead time from supplier of an order is stochastic with mean 4 weeks and standard deviation 2 weeks. The company calculates the holding cost by using an interest rate of 25%. a) Determine the (Q, R) values if the company desires to use a Type 1 service level of 98%. b) Determine the (Q, R) values if the company desires to use a Type 2 service level of 95%. c) Determine the (Q, R) values if the company desires to use a shortage cost of $6.74 per unit of unsatisfied demand.

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