Your company is preparing an estimate of its production costs for the coming period. The controller...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664ddf53dda5d_475664ddf537f367.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664ddf54699ce_476664ddf5416155.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664ddf55116df_476664ddf54a69fb.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664ddf5594565_477664ddf554089b.jpg)
Transcribed Image Text:
Your company is preparing an estimate of its production costs for the coming period. The controller estimates that direct materials costs are $30 per unit and that direct labor costs are $20 per hour. Estimating overhead, which is applied on the basis of direct labor costs, is difficult The controller's office estimated overhead costs at $3,700 for fixed costs and $14 per unit for variable costs. Your colleague, Lance, who graduated from a rival school, has already done the analysis and reports the "correct" cost equation as follows. Overhead $10,548+ $16.06 per unit Lance also reports that the correlation coefficient for the regression is 0.82 and says, "With 82% of the variation in overhead explained by the equation, it certainly should be adopted as the best basis for estimating costs. When asked for the data used to generate the regression, Lance produces the following Month Overhead Unit Production 1 $57,101 3,040 2 60,689 3,250 3 77,278 4,180 A 56,633 3,010 5 81,400 3,410 6 72,364 3,920 7 63,763 3,340 8 73,791 4,020 9 77,655 4,130 10 60,187 3,200 11 61,588 3,370 12 73,986 4,090 13 73,234 3,090 The company controller is somewhat surprised that the cost estimates are so different. You have therefore been assigned to check Lance's equation. You accept the assignment with glee. Required: Prepare a scattergraph relating overhead cost to the number of units produced. Instructions: 1. Click on a point to the right of the graph. 2. Click within the graph to place the point. 3. To enter exact coordinates, click on the point and then click on the processing wheel symbol and then enter the exact coordinates in the dialog box that pops up. 4. Click OK. Interpretation of Regression Results-Simple Regression $85,000- $80,000- $75,000- Overhead Cost $70,000- $65,000- $60,000- $55,000- Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 $50,000- 2.800 3,000 3,200 3,400 3,600 3,800 4.000 4,200 4,400 Month 7 Unit Production reset Removing any outliers identified in the scattergraph, use Excel to perform a new regression analysis. (Round "Intercept" value to 5 decimal places and "Unit Production" to 7 decimal places.) Coefficients Intercept Unit production What is the cost equation with the new results? (Round variable costs per unit to 2 decimal places.) Overhead cost Units Your company is preparing an estimate of its production costs for the coming period. The controller estimates that direct materials costs are $30 per unit and that direct labor costs are $20 per hour. Estimating overhead, which is applied on the basis of direct labor costs, is difficult The controller's office estimated overhead costs at $3,700 for fixed costs and $14 per unit for variable costs. Your colleague, Lance, who graduated from a rival school, has already done the analysis and reports the "correct" cost equation as follows. Overhead $10,548+ $16.06 per unit Lance also reports that the correlation coefficient for the regression is 0.82 and says, "With 82% of the variation in overhead explained by the equation, it certainly should be adopted as the best basis for estimating costs. When asked for the data used to generate the regression, Lance produces the following Month Overhead Unit Production 1 $57,101 3,040 2 60,689 3,250 3 77,278 4,180 A 56,633 3,010 5 81,400 3,410 6 72,364 3,920 7 63,763 3,340 8 73,791 4,020 9 77,655 4,130 10 60,187 3,200 11 61,588 3,370 12 73,986 4,090 13 73,234 3,090 The company controller is somewhat surprised that the cost estimates are so different. You have therefore been assigned to check Lance's equation. You accept the assignment with glee. Required: Prepare a scattergraph relating overhead cost to the number of units produced. Instructions: 1. Click on a point to the right of the graph. 2. Click within the graph to place the point. 3. To enter exact coordinates, click on the point and then click on the processing wheel symbol and then enter the exact coordinates in the dialog box that pops up. 4. Click OK. Interpretation of Regression Results-Simple Regression $85,000- $80,000- $75,000- Overhead Cost $70,000- $65,000- $60,000- $55,000- Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 $50,000- 2.800 3,000 3,200 3,400 3,600 3,800 4.000 4,200 4,400 Month 7 Unit Production reset Removing any outliers identified in the scattergraph, use Excel to perform a new regression analysis. (Round "Intercept" value to 5 decimal places and "Unit Production" to 7 decimal places.) Coefficients Intercept Unit production What is the cost equation with the new results? (Round variable costs per unit to 2 decimal places.) Overhead cost Units
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
What are due process and stare decisis, and why are they important?
-
a) What SPI firewall has come with client version of Windows since Windows XP SP2? b) What improvements come with Windows Firewall with Advanced Security?
-
Montenegro Metal Company operates two factories. The company applies factory overhead to jobs on the basis of machine hours in Factory 1 and on the basis of direct labor hours in Factory 2. Estimated...
-
Do employees of banks and mortgage companies have an ethical obligation to question the process of mass robo-signing? Who has ultimate responsibility for the mistreatment of hundreds of thousands of...
-
Transactions to incorporate and run a business. The following events relate to shareholders equity transactions of Wilson Supply Company during the first year of its existence. Present journal...
-
In 2021, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2023, Information related to the contract is...
-
Last year Carson Industries issued a 10-year, 13% semiannual coupon bond at its par value of $1,000. Currently, the bond can be called in 6 years at a price of $1,065 and it sells for $1,230. What is...
-
Write out the form of the partial fraction decomposition of the function (See Example ). Do not determine the numerical values of the coefficients. (If the partial fraction decomposition does not...
-
Below is the actual assignment information. Here is where you will submit your event for approval. It is not graded, but you will need it to be marked complete in order to submit your paper, so...
-
3. (20 points) A researcher is interested in whether the phonics method of teaching reading is more or less effective than the sight method, depending on what grade the child is in. Twenty children...
-
Let A and B be the matrices given below: -5 9 -7 A= 8 -1 -3 B=9 6 -1 8 -1 -7. 0 Perform the following matrix operations and enter the entries below: -4A = A-4B = 5A-3B=
-
The product business can be isolated into four principal classes: programming administrations, framework administrations, open source and SaaS. The accompanying depicts the classifications of...
-
"8. Given the following total-revenue and total-cost functions of a firm TR - 220 -0.50 TC = Q - 8.50 + 500 +90 determine (a) the level of output at which the firm maximizes its total prof. (b) the...
-
How can you tell from the vertex form y = a(x - h) 2 + k whether a quadratic function has no real zeros?
-
Identifying the type of study. Determine whether each of the following studies is observational or designed, and explain your reasoning: a. An economist obtains the unemployment rate and LO4 gross...
-
Bakers versus brewers yeast. The Electronic Journal of Biotechnology (Dec. 15, 2003) published an article comparing two yeast extracts: bakers yeast and brewers yeast. Brewers yeast is a surplus...
-
Drafting NFL quarterbacks. The Journal of Productivity Analysis (Vol. 35, 2011) published a study of how successful NFL teams are in drafting productive quarterbacks (see Exercise 1.14, p. 48). The...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App