Are the number I got on the right correct with what I was givin on the left?
5 Real Reply all forward Archive Delete Setting Home DrawPage Layout Towns Date Review Help Vew ct project Tever Botton - 0 x A Home O POCHDWW Draw - Acct 2011 ind Project Layout Form to the watc Protected View.acel Data Review Yew h es you need to edit - ding Standard Conta ferone afer to waited Ver HAIVLETTM CONTRIBUTION MARGIN REPORT FOR THE MONTH ENDED OCTOBER 31, 2019 Flexible Budget Variance Actual Flexible Budget Amount FIU 7 45390 0000 45 300 0000 $ 9 Volume el Product Produced and sold Sales Revenue Direct Materials Conding Letter Beads Colortal Beads Disc Labor Variable Overhead To Costs Contribution Margia 1089900 219 79.4325 27 2340 635450 1112055 272 3400 $ 13 14 15 817020 156 1416 1906380 8.170 2000 220 9500 8 R25 3165 36 564 3684 7 897 8800 2269600 85X280613 35 857 1339 292 7655 292 7655 $ 5 $ 12500000 17 Feed Overhead 18 Faily Rent 19 Eupen Depreciation 20 indirect Labor 21 TowFwd Conta Operating income 2025 0000 14 0000 1 800 0000 3 2.500 0000 140000 800 0000 43140000 3 22503884 $ $ $ $ $ 0 1250000 1677855 32.418 1339 5 F wei ten Marge port DF Due Contribution Margin Report Get your Gral on your phone 816 Select one member of your group and enter the last three digits of that student's KUID Actual Results 4,816 48,160.0000 Master Budget 3.200 32,000.0000 $ No. of Hawklet Bracelets Sold Sales Revenue ($10 per Hawklet Direct Materials Elastic Cording Letter Beads Colorful Beads Direct Labor Variable Overhead ($0.0500 per Hawklet Total Variable Costs Contribution Margin 115 5840 233 0944 84 2800 8,379.8400 240 8000 905359845 39.106.4016 $ $ $ $ $ 576000 110.0800 134.4000 5,760.0000 160.0000 6.222.0800 25,777.9200 $ Fixed Overhead Facility Rent Equipment Depreciation 2,625.0000 14.0000 1,800.0000 4.439.0000 34,667 4016 $ $ $ $ 2,500.0000 14.0000 1.800.0000 4314.0000 21.463.9200 Indirect Labor Total Fixed Costs Operating Income Standard Price Standard Quantity 00018 Standard Costs for one Hawklet are as follows: Elastic Cording (in centimeters) Letter Beads (in beads) Colorful Beads (in beads) Direct Labor (in minutes) 0.0043 0.0035 0.1500 10.0000 8.0000 12.0000 12.0000 Actual Price Total Actual Quantity Records indicate the company purchased and used the following quantities at the following prices Elastic Cording (in centimeters) 0.0015 77,056.0000 Letter Beads (in beads) 0.0044 52,976.0000 Colorful Beads (in beads) 0.0025 33,712.0000 Direct Labor (in minutes) 0.1582 52,976 0000 ACCT 201 INDUSTRIES, INC HAWKLET" CONTRIBUTION MARGIN REPORT FOR THE MONTH ENDED OCTOBER 31, 2019 Formulas in the ribbon and then select Show Actual Flexible Budget Flexible Budget Variance Amount FIU HINTS Never doc tions on a calator and then the work for you using forms! All of the BLUE boxes should be a formula 4816 48, 160 0000 4.816 48,160.0000 $ $ Remember, to be able to copy a formula to the next row, but keep the right variable cost, use the storeference the color ample $D$5 always refer to row 5, but the column wil change depending on where the formula is 115.58405 233 0944 84 2800 8 379 8400 240 8000 90585034 39106 4016 86 6880 165.6704 200 2720 8.868 8000 240 000 9.364 23045 3.796 7896 $ 5 $ $ $ Actual Volume of Product Produced and Sold Sales Revenue Direct Materials Elastic Cording Letter Beads Colorful Beads Direct Labor Variable Overhead Total Variable costs Contribution Margin Fixed Overhead Facility Rent Equipment Depreciation Indirect Labor Total Food Costs Operating Income 28 8960 67 4240 1179920 288 000 HINT: Use the Ans function when calculating the variance to returna 18 $ $ $ 3106320 310 6320 $ HINTI Challenge you to use the IF function with formato determine whether a variance is favorable or unfavorabil 18 1250000 2,625.0000 14.0000 1 800 0000 4,439 0000 34,667.4016 $ $ $ $ $ 2,500 0000 140000 18000000 43140000 34.481 7696 $ $ $ $ HINT: Remember, you are dealing with ever ncome, and ACTUAL is larger than the PLEXIBLE xe, that's good favole. you are analyzing cost, and actual is larger than the fede bude that's bad or unfavorable 1250000 22 $ 185 6320 5 Real Reply all forward Archive Delete Setting Home DrawPage Layout Towns Date Review Help Vew ct project Tever Botton - 0 x A Home O POCHDWW Draw - Acct 2011 ind Project Layout Form to the watc Protected View.acel Data Review Yew h es you need to edit - ding Standard Conta ferone afer to waited Ver HAIVLETTM CONTRIBUTION MARGIN REPORT FOR THE MONTH ENDED OCTOBER 31, 2019 Flexible Budget Variance Actual Flexible Budget Amount FIU 7 45390 0000 45 300 0000 $ 9 Volume el Product Produced and sold Sales Revenue Direct Materials Conding Letter Beads Colortal Beads Disc Labor Variable Overhead To Costs Contribution Margia 1089900 219 79.4325 27 2340 635450 1112055 272 3400 $ 13 14 15 817020 156 1416 1906380 8.170 2000 220 9500 8 R25 3165 36 564 3684 7 897 8800 2269600 85X280613 35 857 1339 292 7655 292 7655 $ 5 $ 12500000 17 Feed Overhead 18 Faily Rent 19 Eupen Depreciation 20 indirect Labor 21 TowFwd Conta Operating income 2025 0000 14 0000 1 800 0000 3 2.500 0000 140000 800 0000 43140000 3 22503884 $ $ $ $ $ 0 1250000 1677855 32.418 1339 5 F wei ten Marge port DF Due Contribution Margin Report Get your Gral on your phone 816 Select one member of your group and enter the last three digits of that student's KUID Actual Results 4,816 48,160.0000 Master Budget 3.200 32,000.0000 $ No. of Hawklet Bracelets Sold Sales Revenue ($10 per Hawklet Direct Materials Elastic Cording Letter Beads Colorful Beads Direct Labor Variable Overhead ($0.0500 per Hawklet Total Variable Costs Contribution Margin 115 5840 233 0944 84 2800 8,379.8400 240 8000 905359845 39.106.4016 $ $ $ $ $ 576000 110.0800 134.4000 5,760.0000 160.0000 6.222.0800 25,777.9200 $ Fixed Overhead Facility Rent Equipment Depreciation 2,625.0000 14.0000 1,800.0000 4.439.0000 34,667 4016 $ $ $ $ 2,500.0000 14.0000 1.800.0000 4314.0000 21.463.9200 Indirect Labor Total Fixed Costs Operating Income Standard Price Standard Quantity 00018 Standard Costs for one Hawklet are as follows: Elastic Cording (in centimeters) Letter Beads (in beads) Colorful Beads (in beads) Direct Labor (in minutes) 0.0043 0.0035 0.1500 10.0000 8.0000 12.0000 12.0000 Actual Price Total Actual Quantity Records indicate the company purchased and used the following quantities at the following prices Elastic Cording (in centimeters) 0.0015 77,056.0000 Letter Beads (in beads) 0.0044 52,976.0000 Colorful Beads (in beads) 0.0025 33,712.0000 Direct Labor (in minutes) 0.1582 52,976 0000 ACCT 201 INDUSTRIES, INC HAWKLET" CONTRIBUTION MARGIN REPORT FOR THE MONTH ENDED OCTOBER 31, 2019 Formulas in the ribbon and then select Show Actual Flexible Budget Flexible Budget Variance Amount FIU HINTS Never doc tions on a calator and then the work for you using forms! All of the BLUE boxes should be a formula 4816 48, 160 0000 4.816 48,160.0000 $ $ Remember, to be able to copy a formula to the next row, but keep the right variable cost, use the storeference the color ample $D$5 always refer to row 5, but the column wil change depending on where the formula is 115.58405 233 0944 84 2800 8 379 8400 240 8000 90585034 39106 4016 86 6880 165.6704 200 2720 8.868 8000 240 000 9.364 23045 3.796 7896 $ 5 $ $ $ Actual Volume of Product Produced and Sold Sales Revenue Direct Materials Elastic Cording Letter Beads Colorful Beads Direct Labor Variable Overhead Total Variable costs Contribution Margin Fixed Overhead Facility Rent Equipment Depreciation Indirect Labor Total Food Costs Operating Income 28 8960 67 4240 1179920 288 000 HINT: Use the Ans function when calculating the variance to returna 18 $ $ $ 3106320 310 6320 $ HINTI Challenge you to use the IF function with formato determine whether a variance is favorable or unfavorabil 18 1250000 2,625.0000 14.0000 1 800 0000 4,439 0000 34,667.4016 $ $ $ $ $ 2,500 0000 140000 18000000 43140000 34.481 7696 $ $ $ $ HINT: Remember, you are dealing with ever ncome, and ACTUAL is larger than the PLEXIBLE xe, that's good favole. you are analyzing cost, and actual is larger than the fede bude that's bad or unfavorable 1250000 22 $ 185 6320