I need an accurate excel solution with explanations using solver A manufacturer can sell product 1...
I need an accurate excel solution with explanations using solver
- 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.
- Formulate this problem.
- Solve this problem using Excel.
Homework Answers
Add Answer to:
I need an accurate excel solution with explanations using
solver
A manufacturer can sell product 1...
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;...
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....
Can i have the complete solution for this? if needed using excel solver and the explanaition....
Can i have the complete solution for this?
if needed using excel solver and the explanaition.
thank you!!!
1. A company manufactures two products, A and B. The unit revenues are $2 and $3, respectively. Two raw materials, M1 and M2, used in the manufacture of the two products have daily availabilities of 8 and 18 units, respectively. One unit of A uses 2 units of M1 and Aunits of M2, and 1 unit of B uses@ units of M1...
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 HELP!!!!! A product Using excel solver and LP formulate the model and find the least...
PLEASE HELP!!!!!
A product Using excel solver and LP formulate the model and find the least cost schedule on the machines for the productior Be sure to have solver produce the sensitivity report. Then discuss the reduced cost for each decision variable and the shadow price for each constraint. can be produced on four different machines. Each Machine has a production cost per unit processed and a production capacity (Cap) 2984 units/day. Cost/unit Cap/day Machine1 24 1066 Machine2 Machine3 Machine4...
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...
Use the 'Solver' add in on excel to formulate the constraints The Clarke Special Parts Company...
Use the 'Solver' add in on excel to formulate the constraints The Clarke Special Parts Company manufactures three products: A, B, and C. Three manufacturing centers are necessary for the production process. Product A only passes through Centers 1 and 2; Products B and C must pass through all three manufacturing centers. The time required in each center to produce one unit of each of the three products is noted as follows: X1 X2 X3 Z Profit Constraints Center 1...
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...
Use Excel/Solver add in for accurate answers. Problem 3-19 (Algorithmic) Better Products, Inc., manufactures three products...
Use Excel/Solver add in for accurate answers.
Problem 3-19 (Algorithmic) Better Products, Inc., manufactures three products on two machines. In a typical week, 40 hours are available on each machine. The profit contribution and production time in hours per unit are as follows: Category Product 1 Product 2 Product 3 Profit/unit $39 $51 $18 Machine 1 time/unit 1.5 Machine 2 time/unit Two operators are required for machine 1; thus, 2 hours of labor must be scheduled for each hour of...
(Provide formula without using Excel Solver , because i need to do this question in exam without using any software ) 1...
(Provide formula without using Excel Solver , because i need to
do this question in exam without using any software )
11. The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in S) from each plant to each warehouse are as follows: Warehouse Plant Capacity 450 600 6 380 Customer demand and shipping costs per unit (in $) from each warehouse to each customer are as...
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....
Can i have the complete solution for this?
if needed using excel solver and the explanaition.
thank you!!!
1. A company manufactures two products, A and B. The unit revenues are $2 and $3, respectively. Two raw materials, M1 and M2, used in the manufacture of the two products have daily availabilities of 8 and 18 units, respectively. One unit of A uses 2 units of M1 and Aunits of M2, and 1 unit of B uses@ units of M1...
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 HELP!!!!!
A product Using excel solver and LP formulate the model and find the least cost schedule on the machines for the productior Be sure to have solver produce the sensitivity report. Then discuss the reduced cost for each decision variable and the shadow price for each constraint. can be produced on four different machines. Each Machine has a production cost per unit processed and a production capacity (Cap) 2984 units/day. Cost/unit Cap/day Machine1 24 1066 Machine2 Machine3 Machine4...
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...
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...
Use Excel/Solver add in for accurate answers.
Problem 3-19 (Algorithmic) Better Products, Inc., manufactures three products on two machines. In a typical week, 40 hours are available on each machine. The profit contribution and production time in hours per unit are as follows: Category Product 1 Product 2 Product 3 Profit/unit $39 $51 $18 Machine 1 time/unit 1.5 Machine 2 time/unit Two operators are required for machine 1; thus, 2 hours of labor must be scheduled for each hour of...
(Provide formula without using Excel Solver , because i need to
do this question in exam without using any software )
11. The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in S) from each plant to each warehouse are as follows: Warehouse Plant Capacity 450 600 6 380 Customer demand and shipping costs per unit (in $) from each warehouse to each customer are as...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago