Show LP models for all problems. Attach the original Excel Solver solutions, including the answer report and the sensitivity report for the LP models.

1. (25 points) Fred Publishing Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation and production setup is estimated to be 150,000. Variable production and material costs are $6 per book. The publisher plans to sell the text to college and university bookstore for $45 each a. Write a math model for total cost. B. Write a math model for total revenue. c. Write a math model for total profit. d. Find the break-even point