CREATING AND USING YOUR OWN SPREADSHEET

Open SPREADSHEET F and locate Spreadsheet #$2.$

Input formulas in the appropriate cells that will calculate Units Needed, Number of each size and color needed, Total Number of each size needed, and Total Number of each color needed.

When you have completed the lesson, save the file as SPREADSHEET F$\_$COPY, and close the file.

PROBLEMS

You have a $$1,000$ budget to purchase $1$ sweatshirts for your store. All the sweatshirts will be purchased from Hanes for $$10$ each. The distribution of sizes will be as follows:

$\backslash$table$[[$Small$,20\%$