Regression Analysis Using Excel (Appendix).Brake Products, Inc., produces brake pads. Management wants to estimate the cost of production equipment used to produce the brake pads. The company reported the following monthly cost data related to production equipment:
Chrome File Edit View History Bookmarks People Tab Window Help 70% O Sat 7:44 PM Q E . .. Mail - Silvia Lat X Bb Take Test: Fina X mySLU: Tools X Bb Module 4: Cha; x Homework Hel x 5.6 End-of-Ch: x Courses | Hom x G mac screensho x + C A scholar.flatworldknowledge.com/books/29836/heisinger-27401-20151025-173752-316836/read G Production Costs? Search this book Q Read Study Aa Silvia v -5. How Do Organizations Identify Cost Behavior Patterns? b. Prepare a contribution margin income statement for Palermo Company. arpe 5.1. Cost Behavior Patterns c. Why do companies use the contribution margin income statement format? AY 33. Regression Analysis Using Excel (Appendix). Brake Products, Inc., produces brake pads. 5.2. Cost Estimation Methods Management wants to estimate the cost of production equipment used to produce the brake pads. The company reported the following monthly cost data related to production equipment: 5.3. The Contribution Margin Income Reporting Period (Month) Total Costs Machine Hours Statement January $1,104,000 54,000 on 5.4. The Relevant Range and Nonlinear February 720,000 30,000 Costs March 600,000 24,000 April 1,320,000 108,000 5.5. Appendix: Performing Regression Analysis with Excel May 1,368,000 114,000 June 744,000 36,000 5.6. End-of-Chapter Exercises July 1,056,000 45,600 August 1,092,000 57,600 6. How Is Cost-Volume-Profit Analysis Used for Decision Making? September 1,272,000 93,600 October 1,152,000 51,200 7. How Are Relevant Revenues and Costs Used to November 1,680,000 115,200 Make Decisions? December 1,176,000 64,800 8. How Is Capital Budgeting Used to Make Required: Decisions? a. Use Excel to perform regression analysis. Provide a printout of the results. b. Use the regression output to develop the cost equation Y = f + UX by filling in the dollar 9. How Are Operating Budgets Created? amounts for fand v. c. What would Brake Product's estimated costs be if it used 90,000 machine hours this month? 10. How Do Managers Evaluate Performance Using Cost Variance Analysis? Exercises: Set B 11. How Do Managers Evaluate Performance in
