Please show formulas used and show solve table formula.

AutoSave OFF Dr Fa20-3560-ETO3-Cho3-1-Shell Home Insert Draw Page Layout Formulas Data Review View Developer XLSTAT Tell me Le Share O Comments Calibri v 11 v i A General ' ' Insert v & Delete v Conditional Formatting Format as Table Cell Styles O 4 B Paste BI I U Av $ % Ideas Sensitivity Format v Sort & Filter Find & Select T3 - X fox F H I J K L M . N 0 P Q R 5 T U Caution: Do not alter the structure of this Excel file like adding/deleting columns/rows, moving contents from their cells, or renaming sheet names. Use the specified output cell range. You may change the column widths slightly to accommodate proper formatting, but changing the widths in a significant manner is prohibited. Not following these instructions can result in serious loss of points. All cells in all sheets must be properly formatted. These include aligning contents, using appropriate number format and decimal places for numerical contents, use of bolding, italics, borders, etc. in an appropriate fashion so that the readability of the content is enhanced. 4 A B C C D E 4 #2. Problem #37 (50 points) 6 a. (35 points) 7 Regular time unit cost B Overtime unit cost 9 Unit holding cast 10 11 Initial inventory 12 13 Production schedule 14 Quarter 1 2 3 15 Regular time production 16 17 Upper bound 18 19 Overtime production 20 21 Onhand after production 22 23 Demand 24 25 Ending inventory 26 27 Regular timecast 28 Overtime cost 29 Holding cost 30 31 Total cost 32 33 34 b. Run SolverTable with C9 as input cell. Use $10 to $300 with $10 increments for input. 35 Describe your finding below. Stay within the box provides. Use Justily to fit your answer 36 inside the box. 15 points) 37 38 39 Hints: On hand after production is the sum of the beginning inventory and the production from regular and overtime. Changing cells are Regular time production and Overtime production. Answer key: Total cost = $1,255,200 Sheet1 Sheet2 + Ready IT BE 100% AutoSave OFF Dr Fa20-3560-ETO3-Cho3-1-Shell Home Insert Draw Page Layout Formulas Data Review View Developer XLSTAT Tell me Le Share O Comments Calibri v 11 v i A General ' ' Insert v & Delete v Conditional Formatting Format as Table Cell Styles O 4 B Paste BI I U Av $ % Ideas Sensitivity Format v Sort & Filter Find & Select T3 - X fox F H I J K L M . N 0 P Q R 5 T U Caution: Do not alter the structure of this Excel file like adding/deleting columns/rows, moving contents from their cells, or renaming sheet names. Use the specified output cell range. You may change the column widths slightly to accommodate proper formatting, but changing the widths in a significant manner is prohibited. Not following these instructions can result in serious loss of points. All cells in all sheets must be properly formatted. These include aligning contents, using appropriate number format and decimal places for numerical contents, use of bolding, italics, borders, etc. in an appropriate fashion so that the readability of the content is enhanced. 4 A B C C D E 4 #2. Problem #37 (50 points) 6 a. (35 points) 7 Regular time unit cost B Overtime unit cost 9 Unit holding cast 10 11 Initial inventory 12 13 Production schedule 14 Quarter 1 2 3 15 Regular time production 16 17 Upper bound 18 19 Overtime production 20 21 Onhand after production 22 23 Demand 24 25 Ending inventory 26 27 Regular timecast 28 Overtime cost 29 Holding cost 30 31 Total cost 32 33 34 b. Run SolverTable with C9 as input cell. Use $10 to $300 with $10 increments for input. 35 Describe your finding below. Stay within the box provides. Use Justily to fit your answer 36 inside the box. 15 points) 37 38 39 Hints: On hand after production is the sum of the beginning inventory and the production from regular and overtime. Changing cells are Regular time production and Overtime production. Answer key: Total cost = $1,255,200 Sheet1 Sheet2 + Ready IT BE 100%