Business, 18.02.2021 21:30, natalie2sheffield

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:
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 Machine 800
Lathe 480
Grinder 320
The salespeople estimate they can sell all the units of X1 and X2 that can be made. But the sales potential of X3 is 80 units per week maximum. Unit profits for the three products are Unit Profits X1 $20 X2 6 X3 8 Set up the equations that can be solved to maximize the profit per week.
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. Show your work in Sheet "Problem 4b."c) What is the optimal solution?

Answers: 2

Show answers

Other questions on the subject: Business

Business, 22.06.2019 01:00, reagriffis24

How does the economy of cuba differ from the economy of north korea? in north korea, the government’s control of the economy has begun to loosen. in cuba, the government maintains a tight hold over the economy. in cuba, the government’s control of the economy has begun to loosen. in north korea, the government maintains a tight hold over the economy. in north korea, there is economic uncertainty in exchange for individual choice. in cuba, there is economic security in exchange for government control. in cuba, there is economic uncertainty in exchange for individual choice. in north korea, there is economic security in exchange for government control.\

Answers: 2

continue

Business, 22.06.2019 07:20, amcdonald009

Suppose that real interest rates increase across europe. this development will u. s. net capital outflow at all u. s. real interest rates. this causes the loanable funds to because net capital outflow is a component of that curve.

Answers: 1

continue

Business, 22.06.2019 07:30, mv603177

Most states have licensing registration requirements for child care centers and family daycare homes. these usually include minimum standard for operation. which of the following would you most likely find required in a statement of state licensing standards for child care centers?

Answers: 2

continue

Business, 22.06.2019 08:00, connermichaela

Who is not spending wisely? erika goes shopping and saves her receipts. she totals how much she spent and writes it down. mia needs to buy a new pair of shoes because she joined the soccer team. she looks at newspaper ads to find the best price. lauren has been thinking about getting a puppy for a long time. she walks by the pet store at the mall and decides to get a puppy. erin makes a purchase online using a credit card. she knows that she can pay the entire bill when it arrives.

Answers: 2

continue

Do you know the correct answer?

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