Question
You are given the following data about the utility for coffee. Total Utility (TU) is measured in 100s of utils and the quantity of coffee
You are given the following data about the utility for coffee. Total Utility (TU) is measured in 100s of utils and the quantity of coffee (Q) is measured in number of cups of coffee consumed. You will be making a presentation about utility to your Microeconomics class. The data is listed below. The source for your knowledge about utility is from a book Coffee Utility and The Individual, 5rd edition, by Herman Franks, Pantheon Press Publishers, Toronto, Ontario, 2019. Total Utility (TU) 0 10 17 25 31 35 35 26 18 Quantityofcoffee 012345678
1.a. In one clearly and accurately labeled graph, created using Excel, graph your Total Utility (TU) curve of your coffee consumption. This will be graph
B.In one clearly and accurately labeled graph, created using Excel, graph your Marginal Utility (MU) curve of your coffee consumption. MU is measured in 100s utils. This will be graph # 3 in your presentation.
C. In one clearly and accurately labeled table, created using Excel, list your data for MU, being certain to show all your work for calculating MU.
d. Based solely on your graphs in parts a and b, and specifically referencing both graphs, explain,
a. where TU and MU have hit their peak and why,
b. explain where and why diminishing marginal utility is located on both graphs, and
c. explain where negative marginal utility is located on both curves and why.
Graphs and tables for this assignment must be properly constructed and created using Excel. Prepare your assignment as a Word document with embedded Excel charts. Number each step of the assignment. The assignment may be submitted
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