Question: question will be sent to your instructor for grading. 2 03) ANSWER YOUR QUESTIONS ON AN EXCEL FILE AND SUBMITIT HERE Puck and Pawn Company

question will be sent to your instructor for

question will be sent to your instructor for grading. 2 03) ANSWER YOUR QUESTIONS ON AN EXCEL FILE AND SUBMITIT HERE Puck and Pawn Company manufactures hockey sticks and chess sets. Each hockey stick yields an incremental profit of $1 and cach chess set $3. A hockey stick requires 14 hours of processing at machine center Alpha and 2 hours at machine center Beta. A chess set requires 12 hours at machine center Alpha, 3 hours at machine center Beta and 1 hour at machine center Gamma, Machine center Alpha has a maximum of 85 hours of available capacity per day, machine center Beta has 18 hours, and machine center Gamma has 4 hours. Answer the following questions by clearly write your answers so that you can recelve full and/or partial credits. Use Excel solver to get your solutions, make sure you record yourself while doing the Excel. Question 1: Using LP model (clearly write the equations) Question 2: If the company wishes to maximize profit, how Inany hockey sticks and chess sets should be produced per day? Question 3: Determine the binding and non-binding constraints. Question 4 If the profit of the chess set increases to $4, will that affect the solution and WHY

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!