Need Excel to do it and show the Excel formulas with picture please!!

o ZOOM + Product Mix Problem PC Tech company assembles and tests two models of computers - Basic and XP Following tables gives all the associated data Model Assembly Hours Testing hours Selling price 300 450 Component cost 150 225 Basic 5 1 XP 6 2 10,000 assembly hours and 3000 testing hours available Assembling labor hour costs $11 and testing labor hour costs $15 PC Tech company can sell at most 600 Basic and 1200 XP models Objective is to determine the product mix to maximize profit Extension to the problem covered in the video for Assignment 1: In PC Tech's product mix problem above, assume there is another PC model, the VXP model, that the company can produce in addition to Basics and XPs. Each VXP requires eight hours for assembling, three hours for testing, $275 for component parts, and sells for $560. At most 50 VXPs can be sold 1. Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix. 2. You should find that the optimal solution is not integer-valued. You can round the values in the decision variable cells to the nearest integers, but make sure it is still a feasible solution that covers all the constraints