5 Last month's sales of the ET electric truck were 25,400 units. The company anticipates a monthly sales growth of 0.5%. Currently, one competitor is developing an equivalent truck. In the month that the competitor's truck enters the marketplace, sales of the ET electric truck is expected to decrease by 1%. Create an Excel spreadsheet that will compute the monthly sales for the next 24 months. Your spreadsheet should allow the 21 Page user to enter the date the competitor enters the marketplace, and your sales computations should reflect the change in sales when the competitor enters. 5. 5 In Moray, employees have Wednesdays and Thursdays off, and the following holidays: January 1, February 12, April 5, May 4, July 21, October 10-12, December 24-26. Design a spreadsheet in which the user can enter start and end dates, and the worksheet returns the total number of working days? Your spreadsheet should work for end dates entered up to and including December 31, 2030. Use formulas to generate the dates of the holidays. The result should be blank if no dates are entered. 6. 5 Rename the covid2 worksheet q6 and position it sequentially in your workbook. In the renamed worksheet, write formulas using the appropriate summary statistical functions (countif, sumif, averagelf...) to provide the following information: a) How many countries has "land" in its name? b) What are the average total cases of countries with below average Tests Per 1M pop? c) What are the total population of countries with Total Deaths below 100? 7 5 Sam Clemens would like to automate his billing system. His policy is to set the due date of a client invoice to the 10% of the month following the invoice date. Create a spreadsheet in which a user can enter an invoice date, and the spreadsheet returns the appropriate invoice due date message. Please make your payment by XXX, where XXX is the due date. For example, if the invoice date is October 1, 2021, the invoice due date message should read. Please make your payment by November 10, 2021 8. 10 Wheels Corp., based in Surrey, British Columbia, offers a comprehensive array of environmentally friendly luxury bicycles. The company takes pride in its implementation of clean energy in its manufacturing plant Wheels sells two types of bikes: mountain and road. 8. 10 Wheels Corp., based in Surrey, British Columbia, offers a comprehensive array of environmentally friendly luxury bicycles. The company takes pride in its Implementation of clean energy in its manufacturing plant Wheels sells two types of bikes: mountain and road. Each mountain bicycle sells for $7,626 and road bicycle for $5,597. The per unit variable costs for a mountain bike include $1,780 In raw materials, $24.75 in packaging, $950.50 In manufacturing overhead and $39.95 In shipping. The variable costs for a road bike are $645 in raw materials, $27.95 In packaging, $155 in manufacturing overhead and $35 in shipping. Wheels' fixed costs include office rent of $48,000, office supplies of $12,000 and marketing expenses of $75,000. Create a spreadsheet that provides the income position of the company for the upcoming year. The company projects demand to be 750 for mountain bikes, and 1,500 for road bikes. Assuming a unit-to-unit sale, what is a more profitable product for Wheels? . Determine the break-even for each product, assuming that fixed expenses are allocated equally between the two products. Provide a chart showing the break-even point for each product. 9. 5 Using the dataset in the sales worksheet, write a formula (in a separate worksheet) using the MATCH and OFFSET functions to display (based on a store location and product which the user of your worksheet chooses) the sales. For example, if the user chooses the store location, London, ON and the product, Laptop, the formula result ay