Ella Jackson is planning to open an R&H Black Tax Service office for the upcoming tax...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Ella Jackson is planning to open an R&H Black Tax Service office for the upcoming tax season, January through April 15. She plans to offer one service, individual income tax return preparation. She wants to estimate her labor needs using a learning curve and estimate her support costs using regression for the 15-week season with the following anticipated number of returns: Estimated Estimated Estimated Returns Prep Hours Support Costs 10 20 25 Week 1 2 3 4 5 56 6 7 8 9 10 11 28 34 35 46 52 40 37 45 53 57 12 13 14 69 15 75 Ella is trying to estimate her labor needs for the tax season. She plans to hire several accounting students as interns from the local university on a part-time basis to do the simpler returns while she does more complicated returns herself. Because there is a significant amount of learning that takes place in preparing tax returns, Ella wants to apply a cumulative average time learning curve to her estimate of labor needs. Ella expects the learning curve to level out after 16 returns, so the time for the 16th return is the best estimate of future return preparation. Based on her observations during training, she estimates the following: Hours to prepare first income tax return Learning curve percentage Learning curve factor b 7 labor hours 87% -0.2009127 Ella has also hired an office manager to perform administrative support duties such as answering phones, processing paperwork, filing, etc. While the returns are prepared and filed electronically, the office manager prints out and assembles a copy for the client and then notifies the client that their return is ready to be picked up. Ella wants to estimate the weekly support costs and believes she can estimate a cost function using data for the prior 15-week tax season (from January through April15) from an office in a comparable community. Since it is uncertain which would be a better cost driver, Ella is considering either number of returns or preparation hours. Data are listed below (also provided in a Word document in Blackboard that you can copy and paste into your Excel spreadsheet): Number of Preparation Returns 13 19 28 23 21 46 52 Week 1 2 3 4 5 6 7 8 9 10 11 b. 12 13 14 15 Support Costs $1,290 1,438 1,711 1,637 1,532 2,119 1,761 2,055 1,383 1,927 1,836 1,621 2,184 2,237 2,378 63 35 44 50 38 54 63 68 Hours 78 106 87 74 89 107 119 118 96 103 132 120 144 122 137 REQUIRED: Follow the instructions below to (a) estimate the preparation time using a cumulative average time learning curve; (b) use regression to choose the better cost driver (number of returns or preparation hours) and determine a cost function for support costs; and (c) prepare a summary as shown below. a. Estimate the preparation hours per return: Prepare a learning curve schedule through 16 units similar to Exhibit 10-10 in the text. Preparation hours per return are expected to level off at 16 returns, so the estimated hours to prepare each return is the "Individual unit time for the 16th unit" (Column 4 in Exhibit 10-10). Note: To raise a number to a power in Excel, use the symbol (above the numeral 6 on the keyboard); for example, 102 would be input as = 10^2 in Excel. Estimate support costs per week: For each cost driver (number of returns and preparation hours), use the data above to do the following: (1) Plot the data on two separate scattergraphs, one for each cost driver. To do the scattergraph, click on Insert in the menu bar and click on the XY (scatter) chart with dots only (no lines). Click inside the empty chart to open the Chart Design menu, then click on Select Data. Click on Add to open the Edit Series box, give your chart a name, click on the arrow for Series X values and highlight activity data (returns or hours) and click on the arrow. Do the same for Series Y values, highlighting costs, then click OK. (NOTE: Check to make sure your chart has costs on the Y (vertical) axis and activity on the X (horizontal) axis. If it's backwards, do the following: Right-click on the data points, click on "Select Data", and click on Edit. Click on the arrow icon for X values, highlight the data in the cost driver column, and click on the arrow icon again. Do the same for Y values, highlighting the costs. Click OK.) Move the chart to the location on the spreadsheet where you want it. Use the right mouse button to change the appearance of the graph to look the way you want it. In particular, change the X and Y axes to start at a number other than zero: Right-click on the Y-axis, click on Format axis, and change "Minimum" from 0 to a number slightly C. (2) (3) 123410 less than the minimum number in your data, then click the x to close. Do the same for the X-axis. Look at the graphs for trends and outliers. 1. 2. 3. Estimate a separate cost function for each cost driver using the regression method. To do the regression in Excel, click on Data, Data Analysis*, and choose Regression. Specify each input range by clicking on the arrow icon and highlighting the range of cells. The Y-range is the dependent variable (cost), and the X-range is the independent variable (cost driver/activity). For the output range, click on the arrow icon, move to the area of the spreadsheet where you want the regression output, and click on the upper left cell of that area. Then click on OK. Note that the output contains the calculated values, not formulas, so if you make any changes, you must redo the regression (it will not change automatically). Prepare a summary of the following information: 5. *If you do not see Data Analysis under Data, do the following: Click on File, Options (bottom left), Add-ins. Find Manage: Excel Add-ins and click on Go... next to it, place check mark in front of Analysis ToolPak, and click OK. Prepare a comparison of the cost drivers on the first three criteria in Exhibit 10-18 in the Appendix (omit specification analysis). Based on your comparison, decide which Estimated hours to prepare each income tax return (time for 16th unit) Cost function y = a + bX for estimating support costs using number of returns. Cost function y = a + bX for estimating support costs using preparation hours. 4. Identify choice of cost driver. predictor, number of returns or preparation hours, you believe is a more appropriate cost driver for estimating overhead costs. Ella estimates the number of returns for each week through the 15-week season below (data also available in the Data Word document to copy and paste into your spreadsheet). She would like an estimate of the preparation hours to use for scheduling student workers, and an estimate of support costs for budgeting purposes. Estimated Support Costs Week 1 2 3 4 5 6 7 8 9 SO123H5 10 11 14 Estimated Estimated Returns Prep Hours 10 20 25 28 34 35 46 52 40 37 45 53 57 69 75 * ** * estimated returns x estimated prep hours (learning curve 16th unit). Set up your formula as: =(cell for # returns (column 2))*(cell for time for 16th unit from your learning curve) ** Use the cost function for your chosen cost driver y = a + bX. Set up your formula as: =(cell for a coefficient)+(cell for b coefficient)*(cell for X) where X is your chosen cost driver, either returns (column 2) or prep hours (column 3). Ella Jackson is planning to open an R&H Black Tax Service office for the upcoming tax season, January through April 15. She plans to offer one service, individual income tax return preparation. She wants to estimate her labor needs using a learning curve and estimate her support costs using regression for the 15-week season with the following anticipated number of returns: Estimated Estimated Estimated Returns Prep Hours Support Costs 10 20 25 Week 1 2 3 4 5 56 6 7 8 9 10 11 28 34 35 46 52 40 37 45 53 57 12 13 14 69 15 75 Ella is trying to estimate her labor needs for the tax season. She plans to hire several accounting students as interns from the local university on a part-time basis to do the simpler returns while she does more complicated returns herself. Because there is a significant amount of learning that takes place in preparing tax returns, Ella wants to apply a cumulative average time learning curve to her estimate of labor needs. Ella expects the learning curve to level out after 16 returns, so the time for the 16th return is the best estimate of future return preparation. Based on her observations during training, she estimates the following: Hours to prepare first income tax return Learning curve percentage Learning curve factor b 7 labor hours 87% -0.2009127 Ella has also hired an office manager to perform administrative support duties such as answering phones, processing paperwork, filing, etc. While the returns are prepared and filed electronically, the office manager prints out and assembles a copy for the client and then notifies the client that their return is ready to be picked up. Ella wants to estimate the weekly support costs and believes she can estimate a cost function using data for the prior 15-week tax season (from January through April15) from an office in a comparable community. Since it is uncertain which would be a better cost driver, Ella is considering either number of returns or preparation hours. Data are listed below (also provided in a Word document in Blackboard that you can copy and paste into your Excel spreadsheet): Number of Preparation Returns 13 19 28 23 21 46 52 Week 1 2 3 4 5 6 7 8 9 10 11 b. 12 13 14 15 Support Costs $1,290 1,438 1,711 1,637 1,532 2,119 1,761 2,055 1,383 1,927 1,836 1,621 2,184 2,237 2,378 63 35 44 50 38 54 63 68 Hours 78 106 87 74 89 107 119 118 96 103 132 120 144 122 137 REQUIRED: Follow the instructions below to (a) estimate the preparation time using a cumulative average time learning curve; (b) use regression to choose the better cost driver (number of returns or preparation hours) and determine a cost function for support costs; and (c) prepare a summary as shown below. a. Estimate the preparation hours per return: Prepare a learning curve schedule through 16 units similar to Exhibit 10-10 in the text. Preparation hours per return are expected to level off at 16 returns, so the estimated hours to prepare each return is the "Individual unit time for the 16th unit" (Column 4 in Exhibit 10-10). Note: To raise a number to a power in Excel, use the symbol (above the numeral 6 on the keyboard); for example, 102 would be input as = 10^2 in Excel. Estimate support costs per week: For each cost driver (number of returns and preparation hours), use the data above to do the following: (1) Plot the data on two separate scattergraphs, one for each cost driver. To do the scattergraph, click on Insert in the menu bar and click on the XY (scatter) chart with dots only (no lines). Click inside the empty chart to open the Chart Design menu, then click on Select Data. Click on Add to open the Edit Series box, give your chart a name, click on the arrow for Series X values and highlight activity data (returns or hours) and click on the arrow. Do the same for Series Y values, highlighting costs, then click OK. (NOTE: Check to make sure your chart has costs on the Y (vertical) axis and activity on the X (horizontal) axis. If it's backwards, do the following: Right-click on the data points, click on "Select Data", and click on Edit. Click on the arrow icon for X values, highlight the data in the cost driver column, and click on the arrow icon again. Do the same for Y values, highlighting the costs. Click OK.) Move the chart to the location on the spreadsheet where you want it. Use the right mouse button to change the appearance of the graph to look the way you want it. In particular, change the X and Y axes to start at a number other than zero: Right-click on the Y-axis, click on Format axis, and change "Minimum" from 0 to a number slightly C. (2) (3) 123410 less than the minimum number in your data, then click the x to close. Do the same for the X-axis. Look at the graphs for trends and outliers. 1. 2. 3. Estimate a separate cost function for each cost driver using the regression method. To do the regression in Excel, click on Data, Data Analysis*, and choose Regression. Specify each input range by clicking on the arrow icon and highlighting the range of cells. The Y-range is the dependent variable (cost), and the X-range is the independent variable (cost driver/activity). For the output range, click on the arrow icon, move to the area of the spreadsheet where you want the regression output, and click on the upper left cell of that area. Then click on OK. Note that the output contains the calculated values, not formulas, so if you make any changes, you must redo the regression (it will not change automatically). Prepare a summary of the following information: 5. *If you do not see Data Analysis under Data, do the following: Click on File, Options (bottom left), Add-ins. Find Manage: Excel Add-ins and click on Go... next to it, place check mark in front of Analysis ToolPak, and click OK. Prepare a comparison of the cost drivers on the first three criteria in Exhibit 10-18 in the Appendix (omit specification analysis). Based on your comparison, decide which Estimated hours to prepare each income tax return (time for 16th unit) Cost function y = a + bX for estimating support costs using number of returns. Cost function y = a + bX for estimating support costs using preparation hours. 4. Identify choice of cost driver. predictor, number of returns or preparation hours, you believe is a more appropriate cost driver for estimating overhead costs. Ella estimates the number of returns for each week through the 15-week season below (data also available in the Data Word document to copy and paste into your spreadsheet). She would like an estimate of the preparation hours to use for scheduling student workers, and an estimate of support costs for budgeting purposes. Estimated Support Costs Week 1 2 3 4 5 6 7 8 9 SO123H5 10 11 14 Estimated Estimated Returns Prep Hours 10 20 25 28 34 35 46 52 40 37 45 53 57 69 75 * ** * estimated returns x estimated prep hours (learning curve 16th unit). Set up your formula as: =(cell for # returns (column 2))*(cell for time for 16th unit from your learning curve) ** Use the cost function for your chosen cost driver y = a + bX. Set up your formula as: =(cell for a coefficient)+(cell for b coefficient)*(cell for X) where X is your chosen cost driver, either returns (column 2) or prep hours (column 3).
Expert Answer:
Answer rating: 100% (QA)
Id be happy to help you with this problem Here is a summary of the problem Ella Jackson is planning ... View the full answer
Related Book For
Operations Management Managing Global Supply Chains
ISBN: 978-1506302935
1st edition
Authors: Ray R. Venkataraman, Jeffrey K. Pinto
Posted Date:
Students also viewed these accounting questions
-
The amount y of photosynthesis that takes place in a certain plant depends on the intensity x of the light present, according to y = 120x2 - 20x3 for x ( 0 (a) Graph this function with a graphing...
-
The amount of photosynthesis that takes place in a certain plant depends on the intensity of light x according to the equation f(x) = 145x2 - 30x3 (a) Find the rate of change of photosynthesis with...
-
An Italian restaurant chain is planning to open a distribution center to prepare and ship the food ingredients required by five of its restaurants in Germany. The map coordinates and the annual...
-
Which annotations will trigger a compiler error if incorrectly applied to a method with no other annotations? (Choose three.) A. @Documented B. @Deprecated C. @SuppressWarnings("unchecked") D....
-
Kane & Associates is a local legal entity employing six solicitors, four paralegals and six administrative staff. The entity has a costing system that assigns costs to clients. There are two...
-
The global recession in 20072009 and the 2020 COVID-19 pandemic slowed down Tescos plans for expansion. Why might Tesco have been more harmed by these events than Walmart?
-
Differentiate between a shaft and an axle?
-
The management team of Magnificent Modems, Inc. (MMI), wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected...
-
According to this article, what ABA rules do you consider would apply to this case, and what analytical questions would be important to analyze in the ethical duty of lawyers and judges. Since I did...
-
Davis has the following obligations at December 31, 2025: Note payable due in monthly installments of $50,000, plus interest, through November 30, 2026 Note payable due in monthly installments of...
-
If a buyer and seller do not have a close working relationship, how can a buyer obtain cost data to perform a cost analysis for a supplier before awarding a purchase contract? How is the price of an...
-
Stephens, Inc currently pays a $3 per share dividend, but is considering eliminating the dividend and using the savings to repurchase shares. Investments of similar risk to Stephens provide an...
-
Your task is to work with Abigail to analyze the situation. You must recommend acceptance or rejection, and evaluate he projects acceptability using the NPV, IRR, modified IRR (MIRR), and payback...
-
Show that for every n N, we have 2" > n. b) Deduce that if S be a subset of IN with the following properties i) 2 S for every n N ii) If n S for some n 2 then n - 1 S, then S = N. c) Show that 1 + 2...
-
A 63-year-old female with an 80-pack-peryear smoking history has been complaining to her husband of feeling weak and being constipated. She also has abdominal pain. He brings her to the emergency...
-
Determine the price today a new Security C which pays $3000 in an Up market and 0 in a Down market. Show your work by showing the combination of existing instruments you would use to create Security...
-
You want to buy a $21,000 car. You can make a 10% down payment, and will finance the balance with a 4% interest rate for 48 months (4 years). What will your monthly payments be? $
-
Estimate a range for the optimal objective value for the following LPs: (a) Minimize z = 5x1 + 2x2 Subject to X1 - x2 3 2x1 + 3x2 5 X1, x2 0 (b) Maximize z = x1 + 5x2 + 3x3 Subject to X1 + 2x2 +...
-
What is finite capacity scheduling (FCS), and what are its features?
-
What are some of the disadvantages of relocating facilities to a foreign country?
-
Discuss briefly each of the four phases of designing a supply chain network.
-
Explain how the Feds doubling of the monetarybase and government bailouts might influencethe short-run and long-run Phillips curves.Will the influence come fromchanges in the expected inflation rate,...
-
Suppose because of a recession, most state governments experience reductions in tax revenues, and respond by reducing their expenditures and increasing their taxes to keep their state budgets in...
-
Explain how large scale structural change mightinfluence the short-run and long-run Phillips curves.Will the influencecome from changes in the expected inflation rate,the natural unemployment rate,...
Study smarter with the SolutionInn App