If your point-of-sale receiving reports does not include retail values, you can proceed as follows.
Enter the information you have available – receiving at cost, sales at cost and retail, you’ll still be able to do the analysis. But you will not have visibility to a critical data point since the Receiving Ext P$ is not available to calculate the Receiving Margin $ and Receiving Mrg %.
After you populate the PFG Worksheet,
you will be able to compare the Sales Mrg % to the Profit %.
You’ll be able to see the percentage difference between the two, but the meaning is not as obvious because of the missing critical data point.
Complete the PFG Worksheet by filling in all of your data. Then schedule a
call with me to review your Profit-First Guide results.
After you populate the PFG Worksheet, you will not be able to compare the Sales Mrg % to the Receiving Mrg% [the receiving at retail provides the means to calculate this]. You begin to see the value in a established digital receiving process.
By tracking each shipment of new goods separately in the point-of-sale system and measuring, you – the retailer, can see how much margin you are realizing on very sale. Another way of saying this is; am I making the profit I thought I would make when I purchased these goods?
For example, I purchased goods from vendor X and I planned to make 57% Receiving Mrg %. When I sold goods from vendor X, I actually made 50% Sales Mrg %