how to create the excel spreadsheet and use solver to complete

Turlock Auto, a car dealership, is planning for the upcoming spring sale season. The dealership is offering three types of vehicles, sedan, suV and pickup truck. The dealership has 5,000 sqft parking space available for displaying all its inventory and has $981,000 budget for purchasing new car inventory from a car manufacturer. The purchasing cost and required parking space for each type of vehicle is listed in the table below. It is estimated that the maximum possible demand for sedan, SUV and truck are 16, 22 and 12 during this sale season. For each sold sedan, SUV and truck, the dealer will make an average profit of $1,000,$1,200 and $1400 respectively. The dealership wants to decide how many sedan, SUV and truck it should purchase and display in its parking lot to make the most profit. Formulate this problem as a linear programming model (type your complete model formulation below) Z=ProfitX1=SedanX2=SUV