Solve out this question by using the SOLVER function in Excel.

File 5 e Undo Home Insert Page Layout Cut LB Copy Paste Format Painter Clipboard A UNITS SOLD PRICE PER UNIT REVENUE 7 8 COST PER UNIT 9 COSTS 10 11 PROFIT 12 13 TARGET PROFIT 14 15 CONSTRAINTS: 16 PRICE 17 PRICE 18 UNIT SOLD 19 20 21 22 23 24 25 26 $ Formulas Data Calibri B S > B I U $ 0.85 $4,500.00 H - ROUNDED Font 11 1 2 Use SOLVER to find Units Sold and Price per unit 3 4 5 6 C Review View Automate Help A A A $ 4.50 $ 3.50 D == = = = = E ab Wrap Text Alignment Merge & Center F V 5 G Accounting $%900 00 Number H Conditional Format as Formatting Table I J Normal Neutral K Bad Calculation Styles L Good Check Cell M N Insert Delete Format Cells O AutoSum Fill Clear P 27 Sort & Find & Filter Select Editing Comments Q GDD M Analyze Data Analysis R Share