PLEASE ANSWER IN EXCEL

APC 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 Cost of components Assembly Time Testing Time $300 $150 5 1 $450 $225 6 2 Basic XP Labor Cost per hour Assembly $11 Testing $15 Time Available 10,000 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. Suggest use the followng template to develop your model but you are free to use your own. Solution 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