Question

In: Statistics and Probability

Minimize total cost = 4X13 + 3X23 + 8X14+ 6X24 + 2X15+ 5X25 + 5X36 +...

Minimize total cost = 4X13 + 3X23 + 8X14+ 6X24 + 2X15+ 5X25 + 5X36 + 8X46 + 2X56 + 7X37 + 3X47 + 9X57

Subject to:

X13 + X14 + X15 ≤ 1500

X23 + X24 + X25 ≤ 1000

X13 + X23 = X36 + X37

X14 + X24 = X46 + X47

X15 + X25 = X56 + X57

X36 + X46 + X56 = 1200

X37 + X47 + X57 = 800

All xij ≥ 0

Solutions

Expert Solution

Excel formulas can be set up as:

Solver in excel can be set up as follows:

Final optimal cost is = 12,000

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Minimize total cost = 4X13 + 3X23 + 8X14+ 6X24 + 2X15+ 5X25 + 5X36 +...
Minimize total cost = 4X13 + 3X23 + 8X14+ 6X24 + 2X15+ 5X25 + 5X36 + 8X46 + 2X56 + 7X37 + 3X47 + 9X57 Subject to: X13 + X14 + X15 ≤ 1500 X23 + X24 + X25 ≤ 1000 X13 + X23 = X36 + X37 X14 + X24 = X46 + X47 X15 + X25 = X56 + X57 X36 + X46 + X56 = 1200 X37 + X47 + X57 = 800 All xij ≥ 0
A business that produces color copies is trying to minimize its average cost per copy​ (total...
A business that produces color copies is trying to minimize its average cost per copy​ (total cost divided by the number of​ copies). This average cost in cents is given by ​f(x)equals=0.00000093x^2−0.0146+60​, where x represents the total number of copies produced. ​(a) Describe the graph of f. ​(b) Find the minimum average cost per copy and the corresponding number of copies made.
Joe's Drones is attempting to minimize total inventory cost and maximize profits this year. Each drone...
Joe's Drones is attempting to minimize total inventory cost and maximize profits this year. Each drone costs Joe $100 to buy and he sells them for $150 each. Joe’s mom helps with the purchasing and ordering and he pays her $100 for every order she places. Joe leases warehouse space from a friend where he can store his inventory and he pays $2.50 per month for each board that he has to store to use this space. Drones are a...
Suppose an optimization problem is trying to minimize the cost function : Cost = 7S +...
Suppose an optimization problem is trying to minimize the cost function : Cost = 7S + 10R.   The company is producing two products, product S and product R, subject to the following constraints:                                 S + R ≤ 90                         3S + 10R ≥ 620                         R ≤ 100                         S ≥ 20                         S, R ≥ 0 Program this into a blank Excel worksheet and use Solver to find the solution for S and R such that the objective function is...
In order to minimize the total costs of quality, a firm should increase expenditures on
In order to minimize the total costs of quality, a firm should increase expenditures on  a internal failure costs relative to external costs b prevention and appraisal costs relative to failure costs c internal failure costs relative to prevention and appraisal costs d prevention and failure costs relative to appraisal costs
Quantity Total Cost Total Fixed Cost Total Variable Cost Average Fixed Cost Average Total Cost Average...
Quantity Total Cost Total Fixed Cost Total Variable Cost Average Fixed Cost Average Total Cost Average Variable Cost Marginal Cost 0 30 1 75 2 150 3 255 4 380 5 525 6 680 7 840 8 1010 9 1200 Given the quantity and total cost, calculate for total fixed cost, total variable cost, average fixed cost, average total cost, average variable cost, and marginal cost. Excel formulas would be nice but not required.
what is capital cost in own words what is capital cost and how to minimize it
what is capital cost in own words what is capital cost and how to minimize it
1. The overall goal of the financial manager is to: a. minimize total costs. b. maximize...
1. The overall goal of the financial manager is to: a. minimize total costs. b. maximize net income. c. maximize earnings per share. d. maximize shareholder wealth. 2. Sustainable Growth Rate You have located the following information on Rock Company: debt ratio = 49.5%, capital intensity ratio = 2.63 times, profit margin = 27%, and dividend payout ratio = 44%. What is the sustainable growth rate for Rock? (Do not round intermediate steps.) 1. 3.92% 2. 12.85% 3. 15.12% 4....
In a marketing study, the researcher wants to minimize the cost of interviewing. These interviews will...
In a marketing study, the researcher wants to minimize the cost of interviewing. These interviews will be done to households with children, without children, and to individuals during the day and during the night. The cost for each type of interview is presented in the following table: Category Cost per day Cost per night With children $1500 $1900 Without children $1200 $1550 Individual $1100 $1250 The sample size is 800 people. At least there must be 400 households with children....
the production department wants to decide on one of the alternatives to minimize the cost. the...
the production department wants to decide on one of the alternatives to minimize the cost. the alternative below    1. continue the production with your existing machine with a 2,00 $ cost per unit.   2. upgrade your machine with 800$ investment and reduce your unit cost to 2.20$per unit.    3. buy a high technology new machine for 1200$and have a lower units cost 1.50$ per unit.    your are expected to give a report on:       a. find the feasible domain in terms...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT