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...
-
Use graphs to solve these simultaneous equations: (a) a + b = 3 and a b = 5 (b) 2x + 3y = 27 and 3x + 2y = 23
-
Selected information from the payroll register of Ebeling's Dairy for the week ended July 7, 20--, is shown below. The SUTA tax rate is 5.4%, and the FUTA tax rate is 0.6%, both on the first $7,000...
-
How would you factor in the absence of liquidity into your valuation?
-
Manson Incorporated reported the following current asset on its December 31, 2006 balance sheet: Temporary investment in available-for-sale securities (at cost) ...... $63,475 Less: Allowance for...
-
Question 2. Suppose today you enter into a short position in September Silver futures contract for $17.20 per ounce. The contract size is 5,000 ounces / contract. The initial margin is $4,000, and...
-
For the liquid storage system shown in Fig. E, it is desired to control liquid levels h1 and h2 by adjusting volumetric flow rates q1 and q2. Flow rate q6 is the major disturbance variable. The...
-
Assume that number is an int variable that has already been initialized. Write a statement that prints out the value of number in a field of 10 positions (right-justified within that field) . Hint:...
-
The Business Plan for a Travel Agency Location Suggestion: Toronto Ontario Canada The Business Plan includes: 1. A mission statement Why are you in business? 2. Objectives of your business should be...
-
The remaining questions pertain to a bidirectional converter that interfaces a battery bank to a main power bus in an electric vehicle. A schematic of the converter and how it fits in the system is...
-
Down Syndrome in a Newborn Mrs. P, a 31-year-old woman, had an uneventful first pregnancy. At 16 weeks' gestation, a triple screen blood test was normal, indicating a 1/275 risk of Down Syndrome;...
-
Find the value of the variable that satisfies the equation. Check your solution. Answers that are not integers may be left in fractional form or decimal form. 5x - 3 = 22
-
3. Consider a standing wave on a string with a length of 1.500 m. The standing wave is vibrating in the 4th harmonic mode. The frequency is 147.0 Hz. a. Determine the wavelength. b. Determine the...
-
Cash versus stock dividend Milwaukee Tool has the following stockholders' equity account. The firm's common stock currently sells for $4.41 per share. Preferred stock $ 97,000 Common stock (100,000...
-
(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 . . . . . . . . . . . . . . . . . . . ....
-
Make a list of the common divisors of 20 and 84 . What is the GCD? Which of the other common divisors of 20 and 84 also divide the GCD?
-
Make a list of the common divisors of 120 and 88. What is the GCD? Which of the other common divisors of 120 and 88 also divide the GCD?
-
\(\{3,927,473,82,709,1,210,121\}\) Find the greatest common divisor of the given set of numbers.
Study smarter with the SolutionInn App