Scribd
Upload
7 views2 pages

Sales Projection Analysis by Segment

This document contains a sales projection model for 8 market segments. It includes each segment's potential market share, total size, growth rate, and projected sales numbers calculated using the formula: Potential Market Share % * Segment Total Size * (2% + Segment Growth Rate). The projected sales are forecast and rounded. The document also shows each segment's inventory on hand and projected production needs calculated as (1.15*Sales)-inventory on hand.

Uploaded by

Abhi Abhi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views2 pages

Sales Projection Analysis by Segment

This document contains a sales projection model for 8 market segments. It includes each segment's potential market share, total size, growth rate, and projected sales numbers calculated using the formula: Potential Market Share % * Segment Total Size * (2% + Segment Growth Rate). The projected sales are forecast and rounded. The document also shows each segment's inventory on hand and projected production needs calculated as (1.15*Sales)-inventory on hand.

Uploaded by

Abhi Abhi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Sales Projection = Potential Market Share % * Segment Total Size * (2% + Segment Growth Rate)

Straight
Potential Market Segment Segment Inventory on
calculated Forecast to Use Round 3 sales
Share % Total Size Growth Rate Hand
Forecast
Traditional Daze 16.50% 9619 9.20% 1,733 1,733 1,697 384
Low Dell 21.30% 12448 11.70% 2,962 2,962 2,774 493
High Dixie 18.80% 4007 16.20% 875 875 804 63
Performance Dot 25.10% 3293 19.80% 990 990 937 21
Size Dune* 22.20% 3284 18.30% 862 862 414 -
2nd Low End Dell-O 3% 11033.5 10.45% 305 463 463 250
2nd High End Dixi-O 10% 8809 9.20% 962 962 263 406
2nd Traditional Duke-O 3% 9619 9.20% 315 315 - -
Production/Best Case
(1.15*Sales)-inv on hand

1,609
2,913
944
1,118
992
282
700
362

You might also like