4. MusicPlayerz Sales Projections MusicPlayerz is a wholesale MP3 distributor headquartered in Morrison, Colorado. Cor- porate buyers for the retail store's contract with MusicPlayerz to supply and ship MP3s to warehouses scattered throughout the western United States. MusicPlayerz chief procure- ment 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 the online store is not a large part of the revenue stream, it is an essential and growing part of MusicPlayerz’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 inves- tigate sales predictions based on the assumption that next year’s wholesale sales will in- crease 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.xls, 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. MusicPlayerz Sales Forecast Fruit Cost Price Actual 2017 Sales Projected 2018 Sales Gross Sales Profit % of Sales Creative Zen Nano $ 59.00 $ 69.99 121,000 Apple iPod Shuffle 512MB 52.99 69.99 159,200 Sandisk e140 Series 1GB 74.99 89.99 98,000 Sony Walkman Bean 512MB 74.99 89.99 100,700 iRiver Jukebox w/Color Display 512MB 82.99 99.99 97,067 Apple iPod nano 1GB 131.99 149.99 197,000 Creative Labs Zen Micro 6GB 177.99 189.99 101,970 Toshiba Silver 20GB 181.99 199.99 92,000 Totals

4. MusicPlayerz Sales Projections MusicPlayerz is a wholesale MP3 distributor headquartered in Morrison, Colorado. Cor- porate buyers for the retail store's contract with MusicPlayerz to supply and ship MP3s to warehouses scattered throughout the western United States. MusicPlayerz chief procure- ment 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 the online store is not a large part of the revenue stream, it is an essential and growing part of MusicPlayerz’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 inves- tigate sales predictions based on the assumption that next year’s wholesale sales will in- crease 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.xls, 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. MusicPlayerz Sales Forecast Fruit Cost Price Actual 2017 Sales Projected 2018 Sales Gross Sales Profit % of Sales Creative Zen Nano $ 59.00 $ 69.99 121,000 Apple iPod Shuffle 512MB 52.99 69.99 159,200 Sandisk e140 Series 1GB 74.99 89.99 98,000 Sony Walkman Bean 512MB 74.99 89.99 100,700 iRiver Jukebox w/Color Display 512MB 82.99 99.99 97,067 Apple iPod nano 1GB 131.99 149.99 197,000 Creative Labs Zen Micro 6GB 177.99 189.99 101,970 Toshiba Silver 20GB 181.99 199.99 92,000 Totals

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Concept explainers

Question

4. MusicPlayerz Sales Projections
MusicPlayerz is a wholesale MP3 distributor headquartered in Morrison, Colorado. Cor-
porate buyers for the retail store's contract with MusicPlayerz to supply and ship MP3s to
warehouses scattered throughout the western United States. MusicPlayerz chief procure-
ment 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
the online store is not a large part of the revenue stream, it is an essential and growing part
of MusicPlayerz’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 inves-
tigate sales predictions based on the assumption that next year’s wholesale sales will in-
crease 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.xls, 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.

MusicPlayerz
Sales Forecast

Fruit	Cost	Price	Actual 2017 Sales	Projected 2018 Sales	Gross Sales	Profit	% of Sales
Creative Zen Nano	$ 59.00	$ 69.99	121,000
Apple iPod Shuffle 512MB	52.99	69.99	159,200
Sandisk e140 Series 1GB	74.99	89.99	98,000
Sony Walkman Bean 512MB	74.99	89.99	100,700
iRiver Jukebox w/Color Display 512MB	82.99	99.99	97,067
Apple iPod nano 1GB	131.99	149.99	197,000
Creative Labs Zen Micro 6GB	177.99	189.99	101,970
Toshiba Silver 20GB	181.99	199.99	92,000
		Totals

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.