You are the executive assistant to the director of sales at B-Trendz, Inc., a trendy retail...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 detemine vhich company would best fit the needs for the B- Jrendz online website. Steps to Perform: Points Possible Step Instructions 1 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 Lastairst with your last and first name. On the Retail vorksheet, 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. 4 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. 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. 4 4 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. 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:G32 based on data in B21:E32. Add High Point markers. 7 Assign the named range of Rank to the cells M4:N8. 8. 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 Viookup 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 Vlookup 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. 3. co Points Possible Step Instructions In cell 15, using logical functions, determine whether the product will be an online product The product will be an online product if it has a ranking of A or B. Set the formula to return a value of Yes if rank was met and a value of No if rank was not met. Copy the formula through 116. Repeat the same formula for the men's clothing lines starting in cell 121, and copy the formula through 132. 9. 10 Create a 3-D clustered column chart that represents the women's clothing sales based on each product line and the product line's yearly sales. Enter a chart title of Women's Clothing Sales. Move the chart so the top left corner of the chart is in cell K10 and the bottom right comer of the chart is in cell Q22. Apply Style 3 to the chart. 6 11 Create a second 3-D clustered column chart that represents the men's clothing sales based on each product line and the product line's yearly sales. Enter a chart title of Men's Clothing Sales. Move the chart so the top left corner of the chart is in cell K23 and the bottom right cormer of the chart is in cell Q38. Apply Style 3 to the chart. Adjust the vertical axis Bounds and Units of the men's clothing chart to match the vertical axis of the women's clothing chart. 6 12 Create a clustered column chart to compare the sales percentages of women's and men's clothing sales for all four quarters. Move the chart to a new chart sheet and name the new worksheet ŞalesComparison. Position the SalesComparison worksheet to the right the Retail worksheet. Apply Style 4 to the chart. Enter the chart title Sales Comparison. Change the chart title format using WordArt, Pattem Fill-Blue, Accent 1, Light Downward Diagonal, Outline - Accent 1. Note, depending on the version of Office used, the WordArt style name may be Pattern Fill: Blue, Accent color 5, Light Downward Diagonal Stripe; Outline: Blue, Accent color 5. Increase the font of the chart title to 40. Insert a rounded rectangle shape in the top left comer of the chart. Note, depending on the version of Office used, the shape name may be Rectangle: Rounded Comers. Enter the text Women's products consistently outsold men's products. Change the size of the rounded rectangle shape to 0.6" high and 2.25" 8. wide. On the Predictions worksheet, in cell B5, calculate the 2019 sales goal amount for women's activeware based on the 2018 amount on the Retail worksheet and the percent in cell B1 on the Predictions worksheet. Copy this formula to the range B5:E16. 13 4 In cell B17, calculate the total quarter 1 sales goal amount and copy the formula over to E17. In cell F5, calculate the total yearly sales goal amount for women's activeware., Copy the formula down to F17. 14 4 In cell B21 calculate the 2019 sales goal amount for men's activeware based on the 2018 amount on the Retail worksheet and the percent in cell B1 on the Predictions worksheet. Copy this formula to the range B21:E32. 15 6 16 In cell B33, calculate the total quarter 1 sales goal amount and copy the formula over to E33. 4 In cell F21, calculate the total yearly sales goal amount for men's activeware. Copy the formula down to F33. 17 In B36:F36, total the quarterly and yearly sales for both women's and men's clothing. 3 Points Possible Step Instructions In cell G36, using a logical function, determine whether the sales goal is met. The sales goal is met if the yearly sales total is greater than or equal to S30,000,000. Set the formula to return a value of Yes if goal vwas met and a value of No if goal was not met. 18 5 19 Using trial and error in cell B1, determine the approximate lowest percentage increase that is needed for all products to meet the total sales goal of $30,000,000 in cell G36. Use only whole number percentages. 2 On the Online worksheet, in cell B11, calculate the end of month payment amount for the loan given the loan amount, term, and interest for the Online Solutions company. Use cell references where applicable. The result should be a positive value. Copy the formula over to 6 D11. In cell B12, calculate the total payment amounts over the life of the loan. Copy the formula over to D12. 22 In B13, calculate how much total interest will be paid over the life of the loan. Copy the formula over to D13. 2 In cells B15:D15, use a logical function to recommend which company B-Trendz should use to create and maintain the online website. The function should return the company name from row 2 if the website will be maintained for at least two years and the monthly payment is $2,100 or less. If the value is false, the cell should remain blank. 23 24 Insert the File Name field in the left custom footer section of the Header/Footer tab in the Page Setup dialog box on all worksheets in the workbook. 3 25 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Retail, SalesCompariso0, Predictions, and Online. Close the workbook and then close Excel. Submit the workbook as directed. Total Points 100 3. 20 21 A в E F G H J K L M P. B-Trendz, Inc. 2 2018 Quarterly Sales Product Line Online Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product Product Line Rank 3 4 Women's Clothing 5 Activeware 6 Casual shirts 7 Graphic Tees 8 Jackets E 732,937 255,936 477,229 312,892 414,756 200,273 293,745 198,295 280,687 126,213 245,666 306,827 745.777 256,789 478,123 734,765 245,198 457,000 312,789 423,465 182,746 293,476 192,782 283,927 124,587 239,847 234,987 740,375 251,529 472,721 315,837 419,202 194,768 297,312 193,800 285,111 121,510 247,897 245,321 500,000 1,000,000 1,250,000 D В 311,987 413,726 201,725 291,234 197,315 281,334 125,079 242,703 310,719 1.500.000 A Jeans 10 Outerwear 11 Pants 12 Shorts 13 Sleepwear 14 Socks 15 Sweaters 16 Swimsuits 17 Total 18 Product Line Online Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product 19 20 Men's Clothing 21 Activeware 445,321 324,987 267,210 392,876 283,746 182,649 294,517 222,036 99,254 122,475 101,345 75,978 446,123 325,968 269,432 394,836 284,998 184,316 301,512 226,897 97,312 122,978 94,968 79,196 449,154 331,825 272,045 395,185 293,199 186,978 310,936 229,465 98,251 126,253 90,156 83,926 451,876 337,345 274,123 395,987 300,154 185,285 312,123 232,000 97,945 127.423 98,127 76,293 22 Casual shirts 23 Graphic Tees 24 Jackets 25 Jeans 26 Outerwear 27 Pants 28 Shorts 29 Sleepwea 30 Socks 31 Sweaters 32 Swimsuits 33 Total 34 35 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales Goal Met? 36 Grand Total 37 Women's % of Sales 38 Men's % of Sales 39 40 41 42 43 44 45 A. B D F G H Sales Goal Increase 1 for 2019 5% Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Sales 4 Women's Clothing 5 Activeware 6 Casual shirts 7 Graphic Tees 8 Jackets 9 Jeans 10 Outerwear 11 Pants 12 Shorts 13 Sleepwear 14 Socks 15 Sweaters 16 Swimsuits 17 Total 18 19 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales 20 Men's Clothing 21 Activeware 22 Casual shirts 23 Graphic Tees 24 Jackets 25 Jeans 26 Outerwear 27 Pants 28 Shorts 29 Sleepwear 30 Socks 31 Sweaters 32 Swimsuits 33 Total 34 35 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales Goal Met? 36 2018 Predicted Total 37 38 39 40 A B 1 Company Options Creative Development Designs website for online product sales Online Solutions Online For You Designs website for online product sales Designs website for online product sales 3 Service/Product 4 Maintains website 5 Cost 1 2 3 $ 100,000.00 $ 110,000.00 $ 120,000.00 6 7 8 Loan Options 9 Term in Years 10 Interest 5.05% 5.05% 5.05% 11 Monthly Payment 12 Total Loan Payment 13 Total Interest 14 15 Best Option 16 17 18 19 20 2. 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 detemine vhich company would best fit the needs for the B- Jrendz online website. Steps to Perform: Points Possible Step Instructions 1 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 Lastairst with your last and first name. On the Retail vorksheet, 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. 4 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. 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. 4 4 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. 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:G32 based on data in B21:E32. Add High Point markers. 7 Assign the named range of Rank to the cells M4:N8. 8. 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 Viookup 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 Vlookup 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. 3. co Points Possible Step Instructions In cell 15, using logical functions, determine whether the product will be an online product The product will be an online product if it has a ranking of A or B. Set the formula to return a value of Yes if rank was met and a value of No if rank was not met. Copy the formula through 116. Repeat the same formula for the men's clothing lines starting in cell 121, and copy the formula through 132. 9. 10 Create a 3-D clustered column chart that represents the women's clothing sales based on each product line and the product line's yearly sales. Enter a chart title of Women's Clothing Sales. Move the chart so the top left corner of the chart is in cell K10 and the bottom right comer of the chart is in cell Q22. Apply Style 3 to the chart. 6 11 Create a second 3-D clustered column chart that represents the men's clothing sales based on each product line and the product line's yearly sales. Enter a chart title of Men's Clothing Sales. Move the chart so the top left corner of the chart is in cell K23 and the bottom right cormer of the chart is in cell Q38. Apply Style 3 to the chart. Adjust the vertical axis Bounds and Units of the men's clothing chart to match the vertical axis of the women's clothing chart. 6 12 Create a clustered column chart to compare the sales percentages of women's and men's clothing sales for all four quarters. Move the chart to a new chart sheet and name the new worksheet ŞalesComparison. Position the SalesComparison worksheet to the right the Retail worksheet. Apply Style 4 to the chart. Enter the chart title Sales Comparison. Change the chart title format using WordArt, Pattem Fill-Blue, Accent 1, Light Downward Diagonal, Outline - Accent 1. Note, depending on the version of Office used, the WordArt style name may be Pattern Fill: Blue, Accent color 5, Light Downward Diagonal Stripe; Outline: Blue, Accent color 5. Increase the font of the chart title to 40. Insert a rounded rectangle shape in the top left comer of the chart. Note, depending on the version of Office used, the shape name may be Rectangle: Rounded Comers. Enter the text Women's products consistently outsold men's products. Change the size of the rounded rectangle shape to 0.6" high and 2.25" 8. wide. On the Predictions worksheet, in cell B5, calculate the 2019 sales goal amount for women's activeware based on the 2018 amount on the Retail worksheet and the percent in cell B1 on the Predictions worksheet. Copy this formula to the range B5:E16. 13 4 In cell B17, calculate the total quarter 1 sales goal amount and copy the formula over to E17. In cell F5, calculate the total yearly sales goal amount for women's activeware., Copy the formula down to F17. 14 4 In cell B21 calculate the 2019 sales goal amount for men's activeware based on the 2018 amount on the Retail worksheet and the percent in cell B1 on the Predictions worksheet. Copy this formula to the range B21:E32. 15 6 16 In cell B33, calculate the total quarter 1 sales goal amount and copy the formula over to E33. 4 In cell F21, calculate the total yearly sales goal amount for men's activeware. Copy the formula down to F33. 17 In B36:F36, total the quarterly and yearly sales for both women's and men's clothing. 3 Points Possible Step Instructions In cell G36, using a logical function, determine whether the sales goal is met. The sales goal is met if the yearly sales total is greater than or equal to S30,000,000. Set the formula to return a value of Yes if goal vwas met and a value of No if goal was not met. 18 5 19 Using trial and error in cell B1, determine the approximate lowest percentage increase that is needed for all products to meet the total sales goal of $30,000,000 in cell G36. Use only whole number percentages. 2 On the Online worksheet, in cell B11, calculate the end of month payment amount for the loan given the loan amount, term, and interest for the Online Solutions company. Use cell references where applicable. The result should be a positive value. Copy the formula over to 6 D11. In cell B12, calculate the total payment amounts over the life of the loan. Copy the formula over to D12. 22 In B13, calculate how much total interest will be paid over the life of the loan. Copy the formula over to D13. 2 In cells B15:D15, use a logical function to recommend which company B-Trendz should use to create and maintain the online website. The function should return the company name from row 2 if the website will be maintained for at least two years and the monthly payment is $2,100 or less. If the value is false, the cell should remain blank. 23 24 Insert the File Name field in the left custom footer section of the Header/Footer tab in the Page Setup dialog box on all worksheets in the workbook. 3 25 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Retail, SalesCompariso0, Predictions, and Online. Close the workbook and then close Excel. Submit the workbook as directed. Total Points 100 3. 20 21 A в E F G H J K L M P. B-Trendz, Inc. 2 2018 Quarterly Sales Product Line Online Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product Product Line Rank 3 4 Women's Clothing 5 Activeware 6 Casual shirts 7 Graphic Tees 8 Jackets E 732,937 255,936 477,229 312,892 414,756 200,273 293,745 198,295 280,687 126,213 245,666 306,827 745.777 256,789 478,123 734,765 245,198 457,000 312,789 423,465 182,746 293,476 192,782 283,927 124,587 239,847 234,987 740,375 251,529 472,721 315,837 419,202 194,768 297,312 193,800 285,111 121,510 247,897 245,321 500,000 1,000,000 1,250,000 D В 311,987 413,726 201,725 291,234 197,315 281,334 125,079 242,703 310,719 1.500.000 A Jeans 10 Outerwear 11 Pants 12 Shorts 13 Sleepwear 14 Socks 15 Sweaters 16 Swimsuits 17 Total 18 Product Line Online Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product 19 20 Men's Clothing 21 Activeware 445,321 324,987 267,210 392,876 283,746 182,649 294,517 222,036 99,254 122,475 101,345 75,978 446,123 325,968 269,432 394,836 284,998 184,316 301,512 226,897 97,312 122,978 94,968 79,196 449,154 331,825 272,045 395,185 293,199 186,978 310,936 229,465 98,251 126,253 90,156 83,926 451,876 337,345 274,123 395,987 300,154 185,285 312,123 232,000 97,945 127.423 98,127 76,293 22 Casual shirts 23 Graphic Tees 24 Jackets 25 Jeans 26 Outerwear 27 Pants 28 Shorts 29 Sleepwea 30 Socks 31 Sweaters 32 Swimsuits 33 Total 34 35 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales Goal Met? 36 Grand Total 37 Women's % of Sales 38 Men's % of Sales 39 40 41 42 43 44 45 A. B D F G H Sales Goal Increase 1 for 2019 5% Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Sales 4 Women's Clothing 5 Activeware 6 Casual shirts 7 Graphic Tees 8 Jackets 9 Jeans 10 Outerwear 11 Pants 12 Shorts 13 Sleepwear 14 Socks 15 Sweaters 16 Swimsuits 17 Total 18 19 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales 20 Men's Clothing 21 Activeware 22 Casual shirts 23 Graphic Tees 24 Jackets 25 Jeans 26 Outerwear 27 Pants 28 Shorts 29 Sleepwear 30 Socks 31 Sweaters 32 Swimsuits 33 Total 34 35 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales Goal Met? 36 2018 Predicted Total 37 38 39 40 A B 1 Company Options Creative Development Designs website for online product sales Online Solutions Online For You Designs website for online product sales Designs website for online product sales 3 Service/Product 4 Maintains website 5 Cost 1 2 3 $ 100,000.00 $ 110,000.00 $ 120,000.00 6 7 8 Loan Options 9 Term in Years 10 Interest 5.05% 5.05% 5.05% 11 Monthly Payment 12 Total Loan Payment 13 Total Interest 14 15 Best Option 16 17 18 19 20 2.
Expert Answer:
Related Book For
Business Law The Ethical Global and E-Commerce Environment
ISBN: 978-0071317658
15th edition
Authors: Jane Mallor, James Barnes, Thomas Bowers, Arlen Langvardt
Posted Date:
Students also viewed these banking questions
-
You have been a director of sales at Privation Insurance Company for the last five years. Next week, you will be promoted to the position of Vice President of Sales, leading a staff of 35 sales...
-
The Milk 4 All Company is considering branching into the ice-cream business. It will need a machine costing $1,000,000 to produce the ice cream. The machine will be depreciated over ten years to zero...
-
You are the executive director of a community service agency in the inner city. Your operation is funded through a combination of cash contributions, federal government grants, and city contracts....
-
You are given the following information concerning Parrothead Enterprises: Calculate the company?s WACC. Debt: 13,000 6.4 percent coupon bonds outstanding, with 15 years to maturity and a quoted...
-
How do organizational cultures develop? What four steps commonly occur?
-
Explain the following concepts: (a) Bargain purchase option (b) Bargain renewal option.
-
Suzanne is a single mother who works full time and pays a sitter to take care of her two children. She recently moved to another state and found a new job. The company offers a variety of employee...
-
Dexter Products, Inc., manufactures and sells a number of items, including an overnight case. The company has been experiencing losses on the overnight case for some time, as shown on the following...
-
Background Forrest runs Y Not Flowers, Inc. (YNF) , a wholesale flower distributor with stores in several major metropolitan areas of the U.S. He is considering expanding his business, but he think...
-
Louie Long started a business called Louie's Lawn Service. The trial balance as of March 31, after the first month of operation, is as follows: REQUIRED 1. Analyze the following adjustments and enter...
-
Marp Conton Event Firm had the following financial information for the past accounting period: Current Liabilities= $174,000 Long-Term Liabilities = $112,000 Total Fixed Assets = $240,000 Current...
-
1 ) Discuss the differences between common and preferred shares. ( 1 0 marks ) 2) Why would a company issue preferred shares instead of common shares? ( 5 marks ) 3) Why would an outside investor...
-
A child accelerates upwards in an elevator which causes his apparent weight to become 405 N. Determine the magnitude of the elevator's acceleration if his normal weight is 400 N. [0.123 m/s]
-
Dunsley Springs plc is looking to acquire a specialist drilling machine. The machine can be either bought for cash or leased and the company is looking into which of the two alternatives is the best...
-
For this case study, we'll take a look at St. Sebastian Health System, a modest-sized Midwest hospital system. The CFO has brought you in to examine some long-term financial trends in his system. She...
-
Manage Emergency Situation Danni Woslecki the Assistant Educator in the Willow Oak room at Little.ly was working on her own on Friday at 8 a.m. as only three children in this age group had arrived....
-
On January 1, 2023, Integrity Co. paid $600,000 to acquire Accountability Corp. Integrity used the equity method to account for the investment. The following information is available for the assets...
-
Suppose that A is an m n matrix with linearly independent columns and the linear system LS(A, b) is consistent. Show that this system has a unique solution.
-
Thompson discovered that the automatic transmission in his car was leaking even though it otherwise was operating properly. He took the car to Mr. Transmission, a transmission repair business, told...
-
AltaVerba, Inc., is a nonpublic company controlled by its majority shareholder, Robyn Streel. AltaVerba wants to make an initial public offering by selling 300 million Class B common shares in a firm...
-
John Henry Kirkpatrick was born Gion Rosetti to J oseph and Beatrice Rosetti in 1914. He had 10 siblings. On January 25, 1927, Edgar and Margaret Kirkpatrick adopted Gion and his brother, Leo. The...
-
At December 31, 2020, the investments in the portfolio of the trading securities of Kennedy Company included the following. Required a. Record the entry for the receipt of quarterly interest from the...
-
On December 31, 2020, Banff Company held an investment in Glacier Inc. bonds with an original cost of \(\$ 23,000\). The investment was classified as an available-for-sale security, had a fair value...
-
On July 1, 2020, West Company purchased for cash, eight \(\$ 10,000\) bonds of North Corporation to yield \(10 \%\). The bonds pay \(9 \%\) interest, payable on a semiannual basis each July 1 and...
Study smarter with the SolutionInn App