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?

Answers: 1

Show answers

Other questions on the subject: Business

Business, 22.06.2019 14:30, lilquanreem8051

Bridge building company estimates that it will incur $1,200,000 in overhead costs for the year. additionally, the company estimates 50,000 direct labor hours will be spent building custom walking bridges for the year at a total direct labor cost of $600,000. what is the predetermined overhead rate for bridge building company if direct labor costs are to be used as an allocation base?

Answers: 3

continue

Business, 22.06.2019 16:50, bandzlvr

Andrea cujoli is a currency speculator who enjoys "betting" on changes in the foreign currency exchange market. currently the spot price for the japanese yen is ¥129.87/$ and the 6-month forward rate is ¥128.53/$. andrea would earn a higher rate of return by buying yen and a forward contract than if she had invested her money in 6-month us treasury securities at an annual rate of 2.50%. true/false?

Answers: 2

continue

Business, 22.06.2019 19:00, williamsvilletiles

When making broccoli cream soup, the broccoli and aromatics should be a. burned. b. simmered. c. puréed. d. sweated.

Answers: 2

continue

Business, 22.06.2019 22:00, mlinares776

In which of the following games is it clearly the case that the cooperative outcome of the game is good for the two players and bad for society? a. two oil companies own adjacent oil fields over a common pool of oil, and each company decides whether to drill one well or two wells. b. two airlines dominate air travel between city a and city b, and each airline decides whether to charge a "high" airfare or a "low" airfare on flights between those two cities. c. two superpowers decide whether to build new weapons or to disarm. d. in all of the above cases, the cooperative outcome of the game is good for the two players and bad for society

Answers: 3

continue

You know the right answer?

A manufacturing firm has discontinued production of a certain unprofitable product line. Considerabl...