Feedco produces two types of cattle feed, bothconsisting totally of wheat and alfalfa. Feed 1 must containat least 80% wheat, and feed 2 must contain at least 60%alfalfa. Feed 1 sells for $1.50/lb, and feed 2 sells for $1.30/lb.Feedco can purchase up to 1,000 lb of wheat at 50¢/lb andup to 800 lb of alfalfa at 40¢/lb. Demand for each type offeed is unlimited. Formulate an LP to maximize Feedco’sprofit.

Feedco produces two types of cattle feed, bothconsisting totally of wheat and alfalfa. Feed 1 must containat least 80% wheat, and feed 2 must contain at least 60%alfalfa. Feed 1 sells for $1.50/lb, and feed 2 sells for $1.30/lb.Feedco can purchase up to 1,000 lb of wheat at 50¢/lb andup to 800 lb of alfalfa at 40¢/lb. Demand for each type offeed is unlimited. Formulate an LP to maximize Feedco’sprofit.

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.
A manufacturer has a production facility that requires 10,237 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 6 days. The unit purchase cost is $31.4 per unit. The cost to place and process an order from the supplier is $168 per order. The unit inventory carrying cost per year is 12.2 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 1,053 units per order, what is the annual holding cost? Use at least 4 decimal places.
The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…
An automotive warehouse stocks a variety of parts that are sold at neighborhoodstores. One particular part, a popular brand of oil filter, is purchased by thewarehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based on warehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based ona 28 percent annual interest rate.The monthly demand for the filter follows a normal distribution with mean280 and standard deviation 77. Order lead time is assumed to be five months.Assume that if a filter is demanded when the warehouse is out of stock, then thedemand is back-ordered, and the cost assessed for each back-ordered demand is$12.80. Determine the following quantities:a. The optimal values of the order quantity and the reorder level.b. The average annual cost of holding, setup, and stock-out associated…
Jays Office Supplies sells Printers, which it orders from Brands mart Inc in . Because of shipping and handling costs, each order must be for 5 printers. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 Printers. It costs $50 to place an order. It costs the company $500 in lost sales when a customer asks for a Printer and the warehouse is out of stock. It costs $100 to keep each Printer stored in the warehouse. If a customer cannot purchase a Printer when it is requested, the customer will not wait until one comes in but will go to a competitor. The following probability distribution for demand for Printer has been determined: Questions 1.Simulate CWD 's ordering and sales policy for 20 weeks 2. Compute the average cost of the policy PLEASE NOTE I SENT THIS IN ALREADY BUT I REALIZED I LEFT OUT SOME VITAL INFORMATION AND AGAIN THIS IS NOT FROM ANOTHER SITE.
Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.
A hospital expects 5,000 admissions for the year, but that number could vary by 1,000 more or less. Its fee-for-service is $4,000 under the current prospective payment system. Under a capitation reimbursement system, the hospital must cover 5,000 patients at a capitation payment of $4,000. The hospital's variable costs are $1,250 per admission and its fixed costs are $13,750,000. Which of the following is most true? The hospital's operating leverage is relatively low, so the capitation reimbursement method is riskier than the prospective payment method. The hospital's operating leverage is relatively high, so the capitation reimbursement method is riskier than the prospective payment method. The hospital's operating leverage is relatively high, so the prospective payment reimbursement method is riskier than the capitation method. The hospital's operating leverage is relatively low, so the prospective payment reimbursement method is riskier than the capitation method.
2.28 A foundry produces castings to order. An order for 20 special castings has been re- ceived. Since the casting process is highly variable, not all castings produced are good. The cost of producing each casting is $550; the additional cost of finishing a good casting is $125. If a casting is not good, it is recycled at a value of $75; excess good castings are not finished but are recycled at a value of $75. The customer has agreed to accept 15, 16, 17, 18, 19, or 20 castings at a price of $1250 each. If fewer than 15 good castings are produced, none will be purchased by the customer. Prob- ability distributions for the number of good castings produced in a batch of varying sizes are given below. How many castings should be scheduled in order to maximize expected profit? #Good Castings 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 79 2 PRODUCT, PROCESS, AND SCHEDULE DESIGN Number of Castings Scheduled 15 16 17 0.05 0.00 0.00 0.00 0.00 0.00 0.05 0.05 0.00…
Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25
A brewery produces regular beer and a lower-carbohydrate "light" beer. Steady customers of the brewery buy 12 units of regular beer and 18 units of light beer monthly. While setting up the brewery to produce the beers, the management decides to produce extra beer, beyond that needed to satisfy customers. The cost per unit of regular beer is $32,000 and the cost per unit of light beer is $60,000. Every unit of reqular beer brings in $100,000 in revenue, while every unit of light beer brings in $300,000 in revenue. The brewery needs at least $9,000,000 in revenue, and has determined that the total demand will be at least 50 units of beer. Complete parts (a) and (b). (a) How much of each type of beer should be made so as to minimize total production costs? 30 units of regular beer and 20 units of light beer should be made, for a minimum total cost of $ 2160000 (Type integers or decimals.) (b) Suppose the minimum revenue is increased to $9,400,000. Use shadow costs to calculate the total…
The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company: