Please provide correct excel formulas and cell references for this question, don't type in the numbers. Thank you!

Question $2-18$ Points $($to save time, copy the problem and paste it in Excel$)$

Use the table below to classify each of the costs $($place the amount in

the appropriate cell$)$ of the following: Variable or Fixed, then if it is Direct

Material, Direct Labour, Manufacturing Overhead, or period cost. Write

the total dollar amount for each type of cost$.$

Calculate the total of each column.

Calculate the EBIT based on selling $3,500$ pots at a sale price of $$40$ each

for the month of January.

Prepare your assignment using Excel $($this is part of the course learning outcomes$).$

Points will be deducted from your grade if the guidelines below are not followed. Post

any Excel questions in the $Q$&$A.$

Use text boxes or word wrapping for your explanations.

Use cell references in all formulas and functions $($no numbers$).$

Use a formula or function for all calculations, don't type in the answer.

Use a formula for transferring data from one sheet to another $(=$cell reference$).$

Use the sum function appropriately. It should be used when adding more than two

consecutive numbers. Example: $=$sum$($C$14$:C$23)$ It should not be used when subtracting,

multiplying or dividing. Don't do this: $=$ sum$($C$14+$C$16-$C$15)$ Instead do this: $=$ C$14+$C$16-$

C$15$

Format accordingly:

All values must be accompanied by an appropriate label.

Numbers should be aligned and formatted properly.