Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Please Answer in as much detail as possible, including formula entries, such as (60*80) instead of A9*B9 PROBLEM: Mascot Mfg. makes costumes for athletic team
Please Answer in as much detail as possible, including formula entries, such as (60*80) instead of A9*B9
PROBLEM: Mascot Mfg. makes costumes for athletic team mascots and uses a standard costing system. The company recognizes (isolates) materials price variances at the time the materials are purchased They allocate (apply) OH based on # of DL hours Following are this year's cost and standards data; assumes 52 weeks per year. Standards (for a planned level of production of 2,100 units per month) Direct Materials Yards per costume 12.00 vards 26.50 average Price per yard Direct Labor 60.00 hours 45.00 average D.L. Hours per costume D.L. Rate per hour Variable MOH standard rate per direct labor hour Fixed MOH standard rate per direct labor hour Total Budgeted Fixed MOH (for 1 month) 4.85 per D.L. hour 10.32 per D.L. hour $1,300,000 Actual cost and data from the current month: Actual number of yards of materials purchased Actual cost of materials purchased Actual number of yards used in production Actual number of costumes produced Actual direct labor hours Actual direct labor cost Actual variable MOH (in total) Actual fixed MOH (in total) 28,000 $ 800,000 $ 28.57 per yd 26,350 2,200 134,500 S 5,112,000 $ 673,000 $1,458,000 38.0 per hr Requirement #1: Using Excel functionality, calculate these variances using the templates to the right. 1. Direct material variances 2. Direct labor variances 3. Variable MOH variances 4. Fixed MOH variances PROBLEM: Mascot Mfg. makes costumes for athletic team mascots and uses a standard costing system. The company recognizes (isolates) materials price variances at the time the materials are purchased They allocate (apply) OH based on # of DL hours Following are this year's cost and standards data; assumes 52 weeks per year. Standards (for a planned level of production of 2,100 units per month) Direct Materials Yards per costume 12.00 vards 26.50 average Price per yard Direct Labor 60.00 hours 45.00 average D.L. Hours per costume D.L. Rate per hour Variable MOH standard rate per direct labor hour Fixed MOH standard rate per direct labor hour Total Budgeted Fixed MOH (for 1 month) 4.85 per D.L. hour 10.32 per D.L. hour $1,300,000 Actual cost and data from the current month: Actual number of yards of materials purchased Actual cost of materials purchased Actual number of yards used in production Actual number of costumes produced Actual direct labor hours Actual direct labor cost Actual variable MOH (in total) Actual fixed MOH (in total) 28,000 $ 800,000 $ 28.57 per yd 26,350 2,200 134,500 S 5,112,000 $ 673,000 $1,458,000 38.0 per hr Requirement #1: Using Excel functionality, calculate these variances using the templates to the right. 1. Direct material variances 2. Direct labor variances 3. Variable MOH variances 4. Fixed MOH variancesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started