Chapter 8 - At the end of the chapter do these excel homework

08-18a / 08-23a / 08-27a

Student Name: Class: Problem 08-18A KASIMER COMPUTER SERVICES Standard Costs Per Hour Services revenue Variable costs: Labor cost Overhead cost Selling, general, & administrative cost Contribution margin Fixed costs: Repair facility Selling, general & administrative Net income d. Evaluation a. Master Budget b. Flexible Budget c. Flexible Budget Per Hr. Per Hr. Per Hr. Hours Hours Hours Given Data P08-18A: KASIMER COMPUTER SERVICES Standard rate and variable costs Service rate per hour Labor cost Overhead cost General, selling, and admin. cost Expected fixed costs: Facility maintenance Selling, general and administrative Part a. Expected hours of repair services Part b. Hourly charge Hours of repair services Part c. Hourly charge Hours of repair services $ 75.00 40.00 7.20 4.30 $ 400,000 150,000 30,000 $ 70 38,000 $ 80 25,000 Student Name: Class: Problem 08-23A KERSTEN CORPORATION a. Materials Variance Information Table Standard price per pound Actual price per pound Standard quantity for flexible budget (pounds) Actual quantity used (pounds) b. Materials price variance: Materials usage variance: c. Labor Variance Information Table Standard price per hour Actual price per hour Standard hours for flexible budget (hours) Actual hours used (hours) d. Labor price variance: Labor usage variance: e. Predetermined overhead rate: f. Overhead spending variance: g. Overhead volume variance: Given Data P08-23A: KERSTEN CORPORATION Planned unit volume for year (static budget) Standard direct materials cost per unit: Number of pounds Price per pound Standard direct labor cost per unit: Number of hours Price per hour Total expected fixed overhead costs Actual volume for year (flexible budget) Actual direct materials cost per unit: Number of pounds Price per pound Actual direct labor cost per unit: Number of hours Price per hour Total actual fixed overhead costs 6,000 $ 3.1 1.50 $ $ 2.0 4.00 28,200 6,300 $ 2.7 2.00 $ $ 2.3 3.60 22,500 Student Name: Class: Problem 08-27A REEVES COMPANY a. Standard Costs Direct Material Direct Labor Overhead b. Total Standard Cost for One Candle: c. Actual Costs Direct Material Direct Labor Overhead d. Total Actual Cost for One Candle: e. Direct Material and Direct Labor Variances: Direct Material: Price Variance Usage Variance Direct Labor: Price Variance Usage Variance f. Fixed Overhead Spending and Volume Variances: Spending Variance Volume Variance Given Data P08-27A: REEVES COMPANY Amount of direct material per candle (pounds) Price of direct materials per pound Quantity of labor per unit (hours) Price of direct labor per hour Total budgeted fixed overhead Expected quantity to be produced Actual quantity produced Actual direct materials used (pounds) Actual price of direct material per pound Actual direct labor cost per hour Actual labor hours worked Actual overhead $ $ $ $ $ $ 1.6 1.20 1 16.00 312,000 30,000 24,000 40,000 1.08 15.00 26,400 264,000