required a answer in which we have to make cash budget, income statement budget, sales budget, cost of sales budget, purchase budget, selling &admin expense budget, schedule of cash collection. quarter 1 run from 1 jan- 31 March. quarter 2 runs from 1 April-30june quarter 3 runs from 1 jul-30 sep quarter 4 runs from 1 oct - 31 dec.

need to make all the budgets from jan 2021 to dec 2021

this question is very big so in the fact sheet there is all information can you please help me it's urgent if you need any other information revert me.

actSheet - Data on 2019 Financial Year 138 Jan-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 Fales Volume - Sunglassses 160 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-20 16S 143 148 Fales Volume - Prescription glasses 171 165 94 98 103 139 130 97 160 -ervice Volume - No. of Clients 108 175 135 129 85 103 89 94 94 88 88 98 120 123 117 94 85 80 109 Felling Price - Sunglasses $ 200.00 Cost Price - Sunglasses $ 60.00 Felling Price - Prescription glasses $ 150.00 Cost Price - Prescription glasses $ 80.00 Fervice Revenue $ 75.00 lumber of Sale Assistants: 2 Vage Rate per Employee per Month $ 4,000 Humber of Office Staff: 1 Vage Rate per Employee per Month $ 4,500 lumber of Optometrists 2 Vage Rate per Employee per Month $ 6,500 Groupon Factsheet Income talent Sales Budget Cost of Sales loget Purchases Budget Selling & Admin Expense Budget Sche Type here to search O N * 4ING 21-05-20 lp 5 6 8 Financial Year 2019 Mar-2019 Apr-2019 May-2019 Jun-2019 Jul 2019 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 58 143 148 138 171 165 139 130 160 175 188 =8 97 135 129 94 88 120 127 59 94 123 117 94 85 80 109 115 103 108 103 88 98 Information Factsheet income Sales Budget Cost of Sales Budget Purchases Budget Seling & Admin Expense Budget Sched here to search O ! CE E Ad 4 ENG 9 hp Om MAA103T12120 Budgeting Agent (1) Protected Vel. Ered Home Insert Page Layout Forms Data Review View Tell me what you want to do PROTECIID VIEW Beritrom the contenen und society in low Wow Melo Additional Information: Both James and Olivia are partners within the business and each of them draws an amount of $1600 per month. Each partner plans on increasing the drawings to : month starting from January of 2021. As the manager, James keeps a close eye on inventory management and would like to always maintain a monthly ending inventory requirement of 30% of next mon can assume starting inventory for Jan 2021 to be O units for both sunglasses and prescription glasses. Additionally, you can assume that all credit amounts for purch inventory prior to January 2021 have been settled All purchases with the current supplier are on a credit basis, with 70% of the amount settled in the same month of purchase and the remaining 30% settled one mor month of purchase. You can assume that all credit amounts for purchase of inventory prior to January 2021 have been settled. The business typically will have 80% of their sales as cash, with the remaining 20% on credit. Of the credit sales, 70% is collected in the month of sale, 20% is collecte after the sale, and 10% is collected two months after the sale. All customers coming in for an eye check pay for the service in cash 100% of the time. The business has a range of equipment and other fixed assets such as: In 2019, the business purchased specialised optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13200 and it is expected tt Other office equipment has a historical cost of $30000 and depreciates at 20% per annum. Shop fittings were originally purchased at $63600 and depreciate at 10% per annum SC Burda fudgeting & Aime Les mation Factsheet O e D Type here to search MAA 120 budgment extend wart per fem De Review Ver to what we 04 re on Inventory management and would like to always maintain a monthly ending inventory requirement of 30% of next month's sales. You 2021 to be units for both sunglasses and prescription glasses. Additionally, you can assume that all credit amounts for purchase of been settled are on a credit basis, with 70% of the amount settled in the same month of purchase and the remaining 30% settled one month after the hat all credit amounts for purchase of inventory prior to January 2021 have been settled. f their sales as cash, with the remaining 20% on credit. Of the credit sales, 70% is collected in the month of sale, 20% is collected one month o months after the sale eck pay for the service in cash 100% of the time. nt and other fixed assets such as: cialised optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13200 and it is expected to last 5 years. cal cost of $30000 and depreciates at 20% per annum. ed at $63600 and depreciate at 10% per annum e and are depreciated using the straight line method of depreciation SCOGS SUSILATUL AQWA 215 O ER O Tehere to search R!e VIEW Te care-Eles from the Internet can contain viruses. Unless you need to edit is safer to stay in Protected View Enable Eating Xf Shop fittings were originally purchased at $63600 and depreciate at 10% per annum. All fixed assets have so residual value and are depreciated using the straight-line method of depreciation. Other Fixed Costs: Marketing expense of $900 per annum is paid evenly across 12 months. $3000 of general business insurance is paid in July every year. This insurance covers the period 1st Jan to 31st Dec. Bank account fees works out to be $48 per month and are paid at the start of each quarter. On average, the office supplies are purchased and expensed every month to the amount of $90. General council rates are $600 per year and are usually paid in December each year. The rates cover the period 1st Jan to 31st D Rent is paid at the start of each quarter and works out to be $6400 per month. (80% store; 20% office) Water, gas and electricity are combined under on utility expense which adds up to $495 per quarter and is usually paid at the end *Note: Quarter 1 runs from 1 Jan-31 Mar: Quarter 2 runs from 1 Apr - 30 Jun; Quarter 3 runs from 1 Jul - 30 Sep: Quarter 4 runs GroupJnformation Factsheet Sales Budget Cost of Sales Budget Purchases dudget Selling & Admin Expense Budget 3 Type here to search O AL e N 2 PROTECTED VIEW Se carefules from the Internet can continues Unless you need to edt is safe to stay in Protected View 1 X Enable Eding $63600 and depreciate at 10% per annum. d are depreciated using the straight-line method of depreciation. paid evenly across 12 months. Ed in July every year. This insurance covers the period 1st Jan to 31st Dec. er month and are paid at the start of each quarter. zased and expensed every month to the amount of $90. nd are usually paid in December each year. The rates cover the period 1st Jan to 31st Dec. (50% store: 50% office) and works out to be $6400 per month. (80% store; 20% office) under on utility expense which adds up to 5495 per quarter and is usually paid at the end of each quarter. (75% store; 25% office) r: Quarter 2 runs from 1 Apr - 30 Jun; Quarter 3 runs from 1 Jul - 30 Sep: Quarter 4 runs from 1 Oct - 31 Dec. Group Information Factsheet Set Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Sched - Type here to search Ole N 3 . AC hp) MAA101 TI 2020 Budgeting Assignment (1) Protected Mew - Excel Formu Data Rew View Help Tell me what you want to do POCIED VEW Bew-testom the merret can contain you need to eat it safe to stay in Protected View Enable Eating CASH BUDGET Ian 21 Feb-21 Mar-21 Apr-21 May 21 Jun-21 Nor21 Jul-21 Aug-21 Sep-21 Oct-21 OPENING CASH BALANCE CASH INFLOWS: TOTAL CASH AVAILABLE: CASH OUTFLOWS 25 26 23 Cash Badget Intl get Sales Budget Cost of Sales budget Purchases ludget Selling & Admin Lapense Budget Schedule of Coah Collection type here to search o Et e Nu 3 2 Ad B Data Review View Tell me what you want to do Help Home Intert Page Layout Formulas Enable Editing POTECIID VIEW Be care-les from the Internet can contain ruses. Unless you need to eat its safer to stay in Protected View 4 D AD BUDGETED INCOME STATEMENT Jul-21 Sep-21 Aug-21 Jun-21 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Revenues: Gross Profit Other Income: 3 9 10 11 12 13 Operating Expenses: Selling Expenses 14 16 37 13 19 20 22 23 26 General Administrative Expenses Incomestatement Budget sales toget Cost Of Sales Judget Purchases budget Selling & Admin Expertise Budget Schedule of Cash Collectie Type here to search O . LEP Sales Budget ales Budget Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Sunglasses Jul-21 Expected Sales * Selling Price per Unit Sales Revenues) Aug-21 Sep- Prescription Glasses Expected Sales * Selling Price per Unit Sales Revenue($) TOTAL Sales Revenue (S) Eye-Tests Expected Sales * Selling Price per Unit TOTAL Service Revenue (5) incon Sales Budget Cost of Sales Budget Type here to search Purchases Budget Selling & Admin Expense Budget Schedule of cash eIN 13 3 BED Cost of Sales Budget Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Sunglasses Expected Sales x Cost Price per Unit Cost of Sales (S) Prescription Glasses Expected Sales x Cost Price per Unit Cost of Sales ($) TOTAL Cost of Sales ($) MAATOI T1 2020 Budgeting Assignment (1) (Protected ewl - Excel Chetna Page Layout Formula Review View Help Tell me what you want to do PROTECTED VIW O care-testom the internet can contanthes you need to edit is safer to stay in Protected ow. Enable Editing f Cost of Sales Budget D Cost of Sales Budget Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Sunglasses Oct-21 [xpected sales Cost Price per Unit Cost of Sales) Prescription Elected Sales Cost Price per Unit Cost of Sales 5) TOTAL Cost of Sale) Sales Budget Cost of Sales Bades. Purchases Baget. Type here to search Selling & Admin Expense Budget o Schedule of Cash Collection e MAAT03 T1 2020 Rudgeting Assignment(1) [Protected View - Excel Page Layout Formulas Data Review View Tell me what you want to do PROTECTED VIEW Be care-les from the Internet can continues Unless you need to edit its safer to stay in Protected View Chel Enable Editing Purchases Budget Purchases Budget Jan 21 Feb-21 Mar-21 Apr-21 May 21 Jun-21 Jul-21 Aug-21 Sep-21 Sunglasses Expected Sales Sunglasses) aut Ending inventory Requirement Total Units Resuired: lese: Beginning inventory Total Purchase Unit Costi per Unit Total Purchase Cort (5) Expected Sales (Prescription Gasses) adt Inding Inventory Readrement Toalhin Required: lese: Beginning inventory Totes Purchase Unite Coper Unit Total Purchase Cost (S) Total Overal Purchase Cor 15) Sales judget Costo es budget type here to search Parchus Budget Selling & Admin pense Budget o Schedule of Cash Collection NS R Formulas Review Data View Home Help Insert Page Layout Tell me what you want to do Enable Editing PROTECTED VIEW Be carefules from the Internet can contain wiruses. Unless you need to edit its safer to stay in Protected View AL A Selling General, and Administrative Expense Budget A G Selling, General, and Administrative Expense Budget Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Selling Expenses Total Expenses General Administrative Lepenses 20 22 26 Sales Budget Coat of Sales Budget rere to search purchases budget Selling & Admin Expense Budget o Schedule of can codec e E an 5 MAA103 T1 2020 Budgeting Assignment(1) [Protected View - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing AI f Schedule of Expected Cash Collections from Customers D E G Schedule of Expected Cash Collections from Customers Jan-21 Feb-21 3 4 5 Mar-21 Apr-21 May 21 Jun-21 Cash Sales Credit Sales Jul-21 Aug-21 Sep-21 TOT AL CASH COLLECTIONS 10 17 12 20 21 24 27 Sales budget costa es udget Purchases budget Snamn Formula Data Rear View Help Tell me what you want to do PEOTECTID VW Beelitrom there can contain we U you need bedtime to stay in Protected View Enable Editing XfSchedule of Expected Payments to Suppliers Schedule of Expected Payments to Suppliers Jan-21 Feb-21 Mar-21 Apr-21 May 21 Jun.21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-2 Churches Crest Picha TOTAL CAR PAYMENTS 11 20 Sting Admin one getree of coin colection Potench Schedule of Cash Payments O e MAA103 T1 2020 Budgeting Assignment (1) Protected View - Excel The Insert Page Layout Formulas Review View Help Tell me what you want to do PROTECTED VIEW Be careful files from the internet can contain viruses. Unless you need to edit its safe to stay in Protected view Enable Editing f FactSheet Data on 2019 Financial Year Sales Volume - Sunglassses Sales Volume - Prescription glasses Service Volume - No. of Clients Jan-2019 160 94 85 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 168 143 148 138 171 98 103 97 108 135 89 94 88 98 123 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-20 165 139 130 160 175 129 103 94 88 120 117 94 85 80 109 Selling Price - Sunglasses Cost Price - Sunglasses $ 200.00 $ 60.00 Selling Price - Prescription glasses Cost Price - Prescription glasses $ 150.00 80.00 $ Service Revenue $ 75.00 Number of Sale Assistants: 2 Wage Rate per Employee per Month $ 4,000 Number of Office Staff: 1 Wage Rate per Employee per Month $ 4,500 Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Group Information Factsheet Cash_Budge! Incomestatement_Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Sched Type here to search e x (? ENG 1547 21-05-2020 REDMI NOTE 6 PRO MI DUAL CAMERA you need to edit it's safer to stay in Protected View Enable Editing cial Year 19 Apr-2019 May-2019 Jun-2019 148 138 171 97 108 135 88 98 123 Jul-2019 165 129 117 160 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 139 130 175 188 103 94 88 120 127 94 85 80 115 109 Cash Buda Purchases Budget Selling 8. Admin Expense Budget Sched REDMI NOTE 6 PRO Sales Budget Cost of Sales Budget MI DUAL CAMERA O MAA103 T1 2020 Budgeting Assignment(1) [Protected view) - Excel File Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful--files from the Internet can contan viruses. Unless you need to edit it's sater to stay in Protected View Enable Eating Chetra Sharma Additional Information: Both James and Olivia are partners within the business and each of them draws an amount of $1600 per month. Each partner plans on increasing the drawings to $ month starting from January of 2021. As the manager, James keeps a close eye on inventory management and would like to always maintain a monthly ending inventory requirement of 30% of next mon can assume starting inventory for Jan 2021 to be 0 units for both sunglasses and prescription glasses. Additionally, you can assume that all credit amounts for purch inventory prior to January 2021 have been settled All purchases with the current supplier are on a credit basis, with 70% of the amount settled in the same month of purchase and the remaining 30% settled one mor month of purchase. You can assume that all credit amounts for purchase of inventory prior to January 2021 have been settled. The business typically will have 80% of their sales as cash, with the remaining 20% on credit. Of the credit sales, 70% is collected in the month of sale, 20% is collecte after the sale, and 10% is collected two months after the sale. All customers coming in for an eye check pay for the service in cash 100% of the time. The business has a range of equipment and other fixed assets such as: In 2019, the business purchased specialised optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13200 and it is expected to Other office equipment has a historical cost of $30000 and depreciates at 20% per annum. Shop fittings were originally purchased at $63600 and depreciate at 10% per annum. Group Information FactSheet Cash Budget Income statement_Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Sched Type here to search 150 o e N x A WENG 15:48 21-06-2020 00 REDMI NOTE 6 PRO MI DUAL CAMERA MAA103 T1 2020 Budgeting Assignment (1) (Protected View] - Excel Chetna Sharma File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing 04 F Xf thin the business and each of them draws an amount of $1600 per month. Each partner plans on increasing the drawings to $3200 per eye on inventory management and would like to always maintain a monthly ending inventory requirement of 30% of next month's sales. You 2021 to be o units for both sunglasses and prescription glasses. Additionally, you can assume that all credit amounts for purchase of been settled r are on a credit basis, with 70% of the amount settled in the same month of purchase and the remaining 30% settled one month after the that all credit amounts for purchase of inventory prior to January 2021 have been settled. f their sales as cash, with the remaining 20% on credit. Of the credit sales, 70% is collected in the month of sale, 20% is collected one month o months after the sale. eck pay for the service in cash 100% of the time. nt and other fixed assets such as: cialised optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13200 and it is expected to last 5 years. ical cost of $30000 and depreciates at 20% per annum. Bed at $63600 and depreciate at 10% per annum. Group Information Factsheet Cash and Home Statement_udget Sales Budget Cost of Sales Budget Purchases Budget Selling 8. Admin Expense Budget Sched Type here to search o e N x (2 0 REDMI NOTE 6 PRO MI DUAL CAMERA PROIECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edits safer to stay in Protected View Enable Editing f Shop fittings were originally purchased at $63600 and depreciate at 10% per annum. All fixed assets have $0 residual value and are depreciated using the straight-line method of depreciation. Other Fixed Costs: Marketing expense of $900 per annum is paid evenly across 12 months. $3000 of general business insurance is paid in July every year. This insurance covers the period 1st Jan to 31st Dec. Bank account fees works out to be $48 per month and are paid at the start of each quarter. On average, the office supplies are purchased and expensed every month to the amount of $90. General council rates are $600 per year and are usually paid in December each year. The rates cover the period 1st Jan to 31st Dec. (50% store; 50% office) Rent is paid at the start of each quarter and works out to be $6400 per month. (80% store; 20% office) Water, gas and electricity are combined under on utility expense which adds up to $495 per quarter and is usually paid at the end of each quarter. (75% store; 25% *Note: Quarter 1 runs from 1 Jan-31 Mar; Quarter 2 runs from 1 Apr - 30 Jun: Quarter 3 runs from 1 Jul - 30 Sep: Quarter 4 runs from 1 Oct - 31 Dec. Group Information FactSheet Casi_Budget Sales Budget Cost of Sales Budget Purchases Budget & Admin Expense Budget Sched O Type here to search O 15:48 ACO ENG 21-05-2020 REDMI NOTE 6 PRO MI DUAL CAMERA 563600 and depreciate at 10% per annum. ere depreciated using the straight-line method of depreciation. d evenly across 12 months. July every year. This insurance covers the period 1st Jan to 31st Dec. month and are paid at the start of each quarter. and expensed every month to the amount of $90. are usually paid in December each year. The rates cover the period 1st Jan to 31st Dec. (50% store; 50% office) orks out to be $6400 per month. (80% store; 20% office) er on utility expense which adds to $495 per quarter and is usually paid at the end of each quarter. (75% store; 25% office) arter 2 runs from 1 Apr - 30 Jun; Quarter 3 runs from 1 Jul - 30 Sep: Quarter 4 runs from 1 Oct - 31 Dec. Group Information Factsheet cash_Budget Income Statement_Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Sched Type here to search O Bi e REDMI NOTE 6 PRO MI DUAL CAMERA CACEI - File Home Insert Page Layout Formulas Chetna Sharma Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful les from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing C4 f CASH BUDGET Jan-21 Feb-21 Mar-21 Apr.21 May-21 Jun-21 Jul-21 Aug-21 OPENING CASH BALANCE CASH INFLOWS: Sep 21 Oct-21 Nov-21 Dec-21 5 TOTAL CASH AVAILABLE: 8 9 10 11 12 73 14 75 16 CASH OUTFLOWS 18 19 20 21 22 3 25 26 37 8 9 0 Group Information Fact Sheet Casheudget Incomestatement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Sched Type here to search O EI e N * @ B x (? AW ENG 1549 21-05-2020 REDMI NOTE 6 PRO MI DUAL CAMERA K UDGETED INCOME STATEMENT Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Revenues: Gross Profit Other Income: Operating Expenses: Selling Expenses General & Administrative Expenses: Group Information Factsheet Cash_Budget IncolyeStatement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Sched O Type here to search O BI e N Q00 W ENG REDMI NOTE 6 PRO MI DUAL CAMERA MAA103T1 2020 Budgeting Assignment(1) [Protected View] - Excel File Home Insert Page Layout Chetna Sharma Formulas Review View Help Tell me what you want to do PROTECTED VIEW Be careful-hles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing 3 x & fr Sales Budget B H M Sales Budget Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Sunglasses Expected Sales x Selling Price per Unit Sales Revenue($) Prescription Glasses Expected Sales Selling Price per Unit Sales Revenue ($) TOTAL Sales Revenue ($) Eye-Tests Expected Sales x Selling Price per Unit TOTAL Service Revenue (S) Group Information FactsheetCash Budget IncomeStatement Budget Sales Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Sched 2 AW ENG Type here to search o REDMI NOTE 6 PRO MI DUAL CAMERA MAA103 T1 2020 Budgeting Assignment (1) (Protected View] - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing A1 X fi Cost of Sales Budget D H Cost of Sales Budget 2 3 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 4 5 Sunglasses Expected Sales x Cost Price per Unit Cost of Sales ($) 8 9 Prescription Glasses Expected Sales x Cost Price per Unit Cost of Sales ($) TOTAL Cost of Sales (S) 10 11 12 13 14 15 16 177 18 19 20 21 22 22 25 23 24 25 26 27 28 29 30 21 Group Information Factsheet cash blogeancomestatement Budget Sch Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Typ here to search REDMI NOTE 6 PRO MI DUAL CAMERA O Logout Formulas Wate Renew View Help Tell me what you want to do PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing A1 *** Purchases Budget Purchases Budget 2 3 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 4 Aug-21 5 6 Expected Sales Sunglasses) add: Ending Inventory Requirement Total Units Required: tess: Beginning Inventory Total Purchase Units: Sunglasses 7 8 9 x Cost (S) per Unit Total Purchase Cost ($) 10 11 12 13 Expected Sales (Prescription Glasses) add: Ending Inventory Requirement Total Units Required: 14 Prescription Glasses 15 16 Jess: Beginning Inventory Total Purchase Units: x Cost (S) per Unit Total Purchase Cost (S) 17 18 19 20 Total Overall Purchase Cost (S) 21 22 23 24 > Group Information Fact Sheet Cash Budget Income Statement_Budget Sales Budget Cost of Sales Budget Pulshases Budget Selling 8. Admin Expens Type here to search i e N REDMI NOTE 6 PRO MI DUAL CAMERA MAA103 T1 2020 Budgeting Assignment (1) (Protected View] - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing A1 x & fr Selling, General, and Administrative Expense Budget D E F UAB Selling, General, and Administrative Expense Budget 1 2 3 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-2: Selling Expenses 6 7 8 9 10 11 12 13 4 Total Selling Expenses General & Administrative Expenses 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Cash Budget Incomestatement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expe Group Information Fact Sheet REDMI NOTE 6 PRO MI DUAL CAMERA O NE MAA103 T1 2020 Budgeting Assignment (1) (Protected View - Excel File. Home Insert Page Layout Formulas Data Review View Help Chetna Sharm Tell me what you want to do PROTECTED VIEW Be careful--files from the Intemet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing A1 ** Schedule of Expected Cash Collections from Customers B D E G Schedule of Expected Cash Collections from Customers 2 3 4 5 Jan-21 Feb-21 Mar 21 Apr-21 May-21 Jun-21 Cash Sales Credit Sales Jul-21 Aug-21 Sep-21 Oct-21 6 8 9 TOTAL CASH COLLECTIONS 10 17 12 73 14 15 16 17 18 19 20 21 2 3 4 5 6 Cash Budget Income Statement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Schedule of Cash Collection Scheduled We he e to REDMI NOTE 6 PRO MI DUAL CAMERA O e TD 9:02 PM MAA103 T1 2..ssignment (1) Group_Information FactSheet Cash_Budget Incomes ... FactSheet - Data on 2019 Financial Year Zetore. DI 35 10 135 12 111 $ LI ter che department ho hodnote monta para pema Fatherer. Jeremyerert und roll to mong ito toronto better the precios do you can do Me peyper www.herad accedere caring for check the The busirene referent and other ache 2013 Feb www The www.cda. Showing writy purchased awn fred wheeltele decided in the regrettede den Sher Bus ang porme perdarymo scopre es un hoy you. There are con pelo seu Dec mais efter dette ville proces space General conduwper yerdy paid in December each you. This cover the periode dalt Dec rent paid teacher and more to be perche i ondore 12:50 PM Group Information Fact Sheet Cash Budget Income Statement_Budget Sales Budget Cost of Sales Budget Pulshases Budget Selling 8. Admin Expens Type here to search i e N REDMI NOTE 6 PRO MI DUAL CAMERA MAA103 T1 2020 Budgeting Assignment (1) (Protected View] - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing A1 x & fr Selling, General, and Administrative Expense Budget D E F UAB Selling, General, and Administrative Expense Budget 1 2 3 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-2: Selling Expenses 6 7 8 9 10 11 12 13 4 Total Selling Expenses General & Administrative Expenses 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Cash Budget Incomestatement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expe Group Information Fact Sheet REDMI NOTE 6 PRO MI DUAL CAMERA O NE MAA103 T1 2020 Budgeting Assignment (1) (Protected View - Excel File. Home Insert Page Layout Formulas Data Review View Help Chetna Sharm Tell me what you want to do PROTECTED VIEW Be careful--files from the Intemet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing A1 ** Schedule of Expected Cash Collections from Customers B D E G Schedule of Expected Cash Collections from Customers 2 3 4 5 Jan-21 Feb-21 Mar 21 Apr-21 May-21 Jun-21 Cash Sales Credit Sales Jul-21 Aug-21 Sep-21 Oct-21 6 8 9 TOTAL CASH COLLECTIONS 10 17 12 73 14 15 16 17 18 19 20 21 2 3 4 5 6 Cash Budget Income Statement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Schedule of Cash Collection Scheduled We he e to REDMI NOTE 6 PRO MI DUAL CAMERA O e TD 9:02 PM MAA103 T1 2..ssignment (1) Group_Information FactSheet Cash_Budget Incomes ... FactSheet - Data on 2019 Financial Year Zetore. DI 35 10 135 12 111 $ LI ter che department ho hodnote monta para pema Fatherer. Jeremyerert und roll to mong ito toronto better the precios do you can do Me peyper www.herad accedere caring for check the The busirene referent and other ache 2013 Feb www The www.cda. Showing writy purchased awn fred wheeltele decided in the regrettede den Sher Bus ang porme perdarymo scopre es un hoy you. There are con pelo seu Dec mais efter dette ville proces space General conduwper yerdy paid in December each you. This cover the periode dalt Dec rent paid teacher and more to be perche i ondore 12:50 PM