File Heme Incert Design eynir References Mailings Rexir Help Tell me what you want to do Share Times New 14 AAA- BIU.XX' A n Paste Found Painter cipar AaBcc AaBbc ABC ABCd Aabbccc AaB AaBbcc dbcc Adbcc daca ABSCCL A BECC AABBOC AaBbcci AaBCcI Emphasis Heading Subtitle I No Sox 5.b Em. Intense ntense. Subtle Rel.. Intense Re. Book Tile List Par.. Find Replace Slut- 1 Normal Strong Title Quote Font Praqah Tatting CC-330 Fall 2020 Case Assignment - in 2 Parts Part I is worth 5% and Part II is worth 10% towards your final grade (a total of 15%). Points will be awarded for content of your spreadsheet, and quality and presentation of the escel model. See Canvas for the grading template that will be used to grade the case. Submit one electronic copy of your spreadsheet per group via Canvas 4. Budget information assembled at the start of 2019 Entry-level Bars Pro-sertes Bats Bodited producto 30.000 10,000 20.00 . Number of bats per batch Shoes ber Sehuplahe experih sho Fustaflumber per het Direct leverer hurt 1 h 2 Manufacturing Operations Overhead Cart Visbil ta Supplies $25,000 Indirect auf Labor 30.000 Power 21,000 Mentorice 83,000 21LADA Fused costs Deprem 35.000 Supervision 100.000 Power 82.000 Menu 60,000 $2000 Submission dates: Part I Friday, October 16 Part 2 Friday, November 20 Case information Beginning of the year: January 1, 2020 Machine Setup Ohuruad Core Variable costs Supplies Induretat. Labo Per Fixed met Deprimin Swastian Powe 80,000 60.000 $150000 75 000 25,000 40,000 $140.000 The "Good Crack" Company (GCC) Inc., a baseball predras matter, recently hired you as a DIY usulat inila Baldiv. GCC'. But divus products producta, akd but made of Nuclen White Aus and 'pro-' tu made of Rock Murple wood. The ecdaction proces ima tusing the wood (baka) and then aning and finishing work to complete eachbal The level tat comes in a standard size weight and finis. The pro-seriestat requires additional attention to procurement, quality control, and sanding and fishing wo Ihe po-series bar is sold to professional players, who was the reduction facilities to discuss technice details such as wehr balance and personalization Thermocore line of hate was rently introduced and chemicelling as many of the predras it can grotere Further expansion of in proceries hurt is planned herser, grestertion personnel are not too imati berst this because of the manufacturing demands placed on then by this sddional product In zapca tu denuncia Lincte elevi wating informace your pardued un AEC ayalazu. Two be production activities, acuting operations and machte setups, were identified Production costs reined to these actavities are now 2siped to the two lives of bats based on the cost anvers of direct matue.cturing labor and stop labor hours, respectively. The old protect costice system allocated all manufacturing awed hard en direct mastering later hour. Yoxer predecercand for more to ARC prestration rate for the preprihat thing to stay and allocating water cet bourdon cetep labor hom beter en ECR conmed hy the that link. The hot die growing in complessity and part of your job at me ad explain the store duced costing informatica awala waed within the davisi You feal task is to zeview la bat disaine's day coating and budging inuice. Tu yua dimsay you are 1534 that the demision's records are industry and the 2020 budget bassot been compiled Since you are sort on time, you decide to use the informatiu tom de last years (2014) records to do nitial exation of the dist. These records aclude soate tradget estinates assembled before de start of 2019 and actual information for 2010 fo R. Actual information for 2019 that can be red directly to each product Entry-level Bass Pro-serics Bac 51,030,000 Duectural DM Uved $266,000 Foct of labai per but beca) Sect Lambeci (12/312019) 40,000 feet 10,000 feet Direct labor cost $$49,90 $450,000 Direct labor hours per Bat 11 hour 2.4 hours Number of laats per latch 100 Number of batches 515 475 Setuplale kes per la trh 3 Secup obor Love) 2,35 3,100 Total sales como $240,000 595,000 Laita produced 51,500 9,300 Units and 08000 Bats inimene (11/2019 2,000 $2.11ac Salat net $1,282,500 52.832.000 Page 1 of 210 w 13 Type here to search Ht 107 10:55 AM 10/13/2000 O File Home Help Till me what you want to do Share Paste For Primer Clipboard Design Layout References Mailings Review Times New Ro 14 ANA BIUX, * AMA = = = = = Font 5 Paragraph l d cci AABBCC AABBC Emphasis Heading I Normal Subtitle Title 1 No Spac. S.buc Em.. Worse.. Cuote Intense O.. Subte Rel. interse Re.. Book Title List Par.. Fird Replace Select- Shyles Editing C. Additionally, the Bar division had the following actual costs in 2019 that SIX not directly read to her product: Actual Matering wheed Costo 2010 Month Direct Ish-Hours Cat Setup-Haus Cout Jan 5,472 3. 34.755 $21.95 Fab 5.022 31.05 $21.959 5,422 $ 34276 400 $22.424 6,573 Day 7,054 $10.783 -167 524.82 9,231 $44.99 499 9,753 $_49.785 us 8.744 $ 51 265 640 S 33.667 7,320 820 5.31893 5,311 725 5.4.131 Nov 4,977 $42.286 9.20.404 Das 4,571 $_35.745 697 $ 32.000 Tets 79,450 5497 000 6375 $365.000 Tause we locativen Cursu lecturing the direct facturing lubos- band setup labee her Direct manufacturing labur bersin the elder for the variable portion of manufacturing operata riced. Direct redacturing laboc-bours is als used to allocate de Exed portios of mulettisg operation verband Setup lahor horas is the cost deiner for the cable portion of machine seteperered. Setop laber hours is also need to allocate the tixed portion of machine setoporreres. Projected sale for the entry level 52,000 in 2030, 51000 in 2021, and 48000 in 2012 Projectat tale for the price 10.1002020 11.000 in 2021 and 12000 in 20 Sulcus marit i paid to take a bold. 2020 input cost and coachty standards for direct materials, durect sufacturing lahor 203 manufacturing and are the max 2020 adested input mets and quantita You require sending investory of estryJevel Bus of 20% of axtyce's total sole seeda. Procica Lala wake wote way of Binatagooda ia luned. You require an ending catenal miestory of Sotnest year's production needs (or both product line) WIP isley ALFLFO cost flow You beginning cash balances $125,000 for 2020. The company requires 2 cash balance of $100,000 29 990 Actus Period Coats - 2019 vertising expert ,14=lin $240,000 210,000 35,000 Scaling administrati dispecialis D. Based on the information you have gathered you also muke the following Symptions: Rex nf permitentia in the division all expERE the guidin ench No ale made cn (all sales are achi Information for the 2020 budget is as follows: The waited unist nput quantities for matenais med in 2019 will also be used in 2020 bodget. 0 For the entry-level but the pointed it us questetics for labo od MOH (Grect miracturing taber hours and machine setup Taher hersed in 2019 wilt sto be wat in the 2030 budget o For the proceries bar the word tegut quantity or direct matig aber will be 24 hoursuimit. The bodigd unit inpur: quantity for stop labor hours and in 2019 will ales he und in the 2020 badge O Tae cet of Add Muleur budgeted to increase by 10% 2020 2019 al costa. Bulgte labestuta a 2020 e aspettol tonercard by 360. zballen i 2012. Calculate 2020 budgeld viable manutes and total Exaduk Cem 2019 utul malbiy cost and activity driz. Use Regression Analysis to determine estimates for variable and monthly Exed costa. Convermouthly estimates fixed costs into cual costa o Ascend MOE de motores changed from budgeted 2019 data. o Production and sales tocca are within de relevantrance o Bodgeted Tuble period costs want and final costs in total for 2020 are somed to be the same as ara period 2019 O A 31 screase in selling price for 2020 is expected for both due catry-level and the pro-series Requirements Requencests for the two parts of the case are listed below. Bester swers will clearly present modus fer ratenlations Presenting calendations in the management can inderstand that is important. The taxlity of your prendere will be de-create a model that can be marily opened and modified by twing appropriate formats and referencing See Canvas for model design tips Requirements for Part 1 - due Friday, October 16 Accuela Normal Coating, CVP is, deli-Bead Coating 1. What were the budgeted indirect cost rates for the manusctocicg operaticas activity and the machine Setup activity 2019 2. We verhoed of indeplied for the yarny how much 3. What was the unit product cat for the entry level and procerie Batsende mama casting! 4. What was the Bat Disco's operating income for 2019 Useronnal costing and adutformi yland Mo. 3. te the 2019 actualmenthly MOH information to calcula estimate of coat babai (fied od vrable courses for each BOH activity. These esticates will be used for the 2020 budget Use the Regresa action Cound der Date Duracelyi Excel. Place outlet one spurte about 6. For Setup Operatiu aled actively, evaluate the local cut hiva und mit toll altercatre of Durect Labbe Hours as the cost Garver. Refer to bit 10-18.1.4. nua a regression for DLHO 2 e cost dever for Setop Operasious city and compare the results ong to the citer in Ex 10-13. 7. Calculate the break-even point in uses (calculate te nuber of baccach product required, and the sucher oturts of both protects that must be sold to earn an operating income at $150,000. Use 20:20 bodgeted to be reber to section toDet post 2 and you results to requirement 3. o Page 17140 words Type here to search 0 AB 10:55 AM 10/13/2020 File Heme Incert Design eynir References Mailings Rexir Help Tell me what you want to do Share Times New 14 AAA- BIU.XX' A n Paste Found Painter cipar AaBcc AaBbc ABC ABCd Aabbccc AaB AaBbcc dbcc Adbcc daca ABSCCL A BECC AABBOC AaBbcci AaBCcI Emphasis Heading Subtitle I No Sox 5.b Em. Intense ntense. Subtle Rel.. Intense Re. Book Tile List Par.. Find Replace Slut- 1 Normal Strong Title Quote Font Praqah Tatting CC-330 Fall 2020 Case Assignment - in 2 Parts Part I is worth 5% and Part II is worth 10% towards your final grade (a total of 15%). Points will be awarded for content of your spreadsheet, and quality and presentation of the escel model. See Canvas for the grading template that will be used to grade the case. Submit one electronic copy of your spreadsheet per group via Canvas 4. Budget information assembled at the start of 2019 Entry-level Bars Pro-sertes Bats Bodited producto 30.000 10,000 20.00 . Number of bats per batch Shoes ber Sehuplahe experih sho Fustaflumber per het Direct leverer hurt 1 h 2 Manufacturing Operations Overhead Cart Visbil ta Supplies $25,000 Indirect auf Labor 30.000 Power 21,000 Mentorice 83,000 21LADA Fused costs Deprem 35.000 Supervision 100.000 Power 82.000 Menu 60,000 $2000 Submission dates: Part I Friday, October 16 Part 2 Friday, November 20 Case information Beginning of the year: January 1, 2020 Machine Setup Ohuruad Core Variable costs Supplies Induretat. Labo Per Fixed met Deprimin Swastian Powe 80,000 60.000 $150000 75 000 25,000 40,000 $140.000 The "Good Crack" Company (GCC) Inc., a baseball predras matter, recently hired you as a DIY usulat inila Baldiv. GCC'. But divus products producta, akd but made of Nuclen White Aus and 'pro-' tu made of Rock Murple wood. The ecdaction proces ima tusing the wood (baka) and then aning and finishing work to complete eachbal The level tat comes in a standard size weight and finis. The pro-seriestat requires additional attention to procurement, quality control, and sanding and fishing wo Ihe po-series bar is sold to professional players, who was the reduction facilities to discuss technice details such as wehr balance and personalization Thermocore line of hate was rently introduced and chemicelling as many of the predras it can grotere Further expansion of in proceries hurt is planned herser, grestertion personnel are not too imati berst this because of the manufacturing demands placed on then by this sddional product In zapca tu denuncia Lincte elevi wating informace your pardued un AEC ayalazu. Two be production activities, acuting operations and machte setups, were identified Production costs reined to these actavities are now 2siped to the two lives of bats based on the cost anvers of direct matue.cturing labor and stop labor hours, respectively. The old protect costice system allocated all manufacturing awed hard en direct mastering later hour. Yoxer predecercand for more to ARC prestration rate for the preprihat thing to stay and allocating water cet bourdon cetep labor hom beter en ECR conmed hy the that link. The hot die growing in complessity and part of your job at me ad explain the store duced costing informatica awala waed within the davisi You feal task is to zeview la bat disaine's day coating and budging inuice. Tu yua dimsay you are 1534 that the demision's records are industry and the 2020 budget bassot been compiled Since you are sort on time, you decide to use the informatiu tom de last years (2014) records to do nitial exation of the dist. These records aclude soate tradget estinates assembled before de start of 2019 and actual information for 2010 fo R. Actual information for 2019 that can be red directly to each product Entry-level Bass Pro-serics Bac 51,030,000 Duectural DM Uved $266,000 Foct of labai per but beca) Sect Lambeci (12/312019) 40,000 feet 10,000 feet Direct labor cost $$49,90 $450,000 Direct labor hours per Bat 11 hour 2.4 hours Number of laats per latch 100 Number of batches 515 475 Setuplale kes per la trh 3 Secup obor Love) 2,35 3,100 Total sales como $240,000 595,000 Laita produced 51,500 9,300 Units and 08000 Bats inimene (11/2019 2,000 $2.11ac Salat net $1,282,500 52.832.000 Page 1 of 210 w 13 Type here to search Ht 107 10:55 AM 10/13/2000 O File Home Help Till me what you want to do Share Paste For Primer Clipboard Design Layout References Mailings Review Times New Ro 14 ANA BIUX, * AMA = = = = = Font 5 Paragraph l d cci AABBCC AABBC Emphasis Heading I Normal Subtitle Title 1 No Spac. S.buc Em.. Worse.. Cuote Intense O.. Subte Rel. interse Re.. Book Title List Par.. Fird Replace Select- Shyles Editing C. Additionally, the Bar division had the following actual costs in 2019 that SIX not directly read to her product: Actual Matering wheed Costo 2010 Month Direct Ish-Hours Cat Setup-Haus Cout Jan 5,472 3. 34.755 $21.95 Fab 5.022 31.05 $21.959 5,422 $ 34276 400 $22.424 6,573 Day 7,054 $10.783 -167 524.82 9,231 $44.99 499 9,753 $_49.785 us 8.744 $ 51 265 640 S 33.667 7,320 820 5.31893 5,311 725 5.4.131 Nov 4,977 $42.286 9.20.404 Das 4,571 $_35.745 697 $ 32.000 Tets 79,450 5497 000 6375 $365.000 Tause we locativen Cursu lecturing the direct facturing lubos- band setup labee her Direct manufacturing labur bersin the elder for the variable portion of manufacturing operata riced. Direct redacturing laboc-bours is als used to allocate de Exed portios of mulettisg operation verband Setup lahor horas is the cost deiner for the cable portion of machine seteperered. Setop laber hours is also need to allocate the tixed portion of machine setoporreres. Projected sale for the entry level 52,000 in 2030, 51000 in 2021, and 48000 in 2012 Projectat tale for the price 10.1002020 11.000 in 2021 and 12000 in 20 Sulcus marit i paid to take a bold. 2020 input cost and coachty standards for direct materials, durect sufacturing lahor 203 manufacturing and are the max 2020 adested input mets and quantita You require sending investory of estryJevel Bus of 20% of axtyce's total sole seeda. Procica Lala wake wote way of Binatagooda ia luned. You require an ending catenal miestory of Sotnest year's production needs (or both product line) WIP isley ALFLFO cost flow You beginning cash balances $125,000 for 2020. The company requires 2 cash balance of $100,000 29 990 Actus Period Coats - 2019 vertising expert ,14=lin $240,000 210,000 35,000 Scaling administrati dispecialis D. Based on the information you have gathered you also muke the following Symptions: Rex nf permitentia in the division all expERE the guidin ench No ale made cn (all sales are achi Information for the 2020 budget is as follows: The waited unist nput quantities for matenais med in 2019 will also be used in 2020 bodget. 0 For the entry-level but the pointed it us questetics for labo od MOH (Grect miracturing taber hours and machine setup Taher hersed in 2019 wilt sto be wat in the 2030 budget o For the proceries bar the word tegut quantity or direct matig aber will be 24 hoursuimit. The bodigd unit inpur: quantity for stop labor hours and in 2019 will ales he und in the 2020 badge O Tae cet of Add Muleur budgeted to increase by 10% 2020 2019 al costa. Bulgte labestuta a 2020 e aspettol tonercard by 360. zballen i 2012. Calculate 2020 budgeld viable manutes and total Exaduk Cem 2019 utul malbiy cost and activity driz. Use Regression Analysis to determine estimates for variable and monthly Exed costa. Convermouthly estimates fixed costs into cual costa o Ascend MOE de motores changed from budgeted 2019 data. o Production and sales tocca are within de relevantrance o Bodgeted Tuble period costs want and final costs in total for 2020 are somed to be the same as ara period 2019 O A 31 screase in selling price for 2020 is expected for both due catry-level and the pro-series Requirements Requencests for the two parts of the case are listed below. Bester swers will clearly present modus fer ratenlations Presenting calendations in the management can inderstand that is important. The taxlity of your prendere will be de-create a model that can be marily opened and modified by twing appropriate formats and referencing See Canvas for model design tips Requirements for Part 1 - due Friday, October 16 Accuela Normal Coating, CVP is, deli-Bead Coating 1. What were the budgeted indirect cost rates for the manusctocicg operaticas activity and the machine Setup activity 2019 2. We verhoed of indeplied for the yarny how much 3. What was the unit product cat for the entry level and procerie Batsende mama casting! 4. What was the Bat Disco's operating income for 2019 Useronnal costing and adutformi yland Mo. 3. te the 2019 actualmenthly MOH information to calcula estimate of coat babai (fied od vrable courses for each BOH activity. These esticates will be used for the 2020 budget Use the Regresa action Cound der Date Duracelyi Excel. Place outlet one spurte about 6. For Setup Operatiu aled actively, evaluate the local cut hiva und mit toll altercatre of Durect Labbe Hours as the cost Garver. Refer to bit 10-18.1.4. nua a regression for DLHO 2 e cost dever for Setop Operasious city and compare the results ong to the citer in Ex 10-13. 7. Calculate the break-even point in uses (calculate te nuber of baccach product required, and the sucher oturts of both protects that must be sold to earn an operating income at $150,000. Use 20:20 bodgeted to be reber to section toDet post 2 and you results to requirement 3. o Page 17140 words Type here to search 0 AB 10:55 AM 10/13/2020