Skip to main content Accessibility help
Internet Explorer 11 is being discontinued by Microsoft in August 2021. If you have difficulties viewing the site on Internet Explorer 11 we recommend using a different browser such as Microsoft Edge, Google Chrome, Apple Safari or Mozilla Firefox.

Chapter 2: Solving Numerical Allocation Problems Using Excel's Solver

Chapter 2: Solving Numerical Allocation Problems Using Excel's Solver

pp. 41-74

Authors

, Cornell University, New York
  • Add bookmark
  • Cite
  • Share

Summary

INTRODUCTION AND OVERVIEW

Numerical allocation problems can serve at least two functions. First, they can make theory and methods less abstract and more meaningful. Second, they can serve as a useful bridge from theory and general models to the actual analysis of “real world” resource-allocation problems. By a numerical problem, I mean a problem where functional forms have been specified, and all relevant parameters and initial conditions have been estimated or assigned values. For example, in Section 1.4, the general net-benefit function took the form πt = π(Xt , Yt ). A specific functional form, used in Exercises E1.1 through E1.3, was, where p > 0 was a parameter denoting the per-unit price for fish on the dock, Yt was the level of harvest in period t, c > 0 was a cost parameter, and Xt was the fish stock in period t. In a numerical problem, we would need values for p > 0 and c > 0, which might be estimated econometrically or simply assigned values based on a knowledge of current market prices and the cost of operating a fishing vessel.

Numerical analysis might involve solving an implicit equation for the steady-state value of a resource stock, the deterministic or stochastic simulation of a harvest or extraction policy, or the selection of escapement, harvest, or extraction rates to maximize some measure of present value.

About the book

Access options

Review the options below to login to check your access.

Purchase options

eTextbook
US$51.00
Hardback
US$154.00
Paperback
US$51.00

Have an access code?

To redeem an access code, please log in with your personal login.

If you believe you should have access to this content, please contact your institutional librarian or consult our FAQ page for further information about accessing our content.

Also available to purchase from these educational ebook suppliers