Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started