Explore BrainMass
Share

Explore BrainMass

    Cubic Production Function

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    In Microsoft Excel please respond to all questions and math problems in the following problem (See Attachment). Please show Microsoft Excel formula(s) and work.

    -----------------------

    Homework Exercise Numbers 1

    1. A firm estimates its cubic production function of the following form: Q = AL3 + BL2 and obtains the following results:

    [see attachment for table]

    a. The equations for total product, average product, and marginal product are:
    TP = ___________________________
    AP = ___________________________
    MP = ___________________________

    b. The estimated values of A and B are statistically significant at the (exact) levels, ________ and _________, respectively.

    c. At _______ units of labor usage, marginal product of labor begins to diminish.

    When the wage rate is $300, answer the following questions. (Remember that AP =
    Q/L; AVC = w/AP; and SMC = w/MP.)

    d. Average product of labor reaches its maximum value at ________ units of labor.

    e. At the output for part d, average variable cost is $______________ and marginal cost is $____________.

    f. When the rate of labor usage is 100 units of labor, output is _______ units.
    Average variable cost is $_________ and marginal cost is $__________.

    © BrainMass Inc. brainmass.com October 10, 2019, 4:07 am ad1c9bdddf
    https://brainmass.com/math/graphs-and-functions/cubic-production-function-449502

    Attachments

    Solution Preview

    Please see the attached file. Feel free to let me know if you have any questions!

    If you are downloading this solution from the solution library, you can send me a message through BrainMass or create a posting requesting me as the OTA if you have addition questions or would like clarification.

    -------------------------------------------------------------------------------------------------------------

    Homework Exercise Numbers 1

    1. A firm estimates its cubic production function of the following form: Q = AL^3 + BL^2 and obtains the following results:

    DEPENDENT VARIABLE Q R?SQUARE F?RATIO P?VALUE ON F
    ...

    $2.19