I need a step by step process for this project

Excel$\_8$E$\_$Seafood$\_$Inventory

Project Description:

In this project, you will use the moving average tool for Joe Flores, manager of the Dallas region, who wants to analyze the fluctuation in the quantity of shrimp that is used at the four Dallas restaurants and determine the projected break$-$even point for the year.

$1$

Open the Excel workbook Student$\_$Excel$\_8$E$\_$Seafood$\_$Inventory.xlsx downloaded with the Project.

$2$

Ensure that the Analysis ToolPak is enabled. On the Moving Average worksheet, insert a Moving Average using the range A$5$:AB$5$ as the Input Range. Type $4$ as the Interval and use cell A$6$ as the Output Range. Select only the Chart Output check box; do NOT select the Labels in First Row check box.

$3$

Position the chart between cells C$8$ and Z$29,$ keeping the chart slightly inside the cell borders.

$4$

Edit the Vertical $($Value$)$ Axis Title to Bags of Shrimp Used. Edit the Horizontal $($Category$)$ Axis Title to Four$-$Week Period

$5$

To display the days of the week as the Horizontal $($Category$)$ Axis Labels, at the bottom of the chart, point to any of the data points, and then click one time to select the axis. From the Design tab, display the Select Data Source dialog box, and then edit the Horizontal $($Category$)$ Axis Labels by selecting the range A$4$:AB$4$; click OK two times.

$6$

To plot the Forecast series on a secondary axis, on the chart, point to the Series $$Forecast$$ line, double$-$click the line to display the Format Data Series pane, and then plot the series on the Secondary Axis.

$7$

Format the Chart Area and the Plot Area with a Solid fill. As the Color, in the eighth column, click the second color. Format the range D$6$:AB$6$ with the Comma $[0]$ cell style.

$8$

Display the Projected Income worksheet. In cell C$3,$ construct a formula that takes the previous month$$s sales in cell B$3$ and multiplies it by $110\%$ to determine a growth rate of $10\%$ shown in B$13(1+$$b$$13).$ Copy the formula across to cell M$3.$ Copy the formula in cell B$9$ across to cell M$9.$

$9$

To create a line chart with a second series, select the nonadjacent ranges A$2$:M$3$ and A$9$:M$9,$ and then insert the first Line chart style.

$10$

Change the Chart Title to Expected Break$-$Even Point

$11$

Position the chart between cells B$15$ and M$36,$ keeping the chart slightly inside the cell borders.

$12$

Double$-$click a value on the vertical axis, and then in the Format Axis pane, display the Axis Options. Set the Minimum bounds to $150000$ and the Maximum to $500000$ to provide more vertical space on the chart to show a more dramatic slope.

$13$

Format both the Plot Area and the Chart Area with a Solid fill. As the Color, in the fifth column, click the second color.

$14$

Deselect the chart. Select all the sheets, and then display the Page Setup dialog box. Insert a custom footer in the left section that includes the file name, and then center the worksheets horizontally. On the ribbon, set the Orientation to Landscape, and scale the Width to $1$ page.

$15$

Display the document properties. As the Tags, type Dallas, seafood inventory and as the Subject, type your course name and section number.

$16$: Moving Average, Projected Income. Save and close the file and then submit for grading.