Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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% | |||
Requirements: | ||||
1. Create an Income Statement by location and in total for both budget and actual data (row format) for both 2017 and 2018. | ||||
2. Use common size and specific ratios to analysize year over year results and to compare to budget data. | ||||
3. Create a 2019 Income Statement budget by location and in total including the following: | ||||
1. provide reasons for values | ||||
2. Budget for improved results and explain how the improvement will be achieved. In particular, the Net Profit for the South location must be improved. | ||||
Use ratios, common size analysis and trend analysis to support your budget estimates and improvements. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started