TOTAL Year 1 Sales Budget Hot Beverages Cald Beverages JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 12,400 14,000 17,360 18,000 18,600 18.000 17,360 24.800 18,600 18.000 21,700 23,560 24,000 9.000...



  1. Assuming that the average customer ticket is $6, determine:


Number of customers per day the first month they are open (January) __________


Number of customers per day the 6th
month they are open (June)       __________


Number of customers per day the 12th
month they are open (December)________


TOTAL<br>Year 1<br>Sales Budget<br>Hot Beverages<br>Cald Beverages<br>JAN<br>FEB<br>MAR<br>APR<br>MAY<br>JUN<br>JUL<br>AUG<br>SEP<br>OCT<br>NOV<br>DEC<br>12,400<br>14,000<br>17,360<br>18,000<br>18,600<br>18.000<br>17,360<br>24.800<br>18,600<br>18.000<br>21,700<br>23,560<br>24,000<br>9.000<br>228,380<br>3,100<br>3,528<br>4,350<br>4,500<br>9.300<br>10,500<br>15.750<br>15,750<br>10,850<br>9.300<br>113,928<br>Food items<br>3,000<br>3,720<br>4.340<br>9,000<br>9,300<br>9,000<br>8,680<br>10,540<br>11,400<br>11,780<br>13,200<br>16,120<br>110,080<br>Caffee and Tea - bulk<br>1,116<br>1.260<br>1,674<br>1,755<br>1,953<br>2,295<br>2,511<br>2,650<br>2,700<br>2,930<br>3,105<br>3,348<br>27,297<br>Gift Cards<br>310<br>560<br>620<br>600<br>1,240<br>750<br>775<br>775<br>900<br>900<br>1,600<br>2,100<br>11,130<br>Gross Sales<br>19,926<br>23,068<br>28,344<br>33,855<br>40,393<br>40,545<br>45,076<br>50,565<br>52,450<br>50,020<br>50,905<br>55,668<br>490.815<br>Less: Returns & Allowances<br>Net Sales<br>19,926<br>23,068<br>28,344<br>33,855<br>40,393<br>40,545<br>45.076<br>50,565<br>52,450<br>50,020<br>50,905<br>55,668<br>490,815<br>Other Income<br>Total Income<br>19,926<br>23,068<br>28,344<br>33,855<br>40,393<br>40,545<br>45.076<br>50,565<br>52,450<br>50.020<br>50,905<br>55,668<br>490,815<br>Credit Management<br>Sales (cash)<br>19,926<br>23.048<br>28,344<br>33,855<br>40,393<br>40,545<br>45,076<br>50,565<br>52,450<br>50,020<br>50,905<br>55,668<br>490,815<br>Sales (credit)<br>Bad Debt Experse - Accrual<br>Received on Account<br>Bad Debt - Cash Flow<br>Assumptions- Year 1<br>Hot Beverages<br>Cald Beverages<br>Coffee, latte, cappuccino, chai tea Average price $4<br>Soft drinks, juice, water, tea, frozen coffee drinks Average price $2<br>Food items<br>Pastries, bagels, desserts Average price $4 for individualS 15 for whole desserts<br>Coffee by the pound; tea bags and loose tea Average price $9 per pound<br>Caffee and Tea - bulk<br>Git Cards<br>Available in any amount<br>Less: Returns & Allowances<br>Other Income<br>Sales (canh)<br>Sales (credit)<br>Bad Debt Experse - Accrual<br>Received on Account<br>Bad Debt - Cash Flow<br>YEAR 1 YEAR 1 YE AR 1 YEAR<br>YE AR 1 YE AR 1 YE AR 1<br>

Extracted text: TOTAL Year 1 Sales Budget Hot Beverages Cald Beverages JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 12,400 14,000 17,360 18,000 18,600 18.000 17,360 24.800 18,600 18.000 21,700 23,560 24,000 9.000 228,380 3,100 3,528 4,350 4,500 9.300 10,500 15.750 15,750 10,850 9.300 113,928 Food items 3,000 3,720 4.340 9,000 9,300 9,000 8,680 10,540 11,400 11,780 13,200 16,120 110,080 Caffee and Tea - bulk 1,116 1.260 1,674 1,755 1,953 2,295 2,511 2,650 2,700 2,930 3,105 3,348 27,297 Gift Cards 310 560 620 600 1,240 750 775 775 900 900 1,600 2,100 11,130 Gross Sales 19,926 23,068 28,344 33,855 40,393 40,545 45,076 50,565 52,450 50,020 50,905 55,668 490.815 Less: Returns & Allowances Net Sales 19,926 23,068 28,344 33,855 40,393 40,545 45.076 50,565 52,450 50,020 50,905 55,668 490,815 Other Income Total Income 19,926 23,068 28,344 33,855 40,393 40,545 45.076 50,565 52,450 50.020 50,905 55,668 490,815 Credit Management Sales (cash) 19,926 23.048 28,344 33,855 40,393 40,545 45,076 50,565 52,450 50,020 50,905 55,668 490,815 Sales (credit) Bad Debt Experse - Accrual Received on Account Bad Debt - Cash Flow Assumptions- Year 1 Hot Beverages Cald Beverages Coffee, latte, cappuccino, chai tea Average price $4 Soft drinks, juice, water, tea, frozen coffee drinks Average price $2 Food items Pastries, bagels, desserts Average price $4 for individualS 15 for whole desserts Coffee by the pound; tea bags and loose tea Average price $9 per pound Caffee and Tea - bulk Git Cards Available in any amount Less: Returns & Allowances Other Income Sales (canh) Sales (credit) Bad Debt Experse - Accrual Received on Account Bad Debt - Cash Flow YEAR 1 YEAR 1 YE AR 1 YEAR YE AR 1 YE AR 1 YE AR 1
Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here