Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ron Lee, a marketing clerk for Star Agency, recorded the following information for last year: Month Number of Customers Customer Service Costs January 355 $

Ron Lee, a marketing clerk for Star Agency, recorded the following information for last year:

Month Number of Customers Customer Service Costs
January 355 $ 527,078
February 416 544,180
March 300 482,430
April 535 667,500
May 399 530,350
June 456 656,760
July 365 543,650
August 494 680,300
September 344 487,110
October 540 709,950
November 442 628,880
December 414 541,900

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 highlow method.

2. Using the equation from part (1), compute the estimated customer service costs if the number of customers is expected to be 690.

3. You also used the least-squares regression method to do the analysis of the costs; the analysis resulted in the following output:

Intercept: 163,651.18
Coefficient of X-variable: 995.31
Adjusted R square: 0.88

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 to Expert-Tailored 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 Accounting

Authors: Michelle Hanlon, Robert Magee, Glenn Pfeiffer, Thomas Dyckman

5th Edition

1618531654, 9781618531650

More Books

Students also viewed these Accounting questions

Question

What is a multivariate data set?

Answered: 1 week ago

Question

4. Explain how to price managerial and professional jobs.

Answered: 1 week ago