Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 408 Weeks Ago, 2 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Management Posted 21 Jan 2018 My Price 9.00

Peterson’s Catering Company

29.    Multiple regression. The managers of Peterson’s Catering Company are analyzing the costs involved in providing catering services. Managers have selected the following cost drivers: units of meals produced, total deliveries, number of VIP services, number of new customers, and new products developed. Here are the cost data and levels of cost driver activity for the past 16 months.

 

 

Month

Total Overhead

 

Meals Produced

 

 

Deliveries

VIP

Services

New Customers

New Products

1

 

.................................

$69,094

 

12,690

 

1,340

 

345

 

3

 

0

2

.................................

64,927

 

11,980

 

1,180

 

310

 

4

 

0

3

.................................

60,332

 

10,950

 

1,050

 

280

 

4

 

1

4

.................................

57,953

 

10,280

 

930

 

245

 

5

 

0

5

.................................

55,984

 

9,020

 

840

 

205

 

7

 

2

6

.................................

53,119

 

8,130

 

780

 

185

 

8

 

2

7

.................................

52,706

 

7,540

 

700

 

160

 

10

 

3

8

.................................

53,874

 

6,980

 

630

 

144

 

12

 

4

9

.................................

53,445

 

8,930

 

680

 

135

 

10

 

2

10

.................................

54,869

 

9,800

 

760

 

120

 

9

 

0

11

.................................

59,985

 

10,560

 

890

 

175

 

8

 

2

12

.................................

61,121

 

11,560

 

1,070

 

200

 

7

 

0

13

.................................

63,926

 

11,710

 

1,240

 

240

 

6

 

0

14

.................................

66,602

 

12,460

 

1,390

 

285

 

4

 

0

15

.................................

72,773

 

13,520

 

1,450

 

330

 

4

 

1

16

.................................

71,391

 

13,620

 

1,510

 

315

 

2

 

0

Totals ........................           $972,101         169,730           16,440            3,674              103               17

 

                                                                                                                                                                      

 

 

a.   Using  multiple  regression,  find  the  cost  driver  rates  for  each  of  the  cost  drivers. (Note: You must use a computer program such as Microsoft1  Excel to perform this step.)

b.   Management estimates the following levels of cost driver volumes for the next month for the budget. What is the estimated cost for the budget? (Don’t forget to include the intercept of the regression in your estimate.)

 

12,000  ......................................................................                Meals produced

1,100   ......................................................................                Deliveries

300   ......................................................................                 VIP services

5   ......................................................................                New customers

2   ......................................................................                New products

 

c.   Peterson’s Catering Company is considering outsourcing deliveries. Compared to your answer in requirement b., how much would be saved per month by outsourcing the delivery service (before considering the cost of outsourcing)?

Answers

Maurice Tutor
(5)
Status NEW Posted 21 Jan 2018 08:01 PM My Price 9.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------

Not Rated(0)