Anderson Engineering provides consulting services and custom installations of proprietary industrial waste water treatment facilities. They...

Anderson Engineering provides consulting services and custom installations of proprietary industrial waste water treatment facilities. They also operate a repair shop for repairs and maintenance of the treatment products. The repair facility costs include salaries, insurance and depreciation, and materials and parts. The supervisor would like to develop a model that predicts repair costs.

Data for the past year is below:

Month	Jobs	Repair costs
January	55	$22,000
February	45	18,000
March	40	17,600
April	50	20,000
May	65	24,000
June	60	22,400
July	35	16,000
August	30	12,800
September	25	13,600
October	20	9,600
November	25	14,100
December	30	13,000

Required:

Using Microsoft Excel, prepare a scattergram by plotting jobs and repair costs on a graph.
Use Excel functions to determine the fixed and variable cost components of repair jobs. Clearly state and label these in your answer.
Use the high-low method to determine the fixed and variable cost components of repair jobs. Clearly state and label these in your answer.
Discuss the difference between the two answers from parts b and c. Which method is more reliable? Why?
The supervisor expects to receive 70 repair jobs next month. What are the predicted costs? Provide an amount for fixed, variable, and total costs. Use the formula that you identified in part d as more reliable.

Expert Solution

ekkarill92 answered 3 years ago

Environmental Engineering Water Treatment Wastewater Treatment Waste Water Treatment. A river is used as water resource...

Environmental Engineering Water Treatment Wastewater Treatment Waste Water Treatment. A river is used as water resource for a town. During monitoring, high level of NH3 is detected. A) What are the reasons for this pollution? B) Is it logical to continue feeding the water treatment system? C) Can NH3 be removed by regular units in a typical water treatment plant? In summary, how do you solve this problem, explain your reasons.

Anderson Accounting Services LLC provides accounting and tax preparation and consulting services. Sometimes customers only wish...

Anderson Accounting Services LLC provides accounting and tax preparation and consulting services. Sometimes customers only wish to have financial statements and/or tax returns prepared. Sometimes customers bundle accounting and tax preparation with consulting services (to be provided over a period of time). Sometimes customers only wish to have consulting services provided over a period of time. Because Anderson is a service firm there is no cost of goods sold associated with their services. Customer is Civic Corporation 1 Tax consulting...

Waste water treatment is a crucial process to ensure that the waste water can be safely...

Waste water treatment is a crucial process to ensure that the waste water can be safely recycled back to the environment. However, there are certain challenges or issues related to this waste water treatment that can endanger the environment. In your opinion (supported by journal or academic references), what are those challenges and how can civil engineers prevent those happening>

Environmental Engineering Water Treatment. Question 1: Aeration is particularly utilized to supply oxygen in water treatment....

Environmental Engineering Water Treatment. Question 1: Aeration is particularly utilized to supply oxygen in water treatment. a) How much oxygen is required for drinking water? b) How do the impurities (pollutants or other ions) in water affect aeration efficiency? Question 2: A) How do you classify the settling types? Explain briefly. B) Explain use of sedimentation units in water treatment (i.e. before or after which processes is sedimentation required).

Q9. A Waste water treatment units is proposed to be designed for the Wilayat of Sur....

Q9. A Waste water treatment units is proposed to be designed for the Wilayat of Sur. Population of Sur is 200,000 and an average sewage generation is 210 liter per capita per day. Design an appropriate waste water treatment plant using the following given data. If needed assume other necessary data. Approach channel velocity = 42 m/min, d = 1.5 w Design three aerated grit chamber Detention time in grit chamber = 3 min Depth of aerated grit chamber =...

A Waste water treatment units is proposed to be designed for the Wilayat of Sur. Population...

A Waste water treatment units is proposed to be designed for the Wilayat of Sur. Population of Sur is 200,000 and an average sewage generation is 210 liter per capita per day. Design an appropriate waste water treatment plant using the following given data. If needed assume other necessary data. Approach channel velocity = 42 m/min, d = 1.5 w Design three aerated grit chamber Detention time in grit chamber = 3 min Depth of aerated grit chamber = 2.0...

On March 12, Medical Waste Services provides services on account to Grace Hospital for $10,200, terms...

On March 12, Medical Waste Services provides services on account to Grace Hospital for $10,200, terms 4/10, n/30. Grace pays for those services on March 20. Required: For Medical Waste Services, record the service on account on March 12 and the collection of cash on March 20. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) 2. During 2021, its first year of operations, Pave Construction provides services on account...

Most water-treatment facilities monitor the quality of their drinking water on an hourly basis. One variable...

Most water-treatment facilities monitor the quality of their drinking water on an hourly basis. One variable monitored is pH, which measures the degree of alkalinity or acidity in the water. A pH below 7.0 is acidic, one above 7.0 is alkaline, and a pH of 7.0 is neutral. One water-treatment plant has a target pH of 8.5(Most try to maintain a slightly alkaline level.) The mean and standard deviation of 1 hour’s test results, based on 17 water samples at...

2. (14 pts) Hardness of water from two different water treatment facilities is investigated. Observed water...

2. (14 pts) Hardness of water from two different water treatment facilities is investigated. Observed water hardness (in ppm) for a random sample of faucets is as follows: Facility 1: 63 57 58 62 66 58 61 60 55 62 59 60 58 Facility 2: 69 65 59 62 61 57 59 60 60 62 61 66 68 66 Use α=0.01. (a) Assume σ1=σ2. Is there evidence to support the claim that the two facilities supply water of different hardness?...

During March, the Meade Consulting Corporation provides $23,000 in consulting services of which $12,000 is collected...

During March, the Meade Consulting Corporation provides $23,000 in consulting services of which $12,000 is collected immediately and $11,000 is on account. The effects of this transaction on Meade Consulting Corporation’s accounts are: a. Cash increases by $12,000; Accounts Receivable increases by $11,000; Revenue increases by $23,000. b. Cash increases by $12,000; Unearned Revenue increases by $11,000; Revenue increases by $23,000 c. Accounts Receivable increases by $11,000; Revenue increases by $12,000; Contributed capital increases by $1,000 d. Accounts Receivable increases...

Question