The cost data for Evencoat Paint for the year 2019 is as follows:

A. Using the high-low method, express the company’s maintenance costs as an equation where x
represents the gallons of paint produced. Then estimate the fixed and variable costs.
B. Predict the maintenance costs if 90,000 gallons of paint are produced.
C. Predict the maintenance costs if 81,000 gallons of paint are produced.
D. Using Excel, create a scatter graph of the cost data and explain the relationship between gallons of
paint produced and equipment maintenance expenses.

Transcribed Image Text:

Month January February March April May June July August September October November December Gallons of Paint Produced 110,000 68,000 71,000 77,000 95,000 101,000 125,000 95,000 95,000 89,000 128,000 122,000 Equipment Maintenance Expenses $70,700 66,800 67,000 68,100 69,200 70,300 70,400 68,900 69,500 68,600 72,800 71,450