[go: up one dir, main page]

0% found this document useful (0 votes)
30 views7 pages

2019 Excel 203 CookieDough

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 7

Cookie Dough

Production Costs (per pound)


Flavors Cost Markup Price Margin
Chocolate Purge 2.32 1.80 6.50 4.18
Nutty Purge 3.25 0.96 6.37 3.12
Vanilla Bean Chunk 2.56 1.28 5.84 3.28
Pancake Syrup 2.59 1.25 5.83 3.24
Caramel Pavement 2.05 1.80 5.74 3.69
Cinnamon Donut 2.14 1.65 5.68 3.54
Mocha Coffee 1.98 1.80 5.55 3.57
Black Bean Chocolate 2.28 1.34 5.34 3.06
Pistachio and Pecans 2.36 1.20 5.20 2.84
Blueberry Chocolate 1.78 1.80 4.99 3.21
Red Hot Chili Chocolate 1.77 1.80 4.96 3.19
Chocolate Heaven Purge 1.76 1.80 4.93 3.17
Caramel Chunk 1.79 1.50 4.48 2.69
Jawbreaker Mint 1.54 1.80 4.32 2.78
Pecan and Peanut Truffle 1.46 1.80 4.09 2.63
Cheesecake Caramel 1.35 1.80 3.78 2.43
Cracker Jacker 1.28 1.80 3.59 2.31
Raspberry Chocolate 1.25 1.80 3.50 2.25
Chocolate Cherry 1.11 1.80 3.11 2.00
Cashew Crunch 1.50 1.03 3.05 1.55
Bacon Bits 1.08 1.80 3.03 1.95
White Chunky Chocolate 0.28 5.86 1.93 1.65
Triple Chocolate 0.35 2.30 1.16 0.81
Cookie Dough
Profit Margins (per pound)
Flavors Cost Price Sales Expense Income Total Profit
Chocolate Splurge 2.14 5.68 662 1416.68 3760.16 2343.48
Nutty Splurge 2.36 5.20 592 1397.12 3078.40 1681.28
Vanilla Bean Chunk 2.59 5.83 264 683.76 1539.12 855.36
Pancake Syrup 1.78 4.99 264 469.92 1317.36 847.44
Caramel Pavement 1.76 4.93 260 457.60 1281.80 824.20
Cinnamon Donut 1.54 4.32 264 406.56 1140.48 733.92
Mocha Coffee 2.56 5.84 204 522.24 1191.36 669.12
Black Bean Chocolate 1.46 4.09 233 340.18 952.97 612.79
Pistachio and Pecans 1.28 3.59 260 332.80 933.40 600.60
Blueberry Chocolate 2.32 6.50 143 331.76 929.50 597.74
Red Hot Chili Chocolate 1.25 3.50 260 325.00 910.00 585.00
Chocolate Heaven Splurge 2.28 5.34 178 405.84 950.52 544.68
Caramel Chunk 0.35 1.16 662 231.70 767.92 536.22
Jawbreaker Mint 2.05 5.74 140 287.00 803.60 516.60
Pecan and Peanut Truffle 1.98 5.55 143 283.14 793.65 510.51
Cheesecake Caramel 3.25 6.37 154 500.50 980.98 480.48
Cracker Jacker 1.77 4.96 143 253.11 709.28 456.17
Raspberry Chocolate 1.08 3.03 233 251.64 705.99 454.35
Chocolate Cherry 1.35 3.78 178 240.30 672.84 432.54
Cashew Crunch 1.79 4.48 154 275.66 689.92 414.26
Bacon Bits 0.28 1.93 189 52.92 364.77 311.85
White Chunky Chocolate 1.11 3.11 140 155.40 435.40 280.00
Triple Chocolate 1.50 3.05 174 261.00 530.70 269.70

Average Costs Per Flavor


Flavor Expenses, Income, and Profit

Expense Income

4000.00

3500.00

3000.00

2500.00

2000.00

1500.00

1000.00

500.00

0.00
e e
rg urg hun yru
k p t
en onu ffe
t e e
at can
s
at
e e e
at urg hun Min uffl
k t e el ker ate ry ch ts te ate
l u l o l o l l m c o l er run n Bi ola l
Sp S p an C k e
S
v em D C oco
Pe oc oc o
S pl
l C er T r
a ra
r J a
oc Ch C o oc oco
a o n a h d h h e k u t C e h te w Ba c h h
te tty Be ca el P am oc an
h C n
an ry C ili C ve ram rea ean ake ack ry C ola she C C
ola u a a n n M i o r h a b c r r c k y
pl e
oc N ill P m Be ach ebe e Ca aw P C e o Ca n i
ra Ci
n tC eH nd ees
e
pb Ch hu Tr
Ch a n
Ca ck s t l u H o t J a s C
V
Bl
a Pi B d ol
a n Ch Ra hi
te
Re hoc eca
P W
C
0.00
ge rge unk rup ent nut ffee late ans late late rge unk in
t e el ker ate rry nch Bit
s
at
e
at
e
l ur l u h y m o o o c o o l u h M ruffl
a m c ol e u ol ol
Sp S p an C k e
S
ve on D ha C hoc d P
e c c p C r
tT
r
rJ
a c Ch Cr con c c
e y a a C n Cho Cho n S el a ke u Ca e Cho te w a Cho Cho
t e P oc an e m n e k la she B
ol
a utt a B c
an me nna
l m a i
rry Chil eav ara wbr
e
ea cak Crac erry oco y le
oc N i l l P i
M
B e hio
be C P e b h Ca unk rip
h n ra C c t H a d s h T
C Va Ca
k
ac Pist
a ue Ho ate J an hee as
p C C
Bl Bl d ol a n C R i te
Re hoc Pe
c
W
h
C
enses, Income, and Profit

Expense Income

at
e e e k
at urg hun Min uffl
t e el ker ate ry ch ts te ate
o l l m c o l er run n Bi ola l
oc hoc
o l
Sp el C ker ut T
r
a ra
r J a
oc Ch C o o c oco
n C e h te w Ba c h h
C a C C C
ili a ve ram bre e an ake rack rry co la she
k y l e
h Ca aw P c Ca n i p
C He J nd ees
e C
pb
e
Ch
o
hu Tr
te a s C
ol
a n Ch Ra hi
te
oc eca
P W
te ate rge unk in
t
ffl
e el ker ate rry nch Bit
s
at
e
at
e
ola ol l u h M ru a m c ol e u ol ol
oc hoc Sp el C ker ut T r
rJ
a c Ch Cr con c c
C n a Ca e Cho te w a Cho Cho
ve ram re n e k a e B
ili ea ak ac ry ol ash y le
Ch Hea Ca awb d P sec Cr ber hoc C unk rip
J C h T
te an hee sp C
o la a n C Ra hi te
oc c
Pe W

You might also like