please help answer this question 1. It is related to business analytics and must use excel spreadsheet matched in the spreadsheet below.

Unit price drop down options:

Total Cost drop down options:

Suppose that a compary oflers quantity discounts. If up to 1,000 units ace purchased, the unit price is 510 ; if more eran 1,000 and up to 5,000 units are purchased, the unit price is $8, 00; and if thore than 5.000 units are purchased, the unit price is $5.50, Develop an Excel template using the VLookuP function to find the unit price associated with any order quanbity and compude the total cost of the order. Complete the formulas in the spreadsheet bolow. Select the correct vLoOkUp hunction in cell Cs to find the unt price for the ceder quantity mmen nhenere of decimal munded to who decimali places as needed the erter. STyepe ntegers of decimals iounded to the decimal nlaces ai feathd WLOCNUPiBe.s+s2s04,1,0\} intoonupe6,s, 52504,4,1) avocicupibs, $452,54,4,1) whookup(sests.s.54,1.0) Suppose that a company offers quartily ditcounts. If up to 1,000 unas are purchased, the unit peice is $10, if more than 1,000 and up to 5,000 units are purchased, the unit price is $8, o0, and if more than 5.000 unts are purchased, the unt price is $5.50. Develop an Excet template using the viookup fianction to find the unit price associated when any order quantily and cormpute the folat cost of the order Complete the formplas in the spreadeheot betion. Solect the correct vLo KuUP function in cell Ce to find the unit price for the order quant y. (Type integere or decimais rounded to two decmat olaces an needed )