MusicPlayerz, headquartered in Morrison, Colorado, distributes MP3 players to retail warehouses scattered throughout the western United States

MusicPlayerz, headquartered in Morrison, Colorado, distributes MP3 players to retail 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 Web site from which it sells to consumers. While not a large part of the revenue stream, the online store is an essential and growing part of MusicPlayerz’s business. Julianne developed a sales report for the coming year, using the current 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, MusicPlayerz_Data.xlsx, for her presentation at the annual board meeting next month.

undefined

• Calculate Projected 2021 Sales (10% more than 2020 sales), Gross 2021 Sales, and 2021 Profit. Also, create an appropriate chart comparing Actual 2020 Sales to Projected 2021 Sales. Calculate % of 2021 Sales and create an appropriate chart. Call this worksheet “2021”.