What is market equilibrium?
Market equilibrium is the price–quantity combination at which quantity demanded equals quantity supplied. There is no shortage or surplus, so there is no pressure for the price to rise or fall.
How do you calculate the equilibrium price and quantity?
Set the demand and supply prices equal. For linear curves P = a − bQ and P = c + dQ, solving gives Q* = (a − c) ÷ (b + d), and substituting back gives P* = a − bQ*. The calculator floors quantity at zero if the curves do not cross at a positive quantity.
Why do I set demand equal to supply?
At equilibrium a single price prevails and the same quantity is bought and sold, so the price buyers will pay for that quantity must equal the price sellers require. Setting the two equations equal pins down that shared point.
What are the slopes b and d?
They measure how steeply price changes with quantity. The demand slope b is how much the price buyers will pay falls for each extra unit; the supply slope d is how much the price sellers require rises for each extra unit. Steeper curves mean a more inelastic side.
What is consumer and producer surplus?
Consumer surplus is the value buyers receive above the price they pay — the triangle between the demand curve and the price. Producer surplus is the amount sellers receive above their minimum acceptable price — the triangle between the price and the supply curve. Together they are total surplus, the gains from trade, which is largest at the competitive equilibrium.
How does a shift in demand or supply change the equilibrium?
An increase in demand (rightward shift) raises both price and quantity; a decrease lowers both. An increase in supply lowers price but raises quantity; a decrease raises price but lowers quantity. When both curves move, one of price or quantity is determinate and the other depends on the relative size of the shifts — the simulator shows this.
When does a price ceiling or floor actually bind?
A price ceiling binds only when it is set below the equilibrium price, creating a shortage. A price floor binds only when it is set above the equilibrium price, creating a surplus. A ceiling above or a floor below equilibrium has no effect, and the market clears normally.
What is deadweight loss from a price control or tax?
Deadweight loss is the value of mutually beneficial trades that no longer happen because the policy holds quantity away from the efficient level. On a linear diagram it is the triangle between the supply and demand curves over the units that stop trading — surplus destroyed that no one captures.
Who bears a tax — buyers or sellers?
Whoever is less able to walk away. Incidence is determined by relative elasticity, not by who legally remits the tax. With linear slopes, buyers bear b ÷ (b + d) of a per-unit tax and sellers bear d ÷ (b + d); the steeper (more inelastic) side carries more.
How is a subsidy different from a tax here?
A per-unit subsidy is a negative wedge: it expands quantity beyond the free-market level, lowers the price buyers pay, and raises the price sellers receive. It costs the government money and still creates deadweight loss by pushing the market past its efficient quantity.
What does elasticity at the equilibrium tell me?
Point elasticity measures how responsive quantity is to price at the equilibrium. The tool computes |Ed| = (1 ÷ b) × (P* ÷ Q*) for demand and Es = (1 ÷ d) × (P* ÷ Q*) for supply. Values above 1 are elastic (responsive), below 1 inelastic, and exactly 1 unit elastic.
Can I enter a real demand and supply schedule instead of an equation?
Yes. Switch to the two-point mode and enter two (quantity, price) points on each curve; the calculator fits the linear equation, warns you if a curve slopes the wrong way, and then runs the full analysis on the fitted curves.
Why might the calculator show a quantity of zero?
If the supply intercept exceeds the demand intercept, sellers’ minimum price already tops buyers’ maximum, so no mutually agreeable trade exists. The model floors quantity at zero and the surplus and policy modules switch off until the curves cross at a positive price.
Is this a forecast of real prices?
No. It is a teaching and decision-support model of idealised linear curves. Real markets curve, shift, and adjust over time, and are affected by frictions the model ignores. Use it to build intuition and check homework, not to predict a market price.
What does the Excel workbook include?
Fifteen sheets: Start Here, Inputs, Equilibrium, Surplus, Schedule, Shift Simulator, Price Ceiling, Price Floor, Tax, Subsidy, Elasticity, Scenario Comparison, Dashboard, Methodology, and a Printable Summary. The Inputs sheet drives everything with live formulas, so editing a, b, c, d or a policy lever recalculates the whole workbook in Excel or Google Sheets.