Supplied Analysis - based on demand; these are the target products to produce to meet the targeted demand

Supplies Analysis
Based on 20% Targeted Demand
Legend:
whole cake = 10 slices
set of cupcakes = 12 pcs
Supplied Analysis - based on demand; these are the target products to produce to meet the targeted demand
Demand Analaysis - based on survey on which to project the total demand (people) that are willing to buy cakes and the store on which they usually buy the product
demand analaysis
area Population (based on Survey)
Year Population Growth rate
Total Target
Population
Market
Acceptability
(buyers) Total Demand
2014 17,385 17,385 69.71%
2015 17,385 4.50% 18,167 69.71% 12,664
2016 18,167 4.50% 18,985 69.71% 13,234
2017 18,985 4.50% 19,839 69.71% 13,830
2018 19,839 4.50% 20,732 69.71% 14,452
2019 20,732 4.50% 21,665 69.71% 15,103
Competitor Market Shares
(based on suvey)
Goldilocks Red Ribbon Starbucks
Others-
competitor
within the area
23% 33% 9% 5%
2015 12,664 2,913 4,179 1,140 633
2016 13,234 3,044 4,367 1,191 662
2017 13,830 3,181 4,564 1,245 691
2018 14,452 3,324 4,769 1,301 723
2019 15,103 3,474 4,984 1,359 755
No of demand on different frequency
Base on targeted demand
1
Legend: 2
whole cake = 10 slices 3
set of cupcakes = 12 pcs 4
5
`
5624 45%
Whole Cake Frequency
Sure Buyer
(70%) based
on Projected
Market
Projected
Demand
Sure Buyer (70%)
based on
Projected
Market
Weekly 5% 52 767 1,993 802
2x a month 20% 24 767 3,679 802
2015 2016
Once a month 75% 12 767 6,899 802
100% 12,571
Piece of Cup cakes Frequency
Projected
Market (30%
based on sure
buyer)
Projected
Demand
Projected
Market (30%
based on sure
buyer)
Weekly 5% 52 230 598 241
2x a month 20% 24 230 1,104 241
Once a month 75% 12 230 2,071 241
100% 3,774
1
2
3
4
5
Beverages
Frequency
Projected
Market (70%
based on sure
buyer)
Projected
Demand
Projected
Market (70%
based on sure
buyer)
Weekly 5% 52 537 1,396 561
2x a month 20% 24 537 2,577 561
Once a month 75% 12 537 4,832 561
100% 8,805
1
2
3
4
5
2015 2016
2015 2016
Demand Analaysis - based on survey on which to project the total demand (people) that are willing to buy cakes and the store on which they usually buy the product
Target Market
opportunity
Allowance target
Market Rate
Projected Target
Market (demand)
Willing to try
Emporia
Product
30% 30% 86.48%
3,799 10% 1266 1,095
3,970 10% 1323 1,145
4,149 10% 1383 1,196
4,336 10% 1445 1,250
4,531 10% 1510 1,306
72% 28%
demand qnty whole slice
12,571 85% 10,685 7,743 2,943
13,145 85% 11,173 8,096 3,077
13,730 85% 11,671 8,456 3,214
14,350 85% 12,198 8,838 3,359
14,993 85% 12,744 9,234 3,510
Projected
Demand
Sure Buyer (70%)
based on Projected
Market
Projected
Demand
Sure Buyer
(70%) based on
Projected
Market
Projected
Demand
Sure Buyer (70%)
based on
Projected
Market
2,084 837 2,177 875 2,275 914
3,847 837 4,019 875 4,200 914
2016 2017 2018 2019
7,214 837 7,535 875 7,875 914
13,145 13,730 14,350
Projected
Demand
Projected Market
(30% based on
sure buyer)
Projected
Demand
Projected
Market (30%
based on sure
buyer)
Projected
Demand
Projected
Market (30%
based on sure
buyer)
626 251 653 263 683 274
1,155 251 1,205 263 1,260 274
2,165 251 2,260 263 2,363 274
3,946 4,118 4,305
demand year qnty per pc yearly set monthly set
3,774 70% 1,698 142 12
3,946 70% 2,762 230 19
4,118 70% 2,883 240 20
4,305 70% 3,014 251 21
4,497 70% 3,148 262 22
Projected
Demand
Projected Market
(70% based on
sure buyer)
Projected
Demand
Projected
Market (70%
based on sure
buyer)
Projected
Demand
Projected
Market (70%
based on sure
buyer)
1,460 586 1,523 613 1,593 640
2,695 586 2,812 613 2,940 640
5,053 586 5,273 613 5,513 640
9,207 9,609 10,045
demand
8,805 70% 6,164
9,207 70% 6,445
9,609 70% 6,726
10,045 70% 7,032
10,493 70% 7,345
2016 2017 2018 2019
2016 2017 2018 2019
Projected Demand
2,377
4,388
2019
8,228
14,993
Projected Demand
713
1,316
2,468
4,497
Projected Demand
1,663
3,071
5,758
10,493
2019
2019
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 649 54.08 1.80 55.00 11 65
Layered Crme Brulee Cheesecake 9.54% 738 61.54 2.05 62.00 13 75
Macademia Sansrival 6.94% 537 44.76 1.49 45.00 9 54
Green tea Layered Cake 3.18% 246 20.51 0.68 21.00 5 26
Ultimate Chocolate Fudge Layer Cake 16.47% 1,276 106.30 3.54 107.00 22 128
Chocolate Oblivion Truffle Torte 23.99% 1,857 154.79 5.16 155.00 31 186
Dulce De Leche with Caramel Buttercream 13.29% 1,029 85.78 2.86 86.00 18 104
Mocha Tiramisu Cake 15.61% 1,208 100.70 3.36 101.00 21 122
Lemon Torte 2.60% 201 16.78 0.56 17.00 4 21
Total 100.00% 7,743 645.25 21.51
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 679 56.55 1.88 57.00 12 69
Layered Crme Brulee Cheesecake 9.54% 772 64.35 2.14 65.00 13 77
Macademia Sansrival 6.94% 562 46.80 1.56 47.00 10 57
Green tea Layered Cake 3.18% 257 21.45 0.71 22.00 5 26
Ultimate Chocolate Fudge Layer Cake 16.47% 1,334 111.15 3.70 112.00 23 134
Chocolate Oblivion Truffle Torte 23.99% 1,942 161.84 5.39 162.00 33 195
Dulce De Leche with Caramel Buttercream 13.29% 1,076 89.70 2.99 90.00 19 109
Mocha Tiramisu Cake 15.61% 1,264 105.30 3.51 106.00 22 127
Lemon Torte 2.60% 211 17.55 0.58 18.00 4 22
Total 8,096 674.68 22.49
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 709 59.06 1.97 60.00 12 71
Layered Crme Brulee Cheesecake 9.54% 807 67.21 2.24 68.00 14 81
Macademia Sansrival 6.94% 587 48.88 1.63 49.00 10 59
Green tea Layered Cake 3.18% 269 22.40 0.75 23.00 5 27
Ultimate Chocolate Fudge Layer Cake 16.47% 1,393 116.09 3.87 117.00 24 140
Chocolate Oblivion Truffle Torte 23.99% 2,029 169.05 5.63 170.00 35 204
Dulce De Leche with Caramel Buttercream 13.29% 1,124 93.69 3.12 94.00 19 113
Mocha Tiramisu Cake 15.61% 1,320 109.98 3.67 110.00 23 133
Lemon Torte 2.60% 220 18.33 0.61 19.00 4 22
Total 8,456 704.70 23.49
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 741 61.73 2.06 62.00 13 75
Layered Crme Brulee Cheesecake 9.54% 843 70.24 2.34 71.00 15 85
Macademia Sansrival 6.94% 613 51.09 1.70 52.00 11 62
Green tea Layered Cake 3.18% 281 23.41 0.78 24.00 5 28
Ultimate Chocolate Fudge Layer Cake 16.47% 1,456 121.33 4.04 122.00 25 146
Chocolate Oblivion Truffle Torte 23.99% 2,120 176.68 5.89 177.00 36 213
Dulce De Leche with Caramel Buttercream 13.29% 1,175 97.92 3.26 98.00 20 118
Mocha Tiramisu Cake 15.61% 1,379 114.95 3.83 115.00 24 139
Lemon Torte 2.60% 230 19.16 0.64 20.00 4 23
Total 8,838 736.51 24.55
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 774 64.50 2.15 65.00 14 78
Layered Crme Brulee Cheesecake 9.54% 881 73.39 2.45 74.00 15 88
Macademia Sansrival 6.94% 641 53.38 1.78 54.00 11 64
Green tea Layered Cake 3.18% 294 24.46 0.82 25.00 5 29
Ultimate Chocolate Fudge Layer Cake 16.47% 1,521 126.77 4.23 127.00 26 153
Chocolate Oblivion Truffle Torte 23.99% 2,215 184.60 6.15 185.00 38 223
Dulce De Leche with Caramel Buttercream 13.29% 1,228 102.31 3.41 103.00 21 123
Mocha Tiramisu Cake 15.61% 1,441 120.10 4.00 121.00 25 145
Lemon Torte 2.60% 240 20.02 0.67 21.00 5 25
Total 9,234.34 769.53 25.65
2018
2019
2017
2015
2016
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 246.65 20.55 0.69 247.00 2.055389 3
Layered Crme Brulee Cheesecake 9.54% 280.67 23.39 0.78 281.00 2.338891 3
Macademia Sansrival 6.94% 204.12 17.01 0.57 205.00 1.701012 2
Green tea Layered Cake 3.18% 93.56 7.80 0.26 94.00 0.77963 1
Ultimate Chocolate Fudge Layer Cake 16.47% 484.79 40.40 1.35 485.00 4.039902 5
Chocolate Oblivion Truffle Torte 23.99% 705.92 58.83 1.96 706.00 5.882665 6
Dulce De Leche with Caramel Buttercream 13.29% 391.23 32.60 1.09 392.00 3.260272 4
Mocha Tiramisu Cake 15.61% 459.27 38.27 1.28 460.00 3.827276 4
Lemon Torte 2.60% 76.55 6.38 0.21 77.00 0.637879 1
Total 2,943 245.23 8.17
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 257.91 21.49 0.72 2.149236 3
Layered Crme Brulee Cheesecake 9.54% 293.48 24.46 0.82 2.445682 3
Macademia Sansrival 6.94% 213.44 17.79 0.59 1.778678 2
Green tea Layered Cake 3.18% 97.83 8.15 0.27 0.815227 1
Ultimate Chocolate Fudge Layer Cake 16.47% 506.92 42.24 1.41 4.22436 5
Chocolate Oblivion Truffle Torte 23.99% 738.15 61.51 2.05 6.151262 7
Dulce De Leche with Caramel Buttercream 13.29% 409.10 34.09 1.14 3.409133 4
Mocha Tiramisu Cake 15.61% 480.24 40.02 1.33 4.002026 5
Lemon Torte 2.60% 80.04 6.67 0.22 0.667004 1
Total 3,077.11 256.43 8.55
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 269.39 22.45 0.75 2.244885 3
Layered Crme Brulee Cheesecake 9.54% 306.54 25.55 0.85 2.554524 3
Macademia Sansrival 6.94% 222.94 18.58 0.62 1.857836 2
Green tea Layered Cake 3.18% 102.18 8.52 0.28 0.851508 1
Ultimate Chocolate Fudge Layer Cake 16.47% 529.48 44.12 1.47 4.41236 5
Chocolate Oblivion Truffle Torte 23.99% 771.00 64.25 2.14 6.425015 7
Dulce De Leche with Caramel Buttercream 13.29% 427.30 35.61 1.19 3.560852 4
Mocha Tiramisu Cake 15.61% 501.62 41.80 1.39 4.18013 5
Lemon Torte 2.60% 83.60 6.97 0.23 0.696688 1
Total 3,214.06 267.84 8.93
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 281.54 23.46 0.78 2.346193 3
Layered Crme Brulee Cheesecake 9.54% 320.38 26.70 0.89 2.669806 3
Macademia Sansrival 6.94% 233.00 19.42 0.65 1.941677 2
Green tea Layered Cake 3.18% 106.79 8.90 0.30 0.889935 1
Ultimate Chocolate Fudge Layer Cake 16.47% 553.38 46.11 1.54 4.611483 5
Chocolate Oblivion Truffle Torte 23.99% 805.80 67.15 2.24 6.714967 7
Dulce De Leche with Caramel Buttercream 13.29% 446.59 37.22 1.24 3.721548 4
Mocha Tiramisu Cake 15.61% 524.25 43.69 1.46 4.368774 5
Lemon Torte 2.60% 87.38 7.28 0.24 0.728129 1
Total 3,359.10 279.93 9.33
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Red Velvet and Raspberry Supreme Cake 8.38% 294.17 24.51 0.82 2.451388 3
Layered Crme Brulee Cheesecake 9.54% 334.74 27.90 0.93 2.78951 3
Macademia Sansrival 6.94% 243.45 20.29 0.68 2.028735 3
Green tea Layered Cake 3.18% 111.58 9.30 0.31 0.929837 1
Ultimate Chocolate Fudge Layer Cake 16.47% 578.19 48.18 1.61 4.818245 5
Chocolate Oblivion Truffle Torte 23.99% 841.92 70.16 2.34 7.016042 8
Dulce De Leche with Caramel Buttercream 13.29% 466.61 38.88 1.30 3.888409 4
Mocha Tiramisu Cake 15.61% 547.76 45.65 1.52 4.564654 5
Lemon Torte 2.60% 91.29 7.61 0.25 0.760776 1
Total 3,509.71 292.48 9.75
2018
2019
2017
2015
2016
Drinks Percentage Annual Quantity Monthly Quantity Daily Quantity
Freshly Brewed Coffee 25.00% 991 83 2.75
Hot Chocolate 11.00% 436 36 1.21
Iced Coffee 27.00% 1,070 89 2.97
Orange Juice 16.00% 634 53 1.76
Mango Juice 13.00% 515 43 1.43
Bottled Water 8.00% 317 26 0.88
Total 3,962 330 11.01
Drinks Percentage Annual Quantity Monthly Quantity Daily Quantity
Freshly Brewed Coffee 25.00% 1,036 86 2.88
Hot Chocolate 11.00% 456 38 1.27
Iced Coffee 27.00% 1,119 93 3.11
Orange Juice 16.00% 663 55 1.84
Mango Juice 13.00% 539 45 1.50
Bottled Water 8.00% 331 28 0.92
Total 4,143 345 11.51
Drinks Percentage Annual Quantity Monthly Quantity Daily Quantity
Freshly Brewed Coffee 25.00% 1,081 90 3.00
Hot Chocolate 11.00% 476 40 1.32
Iced Coffee 27.00% 1,167 97 3.24
Orange Juice 16.00% 692 58 1.92
Mango Juice 13.00% 562 47 1.56
Bottled Water 8.00% 346 29 0.96
Total 4,324 360 12.01
Drinks Percentage Annual Quantity Monthly Quantity Daily Quantity
Freshly Brewed Coffee 25.00% 1,130 94 3.14
Hot Chocolate 11.00% 497 41 1.38
Iced Coffee 27.00% 1,220 102 3.39
Orange Juice 16.00% 723 60 2.01
Mango Juice 13.00% 588 49 1.63
Bottled Water 8.00% 362 30 1.00
Total 4,520 377 12.56
Drinks Percentage Annual Quantity Monthly Quantity Daily Quantity
Freshly Brewed Coffee 25.00% 1,180 98 3.28
Hot Chocolate 11.00% 519 43 1.44
Iced Coffee 27.00% 1,275 106 3.54
Orange Juice 16.00% 755 63 2.10
Mango Juice 13.00% 614 51 1.71
Bottled Water 8.00% 378 31 1.05
Total 4,722 393 13.12
2015
8
2017
2018
2019
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity roundup per set 1698
Oreo Cheesecake 37.70% 640 53.35 1.78 54.00 5 2762.2
Boston Cream cake 12.30% 209 17.40 0.58 18.00 2 2882.6
Rainbow Cupcake 24.20% 411 34.24 1.14 35.00 3 3013.5
Red velvet 25.80% 438 36.51 1.22 37.00 3 3147.9
Total 100.00% 1,698 141.50 4.72
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Oreo Cheesecake 37.70% 1,041 86.78 2.89 87.00 7
Boston Cream cake 12.30% 340 28.31 0.94 29.00 2
Rainbow Cupcake 24.20% 668 55.70 1.86 56.00 5
Red velvet 25.80% 713 59.39 1.98 60.00 5
Total 100.00% 2,762 230.18 7.67
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Oreo Cheesecake 37.70% 1,087 90.56 3.02 91.00 8
Boston Cream cake 12.30% 355 29.55 0.98 30.00 3
Rainbow Cupcake 24.20% 698 58.13 1.94 59.00 5
Red velvet 25.80% 744 61.98 2.07 62.00 5
Total 100.00% 2,883 240.22 8.01
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Oreo Cheesecake 37.70% 1,136 94.67 3.16 95.00 8
Boston Cream cake 12.30% 371 30.89 1.03 31.00 3
Rainbow Cupcake 24.20% 729 60.77 2.03 61.00 5
Red velvet 25.80% 777 64.79 2.16 65.00 5
Total 100.00% 3,014 251.13 8.37
Flavor /Whole Percentage Annual Quantity Monthly Quantity Daily Quantity
Oreo Cheesecake 37.70% 1,187 98.90 3.30 99.00 8
Boston Cream cake 12.30% 387 32.27 1.08 33.00 3
Rainbow Cupcake 24.20% 762 63.48 2.12 64.00 5
Red velvet 25.80% 812 67.68 2.26 68.00 6
Total 100.00% 3,148 262.33 8.74
2015
2016
2017
2018
2019