the yellow boxes are what i need! thanks
ACCT 211 Spring 2021 On the tab are the following budgeted incomes and actual incomes: Satchmo's Custom Coffee Cups Satchmo's Custom Coffee Cups Sales were Actual income Dalaatta H Had 12.00 0.100.000 5 25.00 fonte Del L.100 h 5 000 West Come on OM $ 0.000 11.000 000 Weed Man FA Tort FM PM Me 720 000 Toh 500 g $ TH 11.30 The budget is based on the following assumptions Satchmo's Custom Coffee Cups But I SM SB N$ Weed w JO On the flexible budget tab, simply fill in the correct sales volume in crates along with the budgeted sales price, variable cost per unit and fixed costs. This will then automatically fill the performance report on the second tab, Manufacturing Cost Variances. I did this for youl) On the manufacturing cost variance tab, calculate the variable manufacturing cost variances and post the values cells on the manufacturing cost variances using the following actual data: Di Maria Tables 220,000 lbs 2.480.000 31.000 5 1,150.00 33,000 $4425.000 $7.855,050 Varble Total variables Use the drop-down menu to indicate whether the given variance is favorable or unfavorable. Go to the last page and the overall variance report will be given. Make sure there isn't an error message B D H Master Budget For 2021 Sales Volume (crates) 12,000 crates Sales Revenue $ 850.00 /crate $ 10,200,000 Less: Variable Costs $ 765.00/crate $ 9,180,000 Contribution Margin $ 1,020,000 Less: Fixed Costs Fixed Manufacturing $ 430,000 Fixed Selling S& Administrative $ 290,000 Total Fixed Cost $ 720,000 Operating Income $ 300,000 Budget Assumptions For 2021 Selling Price $850.00 /C Budgeted Sales 12,000 cral Variable Manufacturing Costs Direct Materials 25 lb/crate $12.00/1b. $ 300.00 / Direct Labor 3 hr/crate $35.00/hr $105.00/cr Variable Overhead 3 hr/crate $120.00/hr $360.00 /cr Variable Manufacturing Cost per Crate $ 765.00/cr Fixed Costs Fixed Manufacturing $430,000 Fixed Selling & Administrative $ 290,000 Satchmo's Custom Coffee Cups Flexible Budget For 2021 Sales Volume (crates) Sales Revenue Less: Variable costs $ Contribution Margin $ 2 Less: Fixed Costs 8 Fixed Manufacturing 4 Fixed Selling & Administrative 5 Total Fixed Cost $ 6 Operating Income 7 8 Satchmo's Custom Coffee Cups 09 Actual income 30 For the year ending December 31, 2021 31 Sales Volume (crates) 10.000 crates 32 Sales Revenue $ 8,650,000 33 Less: Variable Costs 5 7,955,OSO 34 Contribution Margin s 694,950 35 Less: Fixed Costs 36 Fixed Manufacturing 435,000 Performance Report Fiscal year, 2021 Activity Variances Actual 10000 crates S 8,650,000 $ $ 7955,050 $ 694,950 $ Flexible Budget crates $ $ Planning Budget 12,000 crates $ 10,200,000 $ 9,180,000 $ 1,020,000 $ un .. I $ $ Sales Revenue Less: Variable Costs Contribution Margin Less: Fixed Costs 0 Fixed Manufacturing 1 Fixed Selling & Administrative 12 Total Fixed Cost 13 Operating Income 14 s $ $ $ $ 435,000 $ 289,000 $ 724,000 $ (29.050) $ $ $ $ $ $ $ $ S 430,000 290,000 720,000 300,000 . 15 16 Direct Materials 17 Direct Labor 18 Variable Overhead 19 Total variable cost 20 Inputused 220,000 lbs. $ 33,000 hrs. 5 33,000 hrs 5 $ Total Cost 2,680,000 1.150,050 4,125,000 7.955,050 Favorable or unfavorable (used drop down menu Amount of variance 21 22 23 Calculate each of the following 24 Direct Materials 25 Direct Materials Price Variance Direct Materials Quantity Variance 27 28 Direct Labor 29 Direct Labor Rate Variance 30 Direct Labor Efficiency Variance 31 32 Variable Overhead: 33 Variable Overhead Rate Variance Variable Overhead Efficiency Variance 35 ACCT 211 Spring 2021 On the tab are the following budgeted incomes and actual incomes: Satchmo's Custom Coffee Cups Satchmo's Custom Coffee Cups Sales were Actual income Dalaatta H Had 12.00 0.100.000 5 25.00 fonte Del L.100 h 5 000 West Come on OM $ 0.000 11.000 000 Weed Man FA Tort FM PM Me 720 000 Toh 500 g $ TH 11.30 The budget is based on the following assumptions Satchmo's Custom Coffee Cups But I SM SB N$ Weed w JO On the flexible budget tab, simply fill in the correct sales volume in crates along with the budgeted sales price, variable cost per unit and fixed costs. This will then automatically fill the performance report on the second tab, Manufacturing Cost Variances. I did this for youl) On the manufacturing cost variance tab, calculate the variable manufacturing cost variances and post the values cells on the manufacturing cost variances using the following actual data: Di Maria Tables 220,000 lbs 2.480.000 31.000 5 1,150.00 33,000 $4425.000 $7.855,050 Varble Total variables Use the drop-down menu to indicate whether the given variance is favorable or unfavorable. Go to the last page and the overall variance report will be given. Make sure there isn't an error message B D H Master Budget For 2021 Sales Volume (crates) 12,000 crates Sales Revenue $ 850.00 /crate $ 10,200,000 Less: Variable Costs $ 765.00/crate $ 9,180,000 Contribution Margin $ 1,020,000 Less: Fixed Costs Fixed Manufacturing $ 430,000 Fixed Selling S& Administrative $ 290,000 Total Fixed Cost $ 720,000 Operating Income $ 300,000 Budget Assumptions For 2021 Selling Price $850.00 /C Budgeted Sales 12,000 cral Variable Manufacturing Costs Direct Materials 25 lb/crate $12.00/1b. $ 300.00 / Direct Labor 3 hr/crate $35.00/hr $105.00/cr Variable Overhead 3 hr/crate $120.00/hr $360.00 /cr Variable Manufacturing Cost per Crate $ 765.00/cr Fixed Costs Fixed Manufacturing $430,000 Fixed Selling & Administrative $ 290,000 Satchmo's Custom Coffee Cups Flexible Budget For 2021 Sales Volume (crates) Sales Revenue Less: Variable costs $ Contribution Margin $ 2 Less: Fixed Costs 8 Fixed Manufacturing 4 Fixed Selling & Administrative 5 Total Fixed Cost $ 6 Operating Income 7 8 Satchmo's Custom Coffee Cups 09 Actual income 30 For the year ending December 31, 2021 31 Sales Volume (crates) 10.000 crates 32 Sales Revenue $ 8,650,000 33 Less: Variable Costs 5 7,955,OSO 34 Contribution Margin s 694,950 35 Less: Fixed Costs 36 Fixed Manufacturing 435,000 Performance Report Fiscal year, 2021 Activity Variances Actual 10000 crates S 8,650,000 $ $ 7955,050 $ 694,950 $ Flexible Budget crates $ $ Planning Budget 12,000 crates $ 10,200,000 $ 9,180,000 $ 1,020,000 $ un .. I $ $ Sales Revenue Less: Variable Costs Contribution Margin Less: Fixed Costs 0 Fixed Manufacturing 1 Fixed Selling & Administrative 12 Total Fixed Cost 13 Operating Income 14 s $ $ $ $ 435,000 $ 289,000 $ 724,000 $ (29.050) $ $ $ $ $ $ $ $ S 430,000 290,000 720,000 300,000 . 15 16 Direct Materials 17 Direct Labor 18 Variable Overhead 19 Total variable cost 20 Inputused 220,000 lbs. $ 33,000 hrs. 5 33,000 hrs 5 $ Total Cost 2,680,000 1.150,050 4,125,000 7.955,050 Favorable or unfavorable (used drop down menu Amount of variance 21 22 23 Calculate each of the following 24 Direct Materials 25 Direct Materials Price Variance Direct Materials Quantity Variance 27 28 Direct Labor 29 Direct Labor Rate Variance 30 Direct Labor Efficiency Variance 31 32 Variable Overhead: 33 Variable Overhead Rate Variance Variable Overhead Efficiency Variance 35
