Database includes 2 years worth of actual data and one year of budget data for a retail business with 2 locations. In 2017, there was just one location, North. In January 2018, a new location, South, opened. Budget data is based on best estimates of business activity. Actual data included: Some maintenance costs that were expensed in Q4 Other Expenses North location were unexpected and not budgeted for; Sales Discounts can be impacted by competition (more competition, more discounts must be offered); In retail, industry averages include the following: Percentage of Total Sales: COGS 33% Wages + Benefits 25% Rent + Utilities 10% . Question: Use common size and specific ratios to analysize year over year results and to compare to budget data.

Raw Data to come in additional info (if I can add it). When i included it here, Chegg said my question was too long....

this is what the data looks like. i am unable to load the raw data. if you could perhaps provide some general instruction, it would be appreciated. thanks! I'm hoping you can zoom in. if not, thanks anyway :)