Spreadsheet Analysis

Spreadsheet Analysis

 

During our spreadsheet analysis of this office supplies store we could tell exactly where the store is making and losing money. In red you can see the four item categories that are losing money, bookcases, tables, rubber bands, and scissors, rulers, and trimmers. By either stop selling these items completely or by bundling them together for cheap the store can clear them out and eventually cease to sell them because of the profit drain that they have become.

On the contrary, the items that make the store the most money are electric office machines and equipment including fax machines and telephones, and in office furnishings and chairs. By pushing these items more the office supply store will see more profits and lose less money by selling unprofitable items.

Skip to toolbar