Calculate the value of your products and services with respect to consumer activity over a given period. Consumer activity within the analysis period should be a proper representation of normal business activities all year round.
Collect data on the trends of sales performances of your products over the last few years. Access this information from your company database. Categorize the data into sales per customer, sales and margins realized per marketing strategy.
Compare the data collected over a few financial years to the value of your products. Use the information to determine whether the business is making profits or sustaining losses and when.
Create a database using Microsoft excel spreadsheet. Create a field for the customer, sales, profit made, and losses realized. The excel application makes it easier for you to input data and for others to interpret it.
Create a table containing the number of years over which data has been collected and amount of losses realized per year. Use the table to create a graph depicting the same. This could either be a bar or line graph or a pie chart. Ensure the graph easily differentiates the decline per year. Use different colors per year to provide a visual appeal and to facilitate understanding for anyone who looks at it.
Record the information from the graphs and tables on a ledger. This acts as a backup in case the soft copy information is tampered with.