E BusinessCourse

Return to course

Course Content $/$ Week $3$ Chapter $6/$ Data Analytics Assignment $1$

Data Analytics Assignment $1$

Determining Fixed vs$.$ Variable Cost Components Using Excel $($Diagnostic Analytics$)$ provide them with a monthly gross profit of $$7,500.($Last year's sales price was $$75$ per unit.$)$ labor, and other$).$ That information is included in the file linked here.

Required

Note: Round all answers to two decimals. for indirect materials, once for indirect labor, and once for other overhead$).$ Use the information from each analysis, along with the direct cost information to estimate the cost equation.

Hint: Click on $95\%$ confidence level box and check the box to add a Line fit plot for each indirect cost element to show the relationship in chart form.

Hint: You may need to change the minimum bound on the horizontal axis to $700$ to see the line clearly on each chart.

$\backslash$table$[[\backslash$table$[[$Manufacturing$],[$Overhead Costs$]],,],[,\backslash$table$[[$Variable$],[$Cost per$],[$Unit$]],\backslash$table$[[$Total Fixed$],[$Cost$]]],[$Direct materials,$$,$$