e01BeverageSales_TestFinished - Beverage Sales and Inventory Week of to Beer Regular Ol Beer Light Beer Classic Pilsner Red Bluff Ale Red Bluff

e01BeverageSales_TestFinished - Beverage Sales and...

This preview shows page 1 - 2 out of 2 pages.

1ddfbb15880fdce1287aecd906029219dcc3c81b.xlsx Beverage Sales and Inventory Week of 10/16/18 to 10/22/18 Beer Brand Revenue Regular Ol' Beer The Best 536 306 460 382 1.41 538.62 2.95 1,126.9000 52.20% Light Beer The Best 738 270 616 392 1.41 552.72 2.95 1,156.4000 52.20% Classic Pilsner Peak Brewing 467 270 468 269 1.44 387.36 3.45 928.0500 58.26% Red Bluff Ale Red Bluff Brewery 613 350 541 422 1.59 670.98 4.95 2,088.9000 67.88% Red Bluff Oktoberfest Red Bluff Brewery - 825 106 719 1.89 1,358.91 4.95 3,559.0500 61.82% Red Bluff Stout Red Bluff Brewery 209 327 140 396 2.01 795.96 4.95 1,960.2000 59.39% Beer Total 2,563 2,348 2,331 2,580 $4,304.55 $10,819.50 60.21% Wine Chardonnay Regular The Font Vineyard 170 37 154 53 6.77 358.81 12.95 686.3500 47.72% Shiraz Bold The Font Vineyard 90 23 78 35 7.77 271.95 13.95 488.2500 44.30% Merlot Red Bluff Winery 68 24 77 15 4.93 73.95 9.95 149.2500 50.45% Pinot Grigio Red Bluff Winery 116 33 90 59 5.93 349.87 10.95 646.0500 45.84% Wine Total 444 117 399 162 $1,054.58 $1,969.90 46.47% Soda Cola World's Best 1,014 1,411 941 1,484 0.24 356.16 1.95 2,893.8000 87.69% Diet Cola World's Best 672 1,176 718 1,130 0.24 271.20 1.95 2,203.5000 87.69% Ginger Ale
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

Unformatted text preview: World's Best 423 931 538 816 0.24 195.84 1.95 1,591.2000 87.69% Lemon Lime World's Best 279 848 758 369 0.24 88.56 1.95 719.5500 87.69% Old Style Root Beer World's Best 229 204 179 254 0.24 60.96 1.95 495.3000 87.69% Soda Total 2,617 4,570 3,134 4,053 $972.72 $7,903.35 87.69% Water Spring Water Country Creek 542 3,270 476 3,336 0.76 2,535.36 2.45 8,173.2000 68.98% Pellegrino Country Creek 259 1,365 246 1,378 0.94 1,295.32 2.99 4,120.2200 68.56% Water Total 801 4,635 722 4,714 $3,830.68 $12,293.42 68.84% Grand Totals 6,425 11,670 6,586 11,509 $10,162.53 $32,986.17 69.19% Starting Inventory Inventory Delivered Ending Inventory Units Sold Cost Per Unit Cost of Goods Sold Sale Price Per Unit Profit Margin 1ddfbb15880fdce1287aecd906029219dcc3c81b.xlsx Create Date By Whom Description Workbook Name 5/12/2018 Alberto Dimas e01BeverageSales_PetersSairah.xlsx Mod. Date By Whom Mod. Description Last Version Backup Name 12/12/2019 Sairah Peters Formatted BeverageSales worksheet Create Date Sheet Name Creator Purpose 5/12/2015 BeverageSales Alberto Dimas Track beverage sales and inventory...
View Full Document

  • Spring '18
  • Maureen Simmons
  • Excel, Test, Practice, Answers , In Class Assignment, Microsoft Office 2016, Beverage Sales

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors