You shed procel to the roquirements below oly after conpletag yout sorksheet The Excel wurksheet form that appears below is to be uned to recreate part of the example retuiar Crafters that appears calier in the chuapter. Download the workbook containing this form fre where you will also coceive instructiom about how to use this worksheet form. Chapte 1 Appilying Excel 3Date 4 Alacation be S itiated manuactuning overhead cost Eatimated utal amout dthe alocation base 7 Acal mandating nehead cest Actul tal ut of the alocation tase Machine-hours Ss00,000 75,000 machinehours $20,000 68.000 machine houn anof the oe matadthelo 11Compton f the predtermined overhead rate tomtedntnuring overtead cost MSt0maauo Emet o't Prettenen ection hooe machihoun loverte frate wen dnderappled or everapplied mandlacturieg verhead Aa arng ovetead cot S Meu 30 cost pled to Wk Process ug te year ocation bape verhead applied ver uring overh Pew Jo Orter Contng Cou u nd bma poing Required L Chock your wksbee by tungng the o d oe hee the Dua Odine-hours. kopng of the der des the ie eigin eanie yo wrksbeet i oering peperly the pre mied u r od e1.00 pr mad bour If yo dsot got es fd the eon your rtndometm Hom much he sleatiod onpliod ndtrng oted? D ta Wy why not? 1 Denermine the aderpplied toerepli manstatg ett rades e kwing da Alocaton bae... Estimated mautactuing ovehrad co Emtd l amout of the aloction bee Actual manufacturing overead tost Actual total amount of the alocation base Machene heus $100 000 so.000 wechineheus $90.000 40.000 meinetiun 3 What happem the underpplied tonorledufaing etdnp e nd sotal amot of the allocation hae is chungode 0 e-bon and eyhing de e he same? Why is the ment of underapplind toveraytiedi nastating mehal dtine bon pat (2 4 Change the estinuted total anout of the allocation bust hako S0 chie-oun t he data kok eacrly like they did in purt (2 Now chane the actd maniliering metad cot 5100.000. What is the undenpplied (overapplicit mnufaring meeal nowWhy de ace of underupplied (overappliodi manulacturing overhead dirree bo part a ill Sprint ? 9:06 AM e O 70% Done 8 of 9 ring Ch the a Phomed M oursnONS idtd el ikin Pces t What d teetal given d dhe shnde of th ig helef ato oalpod pun Chen the danghae ing tem APPLYING EXCEL aconnect The ta i lmte punof the eante Catn hat an miet leear e tk oing w i abth Las- h waksheet m BenllCp wind g t 1. @ O 70% 9:07 AM l Sprint ? 9 of 9 Done 123 as whes the Ao Wo Job-Order Conting Cost Fuws end External Reporting work befe Required: I. Check your worksheet by changing the onimatod total amount of the ullocution huse in the Data arca to 6000 nachine-hours, koeping all of the other data the sanme as in the original example. If your worksheet is operating properly, the predrtermined overhend rote shouid now bo N5.00 per machine- bour. If you di not get this anwer. find the errors in your worksheet and correct thern How much is the underapplied (overapplied) manufacturing overtvrad? Did it change? Why ur why not? 2 Deternine the underapplied (overapplied) manufacturing overhead for a diflerent compary wikh the Kollowing data: ale of con expect giod? Machine hours $ 100 000 50.000 mechine hours Allocation base Estimated manufacturing overhead cos.... Estimntud total amount of the allocntion base Actual manufacturing overhead cost Actual total amount of the allocation base $90.000 40,000 mechine-tours ese 3. What happens to the underapplied (overapplied) anufacaring uverhead froon purt (2) if the estinacd total amount of the allocation base is changod to 40,000 achine bours and everything elie remai part (2)? the same? Why is the amount 4. Change the estimated total amount of the allocation buse hack to S0,000 nachinr-bours n that the data look exactly like they did in part (2) Now change the actunl mamalacturiag nertead cost to S100,000. What is the undenpplied (overapplied) manufactaring overtsead now Why is the amount of underapplied (overapplied) manufacturing ovechoond different ons part (2? What underapplied (uverappliedi munufacturing erhead diferers frora You shed procel to the roquirements below oly after conpletag yout sorksheet The Excel wurksheet form that appears below is to be uned to recreate part of the example retuiar Crafters that appears calier in the chuapter. Download the workbook containing this form fre where you will also coceive instructiom about how to use this worksheet form. Chapte 1 Appilying Excel 3Date 4 Alacation be S itiated manuactuning overhead cost Eatimated utal amout dthe alocation base 7 Acal mandating nehead cest Actul tal ut of the alocation tase Machine-hours Ss00,000 75,000 machinehours $20,000 68.000 machine houn anof the oe matadthelo 11Compton f the predtermined overhead rate tomtedntnuring overtead cost MSt0maauo Emet o't Prettenen ection hooe machihoun loverte frate wen dnderappled or everapplied mandlacturieg verhead Aa arng ovetead cot S Meu 30 cost pled to Wk Process ug te year ocation bape verhead applied ver uring overh Pew Jo Orter Contng Cou u nd bma poing Required L Chock your wksbee by tungng the o d oe hee the Dua Odine-hours. kopng of the der des the ie eigin eanie yo wrksbeet i oering peperly the pre mied u r od e1.00 pr mad bour If yo dsot got es fd the eon your rtndometm Hom much he sleatiod onpliod ndtrng oted? D ta Wy why not? 1 Denermine the aderpplied toerepli manstatg ett rades e kwing da Alocaton bae... Estimated mautactuing ovehrad co Emtd l amout of the aloction bee Actual manufacturing overead tost Actual total amount of the alocation base Machene heus $100 000 so.000 wechineheus $90.000 40.000 meinetiun 3 What happem the underpplied tonorledufaing etdnp e nd sotal amot of the allocation hae is chungode 0 e-bon and eyhing de e he same? Why is the ment of underapplind toveraytiedi nastating mehal dtine bon pat (2 4 Change the estinuted total anout of the allocation bust hako S0 chie-oun t he data kok eacrly like they did in purt (2 Now chane the actd maniliering metad cot 5100.000. What is the undenpplied (overapplicit mnufaring meeal nowWhy de ace of underupplied (overappliodi manulacturing overhead dirree bo part a ill Sprint ? 9:06 AM e O 70% Done 8 of 9 ring Ch the a Phomed M oursnONS idtd el ikin Pces t What d teetal given d dhe shnde of th ig helef ato oalpod pun Chen the danghae ing tem APPLYING EXCEL aconnect The ta i lmte punof the eante Catn hat an miet leear e tk oing w i abth Las- h waksheet m BenllCp wind g t 1. @ O 70% 9:07 AM l Sprint ? 9 of 9 Done 123 as whes the Ao Wo Job-Order Conting Cost Fuws end External Reporting work befe Required: I. Check your worksheet by changing the onimatod total amount of the ullocution huse in the Data arca to 6000 nachine-hours, koeping all of the other data the sanme as in the original example. If your worksheet is operating properly, the predrtermined overhend rote shouid now bo N5.00 per machine- bour. If you di not get this anwer. find the errors in your worksheet and correct thern How much is the underapplied (overapplied) manufacturing overtvrad? Did it change? Why ur why not? 2 Deternine the underapplied (overapplied) manufacturing overhead for a diflerent compary wikh the Kollowing data: ale of con expect giod? Machine hours $ 100 000 50.000 mechine hours Allocation base Estimated manufacturing overhead cos.... Estimntud total amount of the allocntion base Actual manufacturing overhead cost Actual total amount of the allocation base $90.000 40,000 mechine-tours ese 3. What happens to the underapplied (overapplied) anufacaring uverhead froon purt (2) if the estinacd total amount of the allocation base is changod to 40,000 achine bours and everything elie remai part (2)? the same? Why is the amount 4. Change the estimated total amount of the allocation buse hack to S0,000 nachinr-bours n that the data look exactly like they did in part (2) Now change the actunl mamalacturiag nertead cost to S100,000. What is the undenpplied (overapplied) manufactaring overtsead now Why is the amount of underapplied (overapplied) manufacturing ovechoond different ons part (2? What underapplied (uverappliedi munufacturing erhead diferers frora You shed procel to the roquirements below oly after conpletag yout sorksheet The Excel wurksheet form that appears below is to be uned to recreate part of the example retuiar Crafters that appears calier in the chuapter. Download the workbook containing this form fre where you will also coceive instructiom about how to use this worksheet form. Chapte 1 Appilying Excel 3Date 4 Alacation be S itiated manuactuning overhead cost Eatimated utal amout dthe alocation base 7 Acal mandating nehead cest Actul tal ut of the alocation tase Machine-hours Ss00,000 75,000 machinehours $20,000 68.000 machine houn anof the oe matadthelo 11Compton f the predtermined overhead rate tomtedntnuring overtead cost MSt0maauo Emet o't Prettenen ection hooe machihoun loverte frate wen dnderappled or everapplied mandlacturieg verhead Aa arng ovetead cot S Meu 30 cost pled to Wk Process ug te year ocation bape verhead applied ver uring overh Pew Jo Orter Contng Cou u nd bma poing Required L Chock your wksbee by tungng the o d oe hee the Dua Odine-hours. kopng of the der des the ie eigin eanie yo wrksbeet i oering peperly the pre mied u r od e1.00 pr mad bour If yo dsot got es fd the eon your rtndometm Hom much he sleatiod onpliod ndtrng oted? D ta Wy why not? 1 Denermine the aderpplied toerepli manstatg ett rades e kwing da Alocaton bae... Estimated mautactuing ovehrad co Emtd l amout of the aloction bee Actual manufacturing overead tost Actual total amount of the alocation base Machene heus $100 000 so.000 wechineheus $90.000 40.000 meinetiun 3 What happem the underpplied tonorledufaing etdnp e nd sotal amot of the allocation hae is chungode 0 e-bon and eyhing de e he same? Why is the ment of underapplind toveraytiedi nastating mehal dtine bon pat (2 4 Change the estinuted total anout of the allocation bust hako S0 chie-oun t he data kok eacrly like they did in purt (2 Now chane the actd maniliering metad cot 5100.000. What is the undenpplied (overapplicit mnufaring meeal nowWhy de ace of underupplied (overappliodi manulacturing overhead dirree bo part a ill Sprint ? 9:06 AM e O 70% Done 8 of 9 ring Ch the a Phomed M oursnONS idtd el ikin Pces t What d teetal given d dhe shnde of th ig helef ato oalpod pun Chen the danghae ing tem APPLYING EXCEL aconnect The ta i lmte punof the eante Catn hat an miet leear e tk oing w i abth Las- h waksheet m BenllCp wind g t 1. @ O 70% 9:07 AM l Sprint ? 9 of 9 Done 123 as whes the Ao Wo Job-Order Conting Cost Fuws end External Reporting work befe Required: I. Check your worksheet by changing the onimatod total amount of the ullocution huse in the Data arca to 6000 nachine-hours, koeping all of the other data the sanme as in the original example. If your worksheet is operating properly, the predrtermined overhend rote shouid now bo N5.00 per machine- bour. If you di not get this anwer. find the errors in your worksheet and correct thern How much is the underapplied (overapplied) manufacturing overtvrad? Did it change? Why ur why not? 2 Deternine the underapplied (overapplied) manufacturing overhead for a diflerent compary wikh the Kollowing data: ale of con expect giod? Machine hours $ 100 000 50.000 mechine hours Allocation base Estimated manufacturing overhead cos.... Estimntud total amount of the allocntion base Actual manufacturing overhead cost Actual total amount of the allocation base $90.000 40,000 mechine-tours ese 3. What happens to the underapplied (overapplied) anufacaring uverhead froon purt (2) if the estinacd total amount of the allocation base is changod to 40,000 achine bours and everything elie remai part (2)? the same? Why is the amount 4. Change the estimated total amount of the allocation buse hack to S0,000 nachinr-bours n that the data look exactly like they did in part (2) Now change the actunl mamalacturiag nertead cost to S100,000. What is the undenpplied (overapplied) manufactaring overtsead now Why is the amount of underapplied (overapplied) manufacturing ovechoond different ons part (2? What underapplied (uverappliedi munufacturing erhead diferers frora