please show all work must use excel i need the formulas as well and please dont forget to answer the questions in the box will leave a thumbs up

Problem 2: 20 Points Scotts Scooters manufactures produces two popular scooters: the Blazer and the Boomer. In the coming week, the company wants to produce at least 500 scooters. Each Blazer produced results in a unit cost of $70, and each Boomer results in a unit cost of $40. The scooters are identical mechanically and differ only in the appearance of the plastic trim around the fenders and seat. Each Blazer's trim requires 2 pounds of plastic and 3 hours of production time, and each Boomer's trim requires 1 pound of plastic and 8 hours of production time. The company has 900 pounds of plastic and 2400 hours of labor hours available for the next production period. . . 3 Your objective function is required to be located in C5, per the template. You are required to use the Solver add-in to solve the computer-based problems. Your optimization problem must solve" meaning "no Red Exclamation" symbol. You are required to include the Answer Report, and move to right of problem worksheet You are required to complete the problems in numeric order. Each Answer Report should be numbered consecutively, for example, for Problem I then Answer Report 1. next. Problem 2, then Answer Report 2. and so forth. Solver automatically names the reports nome change or move your exam file until graded 6 7 18 19 20 21 . . DVI DV2 Unit Profit DVS Max Profit Used RHS ci VVV 1. Name the decision variables: 2. What is the optimal values of the decision variables: 3. What is the optimal objective function