Excel homework #1

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

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

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

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

View Full Document
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
Java Juice Sales Forecast Prepared by: Dr. Trance January February March April May June Total % Food Sales Sandwiches \$42,000 \$42,500
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online