required answer for cash budget, income statement budget, sales budget, cost of sales budget, purchase budget, selling &admin expense budget and schedule of cash collection. from jan 2021 to dec 2021

MAAGT12020 Budgeting Agent (1) Protected el- File Home Intert Page Layout Formula Date Review New Melo Tell me what you want to do PROTECTED VW ated on UPDATES AVAILARE Updares materne OreShare 1 1 Jan-2019 Feb-2019 Mar-2019 Sales Volume - Sunglassses Apr-2019 May-2019 Jun-2019 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov 160 168 143 148 138 171 Sales Volume - Prescription glasses 165 139 94 130 98 160 103 97 108 135 129 103 Service Volume - No. of Clients 94 SS 88 89 94 88 98 123 117 94 85 80 Selling Price - Sunglasses $ 200.00 Cost Price - Sunglasses $ 60.00 Selling Price - Prescription glasses $ 150.00 Cost Price - Prescription glasses $ 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 Wage Rate per Employee per Month $ 6,500 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 Sroup Factsheet Sales Budget Cost of sales logel ham udget Seng An Lepense Buget 2 Type here to search o e * $ 0 Ba MG 1241 20-5 MAA103T12020 Budgeting Assignment Protected V-bel File Hon Insert Page Layout Formulas Data Raw View Help Tell me what you want to do O ORCHID VIEW Beletrom there can connes det er en Protivi #nhatg UPDATES AVAILABLE Ure orice were to be led but for we need to do some : 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 $3 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 preseription 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. Groupon Factsheet 10 Shes Budget College Sel Selling & Admin Expense Budget Sched E Type here to search @AOLING Chema Shame MAAIGT1 2000 Budgeting Assignment (1) Protected View - Excel File Home Inert Page Layout Formel Data Review View Help Tell me what you want to do O PROTECTED VIEW le contesto internet con contain in you need infotected View 0 UPDATES AVAILABLE Octobet but first werd de mer 04 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 ist 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 590. General councli rates are $600 per year and are usually paid in December each year. The rates cover the period ist Jan to 31st Dec. (50% store: 50% office) Rent is paid at the start of each quarter and works out to be $5400 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% GoPro Factsheet Te udget Cost of Sales Ludget Purchases Budget Seling & Antonse dudget Sched 13:40 Type here to search o AOL @ End 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 S90. General council rates are $600 per year and are usually paid in December each year. The rates cover the period ist 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% st *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 Cogel income talem budget Sales Budget Cost Of Sales Budget Purchases Budget seling & Admin Expense Budget Stres Type here to search ABA ENG & 6 8 On MAIO 20 Bang Angren te latel Apar FactSheet - Data on 2019 Financial Year 160 165 Jan-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-20 Sales Volume -Sunglasses 168 143 148 138 171 139 130 160 175 Sales Volume - Prescription glasses 94 98 103 97 103 135 129 103 94 88 120 Service Volume - No. of Clients 85 89 94 89 98 123 117 94 85 80 109 Selling Price - Sunglasses $ 200.00 Cost Price - Sunglasses $ 60.00 Selling Price - Prescription glasses $ 150.00 Cost Price : Prescription glasses $ 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 por Employee per Month $ 4,500 Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Sellel Lleval Purchaul Seing A Lige 15.25 Type here search o * 40 g (NG Our Shame MAART 2 Autuleted Excel Talwr you do on 2019 Financial Year Ban-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 160 168 143 148 138 171 94 98 103 97 108 85 89 94 88 98 123 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 165 139 130 160 175 188 129 103 94 88 120 127 117 94 85 80 109 115 135 200.00 60.00 150.00 $ 80.00 75.00 2 $4,000 1 4,500 2 6,500 OSS Cost Purchases fugue Scling Annet Sched Type hearth OP Pi 15.25 20-05-2020 et me MAA: 1200 ng Agus thered Exce re Page Lay Fom M Help to me what you want to die POCTED VIEW Wivu wenye tinerari Both James and Olivia are partners within the business and each of them draws an amount of S1600 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 unlts 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. Tormitor fartsheet se odlof Sales budget Preses del Sing Admin Line Type here to search de R$ A OLAN 1927 20-622 Cherr MAA103 T1 23.20 Budgement protected Viol PorLayout View Help File Tell me what you want to do PORCHED VEN beste in contanthen you need to saler to her Enabled CA 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 hat all credit amounts for purchase of inventory prior to January 2021 have been settled, 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. ack 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. Optimation Factsheets Sales Budget Cost of Sales budget Purchases Budget Selling & Admin Expense fudget Scied Type here to search O E 24 View Nel way www x Shop fittings were originally purchased at $63600 and depreciate at 10% per annum Al fined assets have so residual value and are deprecated using the straight-line method of depreciation Other Fixed Costs: Marketing expense of S900 per annum is paid evenly across 12 months. 53000 of general business Insurance is paid in July every year. This Insurance covers the period ist len to 31st Dec. Bank account fees works out to be 543 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 Aprelun:Quarter 3 runs from 1 Jul - 30 SepQuarter 4 runs from 1 Oct 31 Dec. Sasa DIG TITI LOMBO 1 Type here to watch O ed at $63600 and depreciate at 10% per annum. e and are depreciated using the straight-line method of depreciation. ni is paid evenly across 12 months. paid in July every year. This insurance covers the period 1st Jan to 31st Dec. S per month and are paid at the start of each quarter. Irchased and expensed every month to the amount of $90. ar and 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) ed under on utility expense which adds up to $495 per quarter and is usually paid at the end of each quarter. (75% store; 25% office) Mar: Quarter 2 runs from 1 Apr - 30 Jun: Quarter 3 runs from 1001-30 Sep: Quarter 4 runs from 1 Oct - 31 Dec. GoupInformation Factsheet og Purchases Budget Sales Budget Cost of Sales Budget Selling & Admin Expense Budget Sched Type here to search e N 62 Ad 2 racioneel Dald Illalicial Jan-2019 160 Sales Volume Sunglassses Sales Volume - Prescription glasses Service Volume No. of Clients Feb-2019 168 98 89 Mar-2019 Apr-2019 May-2019 Jun-2019 143 148 138 171 103 97 108 135 94 88 98 123 Jul-2019 165 129 117 Aug-2019 Sep-2019 Oct-2019 Oct-2019 Nov-2019 Dec-2019 139 130 160 175 188 103 94 88 120 127 94 85 80 109 115 94 85 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: Wage Rate per Employee per Month $ 2 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 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 $3200 per 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 month's sales. You 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 purchase of 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 month after the 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 collected one month after Group_Information Factsheet Cash Budget Income Statement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling 8. Admin E FH Type here to search e N OC REDMI NOTE 6 PRO MI DUAL CAMERA Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Additional Information: Both James and Olivia are partners within the business and each of them draws an amount of $1500 per month. Each partner plans on increasing the drawings to $3200 per 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 month's sales. You 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 purchase of 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 month after the 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 collected one month 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 optomety equipment to provide comprehensive eye tests. The total cost of equipment is $13200 and it is expected to last 5 years. 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, 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 annurn is paid evenly across 12 months Group Information Factsheet Budge! Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget sched Type here to search O e N X REDMI NOTE 6 PRO MI DUAL CAMERA 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 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% office) "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 Cash Budget IncomeStatement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expens Type here to search O N REDMI NOTE 6 PRO MI DUAL CAMERA Enable Editing PROCIED VW Be care-ilestrom the Internet can contain rules. Une you need to edit it safe to stay in Protected View x 6 FactSheet - Data on 2019 Financial Year Jan-2019 Feb-2019 Mar 2019 Apr-2019 May-2019 Jun-2019 160 168 141 148 138 171 98 103 97 108 135 RS 89 944 88 98 123 Sales Volume - Sunglasses Sales Volume. Prescription glasses Service Volume No. of Cients Jul-2019 165 129 117 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 139 120 160 175 189 103 94 120 127 94 BS 109 181818 115 Selling Price - Sunglasses $ 200.00 Cost Price. Sunglasses $ 60.00 Selling Price - Prescription glasses $ 150.00 Cost Price : Prescription glasses $39.00 Servke Revenue $ 75.00 Number of Sale Andante 2 Wage Rate per Employee per Month $ 4,000 Number of Office Statt Wage Rate per Employee per Month $ 4,500 1 Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Additional Information Bom Jarnes and Olivia are partners within the business and each of the draws an amount of $1500 per month. Each partner plans on increasing the drawings to $3200 per 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 month's sales. You can same starting inventory for Jan 2021 to be o units for both sunglasses and prescription glasses. Additionally, you can assume that all credit amounts for purchase of inventory prior to Ianuary 2021 have been setded 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 month after the month of purchase. You can ame 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 collected one month after Group Information FactSheet Cash Budget Income statement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Bud Type here to search e Page Layout Formulas Enable Editing mehlestrom the Internet can contain viruses. Unless you need to eat it's safer to stay in Protected w 1 Wage Rate per Employee per Month $ 4,000 Number of Office Staft: 1 Ware Rate per Employee per Month $4,500 Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Additional Information: Both James and Olivia are partners within the business and each of them draws an amount of S1600 per month. Each partner plans on increasing the drawings to $3200 per month starting from January of 2021. As the manager, James keeps a dose eye on inventory management and would like to always maintain a monthly ending inventory requirement of 30% of next month's sales. You can assume starting inventory for Jan 2021 to be units for both sunglasses and prescription glasses. Additionally, you can assume that all credit amounts for purchase of inventory prior to January 2021 have been setded 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 month after the 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 collected one month 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 last 5 years, 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. All fixed assets have so residual value and are depreciated using the straight-line method of depreciation. Cost of Sales Budget Purchases Budget Selling & Admin Oh luad Cart Group Information Factsheet cash budget Sales Budget Incorrest Ludger Type here to search N MAAGT12020 Budgeting Agent (1) Protected el- File Home Intert Page Layout Formula Date Review New Melo Tell me what you want to do PROTECTED VW ated on UPDATES AVAILARE Updares materne OreShare 1 1 Jan-2019 Feb-2019 Mar-2019 Sales Volume - Sunglassses Apr-2019 May-2019 Jun-2019 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov 160 168 143 148 138 171 Sales Volume - Prescription glasses 165 139 94 130 98 160 103 97 108 135 129 103 Service Volume - No. of Clients 94 SS 88 89 94 88 98 123 117 94 85 80 Selling Price - Sunglasses $ 200.00 Cost Price - Sunglasses $ 60.00 Selling Price - Prescription glasses $ 150.00 Cost Price - Prescription glasses $ 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 Wage Rate per Employee per Month $ 6,500 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 Sroup Factsheet Sales Budget Cost of sales logel ham udget Seng An Lepense Buget 2 Type here to search o e * $ 0 Ba MG 1241 20-5 MAA103T12020 Budgeting Assignment Protected V-bel File Hon Insert Page Layout Formulas Data Raw View Help Tell me what you want to do O ORCHID VIEW Beletrom there can connes det er en Protivi #nhatg UPDATES AVAILABLE Ure orice were to be led but for we need to do some : 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 $3 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 preseription 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. Groupon Factsheet 10 Shes Budget College Sel Selling & Admin Expense Budget Sched E Type here to search @AOLING Chema Shame MAAIGT1 2000 Budgeting Assignment (1) Protected View - Excel File Home Inert Page Layout Formel Data Review View Help Tell me what you want to do O PROTECTED VIEW le contesto internet con contain in you need infotected View 0 UPDATES AVAILABLE Octobet but first werd de mer 04 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 ist 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 590. General councli rates are $600 per year and are usually paid in December each year. The rates cover the period ist Jan to 31st Dec. (50% store: 50% office) Rent is paid at the start of each quarter and works out to be $5400 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% GoPro Factsheet Te udget Cost of Sales Ludget Purchases Budget Seling & Antonse dudget Sched 13:40 Type here to search o AOL @ End 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 S90. General council rates are $600 per year and are usually paid in December each year. The rates cover the period ist 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% st *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 Cogel income talem budget Sales Budget Cost Of Sales Budget Purchases Budget seling & Admin Expense Budget Stres Type here to search ABA ENG & 6 8 On MAIO 20 Bang Angren te latel Apar FactSheet - Data on 2019 Financial Year 160 165 Jan-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-20 Sales Volume -Sunglasses 168 143 148 138 171 139 130 160 175 Sales Volume - Prescription glasses 94 98 103 97 103 135 129 103 94 88 120 Service Volume - No. of Clients 85 89 94 89 98 123 117 94 85 80 109 Selling Price - Sunglasses $ 200.00 Cost Price - Sunglasses $ 60.00 Selling Price - Prescription glasses $ 150.00 Cost Price : Prescription glasses $ 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 por Employee per Month $ 4,500 Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Sellel Lleval Purchaul Seing A Lige 15.25 Type here search o * 40 g (NG Our Shame MAART 2 Autuleted Excel Talwr you do on 2019 Financial Year Ban-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 160 168 143 148 138 171 94 98 103 97 108 85 89 94 88 98 123 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 165 139 130 160 175 188 129 103 94 88 120 127 117 94 85 80 109 115 135 200.00 60.00 150.00 $ 80.00 75.00 2 $4,000 1 4,500 2 6,500 OSS Cost Purchases fugue Scling Annet Sched Type hearth OP Pi 15.25 20-05-2020 et me MAA: 1200 ng Agus thered Exce re Page Lay Fom M Help to me what you want to die POCTED VIEW Wivu wenye tinerari Both James and Olivia are partners within the business and each of them draws an amount of S1600 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 unlts 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. Tormitor fartsheet se odlof Sales budget Preses del Sing Admin Line Type here to search de R$ A OLAN 1927 20-622 Cherr MAA103 T1 23.20 Budgement protected Viol PorLayout View Help File Tell me what you want to do PORCHED VEN beste in contanthen you need to saler to her Enabled CA 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 hat all credit amounts for purchase of inventory prior to January 2021 have been settled, 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. ack 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. Optimation Factsheets Sales Budget Cost of Sales budget Purchases Budget Selling & Admin Expense fudget Scied Type here to search O E 24 View Nel way www x Shop fittings were originally purchased at $63600 and depreciate at 10% per annum Al fined assets have so residual value and are deprecated using the straight-line method of depreciation Other Fixed Costs: Marketing expense of S900 per annum is paid evenly across 12 months. 53000 of general business Insurance is paid in July every year. This Insurance covers the period ist len to 31st Dec. Bank account fees works out to be 543 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 Aprelun:Quarter 3 runs from 1 Jul - 30 SepQuarter 4 runs from 1 Oct 31 Dec. Sasa DIG TITI LOMBO 1 Type here to watch O ed at $63600 and depreciate at 10% per annum. e and are depreciated using the straight-line method of depreciation. ni is paid evenly across 12 months. paid in July every year. This insurance covers the period 1st Jan to 31st Dec. S per month and are paid at the start of each quarter. Irchased and expensed every month to the amount of $90. ar and 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) ed under on utility expense which adds up to $495 per quarter and is usually paid at the end of each quarter. (75% store; 25% office) Mar: Quarter 2 runs from 1 Apr - 30 Jun: Quarter 3 runs from 1001-30 Sep: Quarter 4 runs from 1 Oct - 31 Dec. GoupInformation Factsheet og Purchases Budget Sales Budget Cost of Sales Budget Selling & Admin Expense Budget Sched Type here to search e N 62 Ad 2 racioneel Dald Illalicial Jan-2019 160 Sales Volume Sunglassses Sales Volume - Prescription glasses Service Volume No. of Clients Feb-2019 168 98 89 Mar-2019 Apr-2019 May-2019 Jun-2019 143 148 138 171 103 97 108 135 94 88 98 123 Jul-2019 165 129 117 Aug-2019 Sep-2019 Oct-2019 Oct-2019 Nov-2019 Dec-2019 139 130 160 175 188 103 94 88 120 127 94 85 80 109 115 94 85 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: Wage Rate per Employee per Month $ 2 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 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 $3200 per 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 month's sales. You 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 purchase of 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 month after the 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 collected one month after Group_Information Factsheet Cash Budget Income Statement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling 8. Admin E FH Type here to search e N OC REDMI NOTE 6 PRO MI DUAL CAMERA Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Additional Information: Both James and Olivia are partners within the business and each of them draws an amount of $1500 per month. Each partner plans on increasing the drawings to $3200 per 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 month's sales. You 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 purchase of 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 month after the 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 collected one month 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 optomety equipment to provide comprehensive eye tests. The total cost of equipment is $13200 and it is expected to last 5 years. 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, 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 annurn is paid evenly across 12 months Group Information Factsheet Budge! Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget sched Type here to search O e N X REDMI NOTE 6 PRO MI DUAL CAMERA 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 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% office) "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 Cash Budget IncomeStatement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expens Type here to search O N REDMI NOTE 6 PRO MI DUAL CAMERA Enable Editing PROCIED VW Be care-ilestrom the Internet can contain rules. Une you need to edit it safe to stay in Protected View x 6 FactSheet - Data on 2019 Financial Year Jan-2019 Feb-2019 Mar 2019 Apr-2019 May-2019 Jun-2019 160 168 141 148 138 171 98 103 97 108 135 RS 89 944 88 98 123 Sales Volume - Sunglasses Sales Volume. Prescription glasses Service Volume No. of Cients Jul-2019 165 129 117 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 139 120 160 175 189 103 94 120 127 94 BS 109 181818 115 Selling Price - Sunglasses $ 200.00 Cost Price. Sunglasses $ 60.00 Selling Price - Prescription glasses $ 150.00 Cost Price : Prescription glasses $39.00 Servke Revenue $ 75.00 Number of Sale Andante 2 Wage Rate per Employee per Month $ 4,000 Number of Office Statt Wage Rate per Employee per Month $ 4,500 1 Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Additional Information Bom Jarnes and Olivia are partners within the business and each of the draws an amount of $1500 per month. Each partner plans on increasing the drawings to $3200 per 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 month's sales. You can same starting inventory for Jan 2021 to be o units for both sunglasses and prescription glasses. Additionally, you can assume that all credit amounts for purchase of inventory prior to Ianuary 2021 have been setded 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 month after the month of purchase. You can ame 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 collected one month after Group Information FactSheet Cash Budget Income statement Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Bud Type here to search e Page Layout Formulas Enable Editing mehlestrom the Internet can contain viruses. Unless you need to eat it's safer to stay in Protected w 1 Wage Rate per Employee per Month $ 4,000 Number of Office Staft: 1 Ware Rate per Employee per Month $4,500 Number of Optometrists 2 Wage Rate per Employee per Month $ 6,500 Additional Information: Both James and Olivia are partners within the business and each of them draws an amount of S1600 per month. Each partner plans on increasing the drawings to $3200 per month starting from January of 2021. As the manager, James keeps a dose eye on inventory management and would like to always maintain a monthly ending inventory requirement of 30% of next month's sales. You can assume starting inventory for Jan 2021 to be units for both sunglasses and prescription glasses. Additionally, you can assume that all credit amounts for purchase of inventory prior to January 2021 have been setded 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 month after the 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 collected one month 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 last 5 years, 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. All fixed assets have so residual value and are depreciated using the straight-line method of depreciation. Cost of Sales Budget Purchases Budget Selling & Admin Oh luad Cart Group Information Factsheet cash budget Sales Budget Incorrest Ludger Type here to search N