subject
Business, 22.07.2021 20:20 jorgereyes01

A manufacturing firm has discontinued production of a certain unprofitable product line. Considerable excess production capacity was created as a result. Management is considering devoting this excess capacity to one or more of three products: X1, X2, and X3. Machine hours required per unit are
PRODUCT
MACHINE TYPE X1 X2 X3
Milling machine 8 2 3
Lathe 4 3 0
Grinder 2 0 1
The available time in machine hours per week is
MACHINE HOURS PER WEEK
Milling machines 800
Lathes 480
Grinders 320
Unit profits for the three products are $20 (for X1), $6 (for X2), and $8 (for X3).
a) Write the mathematical formulation to maximize the profit per week (Decision variables: Production amount of X1, X2, and X3).
b) Solve the mathematical formulation using Excel Solver.
c) What is the optimal solution?

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 15:40
Acompany manufactures x units of product a and y units of product b, on two machines, i and ii. it has been determined that the company will realize a profit of $3 on each unit of product a and $4 on each unit of product b. to manufacture a unit of product a requires 7 min on machine i and 5 min on machine ii. to manufacture a unit of product b requires 8 min on mchine i and 5 min on machine ii. there are 175 min available on machine i and 125 min available on machine ii in each work shift. how many units of a product should be produced in each shift to maximize the company's profit p?
Answers: 2
question
Business, 22.06.2019 19:30
Kirnon clinic uses client-visits as its measure of activity. during july, the clinic budgeted for 3,250 client-visits, but its actual level of activity was 3,160 client-visits. the clinic has provided the following data concerning the formulas to be used in its budgeting: fixed element per month variable element per client-visitrevenue - $ 39.10personnel expenses $ 35,100 $ 10.30medical supplies 1,100 7.10occupancy expenses 8,100 1.10administrative expenses 5,100 0.20total expenses $ 49,400 $ 18.70the activity variance for net operating income in july would be closest to:
Answers: 1
question
Business, 22.06.2019 19:50
The common stock and debt of northern sludge are valued at $65 million and $35 million, respectively. investors currently require a return of 15.9% on the common stock and a return of 7.8% on the debt. if northern sludge issues an additional $14 million of common stock and uses this money to retire debt, what happens to the expected return on the stock? assume that the change in capital structure does not affect the interest rate on northern’s debt and that there are no taxes.
Answers: 2
question
Business, 22.06.2019 20:20
You are the cfo of a u.s. firm whose wholly owned subsidiary in mexico manufactures component parts for your u.s. assembly operations. the subsidiary has been financed by bank borrowings in the united states. one of your analysts told you that the mexican peso is expected to depreciate by 30 percent against the dollar on the foreign exchange markets over the next year. what actions, if any, should you take
Answers: 2
You know the right answer?
A manufacturing firm has discontinued production of a certain unprofitable product line. Considerabl...
Questions
question
English, 31.08.2019 11:30
question
Chemistry, 31.08.2019 11:30
question
Chemistry, 31.08.2019 11:30
Questions on the website: 13722363