Excel homework #1

Excel homework #1 - $43,000 $43,500 $44,000 $44,500...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Java Juice Sales Forecast Prepared by: Dr. Trance January February March April May June Food Sales Sandwiches $42,000 $42,500 $43,000 $43,500 $44,000 $44,500 Soup/Salads 19000 20710 22574 24606 26820 29234 Desserts 22000 23100 24255 25468 26741 28078 Total Food Sales $83,000 $86,310 $89,829 $93,573 $97,561 $101,812 Beverage Sales Coffee 34000 35020 36071 37153 38267 39415 Tea 15000 15000 15000 15000 15000 15000 Beer/ Wine 12000 11640 11291 10952 10624 10305 Juice 5000 5750 6613 7604 8745 10057 Soft Drinks 8000 8080 8160 8240 8320 8400 $74,000 $75,490 $77,134 $78,949 $80,956 $83,177 Ingredient Costs Food Costs $20,750 Beverage Costs $11,100 Net Revenue $125,150 $161,800 $166,963 $172,522 $178,517 $184,989 Ratios 25% 15% Total Beverage  Sales Food Costs as a %  of Sales Beverage Cost as a  % of Sales
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Total % $259,500 47.0% 142943 25.9% 149642 27.1% $552,085.44 100.0% 219926 46.8% 90000 19.2% 66811 14.2% 43769 9.3% 49200 10.5% $469,706 100.0% $20,750 $11,100 $989,941
Background image of page 2
Java Juice Sales Forecast Prepared by: Dr. Trance January February March April May June Total % Food Sales Sandwiches $42,000 $42,500
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $43,000 $43,500 $44,000 $44,500 $259,500 47.0% Soup/Salads 19000 20710 22574 24606 26820 29234 142943 25.9% Desserts 22000 23100 24255 25468 26741 28078 149642 27.1% Total Food Sales $83,000 $86,310 $89,829 $93,573 $97,561 $101,812 $552,085.44 100.0% Beverage Sales Coffee 34000 35020 36071 37153 38267 39415 219926 46.8% Tea 15000 15000 15000 15000 15000 15000 90000 19.2% Beer/ Wine 12000 11640 11291 10952 10624 10305 66811 14.2% Juice 5000 5750 6613 7604 8745 10057 43769 9.3% Soft Drinks 8000 8080 8160 8240 8320 8400 49200 10.5% $74,000 $75,490 $77,134 $78,949 $80,956 $83,177 $469,706 100.0% Ingredient Costs Food Costs $20,750 $20,750 Beverage Costs $11,100 $11,100 Net Revenue $125,150 $161,800 $166,963 $172,522 $178,517 $184,989 $989,941 Ratios 25% 15% Total Beverage Sales Food Costs as a % of Sales Beverage Cost as a % of Sales...
View Full Document

Page1 / 3

Excel homework #1 - $43,000 $43,500 $44,000 $44,500...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online