Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started