1 / 7

bnm

mnmn,.,.m.,m

HawaStephen
Download Presentation

bnm

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Date Prepared: Beverages Liquid Sunshine Organic Orange Juice Tahiti Coconut Milk YoYo Smoothies Vita Filtered Water NRG Drink Namaste Iced Teas Replenish Water Cool Quencher Almond Joy Milk Chai Time Teas Blueberry Bliss Juice Totals Number of Types of Beverages Average Number of Beverages Sold In Calgary Lowest Sales in Alberta Malls Highest Alberta Recycling Charge Midpoint of Retail Prices Most common Wholesale Cost Nyamkara, Weibe,Li,Lumbers 1

  2. Average number of Fitness Beverages Sold in Alberta Malls Total Sales Revenue of Healthy Choice Beverages Number of types of Natural Beverages Rank of Chai Time Teas in Total Sales Revenue W17 Nyamkara, Weibe,Li,Lumbers 2

  3. BCMP Refresh Beverages Inc. Nyamkara, Li, Lumbers, Weibe- Consultants Sales and Profit Report =TODAY() Store Locations Number of Beverages Sold North Winnipeg Mall Beverage Category West Calgary Mall East Edmonton Mall South Toronto Mall Natural Healthy Choice Healthy Choice Healthy Choice Fitness Natural Fitness Fitness Healthy Choice Natural Natural 3235 3569 3986 4509 3596 4049 3949 3904 4909 3994 3078 2567 2678 2314 2789 4673 3904 4390 4314 3909 4393 3056 2468 2987 2434 2765 4673 3749 4907 4434 3949 4393 3949 4589 4632 4776 4739 4324 2541 4632 4621 4986 5324 2667 =SUM(C22:C32) =SUM(D22:D32) =SUM(E22:E32) =SUM(F22:F32) =COUNT(G22:G32) =AVERAGE(C22:C32) =MIN(C22:D32) =MAX(I22:I32) =MEDIAN(B6:B16) =MODE(C6:C16) Nyamkara, Weibe,Li,Lumbers 3

  4. =AVERAGE(C26,C28,C29,D29,D28,D26) =SUM(H23,H24,H25,H30) =COUNT(C32,C31,C27,C22) =RANK(H31,H22:H32,0) Nyamkara, Weibe,Li,Lumbers 4

  5. BCMP Refresh Beverages Inc. Nyamkara, Li, Lumbers, Weibe- Consultants Sales and Profit Report Total Recycling Charges - Other Provinces Total Number of Beverages Sold Total Sales Revenue excluding Recycle Fee Total Recycling Charges - Alberta Distribution Charges =SUM(C22,D22,E22,F22,) =SUM(C23,D23,E23,F23,) =SUM(C24,D24,E24,F24,) =SUM(C25,D25,E25,F25,) =SUM(C26,D26,E26,F26,) =SUM(C27,D27,E27,F27,) =SUM(C28,D28,E28,F28,) =SUM(C29,D29,E29,F29,) =SUM(C30,D30,E30,F30,) =SUM(C31,D31,E31,F31,) =SUM(C32,D32,E32,F32,) =G22*$B$6 =G23*$B$6 =G24*$B$6 =G25*$B$6 =G26*$B$6 =G27*$B$6 =G28*$B$6 =G29*$B$6 =G30*$B$6 =G31*$B$6 =G32*$B$6 =(C22+D22)*$E$6 =(C23+D23)*$E$6 =(C24+D24)*$E$6 =(C25+D25)*$E$6 =(C26+D26)*$E$6 =(C27+D27)*$E$6 =(C28+D28)*$E$6 =(C29+D29)*$E$6 =(C30+D30)*$E$6 =(C31+D31)*$E$6 =(C32+D32)*$E$6 =(E22+F22)*$E$7 =(E23+F23)*$E$7 =(E24+F24)*$E$7 =(E25+F25)*$E$7 =(E26+F26)*$E$7 =(E27+F27)*$E$7 =(E28+F28)*$E$7 =(E29+F29)*$E$7 =(E30+F30)*$E$7 =(E31+F31)*$E$7 =(E32+F32)*$E$7 =H22*0.05 =H23*0.05 =H24*0.05 =H25*0.05 =H26*0.05 =H27*0.05 =H28*0.05 =H29*0.05 =H30*0.05 =H31*0.05 =H32*0.05 =SUM(G22:G32) =SUM(H22:H32) =SUM(I22:I32) =SUM(J22:J32) =SUM(K22:K32) Nyamkara, Weibe,Li,Lumbers 5

  6. Nyamkara, Weibe,Li,Lumbers 6

  7. % of Total Profit % Markup Total Profit =(C6-B6)/B6 =(C7-B7)/B7 =(C8-B8)/B8 =(C9-B9)/B9 =(C10-B10)/B10 =(C11-B11)/B11 =(C12-B12)/B12 =(C13-B13)/B13 =(C14-B14)/B14 =(C15-B15)/B15 =(C16-B16)/B16 =((B6-C6)*G22)-K22 =((B7-C7)*G23)-K23 =((B8-C8)*G24)-K24 =((B9-C9)*G25)-K25 =((B10-C10)*G26)-K26 =((B11-C11)*G27)-K27 =((B12-C12)*G28)-K28 =((B13-C13)*G29)-K29 =((B14-C14)*G30)-K30 =((B15-C15)*G31)-K31 =((B16-C16)*G32)-K32 =M22/H22 =M23/H23 =M24/H24 =M25/H25 =M26/H26 =M27/H27 =M28/H28 =M29/H29 =M30/H30 =M31/H31 =M32/H32 =SUM(M22:M32) =M34/H34 Nyamkara, Weibe,Li,Lumbers 7

More Related