Rasmussen College Super Shopper Store Analysis Worksheet and Presentation

In this phase of your analysis you need to merge your findings from the three previous modules. In addition, you will need to compare your individual stores with one another and U.S. retail stores in general; the best way to make these comparisons is to use each store’s gross sales margins.

The sales margin allows companies to determine how well their business is doing; the higher the sales margin – more profit potential can be realized. A sales margin is also called gross profit margins, typically grocery stores have low margins, but the volume purchased is usually higher than other industries.

Calculating Sales Margin

To calculate your sales margin, you first need to decide on a time period such as weekly, monthly, quarterly and so on. It is important to utilize the same time period when conducting comparisons. First you subtract your cost of sales or the costs incurred in obtaining products from the total sales revenues. This will give you a dollar value result of your sales margin. Once this is accomplished you divide your sales margin dollars by your total gross sales, the result will give you a percentage which is your sales margin or gross profit.

Calculate the Margins for each product in the “Store, Warehouse and Accounting” spreadsheet.

Use the All Stores 8 Week inventories and Store, Warehouse and Accounting spreadsheets (attached) to determine each store sales margins.

Hint: You can calculate weekly sales by determining the difference between inventory periods for each product.

After you have completed the sales margins, merge your findings from all modules and develop an analytical report and visualization. This report should be generated using Microsoft PowerPoint and should include a minimum of 6 slides as well as an introductory slide and provide a written narrative that flows with your graphical information.