urgently need a answer difficult in the cash budget, income statement budget, purchase budget and selling and admin expense budget.

Jul-2019 165 179 217 Aug-2019 Sep-2019 Oct 2019 Nov-2019 Dec 2019 139 130 160 125 189 103 94 120 127 85 109 115 8 Jan-2019 Feb-2019 Mar 2019 Apr 2019 May-2019 Jun-2019 Sales Volim Sunglasses 160 168 119 371 Sales Volume Prescription glas 98 103 97 105 135 Service Volume. No, of clients 85 59 94 99 93 123 Selling Price - Sunglasses $ 200.00 Cost Price : Sunglasses $ 60.00 Selling Price - Prescription glasses $ 150.00 Cost Price Prescription glasses $ R0,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 2 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 $3700 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 mont's sales. You can assure starting inventory for en 2021 to be units for both sunglasses and prescription glasses. Additionally, you can asume that all credit amounts for purchase of inventory prior to Jernuary 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 tylcally will have 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 GroupInformation Factsheet Laudenestatement Budget Sales Ludget Color Ses Budget Purchases budget selling Adminip Type here to search e Number of Optometris 2 Wage Rate per Employee per Month $6,500 Addrional Information: Bottle and Clinio are partner within the business and each of the draws an amant or $1600 per month. Each partner plans on increasing the dawno preth arting fromdanuary of 2021. As the manager, James keeps a close eye on inventory management and weuld like to always maintain a monthly ending inventory requirement of 30% of next montiranoucans same starting inventory for Jan 2021 to be o units for both sunglasses and prescriptiongazes. Additionally, you can assume that all credit armounts for purcharacteritoyener to ary 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 purchase. You can assume that all credit amounts for purchase of inventory prior to January 2021 have been settled The business typically will have 30% of their sales a 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 end 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 hasareree of equipment and other lixed 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 amum. Shop fittings were originally purchased at $63600 and depreciate at 10% per annum Al fixed assets have 50 residual value and are depreciated using the straight-line method of depreciation Other Fixed Costs Marketing expense of $900 per arrum is paid everly across 12 months non Group Information Factsheet suuden Budget Sales Budget Cost of Sales Budget Purchases budge! Selling & Admin : Type here to search O Si e 00 CH Other Fixed Costs Marceting 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 Cec. (50% store; 50% office! Rent is paid at the start of each quorter and works out to be $5400 per month. (90% 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 Budgetcom Budget Sales Budget Cost of Sales Budget Purchases budget Sel 1 Type here to search N O I e MAA103T12020 Budgeting Assignment (1) - Tde PoLayout Formu Data Hep Tell me what you want to do C. A A Cut COM Formatter Thule W Text Merge Center BIU Accent Accents Cordonna Fang. Title Commal KIKA Hun X FactSheet - Data on 2019 Financial Year 143 160 139 103 94 130 94 85 188 127 115 Jan-2019 Feb-2019 Mar-2019 Apr 2019 May-2019 Jun-2019 Jul-2019 Sles Volume Sunglasses 160 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 168 148 138 171 Sales Volume Prescription glasses 94 165 175 98 103 97 IOS 135 129 Service Volume No. of Clients 88 85 89 94 120 98 123 117 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 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 53200 per month starting from Lanuary of 2021 As the manager, lames 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 Group intimation Facisheet CLUSE income on budget sales Budget Cost of Sales Budget Purchases Budget seling & Admin Expense judget Sched-1 Type here to search RI e Paste D COPY Format Painter Cupboard BIU- 10.A Wrap Text sa da Merge Center 09% AC Fort Accents Conditional Format Comma Formatting. The styles Coral Alignment cs et e 1 Number X Additional Information: Both lames 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 $1200 per month starting from January of 2021 As the manager, lames 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 lan 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 lanuary 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, 7096 is collected in the month of sale, 20% in 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 eve-tests. The total cost of equipment is $13200 and it is expected to last year Other office equipment has a historical cost of $30000 and depreciates at 20% per annum Shop fittings were originally purchased at S63600 and depreciate at 10% per annum Allfixed assets have 50 residual value and are depreciated using the straight-line method of depreciation, neka terete Group information Factsheet gel Income Sales Budget Cost of Sales Budget Purchases Budget Seling AGT Lipense fudget Type here to search O e AR * hp ther 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 50 residual value and are depreciated 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 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 tates 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 stan of each quarter and works out to be S6400 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 ban-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 Fact Sheet Ready Sales udget Cost of Sales Budget Purchases Budget Seung & Admin Expertse Budget Type here to search O hop ,00 = S% , Merge & Center 40 .00 Conditional Formal as Formatting - Table Paste PE Copy Format Painter Clipboard BIU 12.0.A. Number Alignment N Font C5 fr FactSheet - Data on 2019 Financial Year Jan-2019 Feb-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 160 168 143 148 138 171 94 98 103 97 108 135 85 89 94 88 98 129 Jul-2019 165 129 117 Aug-2019 Sep-2019 Oct-2019 139 130 160 103 94 88 94 85 80 Sales Volume - Sunglassses Sales Volume - Prescription glass Service Volume - No. of Clients Nov-2019 Dec-2019 175 188 120 127 109 115 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 Months $ 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 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 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 optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13200 and it is expected to last 5 years REDMI NOTE 6 PRO Othequipment has a historical cost of $30000 and depreciates at 20% per annum MI DUAL CAMERA Shop fittings were originally purchased at $63600 and depreciate at 10% per annum Sales Budget Cost of Sales Budget Purchases Budget Selling & Jul-2019 165 179 217 Aug-2019 Sep-2019 Oct 2019 Nov-2019 Dec 2019 139 130 160 125 189 103 94 120 127 85 109 115 8 Jan-2019 Feb-2019 Mar 2019 Apr 2019 May-2019 Jun-2019 Sales Volim Sunglasses 160 168 119 371 Sales Volume Prescription glas 98 103 97 105 135 Service Volume. No, of clients 85 59 94 99 93 123 Selling Price - Sunglasses $ 200.00 Cost Price : Sunglasses $ 60.00 Selling Price - Prescription glasses $ 150.00 Cost Price Prescription glasses $ R0,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 2 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 $3700 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 mont's sales. You can assure starting inventory for en 2021 to be units for both sunglasses and prescription glasses. Additionally, you can asume that all credit amounts for purchase of inventory prior to Jernuary 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 tylcally will have 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 GroupInformation Factsheet Laudenestatement Budget Sales Ludget Color Ses Budget Purchases budget selling Adminip Type here to search e Number of Optometris 2 Wage Rate per Employee per Month $6,500 Addrional Information: Bottle and Clinio are partner within the business and each of the draws an amant or $1600 per month. Each partner plans on increasing the dawno preth arting fromdanuary of 2021. As the manager, James keeps a close eye on inventory management and weuld like to always maintain a monthly ending inventory requirement of 30% of next montiranoucans same starting inventory for Jan 2021 to be o units for both sunglasses and prescriptiongazes. Additionally, you can assume that all credit armounts for purcharacteritoyener to ary 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 purchase. You can assume that all credit amounts for purchase of inventory prior to January 2021 have been settled The business typically will have 30% of their sales a 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 end 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 hasareree of equipment and other lixed 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 amum. Shop fittings were originally purchased at $63600 and depreciate at 10% per annum Al fixed assets have 50 residual value and are depreciated using the straight-line method of depreciation Other Fixed Costs Marketing expense of $900 per arrum is paid everly across 12 months non Group Information Factsheet suuden Budget Sales Budget Cost of Sales Budget Purchases budge! Selling & Admin : Type here to search O Si e 00 CH Other Fixed Costs Marceting 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 Cec. (50% store; 50% office! Rent is paid at the start of each quorter and works out to be $5400 per month. (90% 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 Budgetcom Budget Sales Budget Cost of Sales Budget Purchases budget Sel 1 Type here to search N O I e MAA103T12020 Budgeting Assignment (1) - Tde PoLayout Formu Data Hep Tell me what you want to do C. A A Cut COM Formatter Thule W Text Merge Center BIU Accent Accents Cordonna Fang. Title Commal KIKA Hun X FactSheet - Data on 2019 Financial Year 143 160 139 103 94 130 94 85 188 127 115 Jan-2019 Feb-2019 Mar-2019 Apr 2019 May-2019 Jun-2019 Jul-2019 Sles Volume Sunglasses 160 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 168 148 138 171 Sales Volume Prescription glasses 94 165 175 98 103 97 IOS 135 129 Service Volume No. of Clients 88 85 89 94 120 98 123 117 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 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 53200 per month starting from Lanuary of 2021 As the manager, lames 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 Group intimation Facisheet CLUSE income on budget sales Budget Cost of Sales Budget Purchases Budget seling & Admin Expense judget Sched-1 Type here to search RI e Paste D COPY Format Painter Cupboard BIU- 10.A Wrap Text sa da Merge Center 09% AC Fort Accents Conditional Format Comma Formatting. The styles Coral Alignment cs et e 1 Number X Additional Information: Both lames 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 $1200 per month starting from January of 2021 As the manager, lames 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 lan 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 lanuary 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, 7096 is collected in the month of sale, 20% in 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 eve-tests. The total cost of equipment is $13200 and it is expected to last year Other office equipment has a historical cost of $30000 and depreciates at 20% per annum Shop fittings were originally purchased at S63600 and depreciate at 10% per annum Allfixed assets have 50 residual value and are depreciated using the straight-line method of depreciation, neka terete Group information Factsheet gel Income Sales Budget Cost of Sales Budget Purchases Budget Seling AGT Lipense fudget Type here to search O e AR * hp ther 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 50 residual value and are depreciated 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 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 tates 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 stan of each quarter and works out to be S6400 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 ban-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 Fact Sheet Ready Sales udget Cost of Sales Budget Purchases Budget Seung & Admin Expertse Budget Type here to search O hop ,00 = S% , Merge & Center 40 .00 Conditional Formal as Formatting - Table Paste PE Copy Format Painter Clipboard BIU 12.0.A. Number Alignment N Font C5 fr FactSheet - Data on 2019 Financial Year Jan-2019 Feb-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 160 168 143 148 138 171 94 98 103 97 108 135 85 89 94 88 98 129 Jul-2019 165 129 117 Aug-2019 Sep-2019 Oct-2019 139 130 160 103 94 88 94 85 80 Sales Volume - Sunglassses Sales Volume - Prescription glass Service Volume - No. of Clients Nov-2019 Dec-2019 175 188 120 127 109 115 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 Months $ 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 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 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 optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13200 and it is expected to last 5 years REDMI NOTE 6 PRO Othequipment has a historical cost of $30000 and depreciates at 20% per annum MI DUAL CAMERA Shop fittings were originally purchased at $63600 and depreciate at 10% per annum Sales Budget Cost of Sales Budget Purchases Budget Selling &