practice workbook chapter 03
xlsx
keyboard_arrow_up
School
Central New Mexico Community College *
*We aren’t endorsed by this school
Course
101
Subject
History
Date
Dec 6, 2023
Type
xlsx
Pages
13
Uploaded by ChancellorSnow12162
Item
Pints sold
Pilsner
38
Belgian Style Dubbel
27
Amber ale
16
Classic IPA 61
Special Edition DIPA
43
Porter
18
Imperial Stout
35
Total Served
Use the spreadsheet tools to calculate the percentage of each style of beer sold at your taproom for this day. % of total served
Click here to check your work
Click here to go to the next activity
You will need t
the total--by th
anchor functio
=D9/$C$17
. . . and use the
to divide each of the beer styles--as well as he total served in cell C17, so you can use the on in cell D10 by typing: e fill handle to drag down to row 17.
% of total served
Item
Pints sold
Pilsner
38
16.0%
0.0%
Belgian Style Dubbel
27
11.3%
0.0%
Amber ale
16
6.7%
0.0%
Classic IPA 61
25.6%
0.0%
Special Edition DIPA
43
18.1%
0.0%
Porter
18
7.6%
0.0%
Imperial Stout
35
14.7%
0.0%
Total Served (correct)
238
100.0%
0.0%
Your answer
0
Click on the shaded cells below to see how each cell was calculated. If you used the anchor function for column D, you would have been able to use the fill handle to calculate the numbers for the whole column. Correct answer
Your answer
Click here to go back and review your answers
Click here to go to the next activity
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Item
Popularity index
Pilsner
16.0%
72
Belgian Style Dubbel
11.3%
Amber ale
6.7%
Classic IPA 25.6%
Special Edition DIPA
18.1%
Porter
7.6%
Imperial Stout
14.7%
Total Served
100.0%
450
Assuming customer preferences remain steady, we can use the popularity index we calculated in the previous exercise to predict future sales. If we project 450 beers sold for the next day, use the spreadsheet tools to calculate the percentage of each style of beer you would be likely to sell. Projected Sales
Click here to check your work
Click here to go to the next activity
click here to go to the previous activity
Hint: Use the "ROUNDU
next-highest who
Use the anchor fu
UP" function and round to the ole number. unction to speed up your work.
Item
Popularity index
Pilsner
16.0%
72
72
Belgian Style Dubbel
11.3%
52
0
Amber ale
6.7%
31
0
Classic IPA 25.6%
116
0
Special Edition DIPA
18.1%
82
0
Porter
7.6%
35
0
Imperial Stout
14.7%
67
0
Total Served
100.0%
450
Since we can't predict a partial sale, we should round these numbers up to the nex
number; rounding down would mean the sale won't happen. Because of the round
our total projected served will actually be slightly higher than the 450 total we were
predicting. Projected Sales
Your answer
Click here to go back and change your answers
Click here to go to the next activity
click here to go to the previous activity
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
xt whole ding up, e
You are working on a standardized recipe for a menu item containing eggs. In below, write down at least five different forms of eggs you could purchase from
foodservice vendor. Different forms could include different pack sizes, quality, Several types of egg products will be on the next page, but resist the temptatio
until you have a few on the list here.
column B m a or type. on to check click here to see what kinds of eggs are available
click here to go to the next activity
click here to go to the previous activity
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Your responses:
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
This is just a smal sample of three full pages of o
short explanation regarding specifications if you'
Depending on their intended purpose, customer etc., your choice of products can be an importan
specifications and understanding the appropriate
and the purchasing level.
Just a few examples:
Egg, shell, large, white AA, 1/15 dzn.
Egg, shell, large, white AA, 15/1 dzn.
Egg, shell, large, brown, AA, CF
Egg, shell, large, white, A, pasteurized, CF
Egg, hardboiled, whole peeled select
Egg patty square IQF 1.5 oz. Egg quail 1/24 pack
Egg duck 1/20 cnt
Egg scrambled precooked 10/2 lbs. Egg scramble mix cook in bag 6/5 lbs. Egg whole liquid fresh 2/20 lbs.
Egg whole liquid fresh 15/2 lbs.
Egg yolk unsugared liquid 15/1 lbs.
Egg white 1/30 lbs.
Omelet egg with cheese IQF folded 72/3.5 oz. one of our larger vendors. Click on any shaded cell for a 're curious. base, sales volume, storage, style of service, budget, nt way to save or lose money. Developing clear product e jargon is important at both the recipe development level click here to go back and review your an
click here to finish up!
click here to go to the previous activ
nswers
vity
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Did you complete this workbook? To receive credit for completing this practice workbook, save this file to include your last name, e.g. "jsmith practice workbook chapter 03.xlsx" and submit it on the module page where you downloaded it. Completed workbooks turned in before the due date/time will be credited at 100% for grading purposes. Incomplete workbooks earn 0%. All the answers are included here, so this should be an easy task. If you have any questions about these exercises, your reading, the homework, or anything else, contact the instructor via email, office visit, or text message. Sooner is better! These exercises were pretty basic, but things will eventually get more challenging!
You can use the links on the workbook pages to review or redo any question, or click directly on the worksheet tabs on the bottom of the window. click here to go back to the beginning and check your work
click here to go to the previous activity