Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5. Use Excel to answer the following questions. Make sure to use equations in your excel sheet rather than making the calculation by hand or

5. Use Excel to answer the following questions. Make sure to use equations in your excel sheet rather than making the calculation by hand or using a calculator and entering it in the cells. (Excel is your friend. Doing this by hand would be painful.) Submit your excel file. Candyland is a small manufacturer of lollipops, which sell for 30 cents per lollipop. In the short run the daily production of lollipops, Q, is the following function of its daily employment of workers, L: Q = 10L2 -0.05L3 Suppose they always hire in intervals of 2, so they hire 2, 4, 6, 8, , up to 150 laborers. Using excel, find the Marginal Product of Labor, the Average Product of Labor, the Marginal Revenue Product of Labor for 2, 4, 6, 8, .., 150 laborers. Use the graphing features of excel, graph the Marginal Product of Labor and Average Product of Labor on the same graph. Make sure axes are labelled as well as the lines. At approximately which unit of Labor does Average Product of Labor Peak? Suppose the daily wage rate is $100 per worker. To maximize profit, Candyland employs _______ workers per day. If the total nonlabor costs of producing at this level is $2000, the firm should make approximately $________ in profits per day.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Karen Wilken Braun, Wendy M. Tietz

2nd Custom Edition

1269396803, 978-1269396806

More Books

Students also viewed these Accounting questions

Question

What are the four temperament types included in Pavlovs system?

Answered: 1 week ago