spreedsheet 1

profileEly0817
Helmets.xlsx
Home>Business & Finance homework help>Accounting homework help>spreedsheet 1

Projected Income

TheZone - Helmet Products
Projected Income Statement
For the Period Ended Dec 31, 2016
Item: Adul Bicycle Helmet Blue
Assumptions: Projections:
Unit sales 0 Sales ERROR:#N/A
Unit price ERROR:#N/A COGS ERROR:#N/A
Cost of goods sold (COGS) 300% Gross profit ERROR:#N/A
Payroll ERROR:#N/A Payroll ERROR:#N/A
Advertising ERROR:#N/A Advertising ERROR:#N/A
Rent ERROR:#N/A Rent ERROR:#N/A
Tax rate 35.00% Pretax income ERROR:#N/A
Average number of Est. income tax expense ERROR:#N/A
shares outstanding 200,000 Net Income ERROR:#N/A
EPS ERROR:#N/A

SalesHistory

TheZone - Helmet Products
Sales Volume History
For the Period Ended Dec 31, 2016
Product Salesperson Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total Volume Total Value
Football Helmet Large ANTON 289 112 159 119 679 $ 38,024
Wrestling Helmet Large ALFKI 463 246 14 311 1,034 67,210
Football Helmet Medium ANTON 155 158 332 446 1,091 52,368
Wrestling Helmet Small BERGS 218 396 455 400 1,469 110,175
Adult Bicycle Helmet Silver BERGS 22 106 53 181 8,145
Adult Bicycle Helmet Blue BOLID 215 111 420 329 1,075 48,375
Adult Bicycle Helmet Pink BONAP 159 370 377 77 983 44,235
Football Helmet Small BOTTM 201 439 284 71 995 38,805
Adult Bicycle Helmet Pink BOTTM 7 341 187 168 703 31,635
Adult Bicycle Helmet Blue BOTTM 431 368 186 416 1,401 63,045
Wrestling Helmet Small BSBEV 33 483 157 224 897 67,275
Adult Bicycle Helmet Silver ERNSH 2 132 34 168 7,560
Football Helmet Large ERNSH 461 119 89 363 1,032 57,792
Adult Bicycle Helmet Silver FRANS 168 447 417 310 1,342 60,390
Football Helmet Medium GODOS 89 494 453 1,036 49,728
Adult Bicycle Helmet Pink HILAA 37 474 247 182 940 42,300
Wrestling Helmet Small HUNGC 222 116 478 309 1,125 84,375
Football Helmet Large LAZYK 296 445 267 159 - 0
Wrestling Helmet Small LINOD 48 172 172 262 654 49,050
Adult Bicycle Helmet Pink PICCO 79 64 390 280 813 36,585
Wrestling Helmet Small QUICK 465 400 364 334 1,563 117,225
Football Helmet Large RATTC 88 204 18 111 421 23,576
Wrestling Helmet Small REGGC 364 312 267 446 1,389 104,175
Wrestling Helmet Large SAVEA 163 269 220 89 741 48,165
Football Helmet Medium SEVES 137 408 157 115 817 39,216
Football Helmet Large VAFFE 369 459 400 365 1,593 89,208
Adult Bicycle Helmet Blue WHITC 432 108 255 118 913 41,085

Data

Sales Summary by Item
Items: Unit Price Total Sales $ % of Total
Adult Bicycle Helmet Blue 45 $ 152,505 11%
Adult Bicycle Helmet Pink 45 154,755 11%
Adult Bicycle Helmet Silver 45 76,095 5%
Football Helmet Small 39 38,805 3%
Football Helmet Medium 48 141,312 10%
Football Helmet Large 56 208,600 15%
Wrestling Helmet Large 65 115,375 8%
Wrestling Helmet Small 75 532,275 37%
Total $ 1,419,722 100%
Total Division Expenses:
Payroll $ 55,000
Advertising $ 25,000
Rent $ 10,000