pricing policy to maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold $(N)$ and prices $(P)$ of each model:

$N_A=18-0\mathrm{.}61P_A+0\mathrm{.}38P_B$

$N_B=34+0\mathrm{.}11P_A-0\mathrm{.}56P_B$

Develop a spreadsheet for calculating the total revenue if $P_A=$$$17$ and $P_B=$$$30.$ Design it so that the price$-$demand function parameters can easily be changed.

Complete the spreadsheet below.

$($Type integers or decimals. Round the quantities to the nearest integer as needed. Do not include the $ symbol in your answers.$)$