Bandar Industries Berhad of Malaysia manufactures sporting equipment. One of the company's products, a football helmet for the North American market, requires a special plastic. During the quarter ending June 30, the company manufactured 3,800 helmets using 2,584 kllograms of plastic. The plastic cost the company $17,054. According to the standard cost card, each helmet should require 0.59 killograms of plastic, at a cost of $700 per kilogram. Required: 1. What is the standard quantity of kilograms of plastic (SQ) that is allowed to make 3,800 helmets? 2. What is the standard materials cost allowed (SQ x SP) to make 3,800 helmets? 3. What is the materials spending variance? 4. What is the materials price variance and the materials quantity variance? For requirements 3 and 4, Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.., zero variance). Input all amounts as positive values. Do not round intermediate calculations.) Standard quantity of kilograms allowed 2,242 2 Standard cost allowed for actual output 15,694 Materials spending variance Materials price variance Materials quantity variance 3. 1,360 1,034 1 SkyChefs, Inc., prepares in-flight meals for a number of major airlines. One of the company's products is grilled salmon in dill sauce with baby new potatoes and spring vegetables. During the most recent week, the company prepared 3,500 of these meals using 950 direct labor-hours. The company paid its direct labor workers a total of $10,450 for this work, or $11.00 per hour According to the standard cost card for this meal, It should require 0.30 direct labor-hours at a cost of $9.50 per hour Required 1. What is the standard labor-hours allowed (SH) to prepare 3,500 meals? 2. What is the standard labor cost allowed (SH x SR) to prepare 3,500 meals? 3. What is the labor spending variance? 4. What is the labor rate variance and the labor efficiency variance? (For requirements 3 and 4, Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero varlance). Input all amounts as positive values. Do no round Intermedlate calculations.) 1,050 Standard labor-hours allowed 2. Standard labor cost allowed 3. 4 $ 33,250 Labor spending variance Labor rate variance Labor efficiency variance . Basic Variance Analysis and the Impact of Variances on Unit Costs Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Paste AAlignment Number Conditional Format as Cell Cells Editing N B l u., 2. . FormattingTable Styles- Clipboard r Font A1 X f Standards for one of Patterson, Inc.'s products is shown below, along with actual 25 Standard Cost Variance Analysis Direct Materials 26 Standard Quantity Allowed for Actual Output at Standard Price 27 Actual Quantity of Input, at Standard Price 28 Actual Quantity of Input, at Actual Price 29 30 Materials quantity variance 1 Materials price variance 32 33 Standard Cost Variance Analysis-Direct Labor 4 Standard Hours Allowed for Actual Output at Standard Rate 5 Actual Hours of Input, at Standard Rate 6 Actual Hours of Input, at Actual Rate 37 38 Labor efficiency variance 9 Labor rate variance 40 41 Standard Cost Variance Analysis-Variable Manufacturing Overhead 42 Standard Hours Allowed for Actual Output at Standard Rate 43 Actual Hours of Input, at Standard Rate 44 Actual Hours of Input, at Actual Rate 45 46 Variable overhead efficiency variance 47 Variable overhead rate variance 48 ..S Sheet... t - + 100% Attempt(s) . Basic Variance Analysis and the Impact of Variances on Unit Costs Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri , 2.. AAlignment Number Conditional Format as Cell Cells Editing Paste B 1 u . Nu Formatting Table" Styles Clipboard r Font A1 X f Standards for one of Patterson, Inc.'s products is shown below, along with actual 46Variable overhead efficiency variance 7Variable overhead rate variance 48 49 Using formulas,compute the amount of the unit cost difference 0 that is traceable to each of the variances computed above 51 2 Materials: 53 Quantity variance 4 Price variance 55 Labor 56 Efficiency variance 57 Rate variance 58 Variable overhead: 59 Efficiency variance 60 Rate variance 61 62 Excess of actual over standard cost per unit 63 64 ..S Sheet... t - + 10 Attempt(s)
