Question: Hi can someone assist with doing a moderate table, aggressive, and conservative table to this sales budget template? Sign in Home Insert Page Layout Formulas
Hi can someone assist with doing a moderate table, aggressive, and conservative table to this sales budget template?

Sign in Home Insert Page Layout Formulas Data Review View Help FOXIT PDF Tell me what you want to do Colors cos Width: Automatic Gridlines Headings A Fonts | Height Automatic View Effects . Margins Orientation Size Print Breaks Background Print View Bring Area . Titles Scale: Send 100% Print Print Selection Align Group Rotate Forward . Backward - Pane homes Page Setup Scale to Fit sheet Options Arrange X fx B C D E G H K L M N EXAMPLE: USE TEMPLATE TO CREATE SALES BUDGET WITH VARIATION OPTIONS: DO NOT ENTER ANY DATA IN THE GREYED OUT CELLS Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Number of units 1200 1212 1236 1256 1279 1302 1328 1354 1385 1417 Unit dollar 190.00 190.60 190.00 190.00 190.00 190.00 190.00 190.00 190.00 190.00 Sales ENTER DESIRED GROWTH (") 1.0% 2.0% 1.6% 1.8% 1.8% 2.0% 2.0% 2.3% 2.3% Develop three (3) ten-year (REVENUE) projections USING YOUR COURSE PROJECT SALES PROJECTIONS assuming estimated growth scenarios as shown below Directions BLE 1 (MODERATE) 1. Enter Year 1 Units (Estimate) a. 1% for 2" year 2. Enter Year 1 Unit Price (Estimate) b. 3% for 3" to 5" year 3. Enter Desired Annual Growth in Percentage e: 8% for 6 to 10" your 4. Enter Deired Growth Percentage in Unit Dollars TABLE 2 (AGGRESSIVE) 4. 3% for 2" year b. 61% for ]" to 5 year c. 9% for &" to 10" year TABLE 3 (CONSERVATIVE) a. -29% for 2 year 27 b. 1% for 3 to 5" year 23 C. 2% for 6 to 10 year 24 25 26 27
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
