$10$

A $,$ B

B

$C$

D

E

F

G

$q,$

Part $2$ Requirements

Directions: Use Excel to calculate the cost of no bake cookies with Excel formulas required. Use the recipe provide below on rows $15-23.$ Calculate both $($a$)$ cost per batch and $($b$)$ cost per cookie to two decimal places. Create a new Excel worksheet to document your work. Make sure to include a heading for your worksheet with your name, name of the assignment and course. You will be graded on your Part a calculations $(8$ points$),$ Part b calculations $(2$ points$),$ use of Excel formulas $(5$ points$)$ and presentation in Excel $(5$ points$).$

No$-$bake cookies recipe

$6$ T Butter

$2$ c Sugar

$\frac{1}{2}$ c Milk

$3$ T Cocoa

$\frac{1}{2}$ c Peanut butter

$1$t Vanilla

$3c$ Quick Oats

Melt butter in a saucepan.

Add sugar, milk and cocoa.

Cook at medium heat until boiling.

Boil one minute only.

Remove from heat.

Add peanut butter, vanilla and oats.

Drop by the tablespoon on wax paper. Makes $36.$

ACC $232$ Excel Basics Assignment

ACC $231$ Excel Basics BLANK

Cost information:

$\backslash$table$[[$Ingredient$,$Size,$\backslash$table$[[$Pre$-$COVID$],[$Cost$]],\backslash$table$[[*$ Meijer$],[$Brand Cost$]],\backslash$table$[[**$ Name$],[$Brand Cost$]],\backslash$table$[[**$ Average$],[$Cost$]]],[$Butter$,1lb,$$$2\mathrm{.}79,$$$3\mathrm{.}89,$$$5\mathrm{.}79,$$$4\mathrm{.}84$