$(5$ pts$.)$ Calculate the ADMINISTRATIVE COSTS for booking the trip in cell I$6.$ The

administrative cost is calculated by multiplying the CUSTOMER PRICE in cell $36$ by the

administrative cost percentage in cell $14.$ Copy the formula down the column.

$(3$ pts$)$ Calculate the COST PER TRAVELER in cell J$6.$ Add the AIRFARE, HOTEL,

BREAKFAST, SIGHTSEEING, and ADMINISTRATIVE costs in columns E$.$I. Copy the

formula down the column.

$(3$ pts$.)$ Calculate the TOTAL COSTS in cell $K6$ as the COST PER TRAVELER in J$6$

multiplied by the NUMBER OF TRAVELERS in C$6.$ Copy the formula down the column.

$(3$ pts$)$ Calculate the NET REVENUE in cell L$6.$ It is calculated by the TOUR REVENUE in

D$6$ minus the TOTAL COSTS in K$6.$ Copy the formula down the column.

$(1$ pts$)$ in row $25,$ calculate the TOTALS for each column $C$ to $L.$

$(4$ pts$.)$ in rows $26$ to $27,$ calculate the AVERAGE and COUNT for each column C:L$.$

$(5$ pts $)$ in cell M$6,$ calculate the PERCENTAGE OF NET REVENUE for each Tour. To find

the Percentage of Net Revenue, the NET REVENUE in L$6$ for each tour should be taken as