Because of a backlog of orders for model A grates, Kane's manager had decided to produce at least 150 of these grates a day. Operating under this additional constraint, how many grates of each model should Kane produce to maximize profit? (x,y)= What is the optimal profit?

Because of a backlog of orders for model A grates, Kane's manager had decided to produce at least 150 of these grates a day. Operating under this additional constraint, how many grates of each model should Kane produce to maximize profit? (x,y)= What is the optimal profit?

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

The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
4) The making of rivet holes in structural steel members can be done by 2 methods. The first method consists of laying out the position of the holes in the members and using a drill press costing P100k. The machinist is paid P60 per hour and he can drill 80 holes per hour. The second method makes use of a multiple-punch machine costing P80k. The punch operator is paid P40 an hour and he can punch out 1 hole for 3 seconds. This method also requires an expense of P1.25 per hole to set the machine. (a) if all other costs are assumed equal, what is the total cost for each machine for 10k holes, assuming the total cost of each machine to be charged to these holes? (b) for how many holes will the costs be equal?
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…
fi Auto mobile company manufactures cars and trucks. Each vehicle must be processed in the paint shop and body assembly shop. If the paint shop were only painting trucks, then 80 per day could be painted. If the paint shop were only painting cars, then 120 per day could be painted. If the body shop were only producing cars, then it could process 100 per day. If the body shop were only producing trucks, then it could process 100 per day. Each truck contributes GHS60,000 to profit, and each car contributes GHS40,000 to profit. Use linear programming to determine a daily production schedule that will maximize the company’s profits.
There is an upstream Picking department that feeds two downstream Packing departments: Pack Singles and Pack Multis. Those Packing departments feed to a Shipping department that loads the outgoing trucks. 40% of your Pick volume goes to Pack Singles and has a packing rate of 104 units per labor hour (uph). 60% of the Pick volume goes to Pack Multis and has a pack rate of 215 units per labor hour. Your pickers pick both Single and Multi items throughout the day at an overall average rate of 114 units per labor hour. All units that are packed in both processes go through the Ship process at a rate of 570 units per hour. You have 102 people today for all 4 departments and you absolutely must pack 47,880 units in Pack Multis Items to meet a customer promise metric. How do you allocate labor to balance the flow in your department if you work a 10 hour shift? Do not assume breaks or lunches in your answer. Redirect 1: You now need to process all of the Pack Singles Volume in the first 5…
Three methods can be used for producing heat sensors for high-temperature furnaces. Method A will have a fixed cost of $140,000 per year and a production cost of $62 per part. Method B will have a fixed cost of $210,000 per year and a production cost of $28 per part. Method C will require the purchase of equipment costing $500,000. It will have a life of five years and a 25% of first cost salvage value. The production cost will be $53 per part. At an interest rate of 10% per year, determine the breakeven annual production rate between the two lowest cost methods.
. A group of students organizes a bake sale in which they sell hundreds of cookies at $1per piece. They set up a table on campus and wait for students to come and purchasetheir cookies. Consider the following variables in this bake sale operation:1. Size of the cookies2. Weather conditions on campus3. Organization of the table4. Number of cookies sold5. Competition from other fund-raisers coinciding on campus6. Amount of advertising and shouting of the students at the bake sale table7. Number of students on campus that dayWhich of these variables is an output variable?a. 3b. 4c. 5d. None of the above
A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
During an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing operation. The default operation time is 15 minutes. As the operators of machine are inexperienced, the actual time they take to perform the operation is 20 minutes, and, on average, a fifth of the parts that start to be manufactured are lost. Assuming that each one of the machines used in this operation will not be available for one hour in each shift, determine the number of machines needed.
A 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.