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
How publish Fiverr gig without taking a test?
Alja [10]

Answer:

I don't know

Explanation:

I am out of my mind

Sorry.

7 0
3 years ago
PLS HELP IF YOU CAN!! In the first year of your career you learn that to be promoted, you must demonstrate that you have the ski
Salsk061 [2.6K]

Answer:

Although all of these are good ways to demonstrate skills the best would be to finish projects as it shows you are dedicated and you can put those skills into action with different tasks.

Explanation:

4 0
2 years ago
Read 2 more answers
Future Motors is expected to pay a $3.30 a share annual dividend next year. Dividends are expected to increase by 3.75 percent a
Alborosie

Answer:

One share of this stock worth to you today is $18.08

Explanation:

According to the question, we have the following data:

D1 = $3.30

g = 0.0375

Ke = 0.22

one share of this stock worth to you today = P0

Hence to calculate the P0 we have to use the following formula:

Ke = D1/P0 + g

0.22 = 3.3/P0 + 0.0375

P0 = $18.08

One share of this stock worth to you today is $18.08

3 0
3 years ago
"Phillips and Sanchez is a retailer that operates a national chain of home furnishings stores. It has designed a website and a s
Annette [7]

Answer:

Omnichannel strategy

Explanation:

Omnichannel strategy -

It is the strategy adapted by an organisation in order to enhance the experience of the user .

It is a cross - channel content strategy .

The resources of these , Omnichannel strategy , are are orchestrated  and designed to cooperate .

This approach or strategy is used in many industries , like ,telecommunications ,  retail , government , healthcare and financial services .

Hence , the example given in the question , is of  a Omnichannel strategy .

7 0
3 years ago
If you invested $250 at 16% how much will have after 4.5 years
Iteru [2.4K]

Answer:

$180

Explanation:

$250 * 0.16 * 4.5 = $180

6 0
2 years ago
Read 2 more answers
Other questions:
  • Bob deposits $1,500 at the beginning of each quarter for sixteen years in a fund earning a nominal rate of interest of 6% conver
    10·1 answer
  • JBC Corporation is owned 20 percent by John, 30 percent by Brian, 30 percent by Charlie, and 20 percent by Z Corporation. Z Corp
    15·1 answer
  • Perch Co. acquired 80% of the common stock of Float Corp for $1,600,000. The fair value of Float's net assets was $1,850,000, an
    7·1 answer
  • Derrick invested $70,000 cash in the business. Paid $10,000 in cash for equipment. Performed services for cash amounting to $7,0
    7·1 answer
  • Households and firms with savings lend money to banks and other financial institutions. The credit supply curve shows the relati
    14·1 answer
  • Which of the following would you add to the balance per general ledger to arrive at the reconciled cash balance in a bank reconc
    11·1 answer
  • Wilder, Inc. applies overhead to production at a predetermined rate of 90% based on direct labor cost. Job No. 305, the only job
    5·1 answer
  • Expenses that are not easily traced to a specific department, and which are incurred for the joint benefit of more than one depa
    11·1 answer
  • Nuclear Inc. just paid a $2.75 dividend. Dividends are expected to grow by 30% in year 1, by 25% in year 2, and by 25% in year 3
    11·1 answer
  • What does standard of living measure?
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!