Excel - Project Pt1.xlsx Q- Search Sheet 2+ Share A Ooo Home Insert Page Layout Caramond C Copy Peste Format BIV AT xv fx Cat Formulas 12 A A Data A A Review = = = View = = 33 o Wrap Text Mange & Center " A Ceneral $. % * . .itasun Fill > clear ) Conditional Format Formatting as Table Cell Styles Insert Dalate Femmet Sort & Project - Part 1 3 Assignment You are the accountant at Wesleyan Technology Corpucy (WT) in the fall of 2020. Your boss, the control, has asked you to Iske another passatike Quarter Mulet for 20121 as she is not sare the names are correc. She renk you the attached Excel File, providing the retresury in TITITI O CUCIS Kt the burgut Fruttarch. Yuy jobs to take the inftruim wided as the Info tabia Excel file and pattogether the Badget for 30 2021 on the loputab. You have ucal Mey 12 to get dros doce. 35 Task Info Input + Ready Circular References # B - - + 100% Excel - Project Pt1.xlsx Q- Search Sheet 2+ Share A DO . Home Insert Page Layout Caramond Copy Paste u n B I U Formulas Data 12 'A A . .A Review = = E View = . Wap Text Merge & Center. Ceneral $ . % : *. 4 . . ) 08 Insert sert Dalate Conditional Format Formatting as Table Format Delete Call Styles Format Clea. Sort & Filter D1 x fx Assumptions for Wesleyan Technology Company (WTC) on preparing a budget for 3rd Quarter, 2021 5 Assumptima fut Wesleyan Technology Company (WTC) preparing a budget for 3rd Quarter, 2021 Budgutud Sulus (in units) Aurat -10000 1500 0 Duke Super 00.00 wake DO The Vinir Selling Price $12.00 Cash Collections WIC eles are all on account with the following pamern of collec 10 Collected in the wront of the de w Galled in the man following the sale 9% Uncollectible Tuni's sile ure SvD 16 Production Budget Ending invector is to be equal to 15% of the following months budgroed des 16 Direct Materials 10 pounds of anal 10% of the following U2S custpet poud requised per wat of product th e rion for Meriale on hand is oth end a Cash Dishement for Materials WIC pad to purchases as follows: 50% in the month the returile the purchas +5% in the following month 22 Tume Axcentral halanes $ 187.00 in the air fall in . Direct Labor Tirt of her of directlobe prudens unit of product WTC basa bolsof police so all emporees are paid for 10 hours of work each week The hourly rater beru lar time employex The minim ber of her to be paid cach month 35 36 37 38 39 40 Manufacouring Orechead Macroing overbeadsplied to us of product besed on direct labor hours The viable where it Fund Mirroring Onthead marth Task into Input + 525 4: Ready Circular References # B - - + 100% Q- Search Sheet 2+ Share A Ooo Excel - Project Pt1.xlsx Home Insert Page Layout Formulas Data Review View . Xcut Caramond 12 A A - = = a Wrap Text General Copy Peste Format B IV .A A = = = 33 Mange Canter. $. % ) D1 x fx Assumptions for Wesleyan Technology Company (WTC) on preparing a budget for 3rd Quarter, 2021 : " Cell Insert Insert Styles * Delete Delete .itasun A Clear 27 Conditional Format Formatting as Table Format Format Sort & Filter 32 Manfacturing Overhead Manufacturing overhead is applied to uniss of product based on directlebor bour The val i ditetshut Fixed Monferring hear minh Non cash costs included an laxed becaufacturing Uretend $750,00 $25,000 46 Salland Administrate EXCACS WTC is both land valle wi l ministrative expenses Ratu unifor Sulling and Ministri uspense Lixed Sellica and Adminisceive expeases per mond: N ah istim in Suid Almini ve expenses 1025 $750 51. X 50 Cm Budget Maintena minima munthul exchancesi 54 Maintains a 15% open line of credit for $125,00 Bucuwis pas the daul the anth Rumun ar mailu on the day of the Cash dividend pad is aut Hy-pentu main03 21121 Fun ched with rain Jule patent parchased with ca in September Jurc cnding rahim $30,000 57 $55,00 $35.000 59 G2 Budpeted Financial Staments W TY. Han h u r Accounts Receivable Equgreni Land Commco Stock Resin Fate dhuwur the roll ringan $137.627.00 $195.WO swo $228_006 Task Info Input + Ready Circular References # EE - - Excel - Project Pt1.xlsx Q- Search Sheet 2+ Share A OOO5. Home Insert Page Layout Calibri (Body) Copy Paste u nt B IU . 113 x v fx Formulas Data 11 .A A . . A Review = = E + View = a Wrap Text Merge Cantor. 1 General $ . % 2 A .itasun 4 . ) Conditional Format Formatting as Table Cell Styles sert Delete Format Clear Sort & Filter C Assumptions for Wesleyan Technology Company (WTC) on preparing a budget for 3rd Qasrter, 2021 rue cre: le found Quarter 3, 2021 Fly Augumi Samir Budgeted unir sales Selling price unit Toeul walks Construct Expected Cash Collections Budger Quarter, 2021 August September July Total AR- Total Cash Collection Ciner P er Hodger Quarter 3, 2021 Scharnier July Aur Buleted Sales Add D ding Twenty Tuba NS Les Heuning livet Required Production Correr Nier Material Budget July Quarter 3, 2021 August September Quarter 38 39 40 Paralu Materials per units b) Product Nbeds Aile D u yen Total Needed leu Bepinning remory Task Info Input Ready Circular References # EE - Excel - Project Pt1.xlsx Q- Search Sheet 0 2+ Share A Ooo. Home Insert Page Layout Calibri (Body) Copy Paste faint B i U 113 x v fx Formulas Data 11 . A- A S A Review = = = = View = = E .itasun Wrap Text ergas Centar . Ceneral $ . % 2 " A *. . ) Conditional Format Formatting as Table Cell Styles sert Delete Format Clear Sort & Filter 32 Construct Direct Materials Budget Quarter 3, 2021 August Seprember 14 July Prodason Materials ir units ) P uction Nucts Add Desired ending inventory "Total Noxiler! Less Beginning lovustury Materials to be purchased Cat Materials to be purchased - $ 40 Corner Enerud Canh Nabens Budger Qarier 3, 2021 August September July A/P-30 Jun Total Cash Disbursements Cine I lir Rarele Quarter 3. 2021 August Septemier July | Toral lais Puzluk Direct Labur per uni: Labor hours qui | Cur ' Har Lobce I lours Disd Total Direct Labur Custs 70 Construct Manufacturing Overhead Budget utlet.3, 2021 August Seprember July Task Info Input + Ready Circular References # EE - - Excel - Project Pt1.xlsx Q- Search Sheet 0 2+ Share A Review View DO 05. Home Insert Page Layout Xcut Calibri (Body) Copy Paste Format BIUR 113 x v fx Formulas Data 11 . A- A A .itasun A . - E 5 Wrap Text Merge Center - $ . % ) Conditional Format Formatting as Table Call Styles Insert Insert Delete Delete Format Format Clear Sort & Filter N Heurly Rh Total Direct Labor Costs Coverruci M ufacturing Overhead Budger 71 Quarter 3, 2021 Aur September July 73 74 75 76 77 Dupe DH Variable MOH Variable MOL! costs Pixel MOH Cosis Total MOH Cuts Predecermined Overheed Rece (POHR) Tool MOUcunt | R | Cash disl utsushii l i MC H. 84 Construct Ending Finished Goods faventory Budget QOT Qurer 2, 2021 Conr lbs. T Tisa 86 Production cost per un 82 Direc: Marcials 88 Delalar | Manufacture verhoud Product Cost per Linit Butlet Finishwil G l. Trunury Unit product cost Enun finished and very 96 Construct Selling and Administrative Expense Budger 97 Quarter 3, 2021 uer September July A 99 100 101 102 103 104 L Dudpered Sles Variable: S & A tal Variable expenses Fixed S&A DOS Total SACS ineas cues L Task . Info Input Ready Circular References # EE - - Excel - Project Pt1.xlsx Q- Search Sheet 0 2+ Share A Ooo. Home Insert Page Layout Calibri {Body) Copy mt B I U 113 x v fx Formulas Data 11 .A AY .A.A. Review = = E = View = = = A . Wrap Text Merges contar Ceneral $ % 2 Conditional Format x Delete p R ) Collinsert .itasun rill Clear Format Sort Formatting as Table Styles 94 Ending finished goods inventory 96 Cuisine Selling and Admirative Axpense Hedge Quarter 3. 2021 Senner July Tona/ 99 100 101 102 103 104 Bural Sales Variables & Art Verille expenses His & Act Totals & Acce Lex noch coas Cash & A Expenses 105 106 107 108 C r Cala Murat 109 110 Quarter 2, 2021 Auwwit Spremier July Tora! 111 112 111 114 115 116 117 118 119 120 121 122 123 124 125 126 127 Beginning Cash Malay Acut Cushe willeures Tacal cash aranable Lens Cash disbaren Natal Direct labore Mamurin /H Sell Admin Locuipment parchase Divided Torallabus ) Financing Bordocig | Repayment Tuduling Ending Cash Balance 129 130 Task into Input + Ready Circular References # EE - Excel - Project Pt1.xlsx Q- Search Sheet 0 2+ Share A Formulas 11 A A Data A Review = = E # View = 3 .itasun Wrap Text Mengo & Canter 2 Ceneral $ . % " A *. . 3 3 ) Conditional Format Formatting as Table Cell Styles Insert Dalate Femmet > clear Sort & Ooo. Home Insert Page Layout Calibri (Body) Copy Paste Format BIV 113 x fx A 126 Tees 127 Totul financing 128 Ending Cash Balance 129 MN 120 131 Budgered Income Srarement 132 133 134 e expenses Cost of Goods Sold Gross Margin Sellent and Ad Operating Income Internet expose Ner Income 139 C ar Huda Inwe Statement Buddled Male Sireet ASSETS 142 143 E tuivale: Rowa nity 145 146 Finished the Lad Lupmees 148 149 Toti Assets 150 151 LIABILITIES AND STOCKHOLDERS' EQUITY Acconcrete Soos erable 153 154 155 156 Come rock Retained earnings Tsital Liabilities and Sockholders' Equity Task Info Input + Ready Circular References # B - - Excel - Project Pt1.xlsx Q- Search Sheet 2+ Share A Ooo Home Insert Page Layout Caramond C Copy Peste Format BIV AT xv fx Cat Formulas 12 A A Data A A Review = = = View = = 33 o Wrap Text Mange & Center " A Ceneral $. % * . .itasun Fill > clear ) Conditional Format Formatting as Table Cell Styles Insert Dalate Femmet Sort & Project - Part 1 3 Assignment You are the accountant at Wesleyan Technology Corpucy (WT) in the fall of 2020. Your boss, the control, has asked you to Iske another passatike Quarter Mulet for 20121 as she is not sare the names are correc. She renk you the attached Excel File, providing the retresury in TITITI O CUCIS Kt the burgut Fruttarch. Yuy jobs to take the inftruim wided as the Info tabia Excel file and pattogether the Badget for 30 2021 on the loputab. You have ucal Mey 12 to get dros doce. 35 Task Info Input + Ready Circular References # B - - + 100% Excel - Project Pt1.xlsx Q- Search Sheet 2+ Share A DO . Home Insert Page Layout Caramond Copy Paste u n B I U Formulas Data 12 'A A . .A Review = = E View = . Wap Text Merge & Center. Ceneral $ . % : *. 4 . . ) 08 Insert sert Dalate Conditional Format Formatting as Table Format Delete Call Styles Format Clea. Sort & Filter D1 x fx Assumptions for Wesleyan Technology Company (WTC) on preparing a budget for 3rd Quarter, 2021 5 Assumptima fut Wesleyan Technology Company (WTC) preparing a budget for 3rd Quarter, 2021 Budgutud Sulus (in units) Aurat -10000 1500 0 Duke Super 00.00 wake DO The Vinir Selling Price $12.00 Cash Collections WIC eles are all on account with the following pamern of collec 10 Collected in the wront of the de w Galled in the man following the sale 9% Uncollectible Tuni's sile ure SvD 16 Production Budget Ending invector is to be equal to 15% of the following months budgroed des 16 Direct Materials 10 pounds of anal 10% of the following U2S custpet poud requised per wat of product th e rion for Meriale on hand is oth end a Cash Dishement for Materials WIC pad to purchases as follows: 50% in the month the returile the purchas +5% in the following month 22 Tume Axcentral halanes $ 187.00 in the air fall in . Direct Labor Tirt of her of directlobe prudens unit of product WTC basa bolsof police so all emporees are paid for 10 hours of work each week The hourly rater beru lar time employex The minim ber of her to be paid cach month 35 36 37 38 39 40 Manufacouring Orechead Macroing overbeadsplied to us of product besed on direct labor hours The viable where it Fund Mirroring Onthead marth Task into Input + 525 4: Ready Circular References # B - - + 100% Q- Search Sheet 2+ Share A Ooo Excel - Project Pt1.xlsx Home Insert Page Layout Formulas Data Review View . Xcut Caramond 12 A A - = = a Wrap Text General Copy Peste Format B IV .A A = = = 33 Mange Canter. $. % ) D1 x fx Assumptions for Wesleyan Technology Company (WTC) on preparing a budget for 3rd Quarter, 2021 : " Cell Insert Insert Styles * Delete Delete .itasun A Clear 27 Conditional Format Formatting as Table Format Format Sort & Filter 32 Manfacturing Overhead Manufacturing overhead is applied to uniss of product based on directlebor bour The val i ditetshut Fixed Monferring hear minh Non cash costs included an laxed becaufacturing Uretend $750,00 $25,000 46 Salland Administrate EXCACS WTC is both land valle wi l ministrative expenses Ratu unifor Sulling and Ministri uspense Lixed Sellica and Adminisceive expeases per mond: N ah istim in Suid Almini ve expenses 1025 $750 51. X 50 Cm Budget Maintena minima munthul exchancesi 54 Maintains a 15% open line of credit for $125,00 Bucuwis pas the daul the anth Rumun ar mailu on the day of the Cash dividend pad is aut Hy-pentu main03 21121 Fun ched with rain Jule patent parchased with ca in September Jurc cnding rahim $30,000 57 $55,00 $35.000 59 G2 Budpeted Financial Staments W TY. Han h u r Accounts Receivable Equgreni Land Commco Stock Resin Fate dhuwur the roll ringan $137.627.00 $195.WO swo $228_006 Task Info Input + Ready Circular References # EE - - Excel - Project Pt1.xlsx Q- Search Sheet 2+ Share A OOO5. Home Insert Page Layout Calibri (Body) Copy Paste u nt B IU . 113 x v fx Formulas Data 11 .A A . . A Review = = E + View = a Wrap Text Merge Cantor. 1 General $ . % 2 A .itasun 4 . ) Conditional Format Formatting as Table Cell Styles sert Delete Format Clear Sort & Filter C Assumptions for Wesleyan Technology Company (WTC) on preparing a budget for 3rd Qasrter, 2021 rue cre: le found Quarter 3, 2021 Fly Augumi Samir Budgeted unir sales Selling price unit Toeul walks Construct Expected Cash Collections Budger Quarter, 2021 August September July Total AR- Total Cash Collection Ciner P er Hodger Quarter 3, 2021 Scharnier July Aur Buleted Sales Add D ding Twenty Tuba NS Les Heuning livet Required Production Correr Nier Material Budget July Quarter 3, 2021 August September Quarter 38 39 40 Paralu Materials per units b) Product Nbeds Aile D u yen Total Needed leu Bepinning remory Task Info Input Ready Circular References # EE - Excel - Project Pt1.xlsx Q- Search Sheet 0 2+ Share A Ooo. Home Insert Page Layout Calibri (Body) Copy Paste faint B i U 113 x v fx Formulas Data 11 . A- A S A Review = = = = View = = E .itasun Wrap Text ergas Centar . Ceneral $ . % 2 " A *. . ) Conditional Format Formatting as Table Cell Styles sert Delete Format Clear Sort & Filter 32 Construct Direct Materials Budget Quarter 3, 2021 August Seprember 14 July Prodason Materials ir units ) P uction Nucts Add Desired ending inventory "Total Noxiler! Less Beginning lovustury Materials to be purchased Cat Materials to be purchased - $ 40 Corner Enerud Canh Nabens Budger Qarier 3, 2021 August September July A/P-30 Jun Total Cash Disbursements Cine I lir Rarele Quarter 3. 2021 August Septemier July | Toral lais Puzluk Direct Labur per uni: Labor hours qui | Cur ' Har Lobce I lours Disd Total Direct Labur Custs 70 Construct Manufacturing Overhead Budget utlet.3, 2021 August Seprember July Task Info Input + Ready Circular References # EE - - Excel - Project Pt1.xlsx Q- Search Sheet 0 2+ Share A Review View DO 05. Home Insert Page Layout Xcut Calibri (Body) Copy Paste Format BIUR 113 x v fx Formulas Data 11 . A- A A .itasun A . - E 5 Wrap Text Merge Center - $ . % ) Conditional Format Formatting as Table Call Styles Insert Insert Delete Delete Format Format Clear Sort & Filter N Heurly Rh Total Direct Labor Costs Coverruci M ufacturing Overhead Budger 71 Quarter 3, 2021 Aur September July 73 74 75 76 77 Dupe DH Variable MOH Variable MOL! costs Pixel MOH Cosis Total MOH Cuts Predecermined Overheed Rece (POHR) Tool MOUcunt | R | Cash disl utsushii l i MC H. 84 Construct Ending Finished Goods faventory Budget QOT Qurer 2, 2021 Conr lbs. T Tisa 86 Production cost per un 82 Direc: Marcials 88 Delalar | Manufacture verhoud Product Cost per Linit Butlet Finishwil G l. Trunury Unit product cost Enun finished and very 96 Construct Selling and Administrative Expense Budger 97 Quarter 3, 2021 uer September July A 99 100 101 102 103 104 L Dudpered Sles Variable: S & A tal Variable expenses Fixed S&A DOS Total SACS ineas cues L Task . Info Input Ready Circular References # EE - - Excel - Project Pt1.xlsx Q- Search Sheet 0 2+ Share A Ooo. Home Insert Page Layout Calibri {Body) Copy mt B I U 113 x v fx Formulas Data 11 .A AY .A.A. Review = = E = View = = = A . Wrap Text Merges contar Ceneral $ % 2 Conditional Format x Delete p R ) Collinsert .itasun rill Clear Format Sort Formatting as Table Styles 94 Ending finished goods inventory 96 Cuisine Selling and Admirative Axpense Hedge Quarter 3. 2021 Senner July Tona/ 99 100 101 102 103 104 Bural Sales Variables & Art Verille expenses His & Act Totals & Acce Lex noch coas Cash & A Expenses 105 106 107 108 C r Cala Murat 109 110 Quarter 2, 2021 Auwwit Spremier July Tora! 111 112 111 114 115 116 117 118 119 120 121 122 123 124 125 126 127 Beginning Cash Malay Acut Cushe willeures Tacal cash aranable Lens Cash disbaren Natal Direct labore Mamurin /H Sell Admin Locuipment parchase Divided Torallabus ) Financing Bordocig | Repayment Tuduling Ending Cash Balance 129 130 Task into Input + Ready Circular References # EE - Excel - Project Pt1.xlsx Q- Search Sheet 0 2+ Share A Formulas 11 A A Data A Review = = E # View = 3 .itasun Wrap Text Mengo & Canter 2 Ceneral $ . % " A *. . 3 3 ) Conditional Format Formatting as Table Cell Styles Insert Dalate Femmet > clear Sort & Ooo. Home Insert Page Layout Calibri (Body) Copy Paste Format BIV 113 x fx A 126 Tees 127 Totul financing 128 Ending Cash Balance 129 MN 120 131 Budgered Income Srarement 132 133 134 e expenses Cost of Goods Sold Gross Margin Sellent and Ad Operating Income Internet expose Ner Income 139 C ar Huda Inwe Statement Buddled Male Sireet ASSETS 142 143 E tuivale: Rowa nity 145 146 Finished the Lad Lupmees 148 149 Toti Assets 150 151 LIABILITIES AND STOCKHOLDERS' EQUITY Acconcrete Soos erable 153 154 155 156 Come rock Retained earnings Tsital Liabilities and Sockholders' Equity Task Info Input + Ready Circular References # B