Exercise 3, Java Juice Sales Forecast

Exercise 3, Java Juice Sales Forecast - $43,500 $44,000...

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

View Full Document Right Arrow Icon
Java Juice Sales Forecast Prepared By: Tamara Gardner January February March April May June Total % Food Sales Sandwiches $42,000 $42,500 $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 100% Beverage Sales Coffee $34,000 $35,020 $36,071 $37,153 $38,267 $39,415 $219,926 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% Total Beverage Sales $74,000 $75,490 $77,134 $78,949 $80,956 $83,177 $469,706 100% Ingredient Costs Food Costs $24,900 $25,893 $26,949 $28,072 $29,268 $30,544 $165,626 Beverage Costs $11,100 $11,324 $11,570 $11,842 $12,143 $12,477 $70,456 Net Revenue $121,000 $124,584 $128,444 $132,608 $137,105 $141,969 $785,710 Ratios 30% 15% Food Cost 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
Java Juice Sales Forecast Prepared By: January February March April May June Total % Food Sales Sandwiches $42,000 $42,500 $43,000
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $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 100% Beverage Sales Coffee $34,000 $35,020 $36,071 $37,153 $38,267 $39,415 $219,926 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% Total Beverage Sales $74,000 $75,490 $77,134 $78,949 $80,956 $83,177 $469,706 100% Ingredient Costs Food Costs $24,900 $25,893 $26,949 $28,072 $29,268 $30,544 $165,626 Beverage Costs $11,100 $11,324 $11,570 $11,842 $12,143 $12,477 $70,456 Net Revenue $121,000 $124,584 $128,444 $132,608 $137,105 $141,969 $785,710 Ratios 30% 15% Food Cost as a % of Sales Beverage Cost as a % of Sales...
View Full Document

This note was uploaded on 09/08/2010 for the course BUS 91L at San Jose State University .

Page1 / 2

Exercise 3, Java Juice Sales Forecast - $43,500 $44,000...

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

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