Solve the following. Follow the Linear Programming Model Formulation Steps. 1. Moore’s Meatpacking Company produces a hot dog mixture in 1,000-pound batches. The mixture contains two ingredients—chicken and beef. The cost per pound of each of these ingredients is as follows: Ingredient Cost/lb. Chicken $3 Beef $5 Each batch has the following recipe requirements: At least 500 pounds of chicken At least 200 pounds of bee The ratio of chicken to beef must be at least 2 to 1. The company wants to know the optimal mixture of ingredients that will minimize cost. Formulate a linear programming model for this problem.

Solve the following. Follow the Linear Programming Model Formulation Steps. 1. Moore’s Meatpacking Company produces a hot dog mixture in 1,000-pound batches. The mixture contains two ingredients—chicken and beef. The cost per pound of each of these ingredients is as follows: Ingredient Cost/lb. Chicken $3 Beef $5 Each batch has the following recipe requirements: At least 500 pounds of chicken At least 200 pounds of bee The ratio of chicken to beef must be at least 2 to 1. The company wants to know the optimal mixture of ingredients that will minimize cost. Formulate a linear programming model for this problem.

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

Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
A mixture of pellets is to be made containing x regular pellets, y large pellets and z extra large pellets. Cost, weight and volume data for each type of pellet are shown in the table. Is it possible to make mixture of 55 pellets at a cost of $0.85 if the mixture is to have 120 weight units and 130 volume units? If so, how many each type of pellet should be in the mixture? Pellet Type 5. Number of Cost per Pellet in Cents Weight Units per Pellet Volume Pellets Units per Pellet Regular Large Extra large 2 1 4 y 1 4 3
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has pound raisins and ½ pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $0.60 per pound and raisins cost $1.5 per pound. The deluxe mix will sell for $2.90 per pound, and the standard mix will sell for $2.55 per pound. The owner estimates that no more than 110 bags of one type can be sold. Using Simplex method a. If the goal is to maximize profits, how many bags of each types should be prepared? b. What is the expected profit?
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $.60 per pound and raisins cost $1.50 per pound. The deluxe mix will sell for $4.20 for a one-pound bag, and the standard mix will sell for $3.75 for a one-pound bag. The owner estimates that no more than 230 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? b. What is the expected profit?
A small candy shop is preparing for the holiday season. The owner must decide how many bags of Deluxe Mix and how many bags of Standard Mix of Peanut/Raisin Delite to put up. The Deluxe Mix has 2/3 pound raisins and 1/3 pound peanuts, and the Standard Mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $0.60 per pound and raisins cost $1.50 per pound. The Deluxe Mix will sell for $2.90 per pound, and the Standard Mix will ell for $2.55 per pound. The owner estimates that no more than 110 bags of one type can be sold. If the goal is to maximize profits, how many bags of each type should be prepared?
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $.60 per pound and raisins cost $1.50 per pound. The deluxe mix will sell for $4.00 for a one-pound bag, and the standard mix will sell for $3.55 for a one-pound bag. The owner estimates that no more than 210 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? Deluxe _____bags Standard ______bags b. What is the expected profit? Profit ________
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $.60 per pound and raisins cost $1.50 per pound. The deluxe mix will sell for $4.90 for a one-pound bag, and the standard mix will sell for $4.40 for a one-pound bag. The owner estimates that no more than 300 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? Answer is complete and correct. Deluxe Standard 90 bags 60 bags b. What is the expected profit? Answer is complete but not entirely correct. Profit 617 4
Mark has a company that produces tables and chairs, both having two different models. The product models and related information are given in the following table. Wood costs 3000 $ per cubic meter and 200 m3 of wood are available for the upcoming month. The cost of labor is 40 $/hour and there are 6000 hours of labor available in a month. Mark sells his products to a big chain retail company. The company purchases all products whatever Mark produces. Mark formulates an LP as follows to determine the optimal monthly production plan such that he maximizes the total profit. Decision Variables: X1 : number of basic tables to be produced. X2 : number of elegant tables to be produced. X3 : number of basic chairs to be produced. X4 :number of elegant chairs to be produced. Max Z = 140 X1 + 345 X2 + 120 X3 + 260 X4 ( maximize total profit) Subject to 0.11 X1 + 0.13 X2 + 0.06 X3 + 0.07 X4 ≤ 200 (constraint on the available amount of wood) 2 X1 + 4.5 X2 + 1.5 X3 + 4 X4 ≤ 6000…
standard mix of Peanut/Raisin Delite to put up. The deluxe mix has .68 pounds of raisins and .32 pounds of peanuts, and the standard mix has 0.5 pounds of raisins and 0.5 pounds of peanuts per bag. The shop has 80 pounds of raisins and 50 pounds of peanuts to work with. Peanuts cost $0.75 per pound and raisins cost $1.5 per pound. The deluxe mix will sell for $2.9 for a one-pound bag, and the standard mix will sell for $2.55 for a one-pound bag. The owner estimates that no more than 110 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? (Round your answers down to a whole number.) Deluxe Standard b. What is the expected profit? (Round your answer to two decimal places.) Expected profit
Manufacturer firm manufactures two product(X,Y ). Each kg of X requires 5 kWh of electricity and 0.25 h of labour. Each kg of Y requires 2 kWh of electricity and 0.5 h of labour. For Y , the quantity of raw materials available permits the maximum production of 60 kg/day. Electricity is limited to 500 kWh day and labour to 40 hiday. The X profit is $0,25/kg, while the Y profit is $0,4/kg. To solve this LP problems by simplex method. there are three basic components must understood: 1. Decision variables that seek to determine? 2. Formulated the Objective (goal) that need to optimize (maximize or minimize). 3. Constraints that the solution must satisfy; and, 4. What quantity of cach (X&Y) should be produced and, 5. What would the profit be? Activste WindaE إجابتك
A company produces bicycle frames using two fibreglass materials that improve the strength-to-weight ratio of the frames. The cost of standard grade material is Rs 750 per yard and the cost of professionalgrade material is Rs 900 per yard. The standard and professional grade materials contain two different amounts of fibreglass, carbon fibre and Kevlar as given in table Standard Grade Professional Grade Fibre Glass 84% 58% Carbon Fibre 10% 30% Kevlar 6% 12% The company signed a contract with a bicycle manufacturer to produce a new frame with a carbonfibre content of at least 20 percent and Kevlar content of not more than 10 percent. To meet the requiredweight specification, a total of 30 yárds of material must be used for each frame. (i)Formulate an LPP to determine the size of each grade of fibreglass materials that the company should use in each frame to minimise the total cost. Use graphical method.(ii)If the company is offered professional grade at Rs 800 per yard,…
An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A B 1 Price per Unit 2 Cost per Unit 3 Profit per Unit PricePerUnit Cost_Per_Unit Profit per Unit 4 5 Fixed Costs Fixed_Costs 6 Variable Costs Variable Costs Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name PricePerUnit Cost Per_Unit Profit per Unit Fixed_Costs Variable Costs