Quarterly Sales Worksheet

8

This is the page that displays all the sales figures and cost information about the products. The information about the monthly sales will not be there from the start, the user will have to type that it based on how many units each product sold in the corresponding month.

As the number are typed in, the spreadsheet will calculate the rest of the relevant information (this includes total amount of units the product sold and how much they sold for, whether or not the sales were low and the price needs a reduction, if the item needs reordering, the total sales of each month and the combined sales of all 3 months, the number of items sold across all 3 months, the average sales, the best and worst seller, number of products for sale, number of items that need to be reordered or reduced in price, and the total amount of items aren’t selling well.)