Use Goal Seek to solve values

Help me solve for the monthly price needed to hit a target EBITDA of 1.4 million next quarter. The model links price to volume through a simple elasticity and includes fixed costs of 320,000. Use Goal Seek on the cell that calculates EBITDA, change the price input cell, and write down the converged price so I can put it in the proposal to procurement by Thursday.

Before I present the Goal Seek result to Sales, make it persuasive: show the starting price, the solved price, and the implied percentage change in volume next to it. Call out if the solution requires a price outside our historical range or pushes volume below 10,000 units so Katie won’t be surprised.

I set EBITDA as the target and used price as the changing cell but Goal Seek failed to converge. Procurement expects a number and I don’t know whether the model is non-linear, constrained, or has linked references that block adjustment. What is the most likely reason for failure and the fastest diagnostic I can run to get a usable price before the procurement meeting?

I keep running Goal Seek for similar KPIs across products every month and the work repeats. Should I build a small scenario table with pre-set targets, use named ranges for the changing variables, or create a one-click solver sheet so I stop rebuilding the same Goal Seek steps? Which habit change will cut my time by half?