Autosove MOT2303 - Final Pro Insert Draw Formulas Data Page Layout Home Review View Calibri (Body) 11 ' E- Paste BIU Av 122 2 xv fx A B c D E F G H 1 MGT2303 - Final Project 2 13 Part 1: (a) FAN 5 Transactions during April 2021: 16 A-Apr. 2 Ken invests $10,000 of his own money into the business & B-Apr 2 Purchaseswith cash 2 lawmowers each with a cost of $400 9C-Apr 2 Purchases with cash 2 trimmers at a cost of $180 each 10 D.Apr.2 Purchases with cash 2 rakes at a cost of $20 each 11 E-Apr 3 Using his credit card he places an ad in a local community website for $300 for the month 12 F.Apr. 3 Using his credit card he pays the monthly $200 fee for a website that can handle payments 113 G-Apr. 4 Purchases with cash $100 worth of gas. He will treat the gas as an expense. 14 H-Apr 30 Records sales of $2,000of which he received $1,500 in cash and $500 on credit 15. Apr. 30 Pays a worker $800 in cash for the work performed in the month 16 - Apr 30 Recrds the depreciation for his equipment-lawnmowers, trimmers, and rakes 17 Ken believe his equipment will last 2 years and he will operate for 6 months per year 18 19 120 2 22 23 NECNON Cover Page for Excel Work T-Accounts and Trial Balance Financia 3 AutoSave MGT2303 - Final Projec Insert Draw Formulas Page Layout Data ne Review View X Calibri (Body) 11 GE ste B I U a. A~ $ $ x fe M N 0 Q R s 0) Record the transactions into the T-Accounts Cash $10,000.00 A 8 C D $800.00 $360.00 $40.00 ken, Capital A $10,000.00 DUO Equipment $800.00 $360.00 $40.00 7 9 Cover Page for Excel Work T-Accounts and Trial Balance Financials 3 Share Commer Hitional Formatting ro (0) O: 0 at as Table Cells Styles Editing Analyze Data Sensitivity AA AB AC AD AE (ii) Create the trial balance Trial Balance Account Debit Credit Insert Format Tools Data File Edit View Excel MGT2303 - Fi AutoSave Data Review Home Insert Formulas Draw Page Layout X Calibri (Body) 11 ' Paste BIU a. Av L16 1 x F G H B D E 3 Part 1: (b) c) Create the Statement of Income for April, 2021 5 6 7 B 9 10 11 12 13 14 115 16 17 18 19 20 22 23 24 25 26 22 28 Create the balance sheet for Anrilan 2021 Cover Page for Excel Work T-Accounts and Trial Balance Home X Calibri (Body) 11 ' Paste A BIU L16 x fx F G A E 8 C D (1) Create the balance sheet for April 30, 2021 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 45 16 47 48 49 50 51 52 53 54 Cover Page for Excel Work T-Accounts and Trial Balance Calibri (Body) 11 ' v Paste BIU A 16 X & fx G F B C D E 3 (11) Create a simple cash analysis for April 2021 1 52 53 54 65 66 67 68 69 70 71 73 75 76 77 78 79 80 81 82 83 Cover Page for Excel Work T-Accounts and Trial Balance 1(15 marks - 200 - 250 words for (a)) [CLR 3] Eackground Ken has been hiring part time workers and paying them as casual abour for each lawn they cut. The turnover rate is high and he is continually looking to replace workers. Finding good workers that will stay is a major headache for Ken. With KLE's steady business and a growing list of customers, Ken feels he can now hire a full-time person to help in all areas of the business. One of his current workers, Aiesha, would be the perfect person given her work ethic and friendly demeanor. He would pay Aiesha $500 a week to start. He is also on the verge of being able to offer a winter service so that he can provide Aiesha work year-round. a. (3 marks) Complete in WORD 250 words. MOT2303 Final Project - EXCO Workshops Home Insert Draw Page Layout Formulas Data Review View Tell me Calibr (Body inert 11 - A A == 29 General 16 2 Dalto Data CA Sort IM $ %) Conditional Format Formatting Table Styles Format A26 Xfx c D G M M N O 5 MGT3303 - Project Part 4 - Section Payroll Call the weekly nepy for Alechthering all didactions Calculate and how les montreme born 2021 Payroll State the date the June payroll remittance is de 7 Datetheritance is due 10 16 17 + 10 21 16 JA Cover Page for Excel Work T-Accounts and Trail Balance Financial Statements Payroll Valuation MacBook Air Autosove MOT2303 - Final Pro Insert Draw Formulas Data Page Layout Home Review View Calibri (Body) 11 ' E- Paste BIU Av 122 2 xv fx A B c D E F G H 1 MGT2303 - Final Project 2 13 Part 1: (a) FAN 5 Transactions during April 2021: 16 A-Apr. 2 Ken invests $10,000 of his own money into the business & B-Apr 2 Purchaseswith cash 2 lawmowers each with a cost of $400 9C-Apr 2 Purchases with cash 2 trimmers at a cost of $180 each 10 D.Apr.2 Purchases with cash 2 rakes at a cost of $20 each 11 E-Apr 3 Using his credit card he places an ad in a local community website for $300 for the month 12 F.Apr. 3 Using his credit card he pays the monthly $200 fee for a website that can handle payments 113 G-Apr. 4 Purchases with cash $100 worth of gas. He will treat the gas as an expense. 14 H-Apr 30 Records sales of $2,000of which he received $1,500 in cash and $500 on credit 15. Apr. 30 Pays a worker $800 in cash for the work performed in the month 16 - Apr 30 Recrds the depreciation for his equipment-lawnmowers, trimmers, and rakes 17 Ken believe his equipment will last 2 years and he will operate for 6 months per year 18 19 120 2 22 23 NECNON Cover Page for Excel Work T-Accounts and Trial Balance Financia 3 AutoSave MGT2303 - Final Projec Insert Draw Formulas Page Layout Data ne Review View X Calibri (Body) 11 GE ste B I U a. A~ $ $ x fe M N 0 Q R s 0) Record the transactions into the T-Accounts Cash $10,000.00 A 8 C D $800.00 $360.00 $40.00 ken, Capital A $10,000.00 DUO Equipment $800.00 $360.00 $40.00 7 9 Cover Page for Excel Work T-Accounts and Trial Balance Financials 3 Share Commer Hitional Formatting ro (0) O: 0 at as Table Cells Styles Editing Analyze Data Sensitivity AA AB AC AD AE (ii) Create the trial balance Trial Balance Account Debit Credit Insert Format Tools Data File Edit View Excel MGT2303 - Fi AutoSave Data Review Home Insert Formulas Draw Page Layout X Calibri (Body) 11 ' Paste BIU a. Av L16 1 x F G H B D E 3 Part 1: (b) c) Create the Statement of Income for April, 2021 5 6 7 B 9 10 11 12 13 14 115 16 17 18 19 20 22 23 24 25 26 22 28 Create the balance sheet for Anrilan 2021 Cover Page for Excel Work T-Accounts and Trial Balance Home X Calibri (Body) 11 ' Paste A BIU L16 x fx F G A E 8 C D (1) Create the balance sheet for April 30, 2021 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 45 16 47 48 49 50 51 52 53 54 Cover Page for Excel Work T-Accounts and Trial Balance Calibri (Body) 11 ' v Paste BIU A 16 X & fx G F B C D E 3 (11) Create a simple cash analysis for April 2021 1 52 53 54 65 66 67 68 69 70 71 73 75 76 77 78 79 80 81 82 83 Cover Page for Excel Work T-Accounts and Trial Balance 1(15 marks - 200 - 250 words for (a)) [CLR 3] Eackground Ken has been hiring part time workers and paying them as casual abour for each lawn they cut. The turnover rate is high and he is continually looking to replace workers. Finding good workers that will stay is a major headache for Ken. With KLE's steady business and a growing list of customers, Ken feels he can now hire a full-time person to help in all areas of the business. One of his current workers, Aiesha, would be the perfect person given her work ethic and friendly demeanor. He would pay Aiesha $500 a week to start. He is also on the verge of being able to offer a winter service so that he can provide Aiesha work year-round. a. (3 marks) Complete in WORD 250 words. MOT2303 Final Project - EXCO Workshops Home Insert Draw Page Layout Formulas Data Review View Tell me Calibr (Body inert 11 - A A == 29 General 16 2 Dalto Data CA Sort IM $ %) Conditional Format Formatting Table Styles Format A26 Xfx c D G M M N O 5 MGT3303 - Project Part 4 - Section Payroll Call the weekly nepy for Alechthering all didactions Calculate and how les montreme born 2021 Payroll State the date the June payroll remittance is de 7 Datetheritance is due 10 16 17 + 10 21 16 JA Cover Page for Excel Work T-Accounts and Trail Balance Financial Statements Payroll Valuation MacBook Air