Bus 310 please explain how to solve and put in data. thanks

need help on how to get the data from the word probelm and how to form the charts and get unit profit? DVs and Max profit?

- You are required to use the optimization template contained in the hom ework file. - Your objective fanction is required to be located in C5, per the template. - The SUMPRODUCT function is required for objective functions, and constraints. - You are required to use the OpenSolver add-in for our optim ization problems. - Remember, you have 5 submission attempts to improve your score. Each problem has a value of 4 points, for a total of 20points. Problem 1: Tech Toys and Tools makes RADAR detectors and assembles two models: the Speed King I and the Speed King II. The firm can sell all they make in the Fairfax county. Both models use the same components. The two main components can only be sources from one local supplier. For the next month, the supply of component A is limited to 4,000 and the supply of component B is limited to 3,500. Speed King I uses 18 of component A and 6 of component B. Speed King II uses 12 of component A and 10 of component B. Speed King I has a unit profit of $24, and Speed King II has a unit profit of $40. How many of each model should the company make to maximize profit? Yeu ase rqguircil ie yeu the eptamiratien icmplate on demaon? 1. Name the decision variables: 2. What is the optimal values of the decision variables: 3. What is the optimal objective function: Problem 2: Mason Manufacturing produces two types of academic desks, standard and deluxe. Deluxe desks have oak tops and more expensive hardware and require additional time for finishing and polishing. Standard desks require 70 board feet of pine, and 10 hours of labor. The deluxe desk requires 60 board feet of pine, 18 board feet of oak and 15 hours of labor. For the next week, the Mason Manufacturing has 5,000 board feet of pine, 750 board feet of oak, and 400 hours of labor. Standard desk has a net profit of $225 and the deluxe desk has a net profit of $320. The company must make at least 3 deluxe desks. How many of each type of desk should the company make to maximize profit for the next week? You are required te you the eptimination template as dement 1. Name the decision variables: 2. What is the optimal values of the decision variables: 3. What is the optimal objective function