Let a, b, c be quantities of products x, y, and z respectively.
total quantities of products available from the store 1, then total availability:
Same way quantities of products sold from stores 1 is given by:
The quantities of products remaining in stores 1 is given by:
- Row R1 - row S1
If X, Y, Z are their prices , then
gives the earnings from sales at stores1
are the profits for each products, then
gives the profits from sales at stores1
IF You have one row for each stores, the it will be a matrix :
gives overall profits for all stores.
gives profit from all stores FROM sales of ONE product. So we can find which product is giving maximum profit.
we can find sales of products each day from each stores and overall total. We can find stocks remaining also. So the quantities for replenishment will be know.
We can compare and find similarity or correlation between the customer purchases at one stores and another stores.
If one matrix is maintained for one stores, with different rows representing stock, or sales then average stock or sales on each day, can be found by adding all rows and dividing by number of rows.