Question
Mon Inc. has identified the following costs at different activity levels for Maintenance for their manufacturing plant: Month Units Produced Maintenance Cost 1 380 15,720
| Mon Inc. has identified the following costs at different activity levels for Maintenance for their manufacturing plant: | ||
| Month | Units Produced | Maintenance Cost |
| 1 | 380 | 15,720 |
| 2 | 620 | 16,740 |
| 3 | 210 | 13,250 |
| 4 | 360 | 14,910 |
| 5 | 410 | 15,730 |
| 6 | 380 | 10,280 |
| NO COMMAS, NO $, 2 decimal places | ||
| Using excel for regression analysis what is the variable cost per unit? | ||
| Using excel for regression analysis what is the fixed cost? | ||
| Using excel for regression analysis what is the R square as a percentage? (if your R-square is 67.58%, enter as "67.58%" - yes, DO enter the percentage sign with your answer here) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Accounting Principles Volume 1
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak
8th Canadian Edition
978-1119502425
