A firm offers three different prices on its products, depending upon the quantity purchased. Since available resources are limited, the firmwould like to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $16 each for the first 20units, $15 each for units 21-120, and $14 for each unit over 120. Product 2's profitability is $16 each for the first 40 units, $15 each for units41-70, and $14 each for each unit over 70. The products each require 3 raw materials to produce (see table below for usages andavailable quantities).Product 1 usage(pounds per unit)5Raw MaterialProduct 2 usage(pounds per unit)4Available Quantity(pounds)A1,8001,000B8127C121,800Use separable programming to find the optimal production plan.(Leave no cells blank - be certain to enter "0" wherever required. Round the first two answers (units of Product 1 and 2) to thenearest whole number. Round the total profit answer to 2 decimal places and use unrounded unit quantities to compute it.)units of Product 1 andunits of Product 2.The total profit from this plan will be

Objective Functions and Constraints: Based on the given details, the objective…

Answered: A firm offers three different prices on…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

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.
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.
The Gorman Manufacturing Company must decide whether to manufacture a component part at its plant or purchase the component part from a supplier. The resulting profit is dependent upon the demand for the product. The following payoff table shows the projected profit (in ten thousand of pesos): state of nature state of nature state of nature Decision Alternative Low Demand S1 Medium DEmand S2 High demand S3 Manufacture, d1 -100 200 500 Purchase, d2 50 225 350 The state-of-nature probabilities are P(s1 ) = 0.35, P(s2 ) = 0.35, and P(s3) = 0.30. a. Use a decision tree to recommend a decision b. Use EVPI to determine whether XY Manufacturing Company should attempt to obtain a better estimate of demand. c. What is the probability that the market research report will be favorable? A test market study of the potential demand for the product is expected to report either a favorable (F) or unfavorable (U) condition. The relevant conditional probabilities are as follows: P…
Wheels Distributors sells three types of tires to the commercial market. Type A. Type B and Type C. The anticipated payoffs are as follows for the three types of tires. Light Demand Moderate Demand Heavy Demand Probability 0.25 0.45 0.3 Tire Type A $325,000 $190,000 $170,000 B $300,000 $420,000 $400,000 C -$400,000 $240,000 $800,000 Construct a decision tree to help the management of Wheel Distributor make the appropriate decisions. This tree MUST be constructed in logical order with labels and net payoffs. Given the probabilities for the three types of tires and the expected monetary values, what decision should be made and what is that optimal expected value? What is the most should the firm be willing to pay to obtain further (perfect) information (EVPI) concerning the demand for the tires? 4. What decision should the firm…
Find the cost minimizing amount of K for a producer to use when faced with the following production function, production goal, wage, and rent: q = L2K3; q = 243; w = $20; r = $30
A company is operating in two unrelated businesses. The first one is making common salt, which is sold in one kilogram consumer packs. The second business is making readymade garments. The owner of the businesses has decided to implement Materials Requirement Planning (MRP) in one of the two businesses, which is likely to give him greater benefit. Assuming that the current turnover and profits of both the units are comparable, compare the relative benefits and limitations of Materials Requirement Planning (MRP) for these two businesses.
Lake Stevens Marina has estimated that fixed costs per month are $350,000 and variable cost per dollar of sales is $0.30 . The selling price per dollar of sales is: $1.00 Determine the effect on the break-even point in sales dollars considering each of the following independently. 1. Total fixed costs increase to $365,000. Break-even point = ÷ = 2. Variable costs decline to $0.25 per sales dollar. Break-even point = ÷ = 3. The anticipated sales volume increases to $1,100,000. Break-even point = ÷ = Comment on the BEPs from the above analyses in questions 1,2,3.
XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes one hour to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
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 a 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/ 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 day to produce one coat. The employees can also be asked to work overtime, in which case you need to pay them $70 per coat they produce. You don’t need to assume there is any capacity constraint on the number of overtime…
Bimala is interested in buying a new house and has found a house she likes in Surry Hills. Bimala comes to you for advice about which of the following items would pass to her automatically if she buys the house: • A plastic bird bath which rest on the ground in the back garden; • A concrete swimming pool in the back garden; • A tapestry attached by small tapestry nails to the wall of the living room; and • A barbecue on wheels on the back deck. Advise Bimala. In your advice, please ensure that you refer to relevant case law. *NOTE: This is business law question. can you write more details about the question and answer.
You are asked to help your boss deciding who is considering whether to make or buy a part fora top most demanding product of the company.Your company can make the component for $40 per unit or buy it for $50 per unit from vendor.If the Company decides to make the component, it will require 4 hours of machine time tomake each part. The company has 2,000 hours of machine time available per month. Shouldthe company make or buy the component? How many max parts company can make?________________________________________________________________

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