This time, you are on your own for creating the spreadsheet. You should use the same approach as in Problem 1.
We've placed some of the data in the spreadsheet, but you will need to create the correct formulas and put the correct information into the Solver form.