the solution should be like the last picture

Please form a spreadsheet model to calculate the BE quantity for the below problem: Consider a project where the intial investment (fixed cost) is $100,000. The variable cost of pro Production upto 1000 units: $10.00 1000 Breakeven volume is 8 Total Cost $ 105,333.33 9 Total Revenue $ 10 Profit ($105,333.33) 11 12 13 Use Goal Seek function under the Tools menu 14 and fill it as in the next picture: 15 Profit function into set cell 16 Preferred value (zero) into To value: 17 and the decision variable volume into By changing cell 18 Then say OK, to get the B-E volume in cell B7. 19