(Answered) : Please Read Instructions Carefully Excel Solution Need Part 2 Company Produces Two Product Q33115430

Please read the instructions carefully. Excel solutionneed for part 2.

A Company produces two products. Relevant information for eachproduct is shown in the Table below. The company has a goal of $48in profits and incurs $1 penalty for each dollar it falls short ofthis goal. A total of 32 hours of labor are available. A $2 penaltyis incurred for each hour of overtime (labor over 32 hours) used,and $1 penalty is incurred for each hour of available labor that isunused. Marketing considerations require at least 5 units ofproduct 1 and 10 units of product 2 be produced. For each unit ofeither