Please answer the following question in excel

You will create income statements in Excel linking absolutely every cell you can. If changes occur in the raw data, the entire income statement should update without having to re$-$type any data. Also, any time you would need a calculator to add$/$subtract$/$multiply$/$divide$,$ the cells MUST be linked. ALL RAW DATA NEEDS TO BE SHOWN AT THE TOP OF THE SPREADSHEET.

Purpose

The overall purpose of this assignment is to enhance your skills with Excel relating to linking raw data into a schedule that will be useful to managers. It will also help you integrate and understand the difference between a contribution margin income statement and a gross margin income statement.

Required

In Excel, create a solution with one excel tab labelled "Actual" and one tab labelled "Standard". $($Do NOT use my spreadsheets.$)$ All cells on the income statement MUST be linked to the raw data that is shown at the top of each spreadsheet. Your solution needs to have the following items in the following order:

The tab called "ACTUAL" MUST contain:

a$.$ Raw data for units and all costs for ACTUAL costing AT THE TOP OF THE SPREADSHEET.

b$.$ Variable costing $($contribution margin$)$ income statement using ACTUAL costing for October and November.

c$.$ Absorption costing $($gross margin$)$ income statement using ACTUAL costing for October and November.

The tab called "STANDARD" MUST contain:

d$.$ Raw data for units and all costs for STANDARD costing AT THE TOP OF THE SPREADSHEET.

e$.$ Variable costing $($contribution margin$)$ income statement using STANDARD costing for October and November.

f$.$ Absorption costing $($gross margin$)$ income statement using STANDARD costing for October and November.

Adrena Manufacturing Ltd$.$ has just created a new division to manufacture and sell an advanced TENS device. The facility is highly automated and has high monthly fixed costs, as shown in the following schedule of budgeted monthly costs. This schedule was prepared based on an expectation of a monthly production volume of $\backslash (3,500\backslash$mathrm$\{$units$\}\backslash ).$

The selling price per unit is $\backslash (\backslash$$ $240\backslash ).$

The following activity was recorded:

REQUIRED:

See the details of the "Required" on page $1.$