Travis Metals heats copper ingots to a high temperature by placing them in a large oven. The heated ingots are then run through a shaping machine that forms them into wire. Due to the length of time it takes the oven to heat up, it is never turned off. When the ingots are placed in the oven the temperature is raised to a higher level. Once they are done being heated the oven temperature is turned back down until a new batch of ingots is ready to be heated. The following information shows the ingots processed and the power costs over the past 10 months.

Month	Ingots			Power Cost
January		122		$	5,980
February		102		$	4,980
March		92		$	4,880
April		112		$	5,480
May		142		$	6,480
June		132		$	6,080
July		82		$	4,480
August		72		$	3,680
September		62		$	3,880
October		52		$	2,880

Problem 3-14 Part 1-a

Required:

1-a. Using Microsoft Excel, prepare a scattergraph by plotting ingots processed and power costs on a graph. Use the Add Trendline feature in Excel to plot a line through the points of the graph.

Ignots Processed