The production engineers have also given you the each individual bag produced . assuming ann han is prod Using Excel to Model Cost Behavior* Overview...

This is my Cost Behavior project, I really need a help!

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4
• Attachment 5

The production engineers have also given you theeach individual bag produced . assuming ann han is prodUsing Excel to Model Cost Behavior*Overview :\The goal of this project is to better acquaint you with the Excel features that will allow you toeasily analyze and model cost behavior in your future careers . In this project you will be helpingthe manager of Shima Limousine Service better understand how the company's operating costsbehave . Shima offers transportation services around the Cleveland area . Your goal is to use themethods discussed in class to help Shima's management generate a cost equation that will beuseful for predicting future operating costs .Part 1 : Formatting the data sets and calculating the High - low method using number of tripsDownload the Excel file from Blackboard that contains the data sets . You will notice that thereare two sheets : one for two potential cost drivers ( number of trips made ; number of miles driven ) .Click on the tabs at the bottom of the screen to switch back and forth between the data sheets .Use the formatting options on the toolbar ( format number tab ) to add dollar signs to the costcolumn and commas to the volume column . Delete any extra decimal places not needed .On the "Number of Trips" data sheet , use the High- low method to determine the cost equationthat expresses how monthly operating costs behave in relation to the number of trips made ..To find the high and low months , use max and min formulas to find these valuesAlthough they are easy to spot in this small data set , it is not always so easy.Therefore , learning to use these formulas will make you more efficient in Excel .. Next , highlight the two months you will using ( the highlight icon looks like a spillingpaint bucket ) .. Calculate the variable cost rate and the fixed costs using formulas and cell references. Lastly , enter a textbox following the instructions on the data set to provide the resultingcost equation .Use the resulting cost equation to predict total operating costs for a month in which 1 , 000trips are made . Make sure to use cell references in your formula . Use the space provided .Part 2 : Scatter plot , regression line and high - low line using the number of trips. Highlight all of the volume and cost data with the cursor .Click on the " insert " tab on the menu bar and then choose " Scatter " as the chart type . Next , clickthe Scatter with only Markers ( without any lines ) . You'll now see the scatter plot on the page .Click on "Move Chart Location " on the far right of the toolbar to move the chart to a new sheet( so that it's nice and big ) . Title the Sheet " Scatter - Number of Trips " .In the " Chart Layouts" on the toolbar select " layout 1 . " Add a descriptive title for the scatter plotby clicking on Chart Title and appropriate labels for each axis by clicking on the Axis Titles . Typein your own titles . Delete the " Series 1 " legend by right clicking on it and then deleting