can someone help with this question?

The objective of this exercise is to prepare a bid for the building of $15$ Firefly smart missiles. Your company built the Firefly prototype because of its experience building an earlier version called Fire smart missiles. When the Firefly missile manufacturing specifications were released, the government also released details of the $$1,600,000$ cost in building the Firefly prototype. In addition to direct materials, direct labor, and variable manufacturing overhead, other manufacturing overhead costs were $10\%$ of total variable manufacturing costs. The $$170,000$ equipment purchased by the government will be made available to the selected contractor.

Direct materials $ $800,000$

Direct labor $(4,000$ hours @ $$100)400,000$

Variable manufacturing overhead $(4,000$ hours @ $$25)100,000$

Other manufacturing overhead $($$$1,300,000$ @ $10\%)130,000$

Purchase of reusable equipment $170,000$

Total $ $1,600,000$

With your highly skilled labor force, the $4,000$ direct labor hours incurred for the prototype should not be assumed for each of the fifteen Firefly missiles because of anticipated learning effects from Fire. Assume that the next fifteen Firefly missiles can be built with the same amount of learning that occurred in the production of the sixteen Fire missiles, the earlier version of the Firefly. The direct labor hours for each of the sixteen Fire $($i$.$e$.,$ the older version$)$ missiles are listed below:

Unit # Individual Direct Labor Hours $($DLH$)$ For Fire

$13900$

$22740$

$32660$

$41980$

$52320$

$62000$

$71900$

$81700$

$91950$

$101950$

$111760$

$121540$

$131680$

$141320$

$151500$

$161100$

Cumutive method

$1.$ Using EXCEL, enter the data for the Fire missiles into two columns labeled as Unit # and Individual Direct Labor Hours.

$2.$ Add two more columns $(1)$ Cumulative Direct Labor Hours and $(2)$ Average Cumulative Direct Labor Hours $($Cumulative divided by unit #$).$

$3.$ Generate a scatter plot of Unit number $($X$)$ and Cumulative Direct Labor Hours.

$4.$ With a right$-$click on a data point within the graph, select Add Trendline and then Power as the trend type from the drop$-$down menus.

$5.$ Staying within Add Trendline, select the Options tab and check Display equation on chart and Display R$-$squared value on chart.

$6.$ Now add another column to your data and label it as $$Individual Direct Labor Hours for Firefly$.$

$7.$ For each unit, enter the formula aXb where a is the direct labor hours incurred for the prototype of Firefly $($that is $4,000$ hours$),$ X is the unit number $($your first column you entered$),$ and b is the coefficient $($including its sign if it is negative$)$ from the trendline equation you estimated in step $4$ above.

$8.$ The total of units $2-16$ from your estimation in step $6$ above is the total direct labor hours for the Firefly missile. As a hint, this number should be substantially lower than the labor hours without a learning curve $($think what that would be$).$

$9.$ Prepare a cost sheet with and without learning curve. Include direct material, direct labor, variable manufacturing, and other manufacturing costs.