Question: How can I forecast the numbers for year 15,16,17 using excel? Footwear Operations in North America Historical Operating Performance Year 12 Year 13 Year 14

How can I forecast the numbers for year 15,16,17How can I forecast the numbers for year 15,16,17 using excel?

Footwear Operations in North America Historical Operating Performance Year 12 Year 13 Year 14 Company Industry Company Industry Company Industry B Average B. Average B Average Company B's Projected Operating Performance Year 15 Year 16 Year 17 Branded Internet Price ($ per pair) Pairs Sold Online (000s) Wholesale Price ($ per pair) Pairs Sold to Retailers (000s) 72.00 437 70.92 454 77.00 418 73.08 508 87.00 611 75.17 578 0.00 0 0.00 0 0.00 0 0.00 0.00 50.00 1,925 49.54 2,328 55.00 1,690 50.71 2,410 62.00 1,689 52.08 2,514 0.00 0 0 0 Cost Per Pair Sold ($ per pair) 27.91 28.17 27.38 28.46 33.55 28.77 0.00 0.00 0.00 36.00 0.00 Private-Label Price ($ per pair) Pairs Sold (000s) Cost Per Pair Sold ($ per pair) Warehouse Expenses Branded ($ per pair sold) Private-Label ($ per pair sold) 31.54 492 26.63 145 31.77 39.00 205 30.86 34.75 655 29.08 0.00 0 0.00 0.00 o 33.00 909 28.45 0 0.00 0.00 0 0.00 0.00 5.75 1.00 5.45 1.03 6.02 1.00 5.53 1.00 6.70 0.00 5.62 1.00 0.00 0.00 0.00 0.00 0.00 0.00 Marketing Expenses Branded Mking Expenses ($/pair sold) 10.10 10.28 11.03 10.64 12.05 11.33 0.00 0.00 0.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!