Question
Cubicle Solutions sells productivity software such as word processors, spreadsheets, and personal information managers. Cubicle prides itself on customer support and maintains a large call
Cubicle Solutions sells productivity software such as word processors, spreadsheets, and personal information managers. Cubicle prides itself on customer support and maintains a large call center where customers can call in with technical questions about the installation and use of Cubicle products. Monthly data on the number of support calls and call center costs for the last year have been collected and are shown below (all activities and costs are in thousands): Month Support Calls Call Center Cost 1 37 $528 2 53 690 3 45 590 4 39 535 5 61 720 6 47 610 7 44 590 8 48 620 9 55 700 10 40 545 11 42 565 12 41 550 Required: a. Estimate the monthly fixed costs and the unit variable cost per support call using the high-low estimation method. (Enter your answer in thousands of dollars.) b. Draw a scattergraph relating call center costs to the number of support calls. Instructions: 1. On the graph below, use the point tool to plot the point corresponding to the call center costs to the relating number of support calls (Month 1). 2. Repeat the process for the remainder of the sample (Month 2, Month 3, ). 3. To enter exact coordinates, double click on the point and enter the exact co-ordinates of x and y.
Cubicle products Monthly data on the number of support calls and call center costs for the last year have been collected and are shown below (all activities and costs are in thousands) Support Calls 37 53 45 39 61 47 44 48 55 40 Call Center Cost $528 690 590 535 720 610 590 620 700 545 565 550 Month 1 2 3 4 5 6 7 8 9 10 11 12 42 41 Required: a. Estimate the monthly fixed costs and the unit variable cost per support call using the high-low estimation method. (Enter your answer in thousands of dollars.) per call Support calls Overhead Costs b. Draw a scattergraph relating call center costs to the number of support calls. Instructions: 1. On the graph below, use the point tool to plot the point corresponding to the call center costs to the relating number of support calls (Month 1) 2. Repeat the process for the remainder of the sample (Month 2, Month 3,.. ) 3. To enter exact coordinates, double click on the point and enter the exact co-ordinates of x and y High-Low Method, Scattergraph Cubicle Solutions Month 1 750 Month 2 700 Month 3 650 Month 4 600- Month 5 550 Month 8 500 30 35 40 45 50 55 60 65 iants CostStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started