Business Finance Homework Help

Using the data in the file Makeupdb.xlsx (attached below), answer the following:

1. How many units of lip gloss did Zaret sell during 2004 and 2005?
2. Create a data table that contains each person’s total revenue and units sold.
3. How many units of lip gloss did Colleen sell outside the West region?
4. Using the data in the file Makeupdb.xlsx, create a data table that shows the average per-unit revenue generated by each person for sales in which the average per-unit price exceeded $3.30.