I need to complete this in excel solver and also create a table for the problem.

Data Project 1- Tesla BUS 420 Spring 2021 Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert * Cut Copy Calibri (Body) 11 A A- Wrap Text General AutoSum 19 Fill Paste A BIU Merge & Center $ %) 0 .00 .00 Insert Delete Format Format Conditional Format Cell Formatting as Table Styles Clear Sort & Filter Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. x fe # A5 A B D F G H 1 1 K L M N O P R S T E Project 1 Elon Musk and the staff at Tesla need to decide this month how many of each model to produce. They have a Model S which sells for $69,420, a Model 3 which sells for $37,990 and the Model X SUV version which sells for $79,990. Unfortunately they have a limited amount of battery production and capacity. Their models are built in-house and they cannot purchase batteries externally. They also have a skilled labor force which cannot be increased in the short-term. The total labor hours available for the production team are limited to 5.2 million. The Model 3 uses a much cheaper battery of which they have 10,000 available. The Model S and the Model X each use the same more advance battery of which they have a total of 20,000 available. The resources used to make each car are as follows: Models Model 3 Model X Batteries Req'd 1 Advanced 1 Simple 1 Advanced Employee Hours Req'd 180 120 225 maximize Tesla's customer demand is unlimited and backlogs have grown for all three models. How much should they produce of each of the three different models their revenue? And what will be their maximum revenue? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Data Project 1 - Tesla + Enter + 100%