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
Wildhorse Corp. has total current assets of $12,152,000, current liabilities of $5,849,000, and a quick ratio of 0.94. How much
White raven [17]

Answer:

Wildhorse Corp. has inventory of $6,653,940

Explanation:

The quick ratio is a liquidity ratio that indicates a company's ability to pay its current liabilities when they come due without needing to sell its inventory or get additional financing. The quick ratio is calculated by the following formula:

Quick ratio = (Cash & equivalents + Short Term investments + Accounts receivable)/Current Liabilities

(Cash & equivalents + Short Term investments + Accounts receivable) = Quick ratio x Current Liabilities = 0.94 x $5,849,000 = $5,498,060

Inventory = Total current assets - (Cash & equivalents + Short Term investments + Accounts receivable) = $12,152,000 - $5,498,060 = $6,653,940

4 0
3 years ago
This year, Santhosh, a single taxpayer, estimates that his tax liability will be $100,000. Last year, his total tax liability wa
Alekssandra [29.7K]

Answer:

a) Is Santhosh required to increase his withholding or make estimated tax payments this year to avoid the underpayment penalty?

  • No he is not required to make any payments or increase his withholdings because this year's withholdings already represent a 133% increase with respect to last year's tax liability. If the withholdings for the current are over 100% last year's tax liability, then the taxpayer doesn't need to make any further adjustments in order to avoid underpayment penalties.

b) By how much, if any, must Santhosh increase his withholding and/or estimated tax payments for the year to avoid underpayment penalties?

  • $0

6 0
3 years ago
Taylor Company began manufacturing operations on January 2, 20X1. During 20X1 Taylor reported pre-tax book income of $150,000 an
aleksley [76]

Answer:

$11,300

Explanation:

The computation of the deferred tax asset is shown below:

= 21%(20X2 Expense) + 25%(20X3 and 20X4 Expense)

= 21%($30,000) + 25%($15,000) + 25%($5,000)

= $6,300 + $3,750 + $1,250

= $11,300

3 0
3 years ago
ABC Company leased equipment to Best Corporation under a lease agreement that qualifies as a finance lease. The cost of the asse
alexandr402 [8]

$12120 is the annual amortization expense

<u>Explanation:</u>

The following formula is used to calculate the annual depreciation expense that will be recorded in the books of accounts

Depreciation = ( cost of the asset minus salvage value) divide by number of years.

Given data in the question: number of years = 10, cost of the asset = $124000, salvage value = $28000

Putting the figures in the formula,

Depreciation expense = ($124000 minus $28000) divide by 10

After solving, we get = $12120

Thus, annual depreciation expense = $12120

7 0
3 years ago
Jones Corporation reported current assets of $191,800, current liabilities of $137,000, and total liabilities of $275,714 on its
VMariaS [17]

Based on the information given the current ratio is:1.4.

<h3>Current ratio</h3>

Using this formula

Current ratio=Current assets/Current liabilites

Where:

Current assets=$191,800

Current liabilities=$137,000

Let plug in the formula

Current ratio=$191,800/$137,000

Current ratio = 1.4

Inconclusion the current ratio is:1.4.

Learn more about current ratio here:brainly.com/question/2686492

4 0
2 years ago
Other questions:
  • The balance in the office supplies account on January 1 was $7,000, supplies purchased during January were $3,000, and the suppl
    15·1 answer
  • Under Eagle Co.'s job costing system, manufacturing overhead is applied to Work-in-Process using a predetermined annual overhead
    7·1 answer
  • The prime interest rate is offered by banks to customers with the largest accounts and with very high credit ratings.
    6·1 answer
  • the gdp of a country hasn’t improved in the past three years. the central bank decided to take a measure that will increase the
    13·2 answers
  • Flintlnc. provided the following information for the year 2017.
    12·1 answer
  • You run a small community or country and your primary output is the growing of wheat and the sewing of socks. You are able to pr
    11·1 answer
  • When making a major purchase first determine your
    15·1 answer
  • Calculate how many hours his non-salary employees will take to create a large order of 1,000 shoes. What kind of budget would Jo
    7·1 answer
  • Sentinals FC, a soccer club, is hiring new players. The applicants are required to be of a certain height and physical build to
    11·1 answer
  • To calculate direct materials on the schedule of cost of goods manufactured, add purchases to beginning raw materials inventory
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!