Suppose that Maria is starting a food ordering and delivery company. Customers order meals online. Employees prepare the meals and deliver them to customers. Maintenance of the online platform for ordering meals costs the company $5 per day. The company also rents space where orders are prepared. Rent costs $50 per day. To make the deliveries, the business also rents two delivery cars that cost $10 each per day. The costs of ingredients for preparing different numbers of meals are provided in the table below. Maria also has to hire between 0 and 10 workers (depending on the number of meals she chooses to make) to buy ingredients, prepare meals, and deliver the orders. She will pay each employee $120 per day. The first two columns of the table below show how many meals different number of workers can prepare and deliver. $50 Price per meal Workers Meals (Labor L) (Output Q) 0 0 1 2 3 4 5 6 30 42 52 60 67 73 MPL FC Cost of ingredients $10 $75 $100 $121 $138 $152 $165 $177 $189 $199 $210 VC TC AFC AVC 7 79 8 85 9 90 10 95 a) Use Excel Charts to graph this business' production function (relationship between L and Q). Hint: Select the data that you would like to be included, and go to Insert/ Chart => All charts => Select "Line". ATC b) Use Excel functions to find the marginal product of labor (MPL) and enter it into the third column of the table. Note: MPL = change in Q/ change in L c) Graph MPL as a function of the number of workers Maria hires. MC TR Profit Profit per meal

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
Question 2: Costs and Production (Parts a - k)
Suppose that Maria is starting a food ordering and delivery company.
Customers order meals online. Employees prepare the meals and deliver them to customers.
Maintenance of the online platform for ordering meals costs the company $5 per day.
The company also rents space where orders are prepared. Rent costs $50 per day.
To make the deliveries, the business also rents two delivery cars that cost $10 each per day.
The costs of ingredients for preparing different numbers of meals are provided in the table below.
Maria also has to hire between 0 and 10 workers (depending on the number of meals she chooses to make) to buy ingredients, prepare meals, and deliver the orders.
She will pay each employee $120 per day.
The first two columns of the table below show how many meals different number of workers can prepare and deliver.
Price per meal
$50
Workers
Meals
(Labor L) (Output Q)
0
0 ol
1
2
3
4
5
6
7
8
9
MPL
10
FC
Cost of
ingredients
$10
$75
$100
$121
$138
$152
30
42
52
60
67
73
79
85
90
95
a) Use Excel Charts to graph this business' production function (relationship between Land Q).
Hint: Select the data that you would like to be included, and go to Insert/ Chart => All charts => Select "Line".
$165
$177
VC
$189
$199
$210
TC
AFC
AVC
ATC
b) Use Excel functions to find the marginal product of labor (MPL) and enter it into the third column of the table.
Note: MPL = change in Q/ change in L
c) Graph MPL as a function of the number of workers Maria hires.
MC
TR
Profit
Profit per
meal
Transcribed Image Text:Question 2: Costs and Production (Parts a - k) Suppose that Maria is starting a food ordering and delivery company. Customers order meals online. Employees prepare the meals and deliver them to customers. Maintenance of the online platform for ordering meals costs the company $5 per day. The company also rents space where orders are prepared. Rent costs $50 per day. To make the deliveries, the business also rents two delivery cars that cost $10 each per day. The costs of ingredients for preparing different numbers of meals are provided in the table below. Maria also has to hire between 0 and 10 workers (depending on the number of meals she chooses to make) to buy ingredients, prepare meals, and deliver the orders. She will pay each employee $120 per day. The first two columns of the table below show how many meals different number of workers can prepare and deliver. Price per meal $50 Workers Meals (Labor L) (Output Q) 0 0 ol 1 2 3 4 5 6 7 8 9 MPL 10 FC Cost of ingredients $10 $75 $100 $121 $138 $152 30 42 52 60 67 73 79 85 90 95 a) Use Excel Charts to graph this business' production function (relationship between Land Q). Hint: Select the data that you would like to be included, and go to Insert/ Chart => All charts => Select "Line". $165 $177 VC $189 $199 $210 TC AFC AVC ATC b) Use Excel functions to find the marginal product of labor (MPL) and enter it into the third column of the table. Note: MPL = change in Q/ change in L c) Graph MPL as a function of the number of workers Maria hires. MC TR Profit Profit per meal
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Sales
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education