Question: Problem 5-52 High-Low Method, Scattergraph (LO 5-4) Cubicle Solutions sells productivity software such as word processors, spreadsheets, and personal information managers. Cubicle prides itself on


Problem 5-52 High-Low Method, Scattergraph (LO 5-4) 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 $521 880 620 550 50 710 840 620 650 670 575 595 580 Required: a. Estimate the monthly fixed costs and the unit variable cost per support call using the high-low estimation method. (Round variable cost per unit to 2 decimal places. Enter your answer in thousands of dollars.) Overhead Costs = + per call * Support calls 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 Munth 1 Month 2 Munth 3 Month Cost *** 30 35 40 45 50 55 0 5 7 Calls reset
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
