GD.Let’s connect
← Back to all projects

MANAGERIAL ECONOMICS · ECON 408

Excel Project 1

An Excel model of monopoly pricing, output, and the effects of a per-unit tax.

ExcelEconomic modelingProfit maximizationSensitivity analysis

Overview

A managerial economics exercise using demand, revenue, and cost functions to examine a monopolist’s decisions. The workbook compares outcomes before and after a specific tax.

Methods & skills applied

  • Calculate price, elasticity, revenue, cost, and profit across output levels.
  • Apply the marginal revenue equals marginal cost rule.
  • Examine the Lerner Index and the change in optimal price and output after a tax.

Explore the original work

PDFs open in a new tab. Excel and Word files download for viewing in a compatible application.

Excel Project 1XLSX · Original Excel workbook↓

Academic coursework · Original submitted files are provided for review.