(Q.5) Lauric Daley is examining customer-service costs in the southern region of Capitol Products. Capitol Products has more than 200 separate electrical products that are sold with a six-month guarantee of full repair or replacement with a new product. When a product is returned by a customer, a service report is prepared. This service report includes details of the problem and the time and cost of resolving the problem. Weekly data for the most recent 8-week period are as follows: Customer-Service Department Costs Week 1 2 4 6 Customer-Service Department Costs $20,000 Questions: 1. Plot the relationship between customer-service costs and number of service reports. Is the relationship economically plausible (reasonable, acceptable)? $25,000 $15,000 $10,000 $5,000 $0 0 Write cost function: Calculate intercept (constant): $13,700 20,900 13,000 18,800 14.000 100 21,500 16,900 21,000 200 300 Number of Service Reports 190 275 115 395 265 455 340 305 400 Number of Service Reports 2. Using the high-low method compute cost function, relating customer-service costs to the number of service reports Calculate slope coefficient: 500

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Ma1.

 

(Q.5) Lauric Daley is examining customer-service costs in the southern region of Capitol Products.
Capitol Products has more than 200 separate electrical products that are sold with a six-month
guarantee of full repair or replacement with a new product. When a product is returned by a customer,
a service report is prepared. This service report includes details of the problem and the time and cost
of resolving the problem. Weekly data for the most recent 8-week period are as follows:
Customer-Service Department Costs
Week
1
2
3
4
5
6
8
ervice Department Costs
$25,000
$20,000
$15,000
Questions:
1. Plot the relationship between customer-service costs and number of service reports. Is the relationship
economically plausible (reasonable, acceptable)?
$10,000
$5,000
$0
0
Write cost function:
Calculate intercept (constant):
$13,700
20,900
13.000
100
18,800
14.000
21,500
16.900
21,000
200
300
Number of Service Reports
190
275
400
115
395
265
455
340
305
500
Number of Service Reports
2. Using the high-low method compute cost function, relating customer-service costs to the number of
service reports
Calculate slope coefficient:
7
Transcribed Image Text:(Q.5) Lauric Daley is examining customer-service costs in the southern region of Capitol Products. Capitol Products has more than 200 separate electrical products that are sold with a six-month guarantee of full repair or replacement with a new product. When a product is returned by a customer, a service report is prepared. This service report includes details of the problem and the time and cost of resolving the problem. Weekly data for the most recent 8-week period are as follows: Customer-Service Department Costs Week 1 2 3 4 5 6 8 ervice Department Costs $25,000 $20,000 $15,000 Questions: 1. Plot the relationship between customer-service costs and number of service reports. Is the relationship economically plausible (reasonable, acceptable)? $10,000 $5,000 $0 0 Write cost function: Calculate intercept (constant): $13,700 20,900 13.000 100 18,800 14.000 21,500 16.900 21,000 200 300 Number of Service Reports 190 275 400 115 395 265 455 340 305 500 Number of Service Reports 2. Using the high-low method compute cost function, relating customer-service costs to the number of service reports Calculate slope coefficient: 7
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.