using the beverage rates I need to calculate January and Feb billable total. cannot figure out excel formula. manually it would be 500*.85+500*.79+661*.77 for owner 1 january billable.

Owner Summary HRC would like a worksheet that will quickly display tabulated information about owners and their machine usage. HRC would also like monthly beverage and revenue totals tabulated on this worksheet. The worksheet should include the following: 1. Owner Information (ID, Name, Address) 2. The total number of machines owned by a particular customer 3. Total number of beverages supplied to the owner's machines separated by month 4. Total billable amounts for each month and a cumulative total, 5. Mean and Standard Deviation's calculated by owner. Explanation of data 6. The total number of beverages supplied by HRC monthly and cumulatively 7. Total expected revenue for HRC monthly and cumulatively Prout me Y A 5 EX 1995 ODO I hater Pe charistisch teriton Owner Summary Al 1124 Sonun Aver 410th 1450 31 2229 SR 17 101 incoln 131 Total Machine Lanuary February Mary Balle Free 038 USD OLTI 3 1683 3D1913 2253 25813410 13 1 1935 11 1 12 19 1714 54 1155 14040 2013 1994 2001 2173 2071 372 211 5. Mar Lingwood Tai Best . 5 16115 15 wartages CE Rates Volume co 5 February SC-1000 1001 3000 2001 and Up 5 3 10 Date May One Show 0 Type here to search O acer Owner Summary Address 1 The Faler Paw 1412 4th St 2 Charleston School 160 Lincoln Avenue tersity Lincoln Avenue Hoecklist 410th St County Market 1450 E * Liewood Pinte Apartment 2219 h 512 T Gateway on sot Lincoln Avent Charleston Bowling lanes 1311 ES Total Machines tamany Tots February Total Sean Soy Lungary Blable Februarytale Tatata 1663 1638 1650 165 1603 1682 1019 1351 469 4 225 2551 2410 211 1935 121900 3 + 1812 1735 1774 MISS 14041210 2057 1044 2001 30 2573 271 2722 try Beves 36115 15807 32013 TF 10 Beverlates Volume Hata First 500 DR5 501-1000 5 . 1001-2000 5 0.72 2001 and to 5 0.73 20 Datu Wade Summary Owner Summary Stockings Type here to search o acer