Question

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$

$($answers $[25,000$ and $$5\mathrm{.}75$ per unit$][50,000$ and $$3\mathrm{.}00$ per unit$]$ were marked wrong$)$