Concept explainers
a)
To run: The solver after making the modifications and explain the results.
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
b)
To run: The solver after making the modifications and explain the results.
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
Trending nowThis is a popular solution!
Chapter 4 Solutions
Practical Management Science, Loose-leaf Version
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forwardAssume 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.arrow_forwardIn an oil company, its south refinery produces per day 300 barrels of high grade oil, 200 barrels of medium grade oil and 150 barrels of low grade oil. The cost of operation of this refinery amounts to P 600,000 per day. The north refinery of the company produces each day 100 barrels of high grade oil and 100 barrels of medium-grade oil and 150 of low-grade oil. Which has a total of P500,000 operational costs. If the company’s production requirement is at least 900 barrels for high-grade oil, 800 barrels for medium-grade oil, and 750 for low-grade oil, how many days, are required for each refinery to operate to obtain the minimum cost?arrow_forward
- Shale Oil, located in the middle east, has a capacity of 1,500,000 bbl of crude oil per day. The final products fromthe refinery include three types of unleaded gasoline with different octane numbers (ON): regular with ON = 87,premium with ON = 89, and super with ON = 92. The refining process encompasses three stages: (1) a distillationtower that produces feedstock (ON = 82) at the rate of 0.2 bbl per bbl of crude oil, (2) a cracker unit that producesgasoline stock (ON = 98) by using a portion of the feedstock produced from the distillation tower at the rate of 0.5bbl per bbl of feedstock, and (3) a blender unit that blends the gasoline stock from the cracker unit and the feedstockfrom the distillation tower. The company estimates the net profit per barrel of the three types of gasoline to be $6.70,$7.20, and $8.10, respectively. The input capacity of the cracker unit is 200,000 bbl of feedstock a day. The demandlimits for regular, premium, and super gasoline are 50,000, 30,000, and…arrow_forwardA company owns a 5-year-old turret lathe that has a book value of $23,000. The present market value for the lathe is $18,000. The expected decline in market value is $1,700/year to a minimum market value of $4,080; maintenance plus operating costs for the lathe equal $4,470/year.A new turret lathe can be purchased for $46,000 and will have an expected life of 8 years. The market value for the turret lathe is expected to equal $46,000(0.70)k at the end of year k. Annual maintenance and operating cost is expected to equal $1,900. Based on a 12% MARR, should the old lathe be replaced now? Use an equivalent uniform annual cost comparison, a planning horizon of 7 years, and the cash flow approach.EUAC for keeping old turret lathe: $EUAC for replacing turret lathe: $arrow_forwardA company has one machine which can be used to make product Alpha and product Beta. Each unit of product Alpha requires 45 minutes of machine time, while each unit of product Beta requires 37 minutes of machine time. The machine can be used for 8 hours per day and 5 days per week. Next week the company will produce 23 units of product Alpha. After completing the production of Alpha, the company will produce product Beta. How many units of product Beta can be produced next week? Use at least 4 decimals.You must showm your calculation steps and brief explanation on your Excel spreadsheets.arrow_forward
- A quarry uses five types of rocks to fulfill four orders. The gypsum content, availability of each type of rock, and the production cost per pound for each rock, as well as the size of each order and the minimum and maximum gypsum percentage in each order, are given below.Rock type-------Cost-------% gypsum-------Amount Available1-------------------$1.00-----------2.0%-----------5002-------------------$5.00-----------5.0%-----------6003-------------------$5.50-----------4.5%-----------7004-------------------$2.00-----------3.0%-----------4005-------------------$1.20-----------6.0%-----------450 Order No.--------------------1----------2----------3---------4Order Size------------------500------600------500------350Min % gypsum-----------3.5%-----3.8%-----4.0%-----3.6%Max % gypsum----------4.4%-----4.6%-----4.7%-----4.8%What is the cheapest way to fill the orders?arrow_forwarda. Which of the following best describes the meaning of the equation P(25) = 200? 1. When 200 calculators are sold, the profit is $25. II. When 200 calculators are sold, the profit is increasing at a rate of $25 per additional calculator III. When 25 calculators are sold, the profit is $200. IV. When 25 calculators are sold, the profit is increasing at a rate of $200 per additional calculatoarrow_forwardDecorum, Inc., manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summer months. Typically, sales average 400 units per month. However, in the hot summer months (June, July, and August), sales spike up to 600 units per month. Decorum can produce up to 500 units per month at a cost of $300 each. By bringing in temporary workers, Decorum can produce up to an additional 75 units at a cost of $350 each. Decorum sells the ceiling fans for $500 each. Decorum can carry inventory from one month to the next, but at a cost of $20 per ceiling fan per month. Decorum has 25 units in inventory at the start of January. Assuming Decorum must produce enough ceiling fans to meet demand, how many ceiling fans should Decorum produce each month (using their regular labor force and/or temporary workers) over the course of the next year so as to maximize their total profit? We have a total of type your answer...arrow_forward
- A Las Vegas, Nevada, manufacturer has the option to make or buy one of its component parts. The annual requirement is 20,000 units. A supplier is able to supply the parts for $10 per piece. The firm estimates that it costs $600 to prepare the contract with the supplier. To make the parts in-house, the firm must invest $50,000 in capital equipment, and the firm estimates that it costs $8 per piece to make the parts in-house. Assuming that cost is the only criterion, use breakeven analysis to determine whether the firm should make or buy the item. 1. What is the breakeven quantity? 2. Should the manufacturer Make or Buy? 3. What is the cost savings using your decision in number 2 (above)? Show the total cost for each scenario then the savings amount.arrow_forwardA retail store sold in the month of April 5,000 products that produced $45,000 in sales. In the month of May the company sold 6,000 products. The store workforce consists of four full-time workers who work 40-hour week. In April the store also had seven part-time workers at 10 hours per week, and in May the store had nine part-timers at 15 hours per week (assume four weeks in each month). Using sales dollars as the measure of output (assume the price of the product was the same for both months), what is the percentage change in labor productivity from April to May? Answer: 2.arrow_forwardSoftware EG, a retail company, orders two kinds of software from TeleHard Software. Annually, Software EG sells 800 units of product 1 and 400 units of product 2. The unit purchasing cost is $30 per unit of product 1 and $25 per unit of product 2. It costs $5 to store a unit of either product for a year. The cost of placing an order for either product separately or both products together is $100. Software EG’s annual cost of capital is 14%. Determine a costminimizing ordering policyarrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,