0% found this document useful (0 votes)
37 views5 pages

Sales Subtotals and Totals Overview

The document presents sales data across various quarters, zones, and categories, detailing transactions made by different salespeople. It includes information on payment types, unit prices, and quantities sold for items such as tea, coffee, and wine. Additionally, it summarizes total sales amounts and lists the staff involved in these transactions.

Uploaded by

sakkirsajil
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
37 views5 pages

Sales Subtotals and Totals Overview

The document presents sales data across various quarters, zones, and categories, detailing transactions made by different salespeople. It includes information on payment types, unit prices, and quantities sold for items such as tea, coffee, and wine. Additionally, it summarizes total sales amounts and lists the staff involved in these transactions.

Uploaded by

sakkirsajil
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Quarter Zone Salesperson Category Type Payment Type Unit Price Quantity

Q1 East Jan Kotas Tea Green Cash $ 3.50 10


Q2 East Anne Hellung-Larsen Tea Black Cash $ 10.00 20
Q2 East Andrew Cencini Wine Merlot Cash $ 19.50 100
Q1 East Anne Hellung-Larsen Tea Green Check $ 14.00 100
Q2 East Robert Zare Tea Green Check $ 34.80 50
Q2 East Mariya Sergienko Tea Black Check $ 40.00 25
Q2 East Mariya Sergienko Tea Green Check $ 9.20 25
Q4 East Nancy Freehafer Tea Green Check $ 14.00 87
Q2 East Anne Hellung-Larsen Tea Black Check $ 3.50 10
Q2 East Jan Kotas Tea Black Check $ 18.00 15
Q2 East Robert Zare Tea Green Check $ 22.00 10
Q1 East Mariya Sergienko Tea Black Credit Card $ 2.99 200
Q4 East Nancy Freehafer Wine Merlot Credit Card $ 3.50 20
Q2 East Michael Neipper Coffee Espresso Credit Card $ 14.00 300
Q2 East Anne Hellung-Larsen Tea Black Credit Card $ 21.35 25
Q2 East Anne Hellung-Larsen Wine Cabernet Credit Card $ 9.65 30
Q4 East Anne Hellung-Larsen Tea Black Credit Card $ 18.40 30
Q4 East Jan Kotas Wine Cabernet Credit Card $ 3.50 30
Q4 East Mariya Sergienko Wine Zinfandel Credit Card $ 30.00 10
Q4 East Michael Neipper Coffee Regular Credit Card $ 53.00 10
Q4 North Nancy Freehafer Wine Merlot Cash $ 2.99 50
Q1 North Anne Hellung-Larsen Tea Black Check $ 3.50 30
Q1 North Nancy Freehafer Coffee Regular Check $ 46.00 300
Q3 North Mariya Sergienko Coffee Decaf Credit Card $ 18.00 15
Q3 South Mariya Sergienko Tea Black Cash $ 9.65 200
Q4 South Nancy Freehafer Tea Green Cash $ 18.00 25
Q4 South Nancy Freehafer Tea Black Cash $ 46.00 25
Q4 South Nancy Freehafer Tea Green Cash $ 2.99 25
Q2 South Mariya Sergienko Coffee Cappuccino Cash $ 46.00 20
Q3 South Anne Hellung-Larsen Wine Merlot Check $ 9.20 20
Q3 South Jan Kotas Wine Merlot Check $ 12.75 10
Q3 South Anne Hellung-Larsen Wine Cabernet Check $ 46.00 300
Q1 South Jan Kotas Tea Black Check $ 12.75 100
Q1 South Nancy Freehafer Coffee Cappuccino Check $ 25.00 10
Q2 South Robert Zare Tea Black Check $ 19.50 100
Q4 South Andrew Cencini Wine Zinfandel Check $ 12.75 10
Q1 South Jan Kotas Tea Black Credit Card $ 30.00 10
Q3 South Mariya Sergienko Tea Black Credit Card $ 46.00 20
Q3 South Laura Giussani Coffee Cappuccino Credit Card $ 40.00 17
Q1 South Nancy Freehafer Wine Merlot Credit Card $ 22.00 10
Q1 South Nancy Freehafer Coffee Regular Credit Card $ 9.20 10
Q4 South Nancy Freehafer Tea Green Credit Card $ 9.65 50
Q2 South Nancy Freehafer Wine Cabernet Credit Card $ 18.40 50
Q4 South Jan Kotas Tea Green Credit Card $ 14.00 100
Q2 South Michael Neipper Tea Black Credit Card $ 9.20 10
Q1 West Jan Kotas Tea Green Cash $ 53.00 10
Q2 West Mariya Sergienko Coffee Espresso Cash $ 9.20 30
Q3 West Nancy Freehafer Tea Black Cash $ 46.00 300
Q1 West Nancy Freehafer Tea Black Cash $ 12.75 100
Q3 West Nancy Freehafer Wine Merlot Cash $ 2.99 200
Q3 West Nancy Freehafer Tea Black Cash $ 46.00 300
Q1 West Anne Hellung-Larsen Coffee Espresso Cash $ 2.99 50
Q2 West Andrew Cencini Tea Green Cash $ 18.40 50
Q2 West Anne Hellung-Larsen Tea Green Check $ 12.75 10
Q2 West Jan Kotas Coffee Espresso Check $ 9.65 200
Q1 West Mariya Sergienko Tea Black Check $ 3.50 20
Q1 West Nancy Freehafer Wine Merlot Check $ 46.00 25
Q2 West Andrew Cencini Tea Black Check $ 2.99 25
Q2 West Andrew Cencini Wine Cabernet Check $ 9.65 50
Q3 West Michael Neipper Coffee Espresso Credit Card $ 9.20 30
Q2 West Laura Giussani Wine Cabernet Credit Card $ 9.20 20
Q2 West Mariya Sergienko Tea Black Credit Card $ 40.00 17
Q1 West Nancy Freehafer Coffee Cappuccino Credit Card $ 25.00 10
Q2 West Anne Hellung-Larsen Coffee Regular Credit Card $ 18.00 25
Total
$ 35.00
$ 200.00
$ 1,950.00
$ 1,400.00
$ 1,740.00
$ 1,000.00
$ 230.00
$ 1,218.00
$ 35.00
$ 270.00
$ 220.00
$ 598.00
$ 70.00
$ 4,200.00
$ 533.75
$ 289.50
$ 552.00
$ 105.00
$ 300.00
$ 530.00
$ 149.50
$ 105.00
$ 13,800.00
$ 270.00
$ 1,930.00
$ 450.00
$ 1,150.00
$ 74.75
$ 920.00
$ 184.00
$ 127.50
$ 13,800.00
$ 1,275.00
$ 250.00
$ 1,950.00
$ 127.50
$ 300.00
$ 920.00
$ 680.00
$ 220.00
$ 92.00
$ 482.50
$ 920.00
$ 1,400.00
$ 92.00
$ 530.00
$ 276.00
$ 13,800.00
$ 1,275.00
$ 598.00
$ 13,800.00
$ 149.50
$ 920.00
$ 127.50
$ 1,930.00
$ 70.00
$ 1,150.00
$ 74.75
$ 482.50
$ 276.00
$ 184.00
$ 680.00
$ 250.00
$ 450.00
Total Staff
Jan Kotas
Anne Hellung-Larsen
Andrew Cencini
Robert Zare
Mariya Sergienko
Nancy Freehafer
Michael Neipper
Laura Giussani

You might also like