Kemp Tables, Inc. (KTI) makes picnic tables of 2 4 planks of treated pine. It sells the tables to large retail discount stores such as Walmart. After reviewing the following data generated by KTI's chief accountant, the company president, Arianne Darwin, expressed concern that the total manufacturing cost was more than $0.8 million above budget ($7,151,400 - $6,266,500 = $884,900). Cost of planks per table Cost of labor per table Total variable manufacturing cost per table (a) Total number of tables produced (b) Total variable manufacturing cost (a x b) Total fixed manufacturing cost Total manufacturing cost Actual Results $ 39.60 28.60 $ 68.20 87,000 $ 5,933, 400 1,218,000 $ 7,151,400 Master Budget $ 35.70 25.80 $ 61.50 83,000 $ 5,104,500 1,162,000 $ 6,266,500 Ms. Darwin asked Conrad Pearson, KTI's chief accountant, to explain what caused the increase in cost. Mr. Pearson responded that things were not as bad as they seemed. He noted that part of the cost variance resulted from making and selling more tables than had been expected. Making more tables naturally causes the cost of materials and labor to be higher. He explained that the flexible budget cost variance was less than $0.8 million. Specifically, he provided the following comparison. $ Cost of planks per table Cost of labor per table Total variable manufacturing cost per table (a) Total number of tables produced (b) Total variable manufacturing cost (a x b) Total fixed manufacturing cost Total manufacturing cost Actual Results $ $ 39.60 28.60 $ 68.20 87,000 $ 5,933, 400 1,218,000 $ 7,151,400 $ Flexible Budget 35.70 25.80 61.50 87,000 5,350,500 1,162,000 6,512,500 $ $ Based on this information, he argued that the relevant variance for performance evaluation was only $638,900 ($7,151,400 $6,512,500). Ms. Darwin responded, Only $638,900! I consider that a very significant number. By the end of the day, I want a full explanation as to what is causing our costs to increase. Required a-1. Based on the following information, determine the total materials cost variance and the price and usage variances. Assuming that the variances are an appropriate indicator of cause. Actual Data Standard Data 22 21 Number of planks per table Price per plank Material cost per table * $ 1.70 x $ 1.80 $ 39.60 $ 35.70 a-2. Based on the following information, determine the total labor cost variance and the price and usage variances. Assuming that the variances are an appropriate indicator of cause. Actual Standard Data Data 2.6 3.0 Number of hours per table Price per hour Labor cost per table * $ 11.00 X $ 8.60 $ 28.60 $ 25.80 a-3. Determine the amount of the fixed cost spending and volume variances. a-3. Determine the amount of the fixed cost spending and volume variances. Complete this question by entering your answers in the tabs below. Req A1 Req A2 Req A3 Based on the following information, determine the total materials cost variance and the price and usage variances. Assuming that the variances are an appropriate indicator of cause. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) Materials variances Total materials cost variance Price variance Usage variance a-3. Determine the amount of the fixed cost spending and volume variances. Complete this question by entering your answers in the tabs below. Req A1 Req A2 Req A3 Based on the following information, determine the total labor cost variance and the price and usage variances. Assuming that the variances are an appropriate indicator of cause. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) Labor variances Total labor cost variance Price variance Usage variance Req A1 Req A3 > a-3. Determine the amount of the fixed cost spending and volume variances. Complete this question by entering your answers in the tabs below. Req A1 Req A2 Req A3 Determine the amount of the fixed cost spending and volume variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) Fixed cost Variances Spending variance Volume variane
