GETTING STARTED Open the file NP_EX16_2a_FirstLastName_1.xlsx, available for download from the SAM website.Save the file as NP_EX16_2a_FirstLastName_2.xlsx by changing the “1” to a “2”.If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.With the file NP_EX16_2a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Stephanie manages the employees at the Good Breeze Hotel. For the new year, Stephanie decided to update the workbook she uses to track her team’s compensation data in order to make the information easier to understand. Switch to the Hourly Compensation worksheet. Apply the Title cell style to the merged range A1:G1, and then center the text in that merged range.Merge and center the range A2:G2, and then change the font size of the merged range to 14 pt.Italicize the contents of the range A3:B3, change the font to Times New Roman, and then change the font color to Orange, Accent 2 (6th column, 1st row of the Theme Colors palette).Format cell B3 using the Short Date (e.g., 3/13/2018) number format.Use the Format Painter to copy the format from cell A6 to the range B6:G6.In cell E7, create a formula that calculates the salary for Sarah, one of the servers at The Good Breeze Hotel. Her salary is calculated by multiplying the number of regular hours worked (cell B7) by her hourly rate (cell D7), and then adding to that the number of overtime hours worked (cell C7) multiplied by her hourly rate (cell D7) times 1.5. (Hint: Sarah is paid 50% more than—or 1.5 times—her regular hourly rate when she works overtime.)Stephanie wants to see what percentage of her employees’ total working hours are spent working overtime. In cell G7, enter a formula that divides Sarah’s overtime hours (cell C7) by her total hours worked (cell F7).Change the fill color of cells E8, E10, G8, and G10 to Blue, Accent 1, Lighter 80% (5th column, 2nd row of the Theme Colors palette).To quickly see which employees worked overtime, use the Highlight Cells Rules conditional formatting to format cells in the range C7:C10 with a value greater than 0 using Light Red Fill with Dark Red Text. In cell A11, increase the indent of the cell contents twice.Stephanie would like to know the average number of regular hours worked by her employees. In cell B11, create a formula using the AVERAGE function to find the average number of regular hours her employees work in a week (B7:B10).In the range E7:E11, apply the Currency number format with zero decimal places and $ as the symbol.In the range G7:G11, apply the Percentage number format with one decimal place.For the merged range A20:A30, rotate the cell contents to 0 degrees.Find and replace all instances of the text “Weekly Hour” with Weekly Hours. (Hint: You should find and replace two instances.) Stephanie plans to print the worksheet to review with her team.She wants the table and the chart to appear on separate pages when printed. Select cell A13, and then insert a page break.Set rows 1-3 as print titles. (Hint: Rows 1-3 should repeat at the top of each printed page of the worksheet.)Create a custom footer for the worksheet. In the left footer section, display the current Page Number using a Header and Footer element. In the center footer section, display the Sheet Name using a Header and Footer element. Change the theme of the workbook to Office. To calculate the salary for all of the employees, copy the formula you created and the formatting in cell E7 into the range E8:E10. Copy the formula and the formatting in cell G7 into the range G8:G10. Copy the formula from cell B11 into the range C11:G11 to find the average of the overtime hours, hourly rates, salaries, work hour totals, and percentage of overtime hours for the team. Change the page orientation to Landscape, and then set the margins to Wide. Switch back to Normal View if necessary. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Joe Bright, the marketing manager for Mountain Mist soft drink needs to decide how many TV spots and magazine advertisements to run during the next quarter. Each TV spot costs $5,000 and is expected to increase sales by 300,000 cans. Each magazine advertisement costs $2,000 and is expected to increase sales by 500,000 cans. The total soft drink advertising budget for the next quarter is set at $100,000; however Mountain Mist wants to spend no more than $70,000 on TV spots and no more than $50,000 on magazine ads. Mountain Mist earns a profit of 5 cents on each can of soft drink it sells. Joe has decided to use linear programming to find the most profitable mix of advertisements. He asks for your help.(a) What are the decision variables for this problem?(b) Using decision variables identified in part (a), formulate the objective function for this problem. Is the quantity of interest to be maximized or minimized?(c) What are the constraints relevant to this problem? Using the decision variables from part (a), formulate those constraints.(d) Give the full mathematical model for this problem

Prior to beginning work on this assignment, read Chapter 10.Complete Problem 50 in Chapter 10 on page 477.10-55) A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales.Assume the only factor influencing monthly sales is price. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best?Interpret your best-fitting equation.Using the best-fitting equation, predict sales during a month in which the price is $470.In the discussion area, attach the Excel document showing work.