11.10.22 A stockbroker calls on potential clients from referals. For each call, there is a 20% chance that the client will decide to invest with the stockbroker's firm. Forty percent of those interested are found not to be qualified, based on the brokerage firm's screening criteria. The remaining are qualified. Of these, half will invest an average of $5,000, 25% will invest an average of $20,000, 15% will invest an average of $50,000, and the remainder will invest $100,000. The commission schedule is as follows:

Transaction Amount	Commission
Up to $25,000	$75 + 0.5% of the amount
$25,001 to $75,000	$100 + 0.4% of the amount
$75,001 to $100,000	$150 + 0.3% of the amount

The broker keeps half the commission. Develop a spreadsheet to calculate the broker's commission based on the number of calls per month made. What is the expected commission based on making 250 calls?

PLEASE SHOW ME HOW TO SOLVE ON EXCEL!!!!!

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Markdown Pricing Model & & & Scenario & ITen/ten & Twenty/twenty & Thirty/thirty & Forty/forty \\ \hline & & & Days at full retail price & 10 & 20 & 30 & 40 \\ \hline Data & & & Intermediate markfown & 0.1 & 0.2 & 0.3 & 0.4 \\ \hline Retail price & $70.00 & & & & & & \\ \hline Inventory & 1000 & & & & & & \\ \hline Selling season (days) & 50 & & & & & & \\ \hline Days at full retail & 40 & & & & & & \\ \hline Intermediate markdown & 30% & & & & & & \\ \hline Clearance markdown & 70% & & & & & & \\ \hline & & & & & & & \\ \hline Sales Data & Average & & & & & & \\ \hline Price (X) & Daily Sales (Y) & & & & & & \\ \hline$70 & 7.00 & & & & & & \\ \hline$49 & 32.20 & & & & & & \\ \hline Demand function parameters & & & & & & & \\ \hline Intercept & 91 & & & & & & \\ \hline Slope & -1.2 & & & & & & \\ \hline & & & & & & & \\ \hline Model & & & & & & & \\ \hline & & & & & & & \\ \hline Full Retail Sales & & & & & & & \\ \hline Retail price & $70.00 & & & & & & \\ \hline Daily sales & 7.00 & & & & & & \\ \hline Days at retail price & 40 & & & & & & \\ \hline Units sold at retail & 280 & & & & & & \\ \hline & Retail revenue & $19,600.00 & & & & & \\ \hline Discount Sales & & & & & & & \\ \hline Discount & 30% & & & & & & \\ \hline Discount price & $49.00 & & & & & & \\ \hline Daily sales & 32.20 & & & & & & \\ \hline Unit sold & 322 & & & & & & \\ \hline & Discount revenue & $15,778.00 & & & & & \\ \hline Clearance Sales & & & & & & & \\ \hline Clearance price & $21.00 & & & & & & \\ \hline Units sold at clearance & 398 & & & & & & \\ \hline \end{tabular}