Question: Using Excel 2016 , create a spreadsheet using formulas for Marginal Product , Total Revenue , and Marginal Revenue Product (which must be calculated) as

  1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!