An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. In the Microsoft Excel Online file below you will find a sample of production volumes and total cost data for a manufacturing operation. Conduct a regression analysis to explore the relationship between total cost and production volume and then answer the questions that follow.Production Volume Total Cost
(Units) ($)
400 4,000
450 5,000
550 5,400
600 5,900
700 6,400
750 7,000
1. Use the data to develop an estimated regression equation that could be used to predict the total cost for a given production volume.
2. What is the variable cost per unit produced
3. Compute the coefficient of determination what percentage of the variation in total cost can be explained by production volume
4. The companys production schedule shows 500 units must be produced next month what is the estimated total cost of this operation.
Solved
Show answers
More tips
- F Food and Cooking Unusually Delicious Shashlik - Follow the Etiquette of Proper Preparation!...
- L Leisure and Entertainment Couchsurfing: A New Way to Travel...
- G Goods and services Which TV is better - LCD or Plasma?...
- S Sport How to Learn to Pull Up on Monkey Bars?...
- L Leisure and Entertainment Scrapbooking: What is it and Why is it Becoming More Popular?...
- C Computers and Internet Where did torrents.ru move to?...
- B Business and Finance Understanding Cash Flow: What It Is and How It Works...
- C Computers and Internet What Are Peers and Seeds in Torrenting?...
- H Health and Medicine 10 Simple Techniques on How to Boost Your Mood...
- G Goods and services How to Choose the Right High Chair for Your Baby?...
Answers on questions: Business
- B Business Last year (2016), Bramble Condos installed a mechanized elevator for its tenants. The owner of the company, Ron Richter, recently returned from an industry equipment exhibition...
- B Business Monty Industrial Products Inc. is a diversified industrial-cleaner processing company. The company’s Dargan plant produces two products: a table cleaner and a floor cleaner from...
- B Business Monty Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $218,700 and the following divisional results....
- B Business If a customer exercises an equity call contract, the customer must: A pay the strike price for the security in next business day B pay the strike price for the security in 2 business...
- B Business Determine the net income of a company for which the following information is available for the month of July. Employee salaries expense $192,000 Interest expense 22,000 Rent expense...
- H History What mountain range borders india in the northeast...
- M Mathematics Ineed with this, someone will give you brainliest....
- G Geography Plz ! explain socialism in colombia....
- P Physics Evaporation is a process that requires energy to occur...
- H History Which form of early communication was use in the fertile crescent region...
Ответ:
(1)![\text{Total Cost}=1246.67+7.60\ \text{Volume}](/tpl/images/0692/9749/d14da.png)
(2) The variable cost per unit produced is $7.60.
(3) The coefficient of determination is 0.96 or 96%.
(4) The estimated total cost is $5,046.67.
Explanation:
A regression analysis for the provided data is performed on Microsoft Excel.
The output is attached below.
(1)
The estimated regression equation that could be used to predict the total cost for a given production volume is:
(2)
The variable cost per unit produced is given by the slope of the line.
The slope of a regression line represent the value of the dependent variable for one unit of the independent variable.
So, the variable cost per unit produced is $7.60.
(3)
Consider the regression output attached.
The coefficient of determination is 0.96 or 96%.
This implies that the percentage of the variation in total cost that can be explained by production volume is 96%.
(4)
For Volume = 500 units predict the total cost as follows:
Thus, the estimated total cost is $5,046.67.
Ответ:
The innovations include technological inventions such as wind turbines, photovoltaic cells, concentrated solar power, geothermal energy, ocean wave power and many other emerging innovations.
Explanation: