Homework SourseNIKE FUELBAND Need help filling in this table II Revenue and
NIKE FUELBAND: Need help filling in this table
II. Revenue and Margin Projections (5 years): In a table show 1) units sold (if appropriate), 2) Price per unit (if appropriate), 3) Gross revenue by year (units x price per unit), 4) Direct cost (units x direct cost per unit). If you have start-up costs, show them in Year 0. You may need to estimate some of the numbers. If you have access to additional financial data, you may augment the table with additional rows such as overhead (fixed cost).
Sample Table
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| R&D/Start Up Cost (year 0) | |||||
| Price Per Unit | |||||
| Units | |||||
| Total Gross Revenue | |||||
| Total Direct Cost | |||||
| Gross Profit (or loss) |
Solution
NIKE FUELBAND - Revenue and Margin Projections ( All Amounts in $)
| Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| R&D/Start Up Cost (year 0) | 857416 | ||||
| Price Per Unit | 149.95 | 149.95 | 155 | 156.99 | 156.99 |
| Units | 1000 | 1250 | 1300 | 1275 | 1290 |
| Total Gross Revenue | 149950 | 187437.5 | 201500 | 200162.3 | 202517.1 |
| Total Direct Cost (Labour and Material) | 25740 | 32175 | 39000 | 38250 | 39990 |
| Total Fixed Cost (Rent, Telephone bill etc.) | 21320 | 26650 | 32500 | 31875 | 33540 |
| Gross Profit (or loss) | 102890 | 128612.5 | 130000 | 130037.3 | 128987.1 |
