Copy of Acceleration of Sales - Start with this222222222222222222222222

Copy of Acceleration of Sales - Start with this222222222222222222222222

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sales Projection Worksheet First month total sales (thousands) Second Month total sales (thousands) Constant Acceleration % Month of Projection 0=?month ?year) Projected Sales (thousands of units) Sales Rate (thousands of units per month) Percentage Change of Sales over Previous Month Acceleration of Sales (thousnds of units per month per month Percentage Change of Sales Rate over previous Month Total Sales Projections Sales in Thousands of Units 300.0 250.0 200.0 150.0 100.0 50.0 0 les Acceleration Rate in Thousands of Units per month per month 5 10 15 20 Months ( 0=?Month 200?) Row 10 Sales Acceleration Projections 1 0.8 0.6 0.4 0.2 0 0 5 10 15 Months ( 0=?Month 200?) 20 Sales Acceleration Rate in 0.2 0 0 5 10 15 Months ( 0=?Month 200?) 20 iphone application, send a picture message 0 10 First month Second month 0 2 2 10% note: enter negative for decelaration 4 21.0 5.5 110.0% 6 32.0 5.5 52.4% 0 8 43.0 5.5 34.4% 0 0% 10 54.0 5.5 25.6% 0 0% 12 65.0 5.5 20.4% 0 0% 14 76.0 5.5 16.9% 0 0% 16 87.0 5.5 14.5% 0 0% Sales Rate in Thousands of Units per month ctions Sales Rate Projections 6 5 4 3 2 1 0 0 5 10 15 Months ( 0=?Month 200?) 20 Ro 20 200?) 25 30 Projections Sales Acceleration Percentage Month to Month Sales Rate % 100.00% 80.00% 60.00% 40.00% 20.00% 0.00% 0 5 10 Row 13 1 20 nth 200?) 25 30 Months ( 0=?Mo Sales A 0.00% 0 5 10 1 20 nth 200?) 25 30 Months ( 0=?Mo Month Interval in Projections 18 98.0 5.5 12.6% 0 0% 20 109.0 5.5 11.2% 0 0% 22 120.0 5.5 10.1% 0 0% 24 131.0 5.5 9.2% 0 0% 26 142.0 5.5 8.4% 0 0% 28 153.0 5.5 7.7% 0 0% 30 164.0 5.5 7.2% 0 0% ate Projections Month to Month Sales 120.0% 100.0% Sales % CHange 25 30 80.0% 60.0% 40.0% 20.0% 0.0% Row 11 15 onths ( 0=?Month 200?) 20 0 5 10 Months ( 0 nth Sales Rate % Change Projections Row 14 5 10 15 20 25 30 Months ( 0=?Month 200?) 5 10 15 20 25 30 Months ( 0=?Month 200?) 32 175.0 5.5 6.7% 0 0% 34 186.0 5.5 6.3% 0 0% 36 197.0 5.5 5.9% 0 0% 38 208.0 5.5 5.6% 0 0% 40 219.0 5.5 5.3% 0 0% 42 230.0 5.5 5.0% 0 0% Month Sales % Change Projections Row 12 10 15 20 25 30 Months ( 0=?Month 200?) 44 241.0 5.5 4.8% 0 0% 46 252.0 5.5 4.6% 0 0% 48 263.0 5.5 4.4% 0 0% Sales Projection Worksheet First month total sales (thousands) Second Month total sales (thousands) Constant Acceleration % Month of Projection 0=?month ?year) Projected Sales (thousands of units) Sales Rate (thousands of units per month) Percentage Change of Sales over Previous Month Acceleration of Sales (thousnds of units per month per month Percentage Change of Sales Rate over previous Month Total Sales Projections Sales in Thousands of Units 300.0 250.0 200.0 150.0 100.0 50.0 0 les Acceleration Rate in Thousands of Units per month per month 5 10 15 20 Months ( 0=?Month 200?) Row 10 f(x) = 11x + 10 Linear Regression for Row 10 R² = 1 Sales Acceleration Projections 1 0.8 0.6 0.4 0.2 0 0 5 10 15 Months ( 0=?Month 200?) 20 Sales Acceleration Rate in 0.2 0 0 5 10 15 Months ( 0=?Month 200?) 20 iphone application, send a picture message 0 10 First month Second month 0 2 2 10% note: enter negative for decelaration 4 21.0 5.5 110.0% 6 32.0 5.5 52.4% 0 8 43.0 5.5 34.4% 0 0% 10 54.0 5.5 25.6% 0 0% 12 65.0 5.5 20.4% 0 0% 14 76.0 5.5 16.9% 0 0% 16 87.0 5.5 14.5% 0 0% Sales Rate in Thousands of Units per month ctions Sales Rate Projections 6 5 4 3 2 1 0 0 5 10 15 Months ( 0=?Month 200?) 20 Ro 20 200?) 25 30 Projections Sales Acceleration Percentage Month to Month Sales Rate % 100.00% 80.00% 60.00% 40.00% 20.00% 0.00% 0 5 10 Row 13 1 20 nth 200?) 25 30 Months ( 0=?Mo Sales A 0.00% 0 5 10 1 20 nth 200?) 25 30 Months ( 0=?Mo Month Interval in Projections 18 98.0 5.5 12.6% 0 0% 20 109.0 5.5 11.2% 0 0% 22 120.0 5.5 10.1% 0 0% 24 131.0 5.5 9.2% 0 0% 26 142.0 5.5 8.4% 0 0% 28 153.0 5.5 7.7% 0 0% 30 164.0 5.5 7.2% 0 0% ate Projections Month to Month Sales 120.0% 100.0% Sales % CHange 25 30 80.0% 60.0% 40.0% 20.0% 0.0% Row 11 15 onths ( 0=?Month 200?) 20 0 5 10 Months ( 0 nth Sales Rate % Change Projections Row 14 5 10 15 20 25 30 Months ( 0=?Month 200?) 5 10 15 20 25 30 Months ( 0=?Month 200?) 32 175.0 5.5 6.7% 0 0% 34 186.0 5.5 6.3% 0 0% 36 197.0 5.5 5.9% 0 0% 38 208.0 5.5 5.6% 0 0% 40 219.0 5.5 5.3% 0 0% 42 230.0 5.5 5.0% 0 0% Month Sales % Change Projections Row 12 10 15 20 25 30 Months ( 0=?Month 200?) 44 241.0 5.5 4.8% 0 0% 46 252.0 5.5 4.6% 0 0% 48 263.0 5.5 4.4% 0 0% Sales Projection Worksheet First month total sales (thousands) Second Month total sales (thousands) Constant Acceleration % Month of Projection 0=?month ?year) Projected Sales (thousands of units) Sales Rate (thousands of units per month) Percentage Change of Sales over Previous Month Acceleration of Sales (thousnds of units per month per month Percentage Change of Sales Rate over previous Month Total Sales Projections Sales in Thousands of Units 2,500.0 2,000.0 1,500.0 1,000.0 500.0 0 les Acceleration Rate in Thousands of Units per month per month 5 10 15 20 Months ( 0=?Month 200?) Row 10 Exponential Regression f (x) = 18.02·1.24^x for Row 10 R² = 0.99 Sales Acceleration Projections 20 15 10 5 0 0 5 10 15 Months ( 0=?Month 200?) 20 Sales Acceleration Rate in 0 0 5 10 15 Months ( 0=?Month 200?) 20 iphone application, send a picture message 0 10 First month Second month 0 2 2 10% note: enter negative for decelaration 4 16.1 3.03 60.5% 6 23.4 3.66 45.6% 0.32 8 32.2 4.43 37.9% 0.38 21% 10 42.9 5.36 33.3% 0.47 21% 12 55.9 6.48 30.2% 0.56 21% 14 71.6 7.85 28.1% 0.68 21% 16 90.6 9.49 26.5% 0.82 21% Sales Rate in Thousands of Units per month ctions Sales Rate Projections 250 200 150 100 50 0 0 5 10 15 20 Months ( 0=?Month 200?) R 20 200?) 25 30 Projections Sales Acceleration Percentage Month to Month Sales Rate % 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 0 5 10 Row 13 15 20 nth 200?) 25 30 Months ( 0=?Mo Sales A 21.00% 21.00% 0 5 10 15 20 nth 200?) 25 30 Months ( 0=?Mo Month Interval in Projections 18 113.6 11.49 25.4% 1 21% 20 141.4 13.9 24.5% 1.21 21% 22 175.0 16.82 23.8% 1.46 21% 24 215.7 20.35 23.3% 1.77 21% 26 265.0 24.62 22.8% 2.14 21% 28 324.5 29.8 22.5% 2.59 21% 30 396.7 36.05 22.2% 3.13 21% ate Projections 70.0% 60.0% Sales % CHange 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% 15 onths ( 0=?Month 200?) 20 25 30 Month to Month Sales Row 11 0 5 10 Months ( 0 nth Sales Rate % Change Projections Row 14 10 15 20 25 30 Months ( 0=?Month 200?) 10 15 20 25 30 Months ( 0=?Month 200?) 32 483.9 43.62 22.0% 3.79 21% 34 589.5 52.78 21.8% 4.58 21% 36 717.2 63.87 21.7% 5.54 21% 38 871.8 77.28 21.6% 6.71 21% 40 1,058.8 93.51 21.5% 8.11 21% 42 1,285.1 113.15 21.4% 9.82 21% Month Sales % Change Projections Row 12 10 15 20 25 30 Months ( 0=?Month 200?) 44 1,558.9 136.91 21.3% 11.88 21% 46 1,890.2 165.66 21.3% 14.38 21% 48 2,291.1 200.45 21.2% 17.39 21% Sales Projection Worksheet First month total sales (thousands) Second Month total sales (thousands) Constant Acceleration % Month of Projection 0=?month ?year) Projected Sales (thousands of units) Sales Rate (thousands of units per month) Percentage Change of Sales over Previous Month Acceleration of Sales (thousnds of units per month per month Percentage Change of Sales Rate over previous Month iphone application, send a picture message 0 10 First month Second month 0 2 2 10% note: enter negative for decelaration 4 Month Interval in Projections ...
View Full Document

This note was uploaded on 10/18/2010 for the course SDAS sadas taught by Professor Sdad during the Spring '10 term at Aarhus Universitet.

Ask a homework question - tutors are online