Skip to content
SpreadsheetWeb
FeaturesPricingBlogCustomersEnterpriseGallery
Sign up for freeSign In
FeaturesPricingBlogCustomersEnterpriseGallery
Sign up for freeSign In

Economics demo

Cost Curves Calculator

Explore how fixed and variable costs change as resource use and production output increase. Edit the production grid to compare total, average fixed, average variable, and average total costs.

Cost Curves Calculator with editable production data, calculated costs, and an average-cost chart

SpreadsheetWeb application example

About this cost curves application

In microeconomics and business analysis, costs rarely increase in a straight line with output. Understanding how fixed, variable, average, and total costs behave across production levels is key for evaluating efficiency and decision-making.

This live example preserves the formulas in the published SpreadsheetWeb workbook while replacing its embedded interface with an accessible, responsive browser experience.

What this demo shows

  • A ten-row editable resource and production grid
  • Automatic fixed, variable, total, and per-unit cost calculations
  • Interactive average-cost curves with the minimum-ATC resource highlighted

Live economics model

Build and compare your cost curves

Set the unit and fixed costs, then edit the resource and production levels in the grid. Every valid change recalculates the published workbook automatically.

$

Model assumptions

Cost inputs

Workbook analysis

Minimum average total cost

Lowest cost of the resource is obtained at the minimum point of the ATC curve.

Resource level4
Product / service2,600
Minimum ATC0.1538

Editable production model

Resource and output grid

Yellow cells are inputs. Calculated workbook values update automatically.

Editable inputsTotal costsAverage costs per unit
ResourceProduct / serviceFCVCTCAFCAVCATC
200.0050.00250.000.32000.08000.4000
200.00100.00300.000.15090.07550.2264
200.00150.00350.000.09090.06820.1591
200.00200.00400.000.07690.07690.1538
200.00250.00450.000.06900.08620.1552
200.00300.00500.000.06450.09680.1613
200.00350.00550.000.06080.10640.1672
200.00400.00600.000.05710.11430.1714
200.00450.00650.000.05560.12500.1806
200.00500.00700.000.05410.13510.1892

Visual analysis

Average cost curves

AFCAVCATCBest
Average fixed, variable, and total cost curvesThe chart updates as resource and product levels change. A vertical marker identifies the resource level with the lowest average total cost.Loading workbook curve data…

At the optimum

Cost breakdown

Fixed cost
200.00
Variable cost
200.00
Total cost
400.00
Average fixed cost
0.0769
Average variable cost
0.0769
Average total cost
0.1538

Connecting to the live workbook…

Powered bySpreadsheetWeb
Disclaimer

The information provided by this calculator is intended for informational and educational purposes only. The default figures shown are hypothetical and may not be applicable to your individual situation. We are not responsible for the consequences of decisions or actions taken in reliance upon the information provided by this tool.

Cost curve concepts

What the calculator shows

The workbook separates costs that remain fixed from costs that rise with each additional resource unit, then compares both against the production output entered in the grid.

Fixed and variable cost

Fixed cost remains constant across production levels. Variable cost equals the resource level multiplied by its unit price.

Total cost

Total cost combines the fixed and variable components for each resource level.

Average costs

AFC, AVC, and ATC divide each cost measure by the corresponding product or service output.

Efficient scale

The highlighted resource is the row where average total cost reaches its minimum in the published model.

Practical applications

Use cost curves to compare production scenarios

  • Economics educationExplore the relationship between inputs, output, and per-unit cost.
  • Business analysisModel production costs and identify the most efficient row in a scenario.
  • Operations planningCompare how changing resource prices or fixed overhead affects scale.
  • Policy researchIllustrate cost structures without distributing the underlying workbook.

Build from your spreadsheet

Convert My Excel Model to a Web App

Explore more examples in the gallery or talk with the SpreadsheetWeb team about your application.

Sign-up for a free accountView more demos

Product

FeaturesGalleryCustomersDevelopers & APITemplates

Solutions

IndustriesMarketingHuman ResourcesFinanceSales

Use Cases

Online CalculatorsSales QuotingTimesheet AppsScored QuestionnairesSearch ApplicationsReporting Applications

Support

User GuideTraining VideosCase StudiesTips

Resources

BlogExcel ApplicationsExcel Tips & TricksExcel FormulasExcel MacrosExcel Templates

About

About UsContact UsServices

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use -

FacebookXLinkedIn