A B 3 4 5 6 7 D E F G H Bret's Accounting & Tax Services is a small well-known accounting firm in Sioux City, IA which completes taxes for individuals. Every year, firms like Bret's decide how much they will charge to complete and file an individual tax return. This price determines how many tax returns firms complete each year. Suppose you are an office manager for a firm like Bret's Accounting and Tax Services and you are trying to determine what your firm should charge next year for tax returns. Use the following data to answer these questions. a) Graph the data using a scatter plot. Using the "Insert Trendline" function in Excel, determine whether you should use linear regression or log-linear. Insert the graph below. Be sure to label both axes. We should use regression. b) Using Excel's Regression Analysis Function, run a regression and answer the following questions about your output. 8 9 i) What is your estimated demand function? 10 ii) Discuss the fit and significance of the regression. 11 12 13 14 15 16 17 18 19 23 24 222222221 + R² = The model % of the variation in Returns Completed is explained by our regression using Return Price. statistically significant. K c) How many returns do you expect to be completed if the firms charges $65 per return? What is the elasticity at this point in the demand curve? Are you on the elastic, inelastic, or unit elastic portion of your demand curve? Can you make a recommendation to increase or decrease price with this information? Price (P) $65.00 = Estimated Returns Completed (Q) Own Price Elasticity = We are on The recommendation is portion of the demand curve. price. d) Suppose the firm has a cost function for individual tax returns of TC = 5200 + 6Q. Using functions and Excel's Solver functionality, determine how much the firms should be charging for a return to maximize profit and the corresponding total revenue, total cost, and profit. TC = Price (P) = 5200 + 6 Q Estimated Returns Completed (Q) =| Total Revenue (TR) = Total Cost (TC) = Profit =
A B 3 4 5 6 7 D E F G H Bret's Accounting & Tax Services is a small well-known accounting firm in Sioux City, IA which completes taxes for individuals. Every year, firms like Bret's decide how much they will charge to complete and file an individual tax return. This price determines how many tax returns firms complete each year. Suppose you are an office manager for a firm like Bret's Accounting and Tax Services and you are trying to determine what your firm should charge next year for tax returns. Use the following data to answer these questions. a) Graph the data using a scatter plot. Using the "Insert Trendline" function in Excel, determine whether you should use linear regression or log-linear. Insert the graph below. Be sure to label both axes. We should use regression. b) Using Excel's Regression Analysis Function, run a regression and answer the following questions about your output. 8 9 i) What is your estimated demand function? 10 ii) Discuss the fit and significance of the regression. 11 12 13 14 15 16 17 18 19 23 24 222222221 + R² = The model % of the variation in Returns Completed is explained by our regression using Return Price. statistically significant. K c) How many returns do you expect to be completed if the firms charges $65 per return? What is the elasticity at this point in the demand curve? Are you on the elastic, inelastic, or unit elastic portion of your demand curve? Can you make a recommendation to increase or decrease price with this information? Price (P) $65.00 = Estimated Returns Completed (Q) Own Price Elasticity = We are on The recommendation is portion of the demand curve. price. d) Suppose the firm has a cost function for individual tax returns of TC = 5200 + 6Q. Using functions and Excel's Solver functionality, determine how much the firms should be charging for a return to maximize profit and the corresponding total revenue, total cost, and profit. TC = Price (P) = 5200 + 6 Q Estimated Returns Completed (Q) =| Total Revenue (TR) = Total Cost (TC) = Profit =
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
Transcribed Image Text:A
B
3
4
5
6
7
D
E
F
G
H
Bret's Accounting & Tax Services is a small well-known accounting firm in Sioux City, IA which completes taxes for individuals. Every year, firms like Bret's decide how much they will charge to
complete and file an individual tax return. This price determines how many tax returns firms complete each year.
Suppose you are an office manager for a firm like Bret's Accounting and Tax Services and you are trying to determine what your firm should charge next year for tax returns. Use the following data to
answer these questions.
a) Graph the data using a scatter plot. Using the "Insert Trendline" function in Excel, determine whether you should use linear regression or log-linear. Insert the graph below. Be sure to label
both axes.
We should use
regression.
b) Using Excel's Regression Analysis Function, run a regression and answer the following questions about your
output.
8
9
i) What is your estimated demand function?
10
ii) Discuss the fit and significance of the regression.
11
12
13
14
15
16
17
18
19
23
24
222222221
+
R² =
The model
% of the variation in Returns Completed is explained by our regression using Return Price.
statistically significant.
K
c) How many returns do you expect to be completed if the firms charges $65 per return? What is the elasticity at this point in the demand curve? Are you on the elastic, inelastic, or unit elastic
portion of your demand curve? Can you make a recommendation to increase or decrease price with this information?
Price (P) $65.00
=
Estimated Returns Completed (Q)
Own Price Elasticity =
We are on
The recommendation is
portion of the demand curve.
price.
d) Suppose the firm has a cost function for individual tax returns of TC = 5200 + 6Q. Using functions and Excel's Solver functionality, determine how much the firms should be charging for a
return to maximize profit and the corresponding total revenue, total cost, and profit.
TC =
Price (P) =
5200
+
6
Q
Estimated Returns Completed (Q) =|
Total Revenue (TR) =
Total Cost (TC) =
Profit =
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
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)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
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-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education