please show how to solve step by step in Excel!

thank you

Bookco Publishers is considering publishing five textbooks. The maximum number of copies of each textbook that can be sold, the variable cost of producing each textbook, and the selling price of each textbook are given in the above table. Bookco is limited by two resources. One is capacity. They can produce at most 10,000 books in total. Second is budget. They have $170,000 to spend on producing the books. The cost of producing the books is equal to the sum of number produced of each book multiplied by the respective variable cost. For example, if they produce 2000 copies of Book 2 and 1000 copies of Book 5, then the total cost is 2000$20+1000$22=$62000. Bookco wants to maximize its profit. Profit is calculated by the sum of the profit for each book. For example, if they produce 2000 copies of Book 2 and 1000 copies of Book S, then the profit is 2000($40$20)+1000($40$22)=$58000 Formulate a linear program mathematically to determine how Bookco can maximize its profit. Create a spreadsheet model and solve using Solver. Turn in your spreadsheet model, Answer Report and your answers to the following questions (put your answers below)