Description of the project:

The bookstore has many stores in the US and orders books and delivery them to each store. The store wants a business model that helps them know the amount of books they will need to order from its publisher of any title of books and to know its profit and loss.

Tools used:

  1. Excel
  2. Visualisation(two way table)
  3. Statistical analysis

Result:

The document below shows the result of the analysis done. The blue colour on the table is the profit while the red is the loss. The demands determines the amount they should order.

B&N BOOKSTORE ANALYSIS.pdf