please show the formulas needed to put in excel
4. MusicPlayerz Sales Projections MusicPlayerz is a wholesale Mp3 distributor headquartered in Morrison, Colorado. Corporate buyers for the retail stores contract with MusicPlayerz to supply and ship MP3s to warehouses scattered throughout the western United States. MusicPlayerz chief procurement officer Julianne Beekman oversees the purchase and distribution operations for all divisions from the Morrison office. MusicPlayerz also maintains a small website from which it sells to consumers. Although the online store is not a large part of the revenue stream, it is an essential and growing part of Music- Playerzs 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 on 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 T2.23 shows a sample of what Julianne would like to see as a completed worksheet. Music Playerz Sales Forecast Creative Zen Nano Apple iPod Shuffle 512MB Sandisk e140 Series 1GB Sony Walkman Bean 512MB iRiver Jukebox w/Color Display 512MB Apple iPod nano 1GB Creative Labs Zen Micro 6GB Toshiba Silver 20GB Actual Projected % of Cost Price 2007 Sales 2008 Sales Gross Sales Profit Sales $ 59.00 S 69.99 121,000 133,100 S 9,315,669 $ 1,462,769 8.8% 52.99 69.99 159,200 175,120 12,256,649 2,977,040 17.9% 74.99 89.99 98,000 107,800 9,700,922 1,617,000 9.7% 74.99 89.99 100,700 110,770 9,968,192 1,661,550 10.0% 82.99 99.99 97,067 106,774 10,676,302 1,815,153 10.9% 131.99 149.99 197,000 216,700 32,502,833 3,900,600 23.5% 177.99 189.99 101,970 112,167 21,310,608 1,346,004 8.1% 181.99 199.99 92,000 101,200 20,238,988 1,821,600 11,0% Totals 966,937 1,063,631 $ 125,970, 164 $ 16,601,716 100.0% Music Playerz Sales Forecast Projected 2018 Actual 2017 Sales Sales Fruit Cost Price Gross Sales Profit % of Sales $59.00 $69.99 52.99 69.99 74.99 89.99 74.99 89.99 Creative Zen Nano Apple iPod Shuffle 512MB Sandisk e 140 Series 1GB Sony Walkman Bean 512MB iRiver Jukebox w/Color Display 512MB Apple iPod nano 1GB Creative Labs Zen Micro 6GB Toshiba Silver 20GB 121,000 159,200 98,000 100,700 97,067 197,000 101,970 92,000 82.99 99.99 131.99 149.99 177.99 189.99 181.99 199.99 Totals
