please do it on the excel and with step wise step

now please can you help me with this i want this on excel and want each step how you did that

BCPT 123 Project: Home Renovation Imaging you are assigned to help a customer who is interested in home flooring renovation. The customer has requested a quote for his renovation project. You would need to prepare an invoice for your customer. To find out about your customer's home location (City and Province) and the area of flooring see the excel file titled Home Renovation. The Area-City worksheet lists your customer information based on your Banner ID. PLEASE READ the instructions carefully: 1. Create a VLOOKUP function to obtain your customer information from the table given in Area-City worksheet. You only create an invoice for your own customer. 2. Prepare an invoice for your customer. See the Invoice worksheet for a sample of invoice. You are welcome to use that sample format. a. Assume that Area of kitchen is 15% of the total renovation area Area of bathrooms is 10% of the total renovation area Area of living room and dining room is 35% of the total renovation area Area of bedrooms is 40% of the total renovation area b. Kitchen, living room and dining room flooring would be engineered wood flooring. Bathrooms would be natural stone tile floor and bedrooms would be carpet Calculate the cost of flooring materials for kitchen, bathrooms, living room, dining room and bedrooms Engineered wood flooring costs 4 45 per square foot and installation is $9.55 per square foot Natural stone tile floor costs $7.99 per square foot and installation is $7.25 per square foot Carpet flooring costs $ 3.99 per square foot and installation is $4.95 per square foot c Create an IF function to calculate delivery cost (delivery only applies to the materials and assume that materials will be delivered all together at the same time): Delivery is free of charge on the order of flooring materials below 53500 A $200 flat delivery rate applies on the order of flooring materials above $3500 and below . . . . Changes: Ott Focus . Delivery is free of charge on the order of flooring materials below $3500 A $200 flat delivery rate applies on the order of flooring materials above $3500 and below $5000 A $300 flat delivery rate applies on the order of flooring materials above $5000 d. Notice that the sales and services tax rates are different in each Canadian province Create a VLOOKUP function using the tax table below to calculate the sales and . services tax Province TYPE PST GST HST Total Tax Rate Alberta British Columbia Manitoba New Brunswick GST GST + PST GST + PST HST 796 7% 5% 5% 5% 5% 12% 12% 15% 15% 15% 596 Newfoundland and Labrador Northwest Territories Nova Scotia Nunavut Ontario Prince Edward Island HST GST HST GST HST HST 15% 15% 5% 15% 596 13% 15% 596 139 15% Quebec Saskatchewan Yukon GST + OST GST - PST GST 9.9755 6% 5% 59 5% 14.975% 1156 596 Yukon GST 5% 11% 5% e. Use this address for your Company Home Renovation Ltd 8540 River Road Surrey, BC VIM 3GS t. Customer Information: find an address in the given city/province and use it to Invoice the customer 3. You must show all your calculations in Calculations worksheet. Do Not use a calculator, All calculations must be completed using excel functions. Resize your Calculations worksheet to a legal-size paper format, landscape orientation. Apply proper formatting to your worksheets Use cell references and make links through worksheets 4. Create two charts for your company on Charts worksheet A chart to illustrate the number of renovation projects per province. This chart is for your company to keep a record of their customers in different provinces. Use the chart to answer which province had the greatest number of projects? . A chart to illustrate the total area of renovation per province. This chart is for your company to keep a record of their projects. Use the chart to answer which province had the largest total renovated area completed by Home Renovation Ltd.? 5. Insert your student and course information in the Header of your workbook. Name the file Home Renovation LastFirstName (out your last and first name) and upload to the drop box . on eLeam Track Change of BCPT 123 Project: Home Renovation Imaging you are assigned to help a customer who is interested in home flooring renovation. The customer has requested a quote for his renovation project. You would need to prepare an invoice for your customer. To find out about your customer's home location (City and Province) and the area of flooring see the excel file titled Home Renovation. The Area-City worksheet lists your customer information based on your Banner ID. PLEASE READ the instructions carefully: 1. Create a VLOOKUP function to obtain your customer information from the table given in Area-City worksheet. You only create an invoice for your own customer 2. Prepare an invoice for your customer. See the Invoice worksheet for a sample of invoice. You are welcome to use that sample format a. Assume that Area of kitchen is 15% of the total renovation area Area of bathrooms is 10% of the total renovation area Area of living room and dining room is 35% of the total renovation area Area of bedrooms is 40% of the total renovation area b. Kitchen, living room and dining room flooring would be engineered wood flooring. Bathrooms would be natural stone tile floor and bedrooms would be carpet. Calculate the cost of flooring materials for kitchen, bathrooms, living room, dining room and bedrooms. Engineered wood flooring costs $4.45 per square foot and installation is $9.55 per square foot Natural stone tile floor costs $7.99 per square foot and installation is $7.25 per square foot . Carpet flooring costs $ 3.99 per square foot and installation is $4.95 per square foot c. Create an IF function to calculate delivery cost (delivery only applies to the materials and assume that materials will be delivered all together at the same time) Delivery is free of charge on the order of flooring materials below S3500 A $200 flat delivery rate applies on the order of flooring materials above $3500 and below $5000. A $300 flat de wer of flooring A $300 flat delivery rate applies on the order of flooring materials above $5000 d. Notice that the sales and services tax rates are different in each Canadian province. Create a VLOOKUP function using the tax table below to calculate the sales and services tax. Province TYPE PST GSTHIST Total Tax Rate Alberta GST British Columbia GST.PST 75% Manitoba GST.PST 74 546 New Inwich 15.15 Newfoundland and Labradorit 195.159 Northwest Territories GST Nova Scotia HIST Nunavut GST 59 Ontario 13413 Prince Edward Island HIST Queber GSTOST9.97% 14.975% Saskatchewan GST-PST64 % 11% Yukon GST 34 59 59 HIST e. Use this address for your Company. Home Renovation Ltd 8540 River Road Surrey, BC VIM 365 f. Customer information: find an address in the given city/province and use it to invoice the customer. 3. You must show all your calculations in Calculations worksheet. Do Not use a calculator. All calculations must be completed using excel functions. Resize your Calculations worksheet to a legal-size paper format, landscape orientation. Apply proper formatting to your worksheets. Use cell references and make links through worksheets. 4. Create two charts for your compony on Charts worksheet. A chart to illustrate the number of renovation projects per province. This chart is for your company to keep a record of their customers in different provinces. Use the chart to answer: which province had the greatest number of projects? A chart to illustrate the total area of renovation per province. This chart is for your company to keep a record of their projects. Use the chart to answer: which province had the largest total renovated area completed by Home Renovation Ltd.? 5. Insert your student and course information in the Header of your workbook. Name the file Home Renovation LastFirstName (put your last and first name) and upload to the drop box on eLearn BCPT 123 Project: Home Renovation Imaging you are assigned to help a customer who is interested in home flooring renovation. The customer has requested a quote for his renovation project. You would need to prepare an invoice for your customer. To find out about your customer's home location (City and Province) and the area of flooring see the excel file titled Home Renovation. The Area-City worksheet lists your customer information based on your Banner ID. PLEASE READ the instructions carefully: 1. Create a VLOOKUP function to obtain your customer information from the table given in Area-City worksheet. You only create an invoice for your own customer. 2. Prepare an invoice for your customer. See the Invoice worksheet for a sample of invoice. You are welcome to use that sample format. a. Assume that Area of kitchen is 15% of the total renovation area Area of bathrooms is 10% of the total renovation area Area of living room and dining room is 35% of the total renovation area Area of bedrooms is 40% of the total renovation area b. Kitchen, living room and dining room flooring would be engineered wood flooring. Bathrooms would be natural stone tile floor and bedrooms would be carpet Calculate the cost of flooring materials for kitchen, bathrooms, living room, dining room and bedrooms Engineered wood flooring costs 4 45 per square foot and installation is $9.55 per square foot Natural stone tile floor costs $7.99 per square foot and installation is $7.25 per square foot Carpet flooring costs $ 3.99 per square foot and installation is $4.95 per square foot c Create an IF function to calculate delivery cost (delivery only applies to the materials and assume that materials will be delivered all together at the same time): Delivery is free of charge on the order of flooring materials below 53500 A $200 flat delivery rate applies on the order of flooring materials above $3500 and below . . . . Changes: Ott Focus . Delivery is free of charge on the order of flooring materials below $3500 A $200 flat delivery rate applies on the order of flooring materials above $3500 and below $5000 A $300 flat delivery rate applies on the order of flooring materials above $5000 d. Notice that the sales and services tax rates are different in each Canadian province Create a VLOOKUP function using the tax table below to calculate the sales and . services tax Province TYPE PST GST HST Total Tax Rate Alberta British Columbia Manitoba New Brunswick GST GST + PST GST + PST HST 796 7% 5% 5% 5% 5% 12% 12% 15% 15% 15% 596 Newfoundland and Labrador Northwest Territories Nova Scotia Nunavut Ontario Prince Edward Island HST GST HST GST HST HST 15% 15% 5% 15% 596 13% 15% 596 139 15% Quebec Saskatchewan Yukon GST + OST GST - PST GST 9.9755 6% 5% 59 5% 14.975% 1156 596 Yukon GST 5% 11% 5% e. Use this address for your Company Home Renovation Ltd 8540 River Road Surrey, BC VIM 3GS t. Customer Information: find an address in the given city/province and use it to Invoice the customer 3. You must show all your calculations in Calculations worksheet. Do Not use a calculator, All calculations must be completed using excel functions. Resize your Calculations worksheet to a legal-size paper format, landscape orientation. Apply proper formatting to your worksheets Use cell references and make links through worksheets 4. Create two charts for your company on Charts worksheet A chart to illustrate the number of renovation projects per province. This chart is for your company to keep a record of their customers in different provinces. Use the chart to answer which province had the greatest number of projects? . A chart to illustrate the total area of renovation per province. This chart is for your company to keep a record of their projects. Use the chart to answer which province had the largest total renovated area completed by Home Renovation Ltd.? 5. Insert your student and course information in the Header of your workbook. Name the file Home Renovation LastFirstName (out your last and first name) and upload to the drop box . on eLeam Track Change of BCPT 123 Project: Home Renovation Imaging you are assigned to help a customer who is interested in home flooring renovation. The customer has requested a quote for his renovation project. You would need to prepare an invoice for your customer. To find out about your customer's home location (City and Province) and the area of flooring see the excel file titled Home Renovation. The Area-City worksheet lists your customer information based on your Banner ID. PLEASE READ the instructions carefully: 1. Create a VLOOKUP function to obtain your customer information from the table given in Area-City worksheet. You only create an invoice for your own customer 2. Prepare an invoice for your customer. See the Invoice worksheet for a sample of invoice. You are welcome to use that sample format a. Assume that Area of kitchen is 15% of the total renovation area Area of bathrooms is 10% of the total renovation area Area of living room and dining room is 35% of the total renovation area Area of bedrooms is 40% of the total renovation area b. Kitchen, living room and dining room flooring would be engineered wood flooring. Bathrooms would be natural stone tile floor and bedrooms would be carpet. Calculate the cost of flooring materials for kitchen, bathrooms, living room, dining room and bedrooms. Engineered wood flooring costs $4.45 per square foot and installation is $9.55 per square foot Natural stone tile floor costs $7.99 per square foot and installation is $7.25 per square foot . Carpet flooring costs $ 3.99 per square foot and installation is $4.95 per square foot c. Create an IF function to calculate delivery cost (delivery only applies to the materials and assume that materials will be delivered all together at the same time) Delivery is free of charge on the order of flooring materials below S3500 A $200 flat delivery rate applies on the order of flooring materials above $3500 and below $5000. A $300 flat de wer of flooring A $300 flat delivery rate applies on the order of flooring materials above $5000 d. Notice that the sales and services tax rates are different in each Canadian province. Create a VLOOKUP function using the tax table below to calculate the sales and services tax. Province TYPE PST GSTHIST Total Tax Rate Alberta GST British Columbia GST.PST 75% Manitoba GST.PST 74 546 New Inwich 15.15 Newfoundland and Labradorit 195.159 Northwest Territories GST Nova Scotia HIST Nunavut GST 59 Ontario 13413 Prince Edward Island HIST Queber GSTOST9.97% 14.975% Saskatchewan GST-PST64 % 11% Yukon GST 34 59 59 HIST e. Use this address for your Company. Home Renovation Ltd 8540 River Road Surrey, BC VIM 365 f. Customer information: find an address in the given city/province and use it to invoice the customer. 3. You must show all your calculations in Calculations worksheet. Do Not use a calculator. All calculations must be completed using excel functions. Resize your Calculations worksheet to a legal-size paper format, landscape orientation. Apply proper formatting to your worksheets. Use cell references and make links through worksheets. 4. Create two charts for your compony on Charts worksheet. A chart to illustrate the number of renovation projects per province. This chart is for your company to keep a record of their customers in different provinces. Use the chart to answer: which province had the greatest number of projects? A chart to illustrate the total area of renovation per province. This chart is for your company to keep a record of their projects. Use the chart to answer: which province had the largest total renovated area completed by Home Renovation Ltd.? 5. Insert your student and course information in the Header of your workbook. Name the file Home Renovation LastFirstName (put your last and first name) and upload to the drop box on eLearn