3: PLEASE SOLVE USING EXCEL A manufacturer can sell product 1 at a profit of $2...
3: PLEASE SOLVE USING EXCEL A manufacturer can sell product 1 at a profit of $2 per unit and product 2 at a profit of $5 per unit. Three units of raw material are needed to manufacture 1 unit of product 1, and 6 units of raw material are needed to manufacture 1 unit of product 2. A total of 120 units of raw material are available. If any product 1 is produced a setup cost of $10 is incurred; if any product 2 is produced a setup cost of $20 is incurred. a. Formulate this problem. b. Solve this problem using Excel.
Homework Answers
a) LP Formulation:
Maximize Profit (Z)= 2x+5y-10-20
Subject to constraint:
3x+6y <= 120
x,y >=0
b) 
Add Answer to:
3: PLEASE SOLVE USING EXCEL A manufacturer can sell product 1 at
a profit of $2...
3. Integer Programming Problem (Chapter 6) A manufacturer can sell product 1 at a price of...
3. Integer Programming Problem (Chapter 6) A manufacturer can sell product 1 at a price of $30 per unit and product 2 at a price of $40 per unit. Three units of raw material and 1.5 labor hours are needed to manufacturer one unit of product 1. Six units of raw material and 2 labor hours are need to manufacture one unit of product 2. The unit variable cost for product 1 is $20, and for product 2 is $20....
A chemical manufacturer produces three different chemical products. The profit per unit, the labor and raw material required per unit, and the pollution emitted per unit are given in the file. This co...
A chemical manufacturer produces three different chemical
products. The profit per unit, the labor and raw material required
per unit, and the pollution emitted per unit are given in the file.
This company’s two objectives are to maximize profit and minimize
pollution produced. The company wants to identify a set of points
that constitute a trade-off curve for these two objectives.
Formulate and solve an appropriate optimization model in the given
shell file to help the chemical manufacturer find this...
I need the answer to include solver and excel. Thank you. A Company produces two products....
I need the answer to include solver and excel. Thank
you.
A Company produces two products. Relevant information for each product is shown in the Table below. The company has a goal of $48 in profits and incurs $1 penalty for each dollar it falls short of this goal. A total of 32 hours of labor are available. A $2 penalty is incurred for each hour of overtime (labor over 32 hours) used, and $1 penalty is incurred for each...
Please solve using solver in excel, screenshots appreciated!! Product Mix Homework Problem Furnco manufactures desks an...
Please solve using solver in excel, screenshots
appreciated!!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to...
Please solve using solver in excel, thanks! Product Mix Homework Problem Furnco manufactures desks and chairs. Each des...
Please solve using solver in excel, thanks!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to maximize...
Bexter Labs produces three products: A, B, and C. Bexter can sell up to 2000 units...
Bexter Labs produces three products: A, B, and C. Bexter can
sell up to 2000 units of Product A, up to 3000 units of Product B,
and up to 5000 units of Product C. Each unit of Product C uses two
units of A and three units of B and incurs $7 in processing costs.
Products A and B are produced from either raw material 1 or raw
material 2. It costs $9 to purchase and process one unit of...
Can someone solve all the points for me? Question 1: A manufacturer is reviewing last year's...
Can someone solve all the
points for me?
Question 1: A manufacturer is reviewing last year's budget for its most expensive product, which is mostly hand-made using 2 different raw materials (A and B) and has prepared the following information: Budget Price Actual Units Total Units Total 110,000.00 167.50 18,425,000 125,000 20,000,000 Sales Variable Cost Material A Material B 2.00 Kgs 1.75 Kgs 8.45 25.00 1,859,000 4,812,500 210,000 220.000 2,100,000 5.500.000 Labour Var. Overh. Fixed Cost 2.50 Hours 2.50 Hours...
Solve the following LP problems using the Solver in MS Excel. Q1. A candy manufacturer has...
Solve the following LP problems using the Solver in MS Excel. Q1. A candy manufacturer has 130 pounds of chocolate-covered cherries and 170 pounds of chocolate-covered mints in stock. He decides to sell them in the form of two different mixtures. One mixture will contain half cherries and half mints by weight and will sell for $2.00 per pound. The other mixture will contain one-third cherries and two-thirds mints by weight and will sell for $1.25 per pound. How many...
A company is attempting to decide the mix of products which it should produce next week....
A company is attempting to decide the mix of products which it should produce next week. It has six products, each with a unit profit (unit profit =selling price –variable cost per unit) and a unit production time as shown below: Product Profit ($/unit) Production time (hours/unit) 1 10 1 2 22 2 3 35 1.7 4 19 2.4 5 55 4.5 6 115 9.5 The company has 720 hours available next week. The company has the following additional linear...
Product Ballet shoe Climbing shoe Dress shoe Units made Profit/unit($) $ 8.00 $ &nb
Product Ballet shoe Climbing shoe Dress shoe Units made Profit/unit($) $ 8.00 $ 5.30 $ 8.00 Raw material 1 usage/unit(pound) 0.50 0.40 0.35 Raw material 2 usage/unit(pound) 0.01 0.03 0.02 Raw material 3 usage/unit(pound) 0.20 0.35 0.25 Minimal monthly demand(unit) 100.00 100.00 100.00 This month 1600 pounds of RM1, 2500 pounds of RM2, 1100 pounds of RM3 are available. How can this shoe manufacturer maximize its monthly profit? a) has SOLVER found an integer solution? if yes, what is the...
3. Integer Programming Problem (Chapter 6) A manufacturer can sell product 1 at a price of $30 per unit and product 2 at a price of $40 per unit. Three units of raw material and 1.5 labor hours are needed to manufacturer one unit of product 1. Six units of raw material and 2 labor hours are need to manufacture one unit of product 2. The unit variable cost for product 1 is $20, and for product 2 is $20....
A chemical manufacturer produces three different chemical
products. The profit per unit, the labor and raw material required
per unit, and the pollution emitted per unit are given in the file.
This company’s two objectives are to maximize profit and minimize
pollution produced. The company wants to identify a set of points
that constitute a trade-off curve for these two objectives.
Formulate and solve an appropriate optimization model in the given
shell file to help the chemical manufacturer find this...
I need the answer to include solver and excel. Thank
you.
A Company produces two products. Relevant information for each product is shown in the Table below. The company has a goal of $48 in profits and incurs $1 penalty for each dollar it falls short of this goal. A total of 32 hours of labor are available. A $2 penalty is incurred for each hour of overtime (labor over 32 hours) used, and $1 penalty is incurred for each...
Please solve using solver in excel, screenshots
appreciated!!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to...
Please solve using solver in excel, thanks!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to maximize...
Bexter Labs produces three products: A, B, and C. Bexter can
sell up to 2000 units of Product A, up to 3000 units of Product B,
and up to 5000 units of Product C. Each unit of Product C uses two
units of A and three units of B and incurs $7 in processing costs.
Products A and B are produced from either raw material 1 or raw
material 2. It costs $9 to purchase and process one unit of...
Can someone solve all the
points for me?
Question 1: A manufacturer is reviewing last year's budget for its most expensive product, which is mostly hand-made using 2 different raw materials (A and B) and has prepared the following information: Budget Price Actual Units Total Units Total 110,000.00 167.50 18,425,000 125,000 20,000,000 Sales Variable Cost Material A Material B 2.00 Kgs 1.75 Kgs 8.45 25.00 1,859,000 4,812,500 210,000 220.000 2,100,000 5.500.000 Labour Var. Overh. Fixed Cost 2.50 Hours 2.50 Hours...
Most questions answered within 3 hours.
-
How can having too little or too much of a certain
protein cause problems for an...
asked 29 minutes ago -
Assume a muscle has a PCSA = 20 cm2 and Lo = 12 cm. Assume it...
asked 2 hours ago -
What is the yield to maturity of a ten-year, $1,000 bond with a
5.2% coupon rate...
asked 2 hours ago -
A mass m = 5 kg is tied on one end of a rope and is...
asked 2 hours ago -
The Average sales price of single-family houses in Charlotte is
$210,000 with a standard deviation of...
asked 2 hours ago -
Target Costing
Laser Impressions, Inc., manufactures color laser printers.
Model J20 presently sells for $225 and...
asked 3 hours ago -
a bottle cap manufacturer with four machines and six operators
wants to see if variation in...
asked 3 hours ago -
State Farm Insurance studies show that in Colorado, 55% of the
auto insurance claims submitted for...
asked 4 hours ago -
Complete the following reactions which form ethers (A
and B) and cyclic ethers (C-E) as major...
asked 4 hours ago -
in a perfectly elastic collision what is the velocity of ball A
if the original direction...
asked 5 hours ago -
PLEASE ANSWER ALL
1) The pressure of the atmosphere decreases with increasing
altitude in the
Choose...
asked 5 hours ago -
A simple random sample of 25,000 individuals are surveyed in
order to determine the prevalence of...
asked 5 hours ago