Answered: Determine optimalproduct mix for…

Determine optimalproduct mix for masximizing profit for the problems that show in the table below: Types of product Capacity in min Source A B C F1 2 3 1 20 F2 4 8 15 F3 6 30 Demand is $ 20 30 25

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.
ABC Inc. must make a decision on its current capacity for next year. Estimated profits (in $000s) based on next year's demand are shown in the table below. Next Year's DemandAlternative Low HighExpand $100 $200Subcontract $50 $120Do nothing $40 $50 Using the information above, which alternative should be chosen based on the maximin criterion?
Please answer this using EXEL AND SOLVER ADD IN. Include and identify decision variables, objective, and constraints. Please also upload what the info in solver you added was!!!! It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February and 9000 coats in March. You want to manufacture these coats at the lowest cost possible during your production window (October-March). The first decision you need to make is how many people to hire. Each employee will cost $2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a…
Asilekpe Company Limited is considering constructing a borehole in the village of Adukofe. The construction would cost Gh₵2 million and there will be no cost of maintenance. The following table shows the company’s anticipated demand over the lifetime of the bridge: Price per gallon (Gh₵) Number of gallons 8 0 7 100000 6 200000 5 300000 4 400000 3 500000 2 600000 1 700000 0 800000 a. If the company were to construct the borehole what would be its profit-maximizing price? Would that be the efficient level of output? Explain your answer.b. If the company is interested in maximizing profit, should it construct the borehole? What would be its profit or loss?c. If the government were to construct the borehole, what price should it charge? d. Should the government construct the borehole? Explain.
Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file. An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage investment he will consider are shown on the following table. He wants at least 35% of his investments to be in nonmortgage instruments and no more than 60% to be in high-yield (and high-risk) instruments (i.e., expected interest > 8%). How should his investment be diversified to make the most interest income? Investment Expected Return Maximum Allowed Low-income mortgage loans 6.50% 20% Conventional mortgage loans 6.00% 30% Government sponsored mortgage loans 8.25% 25% Bond investments 5.75% 15% Stock investments 8.75% 18% Futures trading 9.25% 10%
Jean Clark is the manager of the Midtown Saveway-Grocery Store. She now needs to replenish hersupply of strawberries. Her regular supplier can provide as many cases as she wants. However,because these strawberries already are very ripe, she will need to sell them tomorrow and thendiscard any that remain unsold. Jean estimates that she will be able to sell 12, 13, 14, or 15 casestomorrow. She can purchase the strawberries for $7 per case and sell them for $18 per case. Jeannow needs to decide how many cases to purchase. Jean has checked the store’s records on dailysales of strawberries. On this basis, she estimates that the prior probabilities are 0.1, 0.3, 0.4, and 0.2for being able to sell 12, 13, 14, and 15 cases of strawberries tomorrow. a. Develop a decision analysis formulation of this problem by identifying the decisionalternatives, the states of nature, and the payoff table. b. How many cases of strawberries should Jean purchase if she uses the maximin payoffcriterion? c. How…
46. Ford is going to produce a new vehicle, the Pioneer,and wants to determine the amount of annual capacityit should build. Ford’s goal is to maximize the profitfrom this vehicle over the next five years. Each vehicle will sell for $19,000 and incur a variable production cost of $16,000. Building one unit of annual capacity will cost $2000. Each unit of capacity will alsocost $1000 per year to maintain, even if the capacityis unused. Demand for the Pioneer is unknown butmarketing estimates the distribution of annual demandto be as shown in the file P09_46.xlsx. Assume thatthe number of units sold during a year is the minimumof capacity and annual demand. Which capacity levelshould Ford choose? Do you think EMV is the appropriate criterion?
Mary is a sales person for Challenge Furniture. She receives an incremental commission based on the table below. If she sells $26,000 and has already received a draw of $766.15, how much commission is still owed to Mary? level 1 1-11,700 3.7% sales volume 2 11,701-21,200 4.3% commission rate 3 over 21,200 4.7%
Note :write the equations seperately A firm is making two products A & B. Each unit of A incurs a cost of production to the tune of $150 and that of B incurs a cost of $200. Product A carns a profit of $15/unit and B gets $20/unit. The estimated monthly demand of both A & B is at maximum 500 units. Monthly production budget is set at $50.000.How many units of A & B should the firm make in order to maximize profit. Conduct sensitivity analysis and answer the following questions: 1. State the optimal solution. 2. What is the objective function value? 3. Find out the range of profit for A in the objective function for which the above solution remains optimal.
#28Even though independent gasoline stations have been having a difficult time, Susan Solomon hasbeen thinking about starting her own independent gasoline station. Susan’s problem is to decide howlarge her station should be. The annual returns will depend on both the size of her station and a numberof marketing factors related to the oil industry and demand for gasoline. After a careful analysis, Susandeveloped the following table: GOOD FAIR POORSIZE OF MARKET MARKET MARKETFIRST STATION ($) ($) ($)Small 50,000 20,000 –10,000Medium 80,000 30,000 –20,000Large 100,000 30,000 –40,000Very large 300,000 25,000 –160,000For example, if Susan constructs a…
The owners of Sweet-Tooth Bakery have determined thatthey need to expand their facility in order to meet their increaseddemand for baked goods. Th e decision is whether to expand nowwith a large facility or expand small with the possibility of havingto expand again in fi ve years.Th e owners have estimated the following chances for demand:• Th e likelihood of demand being high is 0.70.• Th e likelihood of demand being low is 0.30.Profi ts for each alternative have been estimated as follows:• Large expansion has an estimated profi tability of either$80,000 or $50,000, depending on whether demand turnsout to be high or low.• Small expansion has a profi tability of $40,000, assumingdemand is low.• Small expansion with an occurrence of high demand wouldrequire considering whether to expand further. If the bakeryexpands at this point, the profi tability is to be $50,000.(a) Draw a decision tree showing the decisions, chanceevents, and their probabilities, as well as the profi tabilityof…
Campbell’s Wholesale Company is preparing monthly cash budgets for the fourth quarter of theyear. Monthly sales revenue in this quarter is estimated as follows: October, $30,000; November,$24,000; and December, $20,000. All sales are made on open credit with 70% collected in themonth of sale and 30% collected in the following month. What is the estimated total cash collectedin November? December?