The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 401 Weeks Ago, 2 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Exercise 5-24 Methods of Estimating Costs: Account Analysis (L.O. 3)
| A consulting firm's accounting records show the following costs for year 1: |
Â
| Â | Â | Â | Â |
| Direct materials (supplies) | $ | 360,000 | Â |
| Direct labor | Â | 2,580,000 | Â |
| Total overhead | Â | 1,140,000 | Â |
| Production was 150,000 billable hours. Fixed overhead was $600,000. |
Â
|
For year 2, direct materials costs are expected to increase by 10 percent per unit. Direct labor costs are expected to increase by 15 percent. Variable overhead per billable hour is expected to remain the same, but fixed overhead is expected to increase by 5 percent. |
Â
| Required: |
| (a) |
Year 2 production is expected to be 195,000 billable hours. What are the estimated direct materials, direct labor, variable overhead, and fixed overhead costs for year 2? (Do not round intermediate calculations. Omit the "$" sign in your response.) |
Â
| Cost item | This year's cost |
| Direct materials (supplies) | $ |
| Direct labor | Â |
| Variable overhead | Â |
| Fixed overhead | Â |
| Â | |
| Total costs | $ |
| Â | |
| (b) |
Determine the total costs per billable hour for year 1 and year 2. (Round your answers to 2 decimal places. Omit the "$" sign in your response.) |
| Â | Costs per billable hour |
| Last year | $ |
| This year | $ |
Â
Â
Â
---------------------------------------------------------------------------------------------------------------
Â
Exercise 5-26 Methods of Estimating Costs: High-Low (L.O. 4)
|
Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations: |
Â
| Month | Labor-Hours | Machine-Hours | Overhead Costs | ||||||
| 1 | Â | 3,625 | Â | Â | 6,775 | Â | $ | 513,435 | Â |
| 2 | Â | 3,575 | Â | Â | 7,035 | Â | Â | 518,960 | Â |
| 3 | Â | 3,400 | Â | Â | 7,600 | Â | Â | 549,575 | Â |
| 4 | Â | 3,700 | Â | Â | 7,265 | Â | Â | 541,400 | Â |
| 5 | Â | 3,900 | Â | Â | 7,955 | Â | Â | 581,145 | Â |
| 6 | Â | 3,775 | Â | Â | 7,895 | Â | Â | 572,320 | Â |
| 7 | Â | 3,700 | Â | Â | 6,950 | Â | Â | 535,110 | Â |
| 8 | Â | 3,625 | Â | Â | 6,530 | Â | Â | 510,470 | Â |
| 9 | Â | 3,550 | Â | Â | 7,270 | Â | Â | 532,195 | Â |
| 10 | Â | 3,975 | Â | Â | 7,725 | Â | Â | 565,335 | Â |
| 11 | Â | 3,375 | Â | Â | 6,490 | Â | Â | 503,775 | Â |
| 12 | Â | 3,550 | Â | Â | 8,020 | Â | Â | 564,210 | Â |
| Required: | |
| (a) |
Use the high-low method to estimate the fixed and variable portions of overhead costs based on machine-hours. (Round your variable cost answer to 2 decimal places. Omit the "$" sign in your response.) |
Â
| Variable cost (per machine hour) | $ |
| Fixed cost | $ |
| (b) |
Managers expect the plant to operate at a monthly average of 7,500 machine-hours next year. What are the estimated monthly overhead costs, assuming no inflation? (Use rounded variable cost. Omit the "$" sign in your response.) |
Â
| Overhead costs | $ |
Â
Â
Â
----------------------------------------------------------------------------------------------------------------------
Â
Exercise 5-30 Methods of Estimating Costs: Simple Regression (L.0. 5)
|
Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations: |
Â
| Month | Labor-Hours | Machine-Hours | Overhead Costs |
| 1 | 3,625 | 6,775 | $513,435 |
| 2 | 3,575 | 7,035 | 518,960 |
| 3 | 3,400 | 7,600 | 549,575 |
| 4 | 3,700 | 7,265 | 541,400 |
| 5 | 3,900 | 7,955 | 581,145 |
| 6 | 3,775 | 7,895 | 572,320 |
| 7 | 3,700 | 6,950 | 535,110 |
| 8 | 3,625 | 6,530 | 510,470 |
| 9 | 3,550 | 7,270 | 532,195 |
| 10 | 3,975 | 7,725 | 565,335 |
| 11 | 3,375 | 6,490 | 503,775 |
| 12 | 3,550 | 8,020 | 564,210 |
Â
| Simple regression results from the data of Adriana Corporation are as follows: |
| Â | Â |
| Equation: | Â |
| Overhead = $217,610 + ($88.61 AfA?" Labor-hours) | Â |
| Statistical data | Â |
| Correlation coefficient | .610 |
| R2 | .372 |
Â
| Required: |
|
Estimate overhead if the company expects the plant to operate at a monthly average of 3,000 labor-hours next year. (Omit the "$" sign in your response.) |
| Overhead | $ |
Â
Â
Â
------------------------------------------------------------------------------------------------------------------------------
Â
Exercise 5-31 Methods of Estimating Costs: Multiple Regression (L.O. 5)
|
Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations: |
Â
| Month | Labor-Hours | Machine-Hours | Overhead Costs |
| 1 | 3,625 | 6,775 | $513,435 |
| 2 | 3,575 | 7,035 | 518,960 |
| 3 | 3,400 | 7,600 | 549,575 |
| 4 | 3,700 | 7,265 | 541,400 |
| 5 | 3,900 | 7,955 | 581,145 |
| 6 | 3,775 | 7,895 | 572,320 |
| 7 | 3,700 | 6,950 | 535,110 |
| 8 | 3,625 | 6,530 | 510,470 |
| 9 | 3,550 | 7,270 | 532,195 |
| 10 | 3,975 | 7,725 | 565,335 |
| 11 | 3,375 | 6,490 | 503,775 |
| 12 | 3,550 | 8,020 | 564,210 |
Â
| Multiple regression results from the data of Adriana Corporation are as follows: |
| Â | Â |
| Equation: | Â |
| Overhead = $124,570 + ($31.93 AfA?" Labor-hours) + ($41.10 AfA?" Machine-hours) | Â |
| Statistical data | Â |
| Correlation coefficient | .982 |
| R2 | .964 |
Â
| Required: |
|
Estimate overhead using the multiple regression results, assuming that the company expects the plant to operate at a monthly average of 9,000 machine-hours and 3,000 labor-hours next year. (Omit the "$" sign in your response.) |
| Overhead | $ |
Â
Â
----------------------------------------------------------------------------------------------------------------------------
Â
Â
Problem 5-43 Interpretation of Regression Results: Simple Regression Using a Spreadsheet (L.O. 4, 5, 8)
|
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and wants to estimate overhead costs accurately to plan its operations and its financial needs. Interviews with plant personnel and studies reported in trade publications suggest that overhead in this industry tends to vary with labor-hours. |
|
A member of the controller's staff proposed that the behavior pattern of these overhead costs be determined to improve cost estimation. Another staff member suggested that a good starting place for determining cost behavior patterns is to analyze historical data. Following this suggestion, monthly data were gathered on labor-hours and overhead costs for the past two years. No major changes in operations occurred over this period of time. The data are shown in the following table: |
Â
| Month | Labor-Hours | Overhead Costs | ||||
| 1 | Â | 251,563 | Â | $ | 2,741,204 | Â |
| 2 | Â | 238,438 | Â | Â | 2,166,231 | Â |
| 3 | Â | 192,500 | Â | Â | 1,902,236 | Â |
| 4 | Â | 271,250 | Â | Â | 2,590,765 | Â |
| 5 | Â | 323,750 | Â | Â | 3,071,812 | Â |
| 6 | Â | 290,938 | Â | Â | 2,618,161 | Â |
| 7 | Â | 271,250 | Â | Â | 2,480,231 | Â |
| 8 | Â | 251,563 | Â | Â | 2,745,558 | Â |
| 9 | Â | 231,875 | Â | Â | 2,211,799 | Â |
| 10 | Â | 343,438 | Â | Â | 3,437,704 | Â |
| 11 | Â | 185,938 | Â | Â | 2,314,436 | Â |
| 12 | Â | 231,875 | Â | Â | 2,550,630 | Â |
| 13 | Â | 382,813 | Â | Â | 3,603,709 | Â |
| 14 | Â | 376,250 | Â | Â | 3,404,786 | Â |
| 15 | Â | 290,938 | Â | Â | 3,016,493 | Â |
| 16 | Â | 395,938 | Â | Â | 3,638,331 | Â |
| 17 | Â | 356,563 | Â | Â | 3,553,886 | Â |
| 18 | Â | 323,750 | Â | Â | 3,191,617 | Â |
| 19 | Â | 389,375 | Â | Â | 3,481,714 | Â |
| 20 | Â | 317,188 | Â | Â | 3,219,519 | Â |
| 21 | Â | 343,438 | Â | Â | 3,495,424 | Â |
| 22 | Â | 336,875 | Â | Â | 3,207,258 | Â |
| 23 | Â | 382,813 | Â | Â | 3,600,622 | Â |
| 24 | Â | 376,250 | Â | Â | 3,736,658 | Â |
| Required: | |
| (a) |
Use the high-low estimation method to estimate the overhead cost behavior (fixed and variable portions components of cost) for the Lucas plant. (Round your fixed cost to the nearest dollar amount and the variable cost to 5 decimal places. To calculate the fixed costs, use highest activity level. Omit the "$" sign in your response.) |
Â
| Overhead costs | = | $ | + | ($ | per LH AfA?" Labor hours) |
| (c) |
Use a spreadsheet program to compute regression coefficients to describe the overhead cost equation. (Round your answers to 2 decimal places. Omit the "$" sign in your response.) |
Â
| Coefficients | Â |
| Intercept (Fixed costs) | $ |
| Labor Hours | $ |
| (d) |
Use the results of your regression analysis to develop an estimate of overhead costs assuming 350,000 labor-hours will be worked next month. (Round your Labor Hours to 2 decimal places for intermediate calculation. Round your final answer to the nearest dollar amount. Omit the "$" sign in your response.) |
Â
| Overhead cost | $ |
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll