7. Bret's Accounting & Tax Services is a small but locally well-known accounting firm in Sioux...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
7. Bret's Accounting & Tax Services is a small but locally 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. "Bret's data" provided on the next page and also an excel file is provided 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. b) Using Excel's Regression Analysis Function, run a regression and answer the following questions about your output. (Place your regression results beneath the graph from part a.) c) What is your estimated demand function? (Form Example: Q-100-SP, Round to 2 decimal places) d) How much of the variation in Returns Completed is explained using the price? (Report this as a percentage; round to 2 decimal places.) Is this regression statistically significant? (Acceptable Answers: Yes or No) e) How many returns do you expect to be completed if the firms charges $85 per return? f) What is the elasticity at this point in the demand curve? g) Are you on the elastic, inelastic, or unit elastic portion of your demand curve? (Acceptable Answers: Elastic, Inelastic, or Unit) h) Do you recommend an increase, decrease, or no change in the price with this information? (Acceptable Answers: Increase, Decrease, or NC) "Bret's data" is given below following page Return Price Returns Completed 70 70 75 75 0 80 80 85 80 80 80 90 90 95 95 100 100 90 90 85 80 932 932 910 920 876 852 811 857 847 865 785 802 789 731 663 709 771 792 831 834 7. Bret's Accounting & Tax Services is a small but locally 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. "Bret's data" provided on the next page and also an excel file is provided 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. b) Using Excel's Regression Analysis Function, run a regression and answer the following questions about your output. (Place your regression results beneath the graph from part a.) c) What is your estimated demand function? (Form Example: Q-100-SP, Round to 2 decimal places) d) How much of the variation in Returns Completed is explained using the price? (Report this as a percentage; round to 2 decimal places.) Is this regression statistically significant? (Acceptable Answers: Yes or No) e) How many returns do you expect to be completed if the firms charges $85 per return? f) What is the elasticity at this point in the demand curve? g) Are you on the elastic, inelastic, or unit elastic portion of your demand curve? (Acceptable Answers: Elastic, Inelastic, or Unit) h) Do you recommend an increase, decrease, or no change in the price with this information? (Acceptable Answers: Increase, Decrease, or NC) "Bret's data" is given below following page Return Price Returns Completed 70 70 75 75 0 80 80 85 80 80 80 90 90 95 95 100 100 90 90 85 80 932 932 910 920 876 852 811 857 847 865 785 802 789 731 663 709 771 792 831 834
Expert Answer:
Answer rating: 100% (QA)
Ans no a In drawing the trendline we display the equation as well as the R square values and by hit ... View the full answer
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0077398194
3rd Edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these accounting questions
-
Complete the audit log provided on the next page for each of the seven remaining confirmations. Consider whether each confirmation provides sufficient, appropriate audit evidence, whether sufficient...
-
You are the office manager of a large firm. Your company prides itself on its high-quality customer service. Lately, complaints have surfaced that an increased number of incoming calls are being...
-
You are the office manager of a large firm. Your company prides itself on its high-quality customer service. Lately, complaints have surfaced that an increased number of incoming calls are being...
-
Benny sells an apartment building. His adjusted basis for regular income tax purposes is $450,000, and it is $475,000 for AMT purposes. He receives $700,000 from the sale. a. Calculate Bennys gain...
-
Construct the null and the alternative hypotheses for the following claims: a. I am going to get the majority of the votes to win this election. b. I suspect that your 10-inch pizzas are, on average,...
-
Let observations on the quantity supplied of a certain commodity be generated by \(Y_{i}=x_{i} \beta+V_{i}\), where \(\left|x_{i}ight| \in[a\), b] \(\forall i\) are scalar observations on fixed...
-
Using the variance data for Menounos Manufacturing Co., prepare an income statement through gross profit for the year ended December 31, 20Y6. Assume the company sold 3,000 units at $100 per unit.
-
As of June 30, 2016, the bank statement showed an ending balance of $19,500. The unadjusted Cash account balance was $15,200. The following information is available: 1. Deposit in transit, $2,400. 2....
-
1. A hollow conducting sphere has an inner and outer radius of R and R2 respectively. A point charge of +Q sits inside the hollow sphere at the center. Additionally, a charge of +2Q is distributed...
-
Goldie and Kurt want advice from your financial advising firm. They have provided the following information. They graduated from university four years ago and they have good jobs, but neither of them...
-
Question One: (25 marks) Al-Hawaj & Sons (AHS) is registered trader for VAT with NBR of Ministry of Finance of Bahrain. AHS is dealing with the supplies which are standard rated @5%, zero rated and...
-
Compute the following real or complex integrals by using the residue method: (i) (ii) (iii) +o elax [x: dx, a +x -2T where a is a real number. $ where n and m are integers, and is a circuit enclosing...
-
1 2 1 1 0 1 1 6 1 method of least squares. State the least squares error for your solution. Solve the inconsistent system Ax = b where A - and b B using the
-
1. Show that formally Assume that a function f has a Fourier series nx L f(x) = by sin n=1 [*Pr=[% L 2. Is there a corresponding result if f has a cosine series? explain and justify your answer 3....
-
The rainfalls for a six day period for Omarama and Twizel are as follows a = 7, a = 10, a3 = 0, a = 0, as = 2, and ag = 5, t = 19, t = 18, t3 = 0, t4 = 1, ts=5, and to = 5, where a, and t, are the...
-
Vertical Adventures has an open line of credit with a zero balance at its credit union using a fixed interest rate of 7.3%. On the last day of every month, the accrued interest must be paid. On July...
-
Based on your understanding of various business formations, read the hypothetical below and answer the questions that accompany it. You and your best friend are entrepreneurs. Your goal is to set up...
-
(a) As Section 17.3 discusses, high-frequency sound waves exhibit less diffraction than low-frequency sound waves do. However, even high-frequency sound waves exhibit much more diffraction under...
-
Eagle Company makes the MusicFinder, a sophisticated satellite radio. Eagle has experienced a steady growth in sales for the past five years. However, Ms. Luray, Eagles CEO, believes that to maintain...
-
Curts Casting manufactures metal parts in a large manufacturing facility. Curts customers order 100,000 tons of castings each quarter. The facility has a practical capacity of 150,000 tons. Curt...
-
The following information is available for year 1 for Dancer Components: Revenues (300,000 units). . . . . . . . . . . $5,700,000 Manufacturing costs Materials . . . . . . . . . . . . . . . . . . . ....
-
Let \(X_{1}, \ldots, X_{n}\) be a set of independent and identically distributed random variables from a distribution \(F\) that has parameter \(\theta\). Let \(\hat{\theta}_{n}\) be an unbiased...
-
Consider a sequence of random variables \(\left\{X_{n}ight\}_{n=1}^{\infty}\) where \(X_{n}\) has probability distribution function \[f_{n}(x)= \begin{cases}{[\log (n+1)]^{-1}} & x=n \\ 1-[\log...
-
Consider an arbitrary probability measure space \((\Omega, \mathcal{F}, P)\) and let \(X_{r}\) be the collection of all possible random variables \(X\) that map \(\Omega\) to \(\mathbb{R}\) subject...
Study smarter with the SolutionInn App