Create a spreadsheet that calculates monthly amount due for $5$ customers. Your customers' monthly amount due is comprised of a monthly sales, discount, bonus and shipping fees$).$

Open a new blank workbook inn Excel. Do not use a wizard or table feature.

Create columns for your inputs: five customers first and last names along with weekly sales orders for $4$ weeks.

Add a column after Week $4$ to calculate total monthly sales for each customer. Use the appropriate function.

Add a column for monthly discount for each customer. An$[$your customers earn a $10\%$ discount based on total monthly sales. The discount percentage could change in the future. Any assumptions required should be placed on a new worksheet and that worksheet should be the second sheet in your workbook. You should name your new worksheet assumptions.

Add a column for bonus earned calculation for each customer. If monthly sales are $$10,000$ or less, bonus is $3\%$ of their monthly sales, otherwise bonus is $6\%$ of their monthly sales. $($The cutoff and percentages may change in the future$).$

Add a column for shipping fees for each customer of $$800$ per month. $($This number ma change in the future$).$

Add a column for Monthly Amount Due from each customer $($total monthly salesmonthly discount$-$bonus earned$+$shipping fees$).$

Add three rows at the bottom for the total, average and maximum $($based on the information for the five customers$)$ of each of the columns. Use the proper functions.

Format cells appropriately.

Format the worksheets so they are professional, attractive, readable, and user friendly as possible. Follow the formatting rules and design rules we discussed.

Make sure the completed sales worksheet prints to one page in landscape orientation.