Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2.Grawburg Inc. maintains a call center to take orders, answer questions, and handle complaints. The costs of the call center for a number of recent

2.Grawburg Inc. maintains a call center to take orders, answer questions, and handle complaints. The costs of the call center for a number of recent months are listed below:

Calls Taken

Call Center Cost

April

8,450

$

91,609

May

8,419

$

91,440

June

8,460

$

91,668

July

8,459

$

91,651

August

8,423

$

91,458

September

8,434

$

91,496

October

8,476

$

91,722

November

8,464

$

91,678

Management believes that the cost of the call center is a mixed cost that depends on the number of calls taken.

Required:

Use Excel to estimate the variable cost per call and fixed cost per month using the least-squares regression method. (Round the "Variable cost" to 2 decimal places and the "Fixed cost" to the nearest dollar amount.) Please attach your Excel spreadsheet to support your answer.

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

Montgomery Auditing Continuing Professional Education

Authors: Patrick J. McDonnell, Barry N. Winograd, James S. Gerson, Henry R. Jaenicke, Vincent M. O'Reilly

12th Edition

0471346055, 978-0471346050

More Books

Students also viewed these Accounting questions

Question

assess the infl uence of national culture on the workplace

Answered: 1 week ago