only excel expert
ahabuloshi
Albalushi_e02_grader_hw_B-Trendz.xlsxRetail
| B-Trendz, Inc. | |||||||||||||
| 2018 Quarterly Sales | |||||||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Yearly Sales | Sales at a Glance | Product Line Ranking | Online Product | Product Line Rank | |||||
| Women's Clothing | 0 | E | |||||||||||
| Activeware | 734,765 | 745,777 | 732,937 | 740,375 | 500,000 | D | |||||||
| Casual shirts | 245,198 | 256,789 | 255,936 | 251,529 | 1,000,000 | C | |||||||
| Graphic Tees | 457,000 | 478,123 | 477,229 | 472,721 | 1,250,000 | B | |||||||
| Jackets | 312,789 | 311,987 | 312,892 | 315,837 | 1,500,000 | A | |||||||
| Jeans | 423,465 | 413,726 | 414,756 | 419,202 | |||||||||
| Outerwear | 182,746 | 201,725 | 200,273 | 194,768 | |||||||||
| Pants | 293,476 | 291,234 | 293,745 | 297,312 | |||||||||
| Shorts | 192,782 | 197,315 | 198,295 | 193,800 | |||||||||
| Sleepwear | 283,927 | 281,334 | 280,687 | 285,111 | |||||||||
| Socks | 124,587 | 125,079 | 126,213 | 121,510 | |||||||||
| Sweaters | 239,847 | 242,703 | 245,666 | 247,897 | |||||||||
| Swimsuits | 234,987 | 310,719 | 306,827 | 245,321 | |||||||||
| Total | |||||||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Yearly Sales | Sales at a Glance | Product Line Ranking | Online Product | ||||||
| Men's Clothing | |||||||||||||
| Activeware | 445,321 | 446,123 | 449,154 | 451,876 | |||||||||
| Casual shirts | 324,987 | 325,968 | 331,825 | 337,345 | |||||||||
| Graphic Tees | 267,210 | 269,432 | 272,045 | 274,123 | |||||||||
| Jackets | 392,876 | 394,836 | 395,185 | 395,987 | |||||||||
| Jeans | 283,746 | 284,998 | 293,199 | 300,154 | |||||||||
| Outerwear | 182,649 | 184,316 | 186,978 | 185,285 | |||||||||
| Pants | 294,517 | 301,512 | 310,936 | 312,123 | |||||||||
| Shorts | 222,036 | 226,897 | 229,465 | 232,000 | |||||||||
| Sleepwear | 99,254 | 97,312 | 98,251 | 97,945 | |||||||||
| Socks | 122,475 | 122,978 | 126,253 | 127,423 | |||||||||
| Sweaters | 101,345 | 94,968 | 90,156 | 98,127 | |||||||||
| Swimsuits | 75,978 | 79,196 | 83,926 | 76,293 | |||||||||
| Total | |||||||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Yearly Sales | Sales Goal Met? | ||||||||
| Grand Total | |||||||||||||
| Women's % of Sales | |||||||||||||
| Men's % of Sales |
Predictions
| Sales Goal Increase for 2019 | 5% | |||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year Sales | ||
| Women's Clothing | ||||||
| Activeware | ||||||
| Casual shirts | ||||||
| Graphic Tees | ||||||
| Jackets | ||||||
| Jeans | ||||||
| Outerwear | ||||||
| Pants | ||||||
| Shorts | ||||||
| Sleepwear | ||||||
| Socks | ||||||
| Sweaters | ||||||
| Swimsuits | ||||||
| Total | ||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Yearly Sales | ||
| Men's Clothing | ||||||
| Activeware | ||||||
| Casual shirts | ||||||
| Graphic Tees | ||||||
| Jackets | ||||||
| Jeans | ||||||
| Outerwear | ||||||
| Pants | ||||||
| Shorts | ||||||
| Sleepwear | ||||||
| Socks | ||||||
| Sweaters | ||||||
| Swimsuits | ||||||
| Total | ||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Yearly Sales | Sales Goal Met? | |
| 2018 Predicted Total |
Online
| Company Options | |||
| Online Solutions | Online For You | Creative Development | |
| Service/Product | Designs website for online product sales | Designs website for online product sales | Designs website for online product sales |
| Maintains website | 1 | 2 | 3 |
| Cost | $ 100,000.00 | $ 110,000.00 | $ 120,000.00 |
| Loan Options | |||
| Term in Years | 5 | 5 | 5 |
| Interest | 5.05% | 5.05% | 5.05% |
| Monthly Payment | |||
| Total Loan Payment | |||
| Total Interest | |||
| Best Option |
