The accounting department of Insecurity Protection Services, a company that provides security services for rich, famous, and insecure people is analyzing the costs of its accounting services. Analysts have selected the following cost drivers: paychecks processed, invoices processed, customer accounts maintained, responses to routine inquires, and special analyses.
The accounting department of Insecurity Protection Services, a company that provides security services for rich, famous, and insecure people is analyzing the costs of its accounting services. Analysts have selected the following cost drivers: paychecks processed, invoices processed, customer accounts maintained, responses to routine inquires, and special analyses.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question

Transcribed Image Text:The accounting department of Insecurity Protection Services, a company that provides security services for
rich, famous, and insecure people is analyzing the costs of its accounting services. Analysts have selected
the following cost drivers: paychecks processed, invoices processed, customer accounts maintained,
responses to routine inquires, and special analyses.
MONTH
COSTS
PAYCHECKS
INVOICES
CUSTOMER
ROUTINE
SPECIAL
ACCOUNTS
325
PROCESSED
PROCESSED
INQUIRES
ANALYSIS
$7,013.00
6,469.80
6,129.40
5,905.90
5,659.50
1,340
1,180
1,050
1
12,690
11,980
10,950
10,280
9,020
8,130
7,540
6,980
32
2
310
39
3
280
245
205
185
45
1
4
930
54
840
68
6
780
83
5,115.80
5,101.80
5,488.90
5,284.80
2
7
700
160
97
3
8
630
140
112
4
9
8,930
680
115
101
2
Sort
9,800
10,560
11,560
10
760
93
5,538.40
6,129.30
6,026.10
6,517.20
6,600.50
120
11
890
175
82
1
12
1,070
1,240
1,390
1,450
200
68
13
11,710
12,460
13,520
13,620
169,730
240
55
14
285
45
15
7,153.10
7,207.60
$97,341.10
300
39
1
16
1,510
16,440
315
24
TОTALS
3,600
1,037
16
INCLUDE A PRINTOUT OF YOUR EXCEL REGRESSION ANALYSIS
A. Using the method of least squares, run a simple regression using the number of invoices
processed as the single independent variable. What is the cost formula for this regression?
COST FORMULA =
В.
Run a multiple regression using the five independent variables: paychecks processed, invoices
processed, customer accounts, routine inquires, special analysis. What is the cost formula for this
multiple regression? Which regression equation is better, the simple regression or the multiple
regression? Why?
COST FORMULA =
WHICH REGRESSION EQUATION IS BETTER, THE SIMPLE REGRESSION OR THE
MULTIPLE REGRESSION?
WHY?
C. Assuming the following level of cost-driver volume for a month, what is the accounting department's
estimated costs of doing business? (Don't forget to include the intercept of the regression in your
estimate.)
10,000 paychecks processed
1,000
invoices processed
300
customer accounts maintained
50
1
routine inquires
special analysis
ANSWER =
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman