EDIT: Create an Excel Worksheet given the following objectives and data.

Objective: We would like to know how much of each type of filling (in pounds) we need to make sandwiches for next week and if fillings need to be ordered.

Note: You are able to organize the criteria in your own way as long as we meet the criteria.

Step 1: Input column labels

Sandwiches Offered

Sandwich size: (in ounces)

sandwiches sold per day

Supplies on hand

Sandwiches Sold Each week

Weekly supplies used (in ounces)

Weekly Supplies used (in pounds)

Supplies to be ordered (in ounces)

Supplies to be ordered (in pounds)

Reorder

Step 2: Input Row Labels

Sandwich Names i.e. Roast Beef, Ham, Turkey, Chicken, Veggie, American Cheese, Provolone Cheese

Total Row

Days Open

Ounces in a pound

Step 3: Input data (Example below is for Roast Beef Sandwich)

Sandwiches Offered i.e. Roast Beef

Sandwich size: filling need in ounces i.e. 3

Total number of sandwiches sold per day i.e. 10

Supplies on hand i.e. 96

Step 4: Compute (Create formulas)

Number sandwiches sold each week - Do not include the number 6 in your formula, instead reference the cell and use an absolute reference. (See screenshot below, cell $B$14))

Weekly supplies used in ounces

Weekly supplies to be ordered in ounces (replenish inventory)

Weekly supplies used in pounds (use absolute reference for the number of ounces in a pound- see screenshot below, Cell $B$15)

Weekly supplies to be ordered in pounds (replenish inventory) (use absolute reference the number of ounces in a pound -see screenshot below, Cell $B$15

Include Totals for all columns

Step 5: Analysis

Create a meaningful chart with the chart title

Create an IF Statement - If the supplies on hand are less than 6 pounds, then Order, if not, then No Order

Needed Data

Notes for Tastee Sandwich Shop Inventory

The shop is open Monday through Saturday. It is closed on Sunday.

The slicing machine for meat and cheese cuts slices that weigh 1 ounce each.

We use a 4-ounce scoop to measure veggies for our veggie special sandwich.

Average Daily Sandwich Sales

Roast beef (3 oz per sandwich) We sell 10 sandwiches a day.

Ham (3 oz) sell 8 sandwiches a day

Turkey (4 oz) 10 a day

Chicken (3 oz) 7 a day

Veggies (4 oz) per sandwich 6 per day

American cheese (2 slices/sandwich, each slice weighs 1 oz) 8 sandwiches a day

Provolone (2 slices/sandwich, each slice weighs 1 oz) 4 sandwiches a Day

We currently have on hand:

Roast beef 96 oz

Ham 32 oz

Turkey 48 oz

Chicken 32 oz

Veggies 48 oz

Cheeses - 0 oz