Problem: Basic Linear Programming
Carpenter Joe makes skateboards and snowboards. He uses three different processes, cutting, shaping and finishing. A skateboard requires 2 man-hours for cutting and 3 hours for finishing, while a snowboard requires 2 hours for cutting and 3 hours for shaping. Joe has available 14 hours for cutting, 12 hours for shaping and 15 hours for finishing. How many skateboards and snowboards should Joe manufacture each week in order to maximize profit if skateboard yields a profit of $10 and a snowboard yields a profit of $20?
A) Solve the problem using graphical method.
B) Solve the problem using Excel solver