Scribd
Upload
15 views3 pages

Smores S

The document outlines projected sales and expenses for a business over three years, detailing expected revenue from smores and coffee crumble. It includes calculations for unit prices, packaging costs, and other expenses, leading to a total projected expense of approximately 1,165,500.00. The selling prices for smores and coffee crumble are set at 21.5 and 35.61, respectively.

Uploaded by

202410213
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
15 views3 pages

Smores S

The document outlines projected sales and expenses for a business over three years, detailing expected revenue from smores and coffee crumble. It includes calculations for unit prices, packaging costs, and other expenses, leading to a total projected expense of approximately 1,165,500.00. The selling prices for smores and coffee crumble are set at 21.5 and 35.61, respectively.

Uploaded by

202410213
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

pojected sales

selling price quantity year 1 year 2 year 3


smores 21.5 9,600 341,856.00 376,041.00 413,645.00
coffee crumble 35.61 4,800 103,200.00 113,520.00 124,872.00
TOTAL 14,400 445,056.00 489,561.00 538,517.00

projected expenses
year 1 year 2 year 3
supply 110,000.00 121,000.00 133,100.00
rent 120,000.00 132,000.00 145,200.00
marketing 50,000.00 55,000.00 60,500.00
equipment 300,000.00 330,000.00 363,000.00
maintenance 2,500.00 2,750.00 3,025.00
tools 12,000.00 13,200.00 14,520.00
permits and licenses 5,000.00 5,500.00 6,050.00
insurance 250,000.00 275,000.00 30,250.00
packaging and supplies 96,000.00 105,600.00 116,160.00
furnitures 100,000.00 110,000.00 133,100.00
utilities 120,000.00 132,000.00 145,200.00
TOTAL 1,165,500.00 ### 1,150,105.00

APPENDIX C

no. of smores sold per day 40 x 5 days operation = 200 x 4 weeks = 800 x 12 months = 9,600
no. of coffee crumble sold per day 20 x 5 days operation = 100 x 4 weeks = 400 x 12 months = 4,800
ingredients quantity quantity used unit cost total cost
graham cracker 48 pcs/210 g 48 pcs/ 210 g 42 42
mallow 36 pcs/100 g 24 pcs/66.66g 38 25.33
chocolate bar 500 g 115 g 125 28.75
TOTAL GRAM 388.89 96.08
388.89/16.20 = 24

computation for unit price


96.08/24 = 4
(2 pcs per serving) 8
packaging:
clamshell 6
sticker paper 1
cost per per serving 15

other expenses
utilities 1

vat 12 %
15 (12%) 1.8

mark-up 25%
15 (25%) 3.75
SELLING PRICE 21.5
ingredients quantity quantity used unit cost total cost
crushed ice 5kl/500g 1,525g 0.02 30.5
powdered milk 33g 23g 22 15.45
chocolate syrup 350 ml 80g 135 30.6
coffee 58g 58g 24.8 24.8
stick o 51 pcs/ 380 g 5 pcs/ 37.25 69 6.75
sprinkles 125 g 9g 30 2.15
TOTAL GRAMS 1,732.25 110.25
1,732.25/346.45 = 5 serving
computation for unit price
110.25/5 = 22.05

packaging:
plastic cup 1.4
sticker paper 1
cost per per serving 24.45

other expenses
utilities 3

vat 12 %
22.05 (12%) 2.65

mark-up 25%
22.05 (25%) 5.51
SELLING PRICE 35.61

You might also like