Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

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

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1711

Students also viewed these Accounting questions