I tried to directly add the excel file but it said my question was too long. Please help! thank you!!
Project Description: You are the executive assistant to the director of sales at B-Trendz, Inc., a trendy retail store that has locations in only ten states. The company is considering branching into the online retail market. Your supervisor, Kayla Zimmerman, wants to review last year's sales data and make predictions about this year's sales data before making any decisions on whether or not to begin selling online and, if so, which products may sell well online. You have been asked to determine the best-selling women's and men's clothing line by ranking them on a scale from A to E. Only products that have a ranking of A or B will be considered for online sales. To branch into the online market in the future, next year's total sales must be at least $3,000,000. Finally, if B-Trendz, Inc. begins selling products online, you will need help setting up and maintaining the online store. Several companies have given you their information, and you need to determine which company would best fit the needs for the B- Trendz online website. Steps to Perform: Step Instructions Points Possible 1 0 Start Excel. Open the file named e02_grader_hw_B-Trendz.xlsx. Save the file with the name e02_grader_hw_B-Trendz_LastFirst, replacing Lastist with your last and first name. On the Retail worksheet, in cells B17:E17 calculate the quarterly sales totals for the women's clothing line. In cells B33:E33 calculate the quarterly sales totals for the men's clothing line. 2 3 5 In cells F5:F17, calculate the yearly sales totals for the women's clothing line. In cells F21:F33, calculate the yearly sales totals for the men's clothing line. In B36:F36, calculate the grand totals of women's and men's clothing sales. 4 4 In B37:E37, calculate the percentage of sales from women's clothing. Format as Percentage and display zero decimal places. In B38:E38, calculate the percentage of sales from men's clothing. Format as Percentage and display zero decimal places. 5 5 You have been asked to determine whether the grand total yearly sales goals were met. The 2018 yearly sales goals were met if the yearly sales were $25,000,000 or more. In cell G36, using a logical function, determine whether the yearly sales goals were met. Set the formula to return a value of Yes if the goal was met or a value of No if the goal was not met. 6 3 You want to create quick visuals of the quarterly sales of each product line, so you decide to use Sparklines to view the sales at a glance. In G5:G16, insert Line Sparklines based on the data in B5:E16. Add High Point markers. Also add Line Sparklines for the Men's clothing data in G21:32 based on data in B21:E32. Add High Point markers. 7 Assign the named range of Rank to the cells M4:N8. 2 8 5 To determine which clothing lines may sell well online, you decide to rank them on a scale from A to E. In cell H5, using a lookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H16. In cell H21, using a lookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H32. B-Trendz, Inc. 2018 Quarterly Sales Product Line Online Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product Quarter 1 Product Line Rank 0 E 500,000 D 1,000,000 c 1.250.000 B 1.500,000 A Women's Clothing Activeware Casual Shirts Graphic Tees Jackets Jeans Outerwear Pants Shorts Sleepwear Socks Sweaters Swimsuits Total 734,765 745,777 732,937 740,375 245,198 256,789 255,936 251,529 457,000 478,123 477,229 472,721 312,789 311,987 312,892 315,837 423,465 413,726 414,756 419,202 182,746 201,725 200,273 194,758 293,476 291,234 293,745 297,312 192,782 197,315 198,295 193,800 283,927 281,334 280,687 285,111 124,587 125,079 126 213 121 510 239,847 242,703 245,666 247,897 234.987 310,719 306,827 245,321 Product Line Online Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product Quarter 1 Men's Clothing Activeware Casual Shirts Graphic Tees Jackets Jeans Outerwear Pants Shorts Sleepwear Socks Sweaters Swimsuits Total 445 321 446,123 324,987 325,468 267,210 269,432 392,876 394,836 283,746 284,998 182.649 184, 316 294,517 301 512 222 036 226,897 99,254 97,312 122,475 122.978 101,345 94,958 75,978 79, 196 449,154 451,876 331,825 337,345 272,045 274,123 395,185 395.987 293,199 300,154 186,978 185,285 310,936 312,123 229,465 232,000 98.251 97,945 126,253 127,423 90,156 98,127 83.926 76,293 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales Goal Met? Grand Total Women's % of Sales Men's % of Sales Project Description: You are the executive assistant to the director of sales at B-Trendz, Inc., a trendy retail store that has locations in only ten states. The company is considering branching into the online retail market. Your supervisor, Kayla Zimmerman, wants to review last year's sales data and make predictions about this year's sales data before making any decisions on whether or not to begin selling online and, if so, which products may sell well online. You have been asked to determine the best-selling women's and men's clothing line by ranking them on a scale from A to E. Only products that have a ranking of A or B will be considered for online sales. To branch into the online market in the future, next year's total sales must be at least $3,000,000. Finally, if B-Trendz, Inc. begins selling products online, you will need help setting up and maintaining the online store. Several companies have given you their information, and you need to determine which company would best fit the needs for the B- Trendz online website. Steps to Perform: Step Instructions Points Possible 1 0 Start Excel. Open the file named e02_grader_hw_B-Trendz.xlsx. Save the file with the name e02_grader_hw_B-Trendz_LastFirst, replacing Lastist with your last and first name. On the Retail worksheet, in cells B17:E17 calculate the quarterly sales totals for the women's clothing line. In cells B33:E33 calculate the quarterly sales totals for the men's clothing line. 2 3 5 In cells F5:F17, calculate the yearly sales totals for the women's clothing line. In cells F21:F33, calculate the yearly sales totals for the men's clothing line. In B36:F36, calculate the grand totals of women's and men's clothing sales. 4 4 In B37:E37, calculate the percentage of sales from women's clothing. Format as Percentage and display zero decimal places. In B38:E38, calculate the percentage of sales from men's clothing. Format as Percentage and display zero decimal places. 5 5 You have been asked to determine whether the grand total yearly sales goals were met. The 2018 yearly sales goals were met if the yearly sales were $25,000,000 or more. In cell G36, using a logical function, determine whether the yearly sales goals were met. Set the formula to return a value of Yes if the goal was met or a value of No if the goal was not met. 6 3 You want to create quick visuals of the quarterly sales of each product line, so you decide to use Sparklines to view the sales at a glance. In G5:G16, insert Line Sparklines based on the data in B5:E16. Add High Point markers. Also add Line Sparklines for the Men's clothing data in G21:32 based on data in B21:E32. Add High Point markers. 7 Assign the named range of Rank to the cells M4:N8. 2 8 5 To determine which clothing lines may sell well online, you decide to rank them on a scale from A to E. In cell H5, using a lookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H16. In cell H21, using a lookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H32. B-Trendz, Inc. 2018 Quarterly Sales Product Line Online Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product Quarter 1 Product Line Rank 0 E 500,000 D 1,000,000 c 1.250.000 B 1.500,000 A Women's Clothing Activeware Casual Shirts Graphic Tees Jackets Jeans Outerwear Pants Shorts Sleepwear Socks Sweaters Swimsuits Total 734,765 745,777 732,937 740,375 245,198 256,789 255,936 251,529 457,000 478,123 477,229 472,721 312,789 311,987 312,892 315,837 423,465 413,726 414,756 419,202 182,746 201,725 200,273 194,758 293,476 291,234 293,745 297,312 192,782 197,315 198,295 193,800 283,927 281,334 280,687 285,111 124,587 125,079 126 213 121 510 239,847 242,703 245,666 247,897 234.987 310,719 306,827 245,321 Product Line Online Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product Quarter 1 Men's Clothing Activeware Casual Shirts Graphic Tees Jackets Jeans Outerwear Pants Shorts Sleepwear Socks Sweaters Swimsuits Total 445 321 446,123 324,987 325,468 267,210 269,432 392,876 394,836 283,746 284,998 182.649 184, 316 294,517 301 512 222 036 226,897 99,254 97,312 122,475 122.978 101,345 94,958 75,978 79, 196 449,154 451,876 331,825 337,345 272,045 274,123 395,185 395.987 293,199 300,154 186,978 185,285 310,936 312,123 229,465 232,000 98.251 97,945 126,253 127,423 90,156 98,127 83.926 76,293 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales Goal Met? Grand Total Women's % of Sales Men's % of Sales
