Question: I NEED TO SOLVE WTH USNG EXCEL SOLVER Penguin Random House Publisher Services (PRHPS) is considering publishing five books. The maximum number of copies of

I NEED TO SOLVE WTH USNG EXCEL SOLVER

I NEED TO SOLVE WTH USNG EXCEL SOLVER Penguin

Penguin Random House Publisher Services (PRHPS) is considering publishing five books. The maximum number of copies of each book that can be sold (maximum demand), the variable cost of producing each book, the sales price of each book, and the fixed cost of a production run for each book are given in the table below. For example, producing 2,000 copies of book 1 brings in a revenue of 2,000(50) = $100,000 but costs 80,000 + 25(2,000) = $130,000. Penguin Random House can produce at most 10,000 books if it wants to maximize profit. Solve the integer programming problem using Excel Solver, to help this publisher identify the best production plan. Book 1 2 3 4 5 5000 4000 3000 4000 3000 Maximum Demand Variable Cost ($) 25 20 15 18 22 Sales Price ($) 50 40 38 32 40 Fixed Cost ($ Thousands) 80 50 60 30 40

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!