Question: solve it with Excel pls Test Content a Question 1 10 Points A company is thinking in investing in new products Super Mic and MegaHeadphone.

solve it with Excel pls Test Content a Question 1
solve it with Excel pls
Test Content a Question 1 10 Points A company is thinking in investing in new products Super Mic and MegaHeadphone. The cost of the production system to produce each of the proposed products is $33500 for SuperMic production system and $42100 for MegaHeadphone production system The company can generate a profit of 546 from the Super Mic and $62 from the MegaHeadphone The company has a limited supply of workforce hours. One Super Mic needs 3 workforce-hours, while a MegaHeadphone needs 5.2 workforce hours The company has a total of 13400 workforce hours in the next year. Formulate an IP whese solution will maximize company profits next year SELECT ONLY THE CORRECT STATEMENTS I The optimal solution consists of producing 4466 Super Mic and no MegaHeadphones Al decision variables are BINARY variables Improving the production method for Megaheadphone to take only 4.A workforce hours and decreasing the investment cost to 38500 would change the optimal solution Improving the production method for MegaHeadphone to take only 4.9 workforce hours would change the optimal solution The optimal value for Z is equal to 171936

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!