Question
Using Excel 2016 , create a spreadsheet using formulas for Marginal Product , Total Revenue , and Marginal Revenue Product (which must be calculated) as
- Using Excel 2016, create a spreadsheet using formulas for Marginal Product, Total Revenue, and Marginal Revenue Product (which must be calculated) as shown in question #6a to #6h of your tutorial.
Labour Demand Schedule for a Perfectly Competitive Firm | |||||
Number of Workers | Total Output | Marginal Product | Price | Total Revenue | Marginal Revenue Product |
15 | 50 | $5 | |||
16 | 65 | $5 | |||
17 | 78 | $5 | |||
18 | 89 | $5 | |||
19 | 98 | $5 | |||
20 | 105 | $5 | |||
21 | 110 | $5 | |||
22 | 113 | $5 | |||
23 | 114 | $5 |
2. How many workers could this competitive firm hire to maximize its total profit if the firm is paying its
workers a wage of $17 per hour? make a graph as shown in question #6i in your tutorial. Include all labels.
3. How many workers should be hired if the wage rate were to fall to $13 per hour? make a second graph
as shown in question #6j in your tutorial. Include all labels.
4. For each of the following scenarios in the labour market for "fast food", input the following in a .
(i) Does the supply or demand curve increase or decrease?
(ii) State which supply/demand factor (from your notes) applies to each scenario.
(iii) What impact does each scenario have on the wage rate (increase or decrease)?
a) The federal government imposes a "fast food" tax to encourage healthier eating.
b) There are fewer teenaged workers (in Canada's population) who are available for shift work in the fast food industry.
c) The fast food chains are increasing their minimum wage.
d) The fast food chains offer discounts on fast food over the summertime period.
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