ASAP

Scenario: Assume you own a book store and have 100 books in storage. You sell a certain \% for the highest price of $50 and a certain \% for the Use Data-Table to calculate the total profit for different percentages of books sold with different highest prices. Bookhooia, a bookstore n Melboume, has a new collection of 200 books to sell. The management statt need to make a decis on about which price range to sell for The prices need to be balanced between making a maximum profit, wh ch might discourage sales, and making a minimum profit which wili increase the number of books sold. The data is in the Bookstoce xlsx file: Use the 2 variable data table method to calculate the totai proft for different percentages of books sold with different highest prices and different highest unit prises choose the correct resuits to fill in the table below Note that you may need to adjust the peccentages and prices in the given Excel file to match the question. Scenario: Assume you own a book store and have 100 books in storage. You sell a certain \% for the highest price of $50 and a certain \% for the Use Data-Table to calculate the total profit for different percentages of books sold with different highest prices. Bookhooia, a bookstore n Melboume, has a new collection of 200 books to sell. The management statt need to make a decis on about which price range to sell for The prices need to be balanced between making a maximum profit, wh ch might discourage sales, and making a minimum profit which wili increase the number of books sold. The data is in the Bookstoce xlsx file: Use the 2 variable data table method to calculate the totai proft for different percentages of books sold with different highest prices and different highest unit prises choose the correct resuits to fill in the table below Note that you may need to adjust the peccentages and prices in the given Excel file to match the