Week Total Cost Units Produced $1$ $$81,50110,1212$ $$68,8609,3313$ $$70,10910,8734$ $$79,0219,3515$ $$68,9129,8986$ $$60,5618,7517$ $$95,63810,3278$ $$73,4639,4089$ $$71,1379,83210$ $$91,54810,82811$ $$75,1089,53912$ $$75,60510,13913$ $$94,19312,19814$ $$84,6069,45815$ $$64,8378,23216$ $$94,31611,23417$ $$88,48610,26918$ $$87,1389,97519$ $$89,30810,08420$ $$90,52710,02921$ $$89,3379,44122$ $$86,9119,84223$ $$99,19310,82224$ $$91,94410,57725$ $$83,7399,39626$ $$82,8249,87027$ $$98,28411,88228$ $$85,83910,05429$ $$98,14710,27730$ $$78,00010,20831$ $$83,4669,98432$ $$73,58110,79833$ $$65,44810,53434$ $$66,9529,38335$ $$63,5019,39636$ $$73,40010,23537$ $$77,2239,10538$ $$95,1229,80339$ $$85,8199,59440$ $$85,19810,12341$ $$79,19910,20742$ $$90,7639,54143$ $$93,41210,74944$ $$92,28510,70345$ $$71,0669,48446$ $$74,6259,91147$ $$90,36411,28248$ $$68,0778,36749$ $$85,5149,47850$ $$93,4219,09951$ $$68,4849,06352$ $$85,9769,738$ Double left$-$click on Tableau icon to open it$.$ Left$-$click on Microsoft Excel in the blue Connect pane on left$-$hand side to show data file. Navigate to the data file you just downloaded and double left$-$click the data file name: AT Data Scatter Diagram. Left$-$click on the orange$-$shaded Sheet $1$ at bottom of screen. Double left$-$click Sheet $1$ at top of blank worksheet. Enter title of worksheet as Total Cost and Units Produced; then left$-$click center$-$text; then left$-$click OK$.$ Left$-$click and hold Units Produced and drag it from left$-$hand side Tables pane to the Columns shelf $($on the upper$-$right$).$ Left$-$click and hold Total Cost and drag it from left$-$hand side Tables pane to the Rows shelf $($on the upper$-$right$).$ Left$-$click and hold Week and drag it from left$-$hand side Tables pane to the Detail card $($located under Marks near middle of screen$).$ This creates a scatter diagram. Go to the top ribbon and left$-$click Standard. Select Entire View. This expands the graph to fill the worksheet. On the top ribbon $($or menu bar on Mac$),$ left$-$click Analysis and select Trend Lines and then select Show Trend Lines. Right$-$click $($or Control$-$click on Mac$)$ on the trend line and select Describe Trend Line. Complete the Requirements.

Enter the cost equation generated by Tableau. $($Round your answers to $2$ decimals.$)$

Cost equation $=+$ per unit.

Reviewing the cost equation, identify $($a$)$ total fixed cost and $($b$)$ variable cost per unit. $($Round your answers to $2$ decimals.$)$

Total Fixed CostVariable

Cost per Unit

Using the cost equation, estimate total cost if $12,500$ units are produced. $($Round "Fixed cost" and "Variable cost per unit" answers to $2$ decimal places.$)$

Cost EquationFixed cost$+$Variable cost per unit$$Units produced$=$Estimated total cost$+12,5000\mathrm{.}00$