A PC company assembles Basic and XP computers. Data on sales price, cost of components, assembly and testing time required for each is given in the table below Basic XP Sales price $300 $450 Cost of components $150 $225 Assembly Time 5 6 Testing Time 1 2 Basic XP Labor Cost per hour Time Available Assembly $11 10,000 Testing $15 3000 Basic XP The company can sell at most 600 1200 Find the optimal quantity that should be produced of each computer model to maximixe profit. Note: When I open the Solver dialog box it should be populated. A template is suggested below to develop your model but you are free to use your own. Solution Template Basic XP Cost of Assembly Cost of Testing Qty Revenue per unit Cost of Components Cost of Assembly per unit Cost of Testing Total Cost per unit Unit Margin/Profit Objective Function Max Z Constraints Assembly Time Testing Time