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
Tobiaz, inc., a private firm, wants to create a survey program similar to the Uniform Crime Reporting Program/National incident-
olchik [2.2K]

Answer:

C, they analyze police reports about crimes reported by victims

Explanation:

Option A is wrong because is disregard hard crimes that conducted by blue-collar people (such as theft, store robbery, or even gang attacks).

Option B and D are wrong because 'Potential' victims do not always translate to actual victims, This will make the data that collected by the firm become misleading. They wouldn't find out the type of crimes that often happen in real life and wouldn't be able to design a proper solution for them.

Option C is the best choice from the available options. Even though it's not perfect. There are a lot of crimes that often goes unreported by the victims (such as domestic abuse)

4 0
3 years ago
Bad Debt Expense info:Allowance for Doubtful Accounts has a credit balance of $1,000. Credit sales are $500,000. Cash sales are
kow [346]

Answer:

Bad Debt Expense $24,000 Dr

Allowance for Doubtful Accounts $24,000 Cr

Explanation:

Data:

BB = Beginning Balance = $1,000

CS = Credit Sales = $500,000

CH = Cash Sales = $500,000

SM = Percentage Sales Method = 5% = 0.05

U = Uncollectible = $25,000

AR = Accounts Receivable = $200,000

ADA = Allowance for Doubtful Accounts = ?

Calculations:

ADA = U - BB = $25,000 - $1,000 = $24,000

Net Realizable Cash Value = AR - ADA = $200,000 - $24,000 = $176,000

Balance in the Allowance Account after the adjusting entry = BB + ADA = $1,000 + $24,000 = $25,000

Journal entry:

Bad Debt Expense $24,000 Dr

Allowance for Doubtful Accounts $24,000 Cr

Hope this helps!

8 0
3 years ago
Identify the cultural differences between Greece and Switzerland as per the GLOBE project
7nadin3 [17]
  1. Identify the cultural differences between Greece and Switzerland as per the GLOBE project

your answer is here

3 0
3 years ago
HOW IMPORTANT IS INNOVATION TO ENTREPRENEURSHIP?
faust18 [17]

Answer:

   Successful innovation allows you to add value to your business so that you can increase your profits—if you don't innovate well, your business will plateau. Innovation helps you stay ahead of the competition. With globalization and a rapidly changing market, there are more competing businesses than ever before.

<h2><u>Hope This Helped!</u></h2>

8 0
2 years ago
an annual bond selld for $865 with par value $1,000 and coupoin rate 8% what is bond yeild to maturity for 10 years
lisov135 [29]

Answer:

1.4484 %

Explanation:

The formula for Yield to Maturity =

[C + (FP - MP) /n]/FP + MP/2

Where

C = Coupon rate = 8% = 0.08

MP = Market value or price = $865

FP = Face or Par value = $1000

n = number of years = 10

Yield to Maturity =[ 0.08 +(1000 - 865) /10]/ 1000 + 865/2

Yield to Maturity = 1.4484 %

5 0
3 years ago
Other questions:
  • The Assembly Department started the month with 24,900 units in its beginning work in process inventory. An additional 309,900 un
    13·1 answer
  • Outlining reasons why the customer's concern is not right is it effective
    11·1 answer
  • Professor hoffson maintains a very strict attendance policy in her introduction to business course at wayne college. for each un
    6·1 answer
  • Suppliers are more likely to be powerful relative to the firms to which they sell their goods and services if: 1) differentiatio
    7·1 answer
  • If the demand curve is linear and downward sloping, which of the following statements is not correct? Select one: a. Starting fr
    11·1 answer
  • Can Europe's debt crisis be contained?
    14·1 answer
  • You're 35 years old now, and you want to purchase life insurance which will cover your spouse for your lost income in the event
    13·1 answer
  • A contact center manager is looking for ways to overall cost per case.
    11·1 answer
  • Assuming the total GDP is $1000 billion, if the government increases spending from $800 billion to $900 billion and the initial
    8·1 answer
  • To create and capture customer value, companies must engage the first step of the marketing process, which is __________.
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!