Asked Dec 1, 2019

Solve the following problem with Excel Solver: (Round your answers to the nearest whole number.)

Minimize Z= 2A + 4B.
4A + 6B ≥120
2A + 6B≥72
B ≥ 10

Decision for A

Decision for B

Total cost $

Resources Used




Expert Answer

Step 1

Solve the problem:


Image Transcriptionclose

A с D 1Minimize Z 2A+4B Resource A Resource B Resource C 2 4А+6B 120 2A+6B 72 4 в 10 6 A 15 7 B 10 8 Total profit (Z) 70 9 Resource used 10 11 Resource A 120 90 12 Resource B 13 Resource C 10 AIAA A

Step 2

Formulae to solve the prob...


Image Transcriptionclose

А В C 1 Minimize Z 2A+4B 120 72 10 2 4А+6B Resource A 2А+6B Resource B 4 В Resource C 5 15 10 8 Total profit (Z)2*B6+4*B7 6 A 7 B Resource used 10 - 4*B6+6*B7 - 2*B6+6*B7 EB7 11 Resource A 12 Resource B 13 Resource C AIAAA t


Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in


Operations Management


Related Operations Management Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: Challenges of employee Motivation

A: Motivation:The basic necessities to remain motivated are activation, persistence, and intensity. It ...


Q: definition of comparative advanteges

A: Comparative advantages refer to the technique where a country generates the goods or services for th...


Q: What does a business have to consider when trying to follow a cost leadership strategy and a differe...

A: 1) Price leadership strategy could be a corporation's capacity to style and produce,market a similar...


Q: How do we calculate slack?

A: Click to see the answer


Q: Widgetco is making a prototype of a new product. The product consists of two subassemblies. Before b...

A: This is a sequencing problem with the following data (since certain data is not very clear from the ...


Q: Most experts believe that an ERP system, with all the advantages it offers, also has drawbacks, such...

A: Through ERP systems have on top of mentioned drawbacks however the advantage it gives to the organiz...


Q: 1. Assuming you possessed the right technical skills for the job, would a position at KIEA be appeal...

A: Determine whether I possess the position in the company and the positives and negatives associated w...


Q: Consider the monthly sales data of a company for last year as well as first six month data for curre...

A: Given information: 


Q: I need help with chapter 17, problem 2 (17.2)  Question is A-D

A: a)Arrange the activities into two logical sequences: