Purchase Solution

Solve production function using excel and optimization procedure

Not what you're looking for?

Ask Custom Question

Given the following production function:
Q = 42L + 18L2 -2L3 WHERE Q= TP (TOTAL PRODUCT) or quantity of output in units and L(labor) in units
FIND THE FOLLOWING: First solve this problem using an spreadsheet approach and then do the problem using the optimization procedure; compare the answers for the two methods. Show your work to receive credit.
A: The amount in units of labor when diminishing returns to labor sets in and then explain why this happens.
B. The amount in units of labor used when the average product curve is at its highest point.
C. What amount of labor in units should be used to get maximum output?

Purchase this Solution
Solution Summary

A production function is analyzed using a spreadsheet approach. The amount of units of labor when diminishing returns to labor sets in is explained.

Solution Preview

Please find my response attached,

So, I'll run through normal optimization first. It looks like you've got three different powers of labour. If these are different variables, please let me know so I can correct my calculation.

Q= 42L + 18L2-2L3

Where "Q" is an expression for total product. We're going to need an expression for marginal product to perform a future calculations, so let's take the first derivative of the total product curve.

MP=42+36L-6L2

We're also going to find ...

Purchase this Solution
Free BrainMass Quizzes
Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

View More Free Quizzes
Related BrainMass Solutions

  • Linear Optimization Model

    Formulate and solve a linear optimization model using the auxiliary variable cells method and explain the sensitivity information. b.

  • Using LP Model for determining maximum profit

    Answer the following questions: 3.1)Write down the decision variables. 3.2)Write down the optimization statement for the objective function. 3.3)Write down the constraints. 3.4)Solve the LP problem in Excel Solver and write down the optimal solution

  • Formulation and Spreadsheet Modeling using Excel and Solver

    53715 Linear Programming : Algabraic Formulation and Spreadsheet Modeling using Excel and Solver Optimization Problem using Excel add-in Solver This problem requires the use of Excel and the add-in, called Solver.

  • Product mix linear optimization

    Please solve and describe the model ie objective fx etc The LP formulation is in the attached JPEG file and the solution using excel solver is in the attached excel file. Let me know if you have any questions/comments. Thanks.

  • optimization

    233108 Optimization I have a problem that needs to be solved using any numerical programming. It has been solved and two examples are provided for validation. The only thing missing is the procedure program.

  • Decision models

    Louis Develop an appropriate integer optimization model and solve it with Solver. Hint: your only decision variables are whether or not to select a city as a hub. Hello Please see the excel file for 1.

  • Portfolio Optimization Problem

    w such that |w| = 1 and ?w = 0.12. We solve this using the solver function of excel, taking advantaging of the function mmult (multiplying two matrices).

  • Linear programming model for bicycle manufacturer

    Formulate and solve a linear programming model to find a cost-minimizing production schedule that meets all demands on time.

  • Unconstrained Optimization: level of production that maximizes profits

    2749 Unconstrained Optimization: level of production that maximizes profits Unconstrained Optimization 1. Assume that you can sell widgets at $25 per widgets, for as many widgets as you can make.

View More Related Solutions