Answered step by step
Verified Expert Solution
Question
1 Approved Answer
11. TVGuru Inc. manufactures Smart and UHD TV sets in its Kentucky plant. The company makes a profit of $400 on each Smart TV and
11. TVGuru Inc. manufactures Smart and UHD TV sets in its Kentucky plant. The company makes a profit of $400 on each Smart TV and $300 on each UHD TV set. The production process has a capacity of 30,000 machine-hours. It takes 3 machine-hours to produce a unit of Smart TV and 1 machine-hour to produce a unit of UHD TV. After a market research survey by a well-known research firm, it is concluded that no more than 8,000 Smart and 12,000 UHD TVs could be sold. a. Formulate the LP model. b. Solve this problem graphically. Do not use Excel Solver. What is the optimal product mix? What is the maximum profit?For parts ce, set up a spreadsheet model and use Solver to nd the optimal solu- tion. Use the Solver output and sensitivity reports to answer the questions. Answer d and e independent of each other without resolving the problem. Turn in your spreadsheet model and reports. . What is the optimal product mix? What is the maximum profit? . Capacity can be increased by 1,000 machine-hours for a cost of $100,000. Should the company increase the capacity? Justify your answer. . There was an error in the market research report and the actual demand for the Smart TV is less than 8,000. If the demand is 6,000 would it change the optimum solution? How would this affect the prot? What if it is 5,000? Whatwould be the impact on the production plan and total prot
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started