Please provide correct excel formulas:

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.

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$

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

Snickerdoodle Inc. has provided the following relating to the most recent month $($September

$30,2020)$ of operations, for their main product, cookies.

Required:

Prepare a schedule of cost of goods manufactured in good format.

Prepare the cost of goods sold section of the income statement.

Prepare an income statement in good format.

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$.$