$Hi,$ can you help $me$ understand how I would arrive $atan$ optimal highest and lowest price point for each product being sold $in$ this exercise?

Intro Overview

$of$ the exercise Gabbie's auto shop, $is$ interested $in$ buying a large order $of$ vehicles from $us.We$ expect continued growth $of20\%$

You need $to$ decide what pricing you will propose for the four products, choosing a starting price and $as$ a best and final price. Please decide

price points you feel are best for each product for the walk $in$ and walk out. Your constraints are that:

Lowest product margin allowed $is10\%$

Lowest portfolio margin allowed $is20\%$

Prices should $be$ roughly inline with the comparables $by$ volume for each product $(see$ product comps tab$)$

Then build $a\frac{P}{L}$ for the following scenarios

Current Deal

Walk $In$ Deal $(Starting$ Deal$)$

Walk Out Deal $(Best$ and Final Deal$)$

Please $be$ sure $to$ model $soitis$ easy $to$ follow and easy for someone $to$ pick $up$ where you left off with little questions needed.

Please add a legend $(if$ applicable$)on$ any color coding you use

Please make the prices inputs that can $be$ changed $if$ desired

Please prepare a summary $on$ one tab that clearly shows the following:

For Company

Product Revenue

Ancillary Revenue

Total Revenue

Gross Profit

Gross Margin $(\%)$

$2$

For the Client View

Total Service Fees

Total Additional Costs

Total Cost $(Service$ Fees $+$ Additional Costs$)$

$\%$ change $in$ Total Cost between Current, Walk $in$ and Walk Out

Please prepare a detailed view $on$ a seperate tab from above showing the following

Everything above

Please prepare a detailed view $on$ a seperate tab from above showing the following

Everything above

The prices $by$ product

The margin $by$ product

The profit $by$ product

The $\%of$ Revenue $by$ product $(of$ the total revenue$)$

$367000,$$$240,000,000$

$1700$$$60,000,000$

$27400$$$840,000,000$

$3600$$$120,000,000$

$9400$$$320,000,000$

$11800$$$370,000,000$

$18900$$$540,000,000$

$10000$$$320,000,000$

$12800$$$480,000,000$

$6700$$$220,000,000$

$18700$$$590,000,000$

$10200$$$$310,000,000$

$3200$$$120,000,000$

$4400$$$160,000,000$

$2000$ $$70,000,000$

$16000$ $$500,000,000$

$3500$$$110,000,000$

$5400$$$180,000,000$

$7900$$$270,000,000$

$18000$$$570,000,000$