Question

Tempe Office Services and Supplies (TOSS) provides various products and services in the Tempe Research Park, home to numerous high-tech and bio-tech companies. Making color copies is one of its most popular and profitable services. The controller performed a regression analysis of data from the Color Copy Department with the following results: 561.22689 0.966478 Intercept R square Number of observations X coefficient 0.05852 The regression output was based on the following data: Month July August September October November December Number of Color Copies 24,350 17,200 24,950 23,400 21,550 18,550 Color Copy Department Costs $ 1,935 1,550 2,015 1,975 1,855 1,645 Required: 1. What is the variable cost per color copy for TOSS? 2. What is the fixed cost for the Color Copy Department? 3. Based on the regression output obtained by the controller, what cost formula should be used to estimate future total costs for the Color Copy Department? Enter answer as an equation in the form of y= a + bx. 5-a. Use the high-low method to estimate the variable and fixed costs for the Color Copy Department. 5-b. What cost formula should be used based on your analysis? Enter answer as an equation in the form of y= a + bx. 6. If 21,900 copies are made during January, what is the total cost predicted by each method? X Answer is not complete. Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 5a Req 5b Req 6 If 21,900 copies are made during January, what is the total cost predicted by each method? (Use the answers that you provided in parts 3 and 5-b and round your final answers to 2 decimal places.) Total Cost Regression High-Low

Answer 1

Solution:

1. Variable cost per copy of TOSS = $0.05852 (i.e. X coefficient value)

2. Fixed cost for the color copy dept. = $561.22689 (i.e. Intercept value)

3. Equation is : Y = $561.22689 + 0.05852 X

5-a. Variable cost per Color copy (b) = (Highest activity cost - Lowest activity cost) / (Highest activity units- lowest activity units)

= ($2,015 - 1,550) / (24,950 - 17,200)

   = $0.06

Fixed cost (a) = $2,015 - 24,950×$0.06 = $518

5-b. Total cost = $518 + $0.06 per number of color copies

6. Total cost under regression method = $561.22689 + 0.05852×21,900 = $1842.81

   Total cost under High-low method = $518 + $0.06×21,900 = $1,832