Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
must be done in excel please? Directions for Unit 6 Assignment (Spreadsheet Calculations): Prepare your sales projections for three to five years in Excel. Before
must be done in excel please? Directions for Unit 6 Assignment (Spreadsheet Calculations): 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. (These are the calculations that will occur as you change the numbers as outlined below) Format each cell in whole dollars (not necessary to add cents) format all cells properly-S. %, column width, etc. Format page layout as per instructions from previous spreadsheets for orientation, footers, gridlines, etc Format to print - should not be more than two pages, one is more likely Note: The numbers and percentages you use will be from your data gathering for your market area, and assumptions. Growth Rate is the percentage you anticipate (desired or best guess) growing each year, Year 1 Year 2 Year 3 Year 4 Year 5 Multiplier is Multiplier is Multiplier is Multiplier is 1.1 for 10% 1.1 for 10% 1.05 for 5% 1.05 for 5% increase increase increase increase Growth Rate Per Year 10% 10% 1.05 (or 1.05 (or (Desired or best ress 5% incr.) 5% incr.) Population of your Mkt 20000 (City) Target Demographic 35% 70001 Cage, etc) Target Demographic w/ 40%* 25001 median income base Anticipated Mkt Share 15% of the previous category Average It of visits for 4 the year Average price per visits $100 for the year Total Sales for the Year Add'l Sales (pct of total) 10% 5160001 316,8001 Total Sales in Year 1
must be done in excel please?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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