# Question: The manager of the main laboratory facility at MetroFit Center

The manager of the main laboratory facility at MetroFit Center (from E6-49B) collects seven additional months of data after obtaining the regression results in the prior period. The number of tests performed and the total monthly overhead costs for the lab follows:

Use Excel to perform the requirements.

Requirements

1. Run a regression analysis.

2. Determine the lab’s cost equation (use the output from the regression analysis you perform using Excel).

3. Determine the R- square using the Excel output you obtain. What does the lab’s R- square indicate?

4. Predict the lab’s total overhead costs for the month if 3,000 tests areperformed.

Use Excel to perform the requirements.

Requirements

1. Run a regression analysis.

2. Determine the lab’s cost equation (use the output from the regression analysis you perform using Excel).

3. Determine the R- square using the Excel output you obtain. What does the lab’s R- square indicate?

4. Predict the lab’s total overhead costs for the month if 3,000 tests areperformed.

**View Solution:**## Answer to relevant Questions

Bayview Apartments is a 750- unit apartment complex. When the apartments are 90% occupied, monthly operating costs total $ 217,150. When occupancy dips to 80%, monthly operating costs fall to $ 212,800. The owner of the ...The annual data that follow pertain to Goggle Water Optics, a manufacturer of swimming goggles (the company has no beginning inventories):Sales ...Carmichael Industries is in the process of analyzing its manufacturing overhead costs. Carmichael Industries is not sure if the number of units produced or the number of direct labor (DL) hours is the best cost driver to use ...Use the information from the Crystal Cruiseline Data Set to compute the following: a. What is the contribution margin per passenger? b. What is the contribution margin ratio? c. Use the unit contribution margin to project ...Refer to your answer to S7-9. a. Compute the total number of dinner cruises that Crystal Cruiseline must sell to breakeven. b. Compute the number of regular cruises and executive cruises the company must sell to ...Post your question