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
Serggg [28]
3 years ago
10

The manager of the main laboratory facility at Elmhurst HealthElmhurst Health Center is interested in being able to predict the

overhead costs each month for the lab. The manager believes that total overhead varies with the number of lab tests performed but that some costs remain the same each month regardless of the number of lab tests performed. The lab manager collected the following data for the first seven months of the year.
Requirements

1.

Determine the​ lab's cost equation​ (use the output from the Excel​ regression).

2.

Determine the​ R-square (use the output from the Excel​regression).

3.

Predict the total laboratory overhead for the month if 3,100 tests are performed

Data Table

Number of Lab Tests

Total Laboratory

Month

Performed

Overhead Costs

January. . . . . . . . .

3,000

$21,900

February. . . . . . . .

2,850

$20,600

March. . . . . . . . . . .

3,400

$28,900

April. . . . . . . . . . . .

3,700

$31,000

May. . . . . . . . . . . .

3,900

$28,000

June. . . . . . . . . . . .

1,900

$20,200

July. . . . . . . . . . . .

2,050

$14,000

The laboratory manager performed a regression analysis to predict total laboratory overhead costs. The output generated by Excel is as​ follows:

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.878214

R Square

0.77126

Adjusted R Square

0.725512

Standard Error

3156.338706

Observations

7

ANOVA

df

SS

MS

F

Significance F

Regression

1

167956201.3

167956201.3

16.858885

0.009301

Residual

5

49812370.15

9962474.03

Total

6

217768571.4

Standard

Lower

Upper

Coefficients

Error

t Stat

P-value

95%

95%

Intercept

3187.94

5092.169

0.626

0.559

-9901.898

16277.778

X Variable 1

6.84

1.666

4.106

0.009

2.558

11.123
Business
1 answer:
raketka [301]3 years ago
4 0

Answer:

1.  Lab's cost= 3187.94 +6.84 number of lab test performed

2. 0.77126

3. $24391.94

Explanation:

1.

The Lab's cost depends on the number of lab test performed. So, Lab's cost is a dependent variable while number of lab test is an independent variable. The linear regression equation is written as

Y= a+bx

Where,

y= dependent variable

x= independent variable

a= intercept

b= slope

So, the equation can be written as

Lab's cost= a+b number of lab test performed

From the Excel output we know that

Intercept = a= 3187.94

Slope= b =6.84

So, the required regression equation is

Lab's cost= 3187.94 +6.84 number of lab test performed

2.

The Excel output shows that R-square is 0.77126. R²=0.77126 means that only 77.13% of variation in Lab's cost is explained by its linear relationship with number of lab test performed.

3.

We have to predict the lab's cost for 3100 test.

We know that

Lab's cost= 3187.94 +6.84 number of lab test performed.

Here, number of lab test performed=3100.

So,

Lab's cost= 3187.94 +6.84(3100)

Lab's cost= 3187.94 +21204

Lab's cost=$24391.94

Thus, the predicted total laboratory overhead for the month if 3,100 tests are performed is $24391.94.

You might be interested in
Indirect costs incurred in a manufacturing environment that cannot be traced directly to a product are treated as a.period costs
Dima020 [189]

Answer:

Indirect costs incurred in a manufacturing environment that cannot be traced directly to a product are treated as Product costs and expenses when the goods are sold, Option D.

Explanation:

Indirect costs are also manufacturing overheads which cannot be directly put on the product but they have to be allocated in some way. So, these are treated as 'product costs' and 'expenses' when the goods are sold. They are not period costs as per Option A and option C. Option B which says that it is product costs when incurred, which is also incorrect.

Examples of indirect costs can be accounting and legal expenses, rent, telephone expenses, salaries of administrative.

Direct costs includes the costs of direct 'labor', materials and commissions.

8 0
3 years ago
Without division of labor, no specialization. Discuss​
melomori [17]
Ncncncncmckckclslalamsnndnx
7 0
2 years ago
Read 2 more answers
A promissory note
Sloan [31]

Answer: c. may be used to settle an accounts receivable.

Explanation: A promissory note is defined as a financial instrument that contains a written promise by the note issuer or maker to pay the note payee a definite sum of money at a specific future date or on demand and  may be used to settle an accounts receivable (the balance of money due to a firm for goods or services delivered or used but not yet paid for by customers and are listed on the balance sheet as a current asset). They are commonly used in businesses as a form of short term financing as they can be exchanged for cash at a future time when account receivables have been collected.

8 0
2 years ago
This year, the Tastee Partnership reported income before guaranteed payments of $161,500. Stella owns a 40% profits interest and
Aloiza [94]

Answer

The answer and procedures of the exercise are attached in the image below.  

Explanation  

Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.  

5 0
3 years ago
In 20X5, Elm Corp. bought 10,000 shares of Oil Corp. at a cost of $20,000. On January 15, 20X6, Elm declared a property dividend
xxMikexx [17]

Answer:

c) $25,000

Explanation:

A property dividend should be recorded in retained earnings at the property's  <u>market value at date of declaration.</u>

<u>The date of declaration is the date on which the firm has made the commitment to pay the dividend. The market value on this date is the value that was considered when the board made the decision to distribute a property dividend and thus is the appropriate measure of the sacrifice to the firm. </u>

<u> </u>In application to the scenario, <u>the property dividend will be recorded in retained earnings at the market value at the date of declaration which is Jan 15 </u>NOT on the day it is payable.

Hence, retained earnings will reduce by $25,000

In 20X5, Elm Corp. bought 10,000 shares of Oil Corp. at a cost of $20,000. On January 15, 20X6, Elm declared a property dividend of the Oil stock to shareholders of record on February 1, 20X6, payable on February 15, 20X6. During 20X6, the Oil stock had the following market values:  

January 15

$25,000

February 1

26,000

February 15

24,000

6 0
3 years ago
Other questions:
  • Suppose two companies own adjacent oil fields. under the two fields is a common pool of oil worth $60 million. for each well tha
    9·1 answer
  • Suppose you are starting a PhD program with only $1,000 in your savings account. The university has agreed to waive your tuition
    14·1 answer
  • When pay is made public, people evaluate how equitable their pay is in light of the pay other people are receiving. The problem
    11·1 answer
  • Which of these situations would give rise to the free-rider problem? Items (6 items)
    7·1 answer
  • Christina supervises a group of employees at a company that just went through a downsizing. Many other supervisors are no longer
    6·1 answer
  • At its $60 selling price, Atlantic Company has sales of $15,000, variable manufacturing costs of $4,000, fixed manufacturing cos
    11·1 answer
  • ​You are part of an information systems project team. your job is to ensure that the technology and vendor suggested for use in
    15·1 answer
  • Ceilings are thought to represent the level at which more difficult questions would not be passed.
    5·1 answer
  • A company has two products: A1 and B2 . It uses activity based costing and has prepared the following analysis showing budgeted
    9·1 answer
  • A 15% increase in sales resulted in a 40% increase in net income for Company A and a 60% increase in net income for Company B. B
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!