Question
Sales determine your profitability and whether or not youll stay in business. Sales are also your estimate of how much youll have available to spend.
Sales determine your profitability and whether or not youll stay in business. Sales are also your estimate of how much youll have available to spend. Most products and services will require softer estimates. The sales forecast will also help you assess your capacity needed (and help you chose adequate space, etc.).
The projected sales number is going to be entered in LivePlan as the base for your financial projections.
Review the example provided with this assignment. This is just an example and is very specific to the assumptions for this business (Spirit Spa). Your projections should reflect your business and your assumptions and may look completely different than the example provided.
Make sure you use formulas and do not use a calculator to do this assignment. The whole point of using Excel is to have it do the work for you and allows you to easily change assumptions which will change all other related calculations on your sales projections. Also, your instructor can tell whether your calculations are correct just by looking at the formula, thereby eliminating the need to recalculate all of your numbers.
Directions:
1) Prepare your sales projections for three to five years in Excel. Before submitting your Excel spreadsheet for grading make sure you:
- Check to see that you are not missing any formulas.
- Format each cell with numbers to round up to the nearest dollar
- Format all cells properly - $, %, column width, etc.
- Format page layout properly for orientation, footers, gridlines, etc.
- Format to print should not be more than two pages, one is more likely.
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