Question: Write a linear programming formulation for the following problem: Billy quit university with a great idea to make widgets. There are two types of widget:

  1. Write a linear programming formulation for the following problem:

Billy quit university with a great idea to make widgets. There are two types of widget: A, and B. All widgets require glue, wood, and metal to make, shown in the table below. Billy has 10 packets of glue, 10 pallets of wood, and 10 sheets of metal available. All widgets will sell for $10.

Widget Glue Wood Metal
A 3 1 3
B 2 1 2

  1. What assumptions are you making? Discuss.
  2. Could you simplify the problem? Discuss.

b) Enter the problem into MS Excel and solve. Report your findings in a way you would to senior manager

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!