cost accounting please help

Mailings Review Help B D A File Home Insert Draw Design Layout References X Times New Roman 12 - EEV BIUeb x x D EEEE A L A Aa A A A Clipboard Font Paragraph View I Dictate Styles Editing Sensitive Editor Styles Voice Sensitivity Editor Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Month January February March April May June July August September October November December Maintenance Cost $4,200 $3,000 $3,600 $2,820 $4,350 $2,960 $3,030 $4,470 $4,260 $4,050 $3,300 $3,160 Machine Hours 480 320 400 300 500 310 320 520 490 470 350 340 1. Run a Regression Analysis on the information given. 2. What is the cost equation you would use given the outcome of the regression analysis? 3. Using the cost equation in #2, what would be the Predicted Cost at 400 hours of activity? 4. Given your answer in 83 at 400 hours of activity and using the Standard error of estimate, what is the confidence range that management can expect total costs to be in at the 400 hour activity level? Focus um of 1 194 words 11:41 PM