70.2K

Verified Solution

Link Copied!

i need the yellow boxes and to know if each one is favorable or unfavorable and the last page will come out w/o errors if its right

this was the only data given

For chapter 10, calculate the variable manufacturing cost variances and post the the cells on the manufacturing cost variances using the following actual data: Direct Materials Direct Labor Variable Overhead Total variable cost Inputused Total Cost 220,000 lbs. $ 2,680,000 33,000 hrs. S 1,150,050 33,000 hrs. $ 4.125,000 S 7,955,050 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. Direct Materials Direct Labor Variable Overhead Total variable cost 220,000 lbs. $ 2,680,000 33,000 hrs. $ 1,150,050 33,000 hrs. $ 4,125,000 $ 7,955,050 Favorable or unfavorable (used drop- down menu) Amount of variance Calculate each of the following Direct Materials: Direct Materials Price Variance Direct Materials Quantity Variance Favorable Unfavorable 5 Direct Labor: Direct Labor Rate Variance Direct Labor Efficiency Variance 1 2 Variable Overhead: 8 Variable Overhead Rate Variance 4 Variable Overhead Efficiency Variance -5 Satchmo's Custom Coffee Cups Performance Report Fiscal year, 2020 Flexible Actual Budret 10,000 crates crates $ 8,650,000 $ $ $ $ 7,955,050 $ $ $ 694,950 $ $ $ $ Activity Variances Planning Budret 12,000 crates $ 10,200,000 $ 9,180,000 $ 1.020,000 w - Sales Revenue Ress: Variable Costs Contribution Margin Less: Fixed Costs Fixed Manufacturing Fixed Selling & Administrative Total Fixed Cost Operating Income $ $ S $ $ $ $ 435,000 $ 289,000 $ 724,000 $ (29.050) $ S $ S S $ $ $ 430,000 290,000 720,000 300,000 $ $ Direct Materials Direct Labor Variable Overhead Total variable cost Input used Total Cost 220,000 lbs. $ 2,680,000 33,000 hrs. $ 1,150,050 33,000 hrs. $4,125,000 $ 7/955050 Amount of Favorable or unfavorable (used drop- down menu) LES Favorable norable Calculate each of the following Direct Materials 5 Direct Materials Price Variance 6 Direct Materials Quantity Variance variance 8 Direct Lobar Direct Labor Kate Variance 30 Direct Labor Efficiency Variance 31 82 Variable Overhead 39 Variable Overhead Rate Variance Variable Overhead Efficiency Variance Format Painter Alignment P Font Number Clipboard 8 fx =1FD28-"Flexible Budget - Chp 9'1c39-0,'Manufacturing Cost Variances 'A1 E 8 D Satchmo's Custom Coffee Cups Analysis of Budget to Actual Income Fiscal year, 2020 Budgeted Income for 2020 $ 300,000 Sales Activity Variance $ Flexible Budget Income $ Sales Price Variance $ Direct Materials Variances: Lumber: Direct Materials Price Variance Direct Materials Quantity Variance $ Unfavorable 2 3 Direct Labor Variances: Direct Labor Rate Variance Direct Labor Efficiency Variance $ Unfavorable $ Unfavorable Unfavorable 0 Variable Overhead Variances: 1 Variable Overhead Rate Variance 2 Variable Overhead Efficiency Variance's 3 4 Fixed Cost Variances 5 Fixed Manufacturing $ 26 Fixed Selling & Administrative 27 28 Actual Income for 2020 29 30 31 32 33 34 35 36 32 $ ERROR Direct Materials Direct Labor Variable Overhead Total variable cost Input used 220,000 lbs. S 33,000 hrs. $ 33,000 hrs. $ $ Total Cost 2,680,000 1,150,050 4,125,000 7,955,050 For chapter 10, calculate the variable manufacturing cost variances and post the the cells on the manufacturing cost variances using the following actual data: Direct Materials Direct Labor Variable Overhead Total variable cost Inputused Total Cost 220,000 lbs. $ 2,680,000 33,000 hrs. S 1,150,050 33,000 hrs. $ 4.125,000 S 7,955,050 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. Direct Materials Direct Labor Variable Overhead Total variable cost 220,000 lbs. $ 2,680,000 33,000 hrs. $ 1,150,050 33,000 hrs. $ 4,125,000 $ 7,955,050 Favorable or unfavorable (used drop- down menu) Amount of variance Calculate each of the following Direct Materials: Direct Materials Price Variance Direct Materials Quantity Variance Favorable Unfavorable 5 Direct Labor: Direct Labor Rate Variance Direct Labor Efficiency Variance 1 2 Variable Overhead: 8 Variable Overhead Rate Variance 4 Variable Overhead Efficiency Variance -5 Satchmo's Custom Coffee Cups Performance Report Fiscal year, 2020 Flexible Actual Budret 10,000 crates crates $ 8,650,000 $ $ $ $ 7,955,050 $ $ $ 694,950 $ $ $ $ Activity Variances Planning Budret 12,000 crates $ 10,200,000 $ 9,180,000 $ 1.020,000 w - Sales Revenue Ress: Variable Costs Contribution Margin Less: Fixed Costs Fixed Manufacturing Fixed Selling & Administrative Total Fixed Cost Operating Income $ $ S $ $ $ $ 435,000 $ 289,000 $ 724,000 $ (29.050) $ S $ S S $ $ $ 430,000 290,000 720,000 300,000 $ $ Direct Materials Direct Labor Variable Overhead Total variable cost Input used Total Cost 220,000 lbs. $ 2,680,000 33,000 hrs. $ 1,150,050 33,000 hrs. $4,125,000 $ 7/955050 Amount of Favorable or unfavorable (used drop- down menu) LES Favorable norable Calculate each of the following Direct Materials 5 Direct Materials Price Variance 6 Direct Materials Quantity Variance variance 8 Direct Lobar Direct Labor Kate Variance 30 Direct Labor Efficiency Variance 31 82 Variable Overhead 39 Variable Overhead Rate Variance Variable Overhead Efficiency Variance Format Painter Alignment P Font Number Clipboard 8 fx =1FD28-"Flexible Budget - Chp 9'1c39-0,'Manufacturing Cost Variances 'A1 E 8 D Satchmo's Custom Coffee Cups Analysis of Budget to Actual Income Fiscal year, 2020 Budgeted Income for 2020 $ 300,000 Sales Activity Variance $ Flexible Budget Income $ Sales Price Variance $ Direct Materials Variances: Lumber: Direct Materials Price Variance Direct Materials Quantity Variance $ Unfavorable 2 3 Direct Labor Variances: Direct Labor Rate Variance Direct Labor Efficiency Variance $ Unfavorable $ Unfavorable Unfavorable 0 Variable Overhead Variances: 1 Variable Overhead Rate Variance 2 Variable Overhead Efficiency Variance's 3 4 Fixed Cost Variances 5 Fixed Manufacturing $ 26 Fixed Selling & Administrative 27 28 Actual Income for 2020 29 30 31 32 33 34 35 36 32 $ ERROR Direct Materials Direct Labor Variable Overhead Total variable cost Input used 220,000 lbs. S 33,000 hrs. $ 33,000 hrs. $ $ Total Cost 2,680,000 1,150,050 4,125,000 7,955,050

Answer & Explanation Solved by verified expert

See Answer