Item 2 LP PROBLEM:Ozark Farms uses at least 800 lb. of special feed daily. The special feed is a mixture of corns and soybean meal with the following composition:per Ib. of feedstuffFeedstuffProteinFiberCost ($/lb.)Corn0.090.020.30Soybean meal0.600.060.90The dietary requirements of the special feed are at least 30% protein and at most 5% fiber. Ozark Farms wishes to determine the daily minimum-cost feed mix1. Enter all the data from the problem into cells.1. Data for corn, soybean meal and dietary requirements go in the G, H and I column respectively.2. Data for protein go in G3 though 133. G4 through 14 are reserved for data about fiber.4. The cost of corn per pound appears in cell G5 while the cost of soybean meal per pound appears in cell H5.5. Merge the cell G7 and H7 (it contains the minimum daily special feed)2. Set up the optimization model.1. The cells G10 through H10 are reserved for values of the variables.2. G12 contains a formula. It is the formula for the value of the objective function.3. G15 through 115 contain the constraint for daily special feed4. G16 through 116 contain the constraint for protein5. G17 through 117 contain the constraint for fiber

Answered: LP PROBLEM: Ozark Farms uses at least…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

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.
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Always Rain Irrigation, Inc., would like to determine capacity requirements for the next four years to make three types of bronze sprinklers: 90-degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next 4 years as follows: Yearly Demand in 000's: Year 1, Year 2, Year 3, Year 4: Bronze 90: 7, 8, 9, 10 Bronze 190: 3, 4, 5, 6 Bronze 360: 11, 12, 15, 18 The machines needed for the bronze sprinklers require two operators, and can produce up to 12,000 sprinklers. Three bronze machines and only one injection molding machine are available. What are the capacity requirements for the next four years, assume that there is no learning? Capacity: Year 1, Year 2, Year 3, Year 4: Demand for bronze sprinklers: Percentage of capacity used: Machine requirements: Labor requirements:
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $11 $12 $13 2 $9 $10 $9 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 500 900 700 If the Edwards production plan for the next period includes 900 units of component 1 and 700 units of component 2, what purchases do you recommend? That is, how many units of each…
fter spending $300,000 for research and development, chemists at Diversified Citrus Industries have developed a new breakfast drink. The drink, called Zap, will provide the consumer with twice the amount of vitamin C currently available in breakfast drinks. Zap will be packaged in an 8-ounce can and will be introduced to the breakfast drink market, which is estimated to be equivalent to 21 million 8-ounce cans nationally. One major management concern is the lack of funds available for marketing. Accordingly, management has decided to use newspapers (rather than television) to promote Zap in the introductory year and distribute Zap in major metropolitan areas that account for 65 percent of U.S. breakfast drink volume. Newspaper advertising will carry a coupon that will entitle the consumer to receive $0.20 off the price of the first can purchased. The retailer will receive the regular margin and be reimbursed for redeemed coupons by Diversified Citrus Industries. Past experience…
PROBLEM 3 Magasin Publishing Company publishes two types of magazines on a monthly basis: a restaurant and entertainment guide and a real estate guide. The company distributes the magazines free to businesses, hotels, and stores on Zamboanga City. The company’s profits come exclusively from the paid advertising in the magazines. Each of the restaurant and entertainment guides distributed generates P50 per magazine in advertising revenue, whereas the real estate guide generates P75 per magazine. The real estate magazine is a more sophisticated publication that includes color photos, and accordingly it costs P25 per magazine to print, compared with only P17 for the restaurant and entertainment guide. The publishing company has a printing budget of P400,000 per month. There is enough rack space to distribute at most 18,000 magazines each month. In order to entice businesses to place advertisements, Magasin Publishing promises to distribute at least 8,000 copies of each…
Ana Chavarria, front office manager at The Times Hotel, has completed a yield management seminar at Keystone University and is preparing an argument to adopt this concept at The Times Hotel to present to Margaret Chu, general manager. She begins by com- piling a history of room occupancy and ADRs, which she hopes will reveal areas in which yield management could help. She prepares an electronic spreadsheet that lists rooms sold with corresponding room rates and correlates the data to tourism activities in the area. Ana sends an analysis of revenue realized and revenue potential to Ms. Chu for review prior to their discussion. After reviewing the analysis, Ms. Chu concludes, “This is just another scam; the industry is slow to adopt this,” and disregards the entire report. She knows that occupancy percentage, ADR, and RevPAR are all that you need to be efficient today, so why change? Ana passes Ms. Chu in the lobby, and Ms. Chu indicates her distrust of the yield management concept but…
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 What is the optimal objective function value for this problem?
Carson Trucking is considering whether to expand its regional service center in Mohab, UT. The expansion requires the expenditure of $10,000,000 on new service equipment and would generate annual net cash inflows from reduced costs of operations equal to $2,500,000 per year for each of the next 8 years. In year 8 the firm will also get back a cash flow equal to the salvage value of the equipment, which is valued at $1 million. Thus, in year 8 the investment cash inflow totals $3, 500, 000. Calculate the project's NPV using a discount rate of 9 percent.
CASE BACKGROUND The MGMT Insurance Ltd. accepts payments on various insurance policies from employees of businesses across the island. These businesses deduct payments from employees' salaries and pay the insurance company a lump sum each month. This total amount deducted is shown on each employee's payslip. Deductions are due at the end of each month and each participating business submits one payment for its employees to the insurance company via online payments through the bank. However, if payments were received after 11:00 a.m., the bank does not process them until the next business day. At the beginning of each month an administrative assistant at MGMT Insurance Ltd. downloads the deductions for each company and allocates payments to the various policies. These payments include the client's unique number along with his/her relevant policy numbers and amounts due. However, recently there has been some complaints that payments for some policies were not being allocated correctly.…
CASE BACKGROUND The MGMT Insurance Ltd. accepts payments on various insurance policies from employees of businesses across the island. These businesses deduct payments from employees’ salaries and pay the insurance company a lump sum each month. This total amount deducted is shown on each employee’s payslip. Deductions are due at the end of each month and each participating business submits one payment for its employees to the insurance company via online payments through the bank. However, if payments were received after 11:00 a.m., the bank does not process them until the next business day. At the beginning of each month an administrative assistant at MGMT Insurance Ltd. downloads the deductions for each company and allocates payments to the various policies. These payments include the client’s unique number along with his/her relevant policy numbers and amounts due. However, recently there has been some complaints that payments for some policies were not being allocated correctly.…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS