Regular coffee sales quantities needed to achieve break-even? 2) Large coffee sales quantities to achieve break-even? 3) Retail pre-packaged product sales quantities to achieve break-even? 4) Sale quantities of all three together to break-even (Retail pre-packaged products = 30% of total, Regular coffee sales 60% of remaining 70%, and Large coffee sales 40% of remaining 70% (hope this makes sense!)) 

Transcribed Image Text:

Regular Coffee Large Coffee Retail Pre-packaged Products Projected Gross profit per week $469 $345 Average Fixed costs per sale $1.74 $1.74 Projected Gross profit per week Average Fixed costs per sale $215 $1.74 Total cost $5.21 $5.75 Total average cost $7.16 Marked up Price $5.99 $6.61 Marked up Price $7.88 Average net profit per sale $0.78 $0.86 Average net profit per sale $0.72 Expected sales per wk 600 400 Expected sales per wk 300 Monthly projected sales quantity Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Coffee regular 2,760 2,666 2,570 2,843 2,621 2,772 2,926 2,568 2,722 2,660 2,706 2,797 32,610 Coffee large 1840 1777.6 1,714 1,895 1,747 1,848 1,950 1,712 1,814 1,918 1,936 1,865 22,017 Bottled water 345 333 321 355 328 347 366 321 340 360 484 350 4,250 Banana cake 345 333 321 355 328 347 366 321 340 360 484 350 4,250 Carrot cake 345 333 321 355 328 347 366 321 340 360 484 350 4,250 Choc chip cookie 345 333 321 355 328 347 366 321 340 360 484 350 4,250 Total sales quantity 5,980 5,776 5,568 6,158 5680 6008 6340 5564 5896 6018 6578 6062 71,627 Monthly projected $ sales Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Coffee regular $ 16,528 $ 15,968 $ 15,393 $ 17,024 $ 15,695 $ 16,600 $ 17,520 $ 15,378 $ 16,298 $ 15,927 $ 16,205 $ 16,751 $ 195,287 Coffee large Bottled water Banana cake Carrot cake Choc chip cookie 55555 12,158 $ 11,746 $ 11,323 $ 12,523 $ 11,544 $ 12,211 $ 12,888 $ 11,312 $ 11,989 $ 12,676 $ 12,792 $ 12,322 $ 145,484 $ 961 $ 928 $ 895 $ 990 $ 914 $ 966 $ 1,019 $ 895 $ 947 $ 1,003 $ 1,349 $ 975 $ 11,842 2,521 $ 2,433 $ 2,346 $ 2,594 $ 2,397 $ 2,536 $ 2,675 $ 2,346 $ 2,485 $ 2,631 $ 3,537 $ 2,558 $ 31,058 $ 2,369 $ 2,287 $ 2,205 $ 2,438 $ 2,253 $ 2,383 $ 2,514 $ 2,205 $ 2,335 $ 2,472 $ 3,324 $ 2,404 $ 29,188 2,369 $ 2,287 $ 2,205 $ 2,438 $ 2,253 $ 2,383 $ 2,514 $ 2,205 $ 2,335 $ 2,472 $ 3,324 $ 2,404 $ 29,188 Total sales dollars $ 36,908 $ 35,649 $ 34,365 $ 38,008 $ 35,054 $ 37,079 $ 39,128 $ 34,340 $ 36,389 $ 37,182 $ 40,531 $ 37,413 $ 442,047 Total operating expenses $31,814 $31,064 $30,299 $32,469 $30,710 $32,096 $33,138 $30,284 $31,505 $32,001 $34,053 $32,116 $381,371 Projected Net Profit $5,093.47 $4,584.93 $4,066.16 $5,538.40 $4,344.39 $4,982.72 $5,990.48 $4,055.94 $4,884.13 $5,181.36 $6,477.69 $5,297.69 $ 60,677 Regular Coffee Large Coffee Retail Pre-packaged Products Projected Gross profit per week $469 $345 Average Fixed costs per sale $1.74 $1.74 Projected Gross profit per week Average Fixed costs per sale $215 $1.74 Total cost $5.21 $5.75 Total average cost $7.16 Marked up Price $5.99 $6.61 Marked up Price $7.88 Average net profit per sale $0.78 $0.86 Average net profit per sale $0.72 Expected sales per wk 600 400 Expected sales per wk 300 Monthly projected sales quantity Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Coffee regular 2,760 2,666 2,570 2,843 2,621 2,772 2,926 2,568 2,722 2,660 2,706 2,797 32,610 Coffee large 1840 1777.6 1,714 1,895 1,747 1,848 1,950 1,712 1,814 1,918 1,936 1,865 22,017 Bottled water 345 333 321 355 328 347 366 321 340 360 484 350 4,250 Banana cake 345 333 321 355 328 347 366 321 340 360 484 350 4,250 Carrot cake 345 333 321 355 328 347 366 321 340 360 484 350 4,250 Choc chip cookie 345 333 321 355 328 347 366 321 340 360 484 350 4,250 Total sales quantity 5,980 5,776 5,568 6,158 5680 6008 6340 5564 5896 6018 6578 6062 71,627 Monthly projected $ sales Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Coffee regular $ 16,528 $ 15,968 $ 15,393 $ 17,024 $ 15,695 $ 16,600 $ 17,520 $ 15,378 $ 16,298 $ 15,927 $ 16,205 $ 16,751 $ 195,287 Coffee large Bottled water Banana cake Carrot cake Choc chip cookie 55555 12,158 $ 11,746 $ 11,323 $ 12,523 $ 11,544 $ 12,211 $ 12,888 $ 11,312 $ 11,989 $ 12,676 $ 12,792 $ 12,322 $ 145,484 $ 961 $ 928 $ 895 $ 990 $ 914 $ 966 $ 1,019 $ 895 $ 947 $ 1,003 $ 1,349 $ 975 $ 11,842 2,521 $ 2,433 $ 2,346 $ 2,594 $ 2,397 $ 2,536 $ 2,675 $ 2,346 $ 2,485 $ 2,631 $ 3,537 $ 2,558 $ 31,058 $ 2,369 $ 2,287 $ 2,205 $ 2,438 $ 2,253 $ 2,383 $ 2,514 $ 2,205 $ 2,335 $ 2,472 $ 3,324 $ 2,404 $ 29,188 2,369 $ 2,287 $ 2,205 $ 2,438 $ 2,253 $ 2,383 $ 2,514 $ 2,205 $ 2,335 $ 2,472 $ 3,324 $ 2,404 $ 29,188 Total sales dollars $ 36,908 $ 35,649 $ 34,365 $ 38,008 $ 35,054 $ 37,079 $ 39,128 $ 34,340 $ 36,389 $ 37,182 $ 40,531 $ 37,413 $ 442,047 Total operating expenses $31,814 $31,064 $30,299 $32,469 $30,710 $32,096 $33,138 $30,284 $31,505 $32,001 $34,053 $32,116 $381,371 Projected Net Profit $5,093.47 $4,584.93 $4,066.16 $5,538.40 $4,344.39 $4,982.72 $5,990.48 $4,055.94 $4,884.13 $5,181.36 $6,477.69 $5,297.69 $ 60,677