1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
tatuchka [14]
3 years ago
15

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cos

t 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.

Business
1 answer:
gulaghasi [49]3 years ago
4 0

Answer:

(1) \text{Total Cost}=1246.67+7.60\ \text{Volume}

(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:

\text{Total Cost}=1246.67+7.60\ \text{Volume}

(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:

\text{Total Cost}=1246.67+7.60\ \text{Volume}

                 =1246.67+(7.60\times 500)\\\\=1246.67+3800\\\\=5046.67

Thus, the estimated total cost is $5,046.67.

You might be interested in
Cindy Medavoy will invest $7,990 a year for 19 years in a fund that will earn 10% annual interest. Click here to view factor tab
Rudik [331]

Answer:

The correct answer for future value if first payment occur today is $449,645.24 and if first payment occur at the end of year is $408,761.13.

Explanation:

According to the scenario, the given data are as follows:

Payment (pmt) = $7,990

Rate of interest (r) = 10%

Time (n) = 19 years

So, we can calculate the future value by using following formula:

Future Value ( if payment occurs today) :

FV = Pmt  (((1+r)^n   - 1) ÷ r) x (1+r)

By putting the value:

= $7,990 ((( 1+ 0.10)^19   -1) ÷ .10) × ( 1 + 0.10)

= $7,990 ( 51.16) × ( 1.10)

= $449,645.24

Future Value ( if payment occurs at the end of year):

FV = Pmt x ((1+r)^n   -1)) ÷ r)

= $7,990 ((1 + 0.10)^19  -1) ÷ 0.10)

= $7,990 × 51.16

= $408,761.13

4 0
3 years ago
EMC Corporation has never paid a dividend. Its current free cash flow of $490,000 is expected to grow at a constant rate of 4.4%
disa [49]

Answer:

$5,697,674

Explanation:

Dividend Valuation method is used to value the operations of a company based on the dividend paid, its growth rate and rate of return/WACC. The price is calculated by calculating present value of future dividend payment.

Free cash flow is the residual cash flow of operation after paying the capital expenditure from net income of the company. It represent the cash from the operations.

Formula to calculate the value of operation

Value of Operations = FCF / ( WACC - growth rate )

Value of Operations = $490,000 / ( 13% - 4.4% )

Value of Operations = $5,697,674

7 0
3 years ago
The following totals for the month of April were taken from the payroll register of Magnum Company. Use this information to answ
tankabanditka [31]

Answer:

(C) debit to Payroll Tax Expense for $1,148

Explanation:

"employer's payroll taxes" This means we are asked for the entry of the employer, not the employee.

The employer will contribute the same amount for FICA(medicare and social security)  FUTA and SUTA

so the entry will be :

<u>payroll tax expense debit 1148</u>

FICA taxes payable credit 900

FUTA payable credit 32

SUTA payable credit 216

7 0
3 years ago
I know it says use firefox, but any search thing can be used
o-na [289]

Answer:

this is easy just follow the steps and youl be done in no time

Explanation:

3 0
3 years ago
Fill out the following tables to practice calculating the CPI for different base years (_____/5)
Temka [501]

Answer:

CPI for 2007 where base year is 2006 is 100%

CPI for 2008 where base year is 2007 is 25%

CPI for 2009 where base year is 2008 is -20%

CPI for 2010 where base year is 2009 is 212.5%

CPI for 2011 where base year is 2010 is 60%

Explanation:

The CPI (consumer price index) for different years is calculated by this formula:

CPI= (Current price in X year/base price in X year)

CPI for 2007 if 2006 is the base year. = $40/$20

                                                              =2x100 then we multiply by 100 to get the percentage as the baseline for the CPI .

                                                                =200% - 100%= 100% we then subtract 100% to get how much change over time has happened and in this case CPI is 100% that meanse there was a 100%inflation rate in prices.

CPI for 2008 if 2007 is the base year = $50/$40 we substitute the prices respective to the base year 2007 using the above mentioned formula to calculate CPI.

                                                                  = 1.25 x 100 then we multiply by 100 to get the percentage as the baseline for the CPI for year 2008.

                                                                   =125% -100% = 25% this means that CPI is 25% which there was an inflation rate of 25% between year 2007 and 2008.

CPI for 2009 if 2008 was the base year= $40/$50 we again substitute the prices using the above mentioned formula to calculate CPI where 2008 is now the base year.

                                                                    =0.8x100 to get the percentage we multiply by 100%

                                                                    = 80% - 100%= -20% this means that CPI has decreased by 25% between 2008 and 2009 there was deflation in prices.

CPI for 2010 if 2009 is the base year = $125/$40 we substitute to the above formula where 2009 is the base year.

                                                                 =3.125x 100 we then multiply by 100 to get the percentage of CPI.

                                                                   =312.5%- 100%=212.5% which means there was inflation of 212.5% in prices on the CPI.

CPI for 2011 if 2010 is the base year = $200/$125

                                                                 =1.6x 100

                                                                 =160%-100%

                                                            CPI= 60%  

This means in the economy there was an inflation of 60%.

4 0
3 years ago
Other questions:
  • In December 2008, Hawaiian Telcom took action to strengthen its balance sheet by reducing debt. Although the company continued t
    11·1 answer
  • According to goal setting theory, an employer can increase employees’ motivation to reach goals by _____
    5·1 answer
  • I just turned 18, an I want to apply for a car loan. But as we all know, I don't have credit. I was think of having my mom co si
    5·2 answers
  • Selected information from Arbon Corporation's accounting records and financial statements for 2021 is as follows ($ in millions)
    14·1 answer
  • Larry and Susan work in an office near 2 Live Stew and Stew-topia, specialty stew restaurants on the same block. Larry notices t
    10·1 answer
  • What does inflation mean?
    14·2 answers
  • Which of the following is an example of promotion?
    6·2 answers
  • You are a provider of portfolio insurance and are establishing a four-year program. The portfolio you manage is currently worth
    11·1 answer
  • Suppose the production of long-distance airline flights is described by a fixed proportion production process in which three cre
    10·1 answer
  • What type of Businesses has limited liability ?
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!