Need help filling out the excel chart. My professor wants a sensitivity report for the five profit scenarios. Thank you.

INSTRUCTIONS The problem is described on the other worksheet in this workbook. Open the spreadsheet in Excel TYPE the last 4 digits of your SFSU ID# into the cells A3, B3, C3, D3 (one digit per cell) Type your Last Name in cell A5 and your First Name in cell D5 Print out the spreadsheet (from cells A1 to L21) in LANDSCAPE (horizontal) mode NOTE: DO NOT PRINT UNTIL YOU HAVE TYPED IN THE LAST 4 DIGITS OF YOUR SFSU ID# Fill in the table (Solve separately for each profit scenario) Fractional answers are permissible (carry 2 or 3 places beyond decimal point). Be able to answer the questions posed at the bottom of the spreadsheet Bring printout of the spreadsheet and solutions to the midterm exam D# Take-home - complete, understand and bring to midterm. Note: scenarios differ for each person The 5 different profit scenarios SFSU ID#last4(1 digit per cell) $Profit/frame $Profit/box 7 9 9 7 A Lastname Firstname 60 90 B 68 34 C An artist can make shadow boxes and frames from 64 30 D wood and silver. Demand for frames is no more 58 58 than four. Available ounces of wood are 18 E 43 86 Available ounces of silver are Each frame takes 2 Each shadow box take 3 Frame Wood in Silver in #Made Frames Frames 10 ounces of ounces of Frames Profit wood and wood and Boxes #Made ounces of silver. 1 ounces of silver. Wood in Silver in Boxes Boxes Boxes Profit 2 Max Wood Silver Leftover Leftover Profit A B C D E For For For For For each each each each each profit profit profit profit profit scenario, scenario, scenario, scenario, scenario, how how how how how would things change much would you pay would things change would things change would things change if you had one more ounce of wood?, of silver? for one more ounce of wood?, of silver? if demand could be as high as 5 frames? if profit/frame increased by one?, decreased by one? if profit/box increased by one?, decreased by one