I need help to solve this problem on a spreadsheet, please, show step by step how to do it on a spreadsheet. Suppose there are $50$ firms operating in a perfectly competitive market. All firms have an identical cost structure which is C$($q$)=3000+1000$q$100$q$^2+5$q$^3.$ If the market demand is Q$=6000\mathrm{.}25$P$.$

a$.$ At what range of prices does this firm earn positive profit?

b$.$ At what range of prices will this firm earn a loss and still operate and does not shut down? Why does

c$.$ this firm prefer to operate even if it is earning a negative profit?

d$.$ At what range of prices does this firm shut down?