The Mechanical Engineering department has a student team that is designing a formula car for national competition. The time required for the team to assemble the first car is 100 hours. Their improvement (or learning rate) is 0.8, which means that as output is doubled, their time to assemble a car is reduced by 20%. Use this information to determine:

1. the time it will take the team to assemble the 10th car.
2. In the excel spreadsheet having the following table. You must show the formula used in the excel sheets to calculate values in the columns.
3. Plot Number of Units vs Time (in hours) and Number of Units vs Cumulative Time (in hours) in the same plot. Use different colors to distinguish the data.

N (no of Units)	Time to Produce Nth	Cumulative Time (1 to N)
1
2
3
4
5
6
7
8
9
10