Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Andrew, marketing clerk for Shine Agency, recorded the following information for last year. Month January February March April May June July August September October November
Andrew, marketing clerk for Shine Agency, recorded the following information for last year. Month January February March April May June July August September October November December Number of Customers 360 421 339 534 404 461 370 499 349 536 447 419 Customer Service Costs $527,853 544,955 483,555 670,250 531,100 657,510 544,250 680,800 487,710 716,015 629,630 542,400 He would like to be able to estimate customer service costs using the number of customers as the basis for estimation However, because he has never taken a course in managerial accounting, he does not know how to set up a cost equation. He has therefore approached you for help. Required: 1. Set up a cost equation for monthly customer service costs using the high-low method. Y 2. Using the equation from Part (1), compute the estimated customer service costs if the number of customers is expected to be 580. Customer service costs 3. You also used the least squares regression method to do the analysis of the costs: the analysis resulted in the following output: Intercept: Coefficient of X-variable: Adjusted R square: 108,018.86 1, 113.02 0.90 Set up a cost equation using the above numbers. (Round the "Fixed cost" to the nearest dollar amount and Variable cost to 2 decimal places)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668e19eecbc02_782668e19ee6e3ed.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668e19ef59e98_783668e19ef03a79.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started