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
Locked-In Real Estate (LIRE) is preparing for their Initial Public Equity Offering (IPO). With its holdings consisting of rent c
jeka57 [31]

Answer: $62.50

Explanation:

The stock price of Locked-In Real Estate (LIRE) will be calculated thus:

Stock price = D /ke - g

where,

D = Dividend paid per share = $7.50

Ke = expected rate of return on equity = 12% = 0.12

g is growth rate of dividend = 0

Stock price = $7.50/0.12

Stock price = $62.5

Therefore, the stock price is $62.50

4 0
3 years ago
You invested $30,000 in BOA, $20,000 in Best Buy, and $50,000 in Harley-Davidson for your portfolio. Betas are 1.8, 1.05 and 1.5
steposvetlana [31]

Answer:

Beta= 1.5

Explanation:

<u>First, we need to calculate the proportional investment of each asset:</u>

Total investment= $100,000

BOA= 30,000/100,000= 0.3

Best Buy= 20,000/100,000= 0.2

Harley-Davidson= 50,000/100,000= 0.5

<u>To calculate the beta of the portfolio, we need to use the following formula:</u>

Beta= (proportion of investment A*beta A) + (proportion of investment B*beta B)...

Beta= (0.3*1.8) + (0.2*1.05) + (0.5*1.5)

Beta= 1.5

4 0
2 years ago
The belief that you have to come up with something no one has ever done before to build a successful business is
mote1985 [20]

Simple; It's wrong. Many companys do the same thing and are still successful.

3 0
3 years ago
Read 2 more answers
g Liabilities of the commercial banking system include Question 69 options: A) deposits. B) loans and deposits. C) reserves and
netineya [11]

Answer:

A) deposits

Explanation:

In the case of the commercial banking system, the  liabilities is deposits as the deposit is the amount of the depositors

So as per the given situation, the option A is correct as the deposits represents the commercial banking liabilities

hence, all the other options are incorrect

Therefore, the same is to be considered

8 0
2 years ago
What are the pros and con's for the arrive alive campaign?
Elena-2011 [213]
The Arrive Alive campaign was launched to prevent road accidents or at least lessen the instances of accidents due to drunk driving and reckless driving.

The advantages of this campaign are:

1. It promotes awareness among drivers to drive safely. 
2. It educates drivers on the rules and safe acts when on the road. 

The disadvantages of this campaign are:

1. It does not completely eliminate the risk of accidents due to drunk and reckless driving. It merely 'educates' the drivers about safe acts. 
2. It still allows the drivers to drink and drive but at 'allowable alcohol level' which does not help at all.

In the end, the Arrive Alive campaign failed. 
3 0
3 years ago
Read 2 more answers
Other questions:
  • The intentional dispossession or unauthorized use of the personal property of another is known as:
    5·1 answer
  • A sale of goods was denominated in a currency other than the entity’s functional currency. The sale resulted in a receivable tha
    15·1 answer
  • Which of the following is the correct way to describe equilibrium in a market?
    9·1 answer
  • 1. What is the maturity value of P12,500 if it is invested at 15% simple interest for 250 days using ordinary interest?
    11·1 answer
  • Charlie Stone wants to retire in 30 years, and he wants to have an annuity of $1,000 a year for 20 years after retirement. Charl
    5·1 answer
  • Harold is an aspiring entrepreneur. He has asked all his professional contacts for some advice. After hearing out all the sugges
    8·1 answer
  • Which of the following traits indicate that Stephanie is good at time management in her new management role?Stephanie's work spa
    6·1 answer
  • Which of the following would classify as a general education requirement ​
    9·1 answer
  • Last year, Bad Tattoo Co. had additions to retained earnings of $4,780 on sales of $95,560. The company had costs of $75,720, di
    8·1 answer
  • The signing of the project portfolio statement signals the transition from the high-level project initiating stage into the more
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!