High-Low Method.The city of Rockville reported the following annual cost data for maintenance work performed on its fleet of trucks.

Reporting Period (Year)	Total Costs	Level of Activity (Miles Driven)
Year 1	$750,000	225,000
Year 2	850,000	240,000
Year 3	1,100,000	430,000
Year 4	1,150,000	454,000
Year 5	1,250,000	560,000
Year 6	1,550,000	710,000

Using Excel

Use the scattergraph method to estimate total fixed costs per year and the variable cost per mile. State your results in the cost equation form Y =f+vX by filling in the dollar amounts forfandv.

• What would the estimated costs be if the trucks drove 500,000 miles in year 7?
• I have already input the data and worked out the answer in excel but I don't know how to make a scatter plot. I have uploaded a screenshot of my excel file for reference

Reporting Period Year Total Costs Activity - Miles Driven {X} Variable Cost Per Mile [17} Variable Cost per year Fixed Cost [Fl Year 1 750,000 225000 1.65 Year 2 850,000 240000 1.65 Year 3 1,100,000 430000 1.65 Year 4 1,150,000 454000 1.65 Year 5 1,250,000 560000 1.65 Year 6 1,550,000 710000 1.65 [Year 6 and 1 are high and low points} Year 7 500,000 Y = F-Hni so that Y=373750+1.65) Y=373750+[1.65*500000:I Y: 5 1,203,750.00 Scattergraph Method :1 371250.00 5 378,750.00 39600.00 709500.00 749100.00 924000.00 117150000