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
icon
Related questions
Question
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 =
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman