MusicPlayerz also maintains a e online store is not a large part of the revenue stream, it is an essential and growing part of Music Ployert's business. Julianne has developed a sales report for the coming year, using the previous year s figures as the basis of the projection. Julianne wants to investigate sales predictions based oi the assumption that next year's wholesale sales will increase by 10 percent for each product included in the projection Julianne has asked you to complete the worksheet she has provided you. T2_Music-Playerz Data.xlsx, for her presentation at the annual board meeting next month. You will have to calculate the following Projected 2018 sales (this is 10 percent more than 2017 figures). Gross sales (this is the projected 2018 sales times the price). Profit Percent of sales " Figure 12.23 shows a sample of what Julianne would like to see as a completed worksheet MasicPlayerz Sales Forecast Aciual Projected %of Price 207 Sales 200 Sals Gross Sales Prcie Sales 12100 133 00 $ 9 315 663 5 1 462 69 58 00 69 Appie Pod Shufe 512 Sandsk e140 Senes 1GB Sony ialkiman ear 512 5299 6999 153200 175 120 12256645 237140 179% 7499 8999 M 127 ,700322 1617000 97% 7499 900 110 770 9 968 192 161 550 100 0199 999 197000216 700 0i02m si00100 235% Apple Pod nane 138 Caathe Labs Zen Micro 6G 16199 1959 2000 131 200 2 23 88 801001 1000% iotals 966 937 1K3 631 $12597) t61 $16.62.7% MusicPlayerz also maintains a e online store is not a large part of the revenue stream, it is an essential and growing part of Music Ployert's business. Julianne has developed a sales report for the coming year, using the previous year s figures as the basis of the projection. Julianne wants to investigate sales predictions based oi the assumption that next year's wholesale sales will increase by 10 percent for each product included in the projection Julianne has asked you to complete the worksheet she has provided you. T2_Music-Playerz Data.xlsx, for her presentation at the annual board meeting next month. You will have to calculate the following Projected 2018 sales (this is 10 percent more than 2017 figures). Gross sales (this is the projected 2018 sales times the price). Profit Percent of sales " Figure 12.23 shows a sample of what Julianne would like to see as a completed worksheet MasicPlayerz Sales Forecast Aciual Projected %of Price 207 Sales 200 Sals Gross Sales Prcie Sales 12100 133 00 $ 9 315 663 5 1 462 69 58 00 69 Appie Pod Shufe 512 Sandsk e140 Senes 1GB Sony ialkiman ear 512 5299 6999 153200 175 120 12256645 237140 179% 7499 8999 M 127 ,700322 1617000 97% 7499 900 110 770 9 968 192 161 550 100 0199 999 197000216 700 0i02m si00100 235% Apple Pod nane 138 Caathe Labs Zen Micro 6G 16199 1959 2000 131 200 2 23 88 801001 1000% iotals 966 937 1K3 631 $12597) t61 $16.62.7%
