Fill in the form according to the information available

You (and your team) work in a boutique firm called 'Business Advisory Pty. Ltd.', a business that provides advisory services to other businesses. Your role in the firm is a business consultant providing advice to business clients. To this end, you are often required to produce budgetary reports and present such reports to clients. Mr. James Hunter and Dr Olivia Ng own an Optometry business trading under the name "i-Optometry" and they have approached you (and your team). Being a brick and mortar store located in Burwood, Victoria, i- Optometry is a business that has traditionally focused on selling eyewear such as sunglasses and prescription glasses. The business also provides optometry services to customers, mainly a comprehensive eye examination. James is in charge of the management of the business while Dr Ng, manages the optometry aspects of the business. As part of their business operations, i-Optometry retails the following types of eyewear: Sunglasses retail on average for $200 per pair of glasses. It costs $60 per pair and the business purchases these from a local supplier. Prescription reading glasses retail for $150 each. It costs $80 to secure from the same local supplier. i-Optometry also provide comprehensive eye tests to clients who wish to assess eye health. The price of a comprehensive eye test is $75. As part of the eye-test, the Optometrist will examine the eyes, detect, diagnose and manage vision problems, and assess eye health. Optometrists can prescribe and fit glasses or contact lenses. Optometrists can also advise you on many aspects of your eye health. It is now the end of 2019. The clients have been thinking of stepping their business up to the next level and so they have approached your firm for some business advice. Specifically, they have listed some potential projects which can be implemented starting from 1st January 2020 as follows: #1 Expansion Project: The owners believe that they can improve business by expanding their storefront location. Specifically, they would like to increase the floorspace of the existing premises to include some additional display cabinets and expand the number of eye-test rooms to reduce customer wait-time. Out of all the projects this has the greatest initial capital requirements. #2 Cost Management Strategy: James suggests that selling prescription glasses does not produce enough margin. He has proposed that they focus on the sunglasses and other casual eyewear products and further increase the margins by changing suppliers. The new supplier will provide slightly inferior products but will be much cheaper than the current supplier. James would also introduce a number of other cost-cutting initiatives such as reduced wages, and energy usage. #3 Advanced Marketing Campaign Olivia has suggested that the current business model works well but they simply need to expand marketing. She believes that if more clients came to the business they can improve revenues. Specifically, if the business paid for an advertising agency to help set up an online portal, advertise in the local newspaper, put up social media ads, etc. more people will come to do eye tests. Based on her estimates, Olivia believes that while eye-tests count for a smaller proportion of revenue, they are strongly tied to the sale of prescription glasses, so the business should focus on eye-care rather than retailing sunglasses. Note that the cost of this project is a repeated amount that the business will need to pay every month on top of any existing marketing expenses. Fact Sheet Jan-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 160 176 1 51 1 26 116 99 84 73 130 160 1 1751 188 Sales Volume - Sunglassses Service Volume - No. of Clie88 97 | 109 121 126 | 113 | 121 139 1 53 1 67 188 I 194 Selling Price - Sunglasses ######## Cost Price - Sunglasses $60.00 Selling Price - Prescriptic ######## Cost Price - Prescription & $80.00 Service Revenue $75.00 Number of Sale Assistants: 2 Wage Rate per Month per Per $4,000 Number of Office Staff: 1 Wage Rate per Month per Per $1,500 Number of Optometrists 2 Wage Rate per Month per Per $6,500 Additional Information for Jan 2019 - Dec 2019: 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 2020. 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. Additionally, all purchases with the current supplier are on a credit basis, with 50% of the amount settled in the same month of purchase and the remaining 50% settled one month after the month of purchase. 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: Specialised optometry equipment to provide the comprehensive eye-tests. The total cost of equipment is $10560 and it is expected to last 4 years. Other office equipment has a historical cost of $30000 and depreciates at 20% per annuin. 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 for Jan 2019 - Dec 2019: Marketing expense of $900 per annum is paid evenly across 12 months. $3000 of annual general business insurance is paid in July every year. 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. Council rates are $600 per year and are usually paid in December each year, t the start of each quarter and works out to be $6400 per month. Water, gas and electricity are combined under on utility expense which adds up $495 per quarter and is usually paid at the end of each quarter. **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 D Selling, General, and Administrative Expense Budget | Jan-20 Feb-20 | Mar-20 Apr-20 May-20 | Jun-20 Jul-20 . Aug-20 Sep-20 Oct-20 | Nov-20 | Dec-20 | TOTAL Selling Expenses Total Selling Expenses L T D General & Administrative Expenses Total General & Admin. Expenses Total Selling & Administrative Expenses ($) Schedule of Expected Cash Collections from Customers Jan-20 Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 Oct-20 Nov-20 Dec-20 Cash Sales Credit Sales TOTAL CASH COLLECTIONS Schedule of Expected Payments to Suppliers Jan-20 Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 Oct-20 Nov-20 Dec-20 Cash Purchases Credit Purchases TOTAL CASH PAYMENTS You (and your team) work in a boutique firm called 'Business Advisory Pty. Ltd.', a business that provides advisory services to other businesses. Your role in the firm is a business consultant providing advice to business clients. To this end, you are often required to produce budgetary reports and present such reports to clients. Mr. James Hunter and Dr Olivia Ng own an Optometry business trading under the name "i-Optometry" and they have approached you (and your team). Being a brick and mortar store located in Burwood, Victoria, i- Optometry is a business that has traditionally focused on selling eyewear such as sunglasses and prescription glasses. The business also provides optometry services to customers, mainly a comprehensive eye examination. James is in charge of the management of the business while Dr Ng, manages the optometry aspects of the business. As part of their business operations, i-Optometry retails the following types of eyewear: Sunglasses retail on average for $200 per pair of glasses. It costs $60 per pair and the business purchases these from a local supplier. Prescription reading glasses retail for $150 each. It costs $80 to secure from the same local supplier. i-Optometry also provide comprehensive eye tests to clients who wish to assess eye health. The price of a comprehensive eye test is $75. As part of the eye-test, the Optometrist will examine the eyes, detect, diagnose and manage vision problems, and assess eye health. Optometrists can prescribe and fit glasses or contact lenses. Optometrists can also advise you on many aspects of your eye health. It is now the end of 2019. The clients have been thinking of stepping their business up to the next level and so they have approached your firm for some business advice. Specifically, they have listed some potential projects which can be implemented starting from 1st January 2020 as follows: #1 Expansion Project: The owners believe that they can improve business by expanding their storefront location. Specifically, they would like to increase the floorspace of the existing premises to include some additional display cabinets and expand the number of eye-test rooms to reduce customer wait-time. Out of all the projects this has the greatest initial capital requirements. #2 Cost Management Strategy: James suggests that selling prescription glasses does not produce enough margin. He has proposed that they focus on the sunglasses and other casual eyewear products and further increase the margins by changing suppliers. The new supplier will provide slightly inferior products but will be much cheaper than the current supplier. James would also introduce a number of other cost-cutting initiatives such as reduced wages, and energy usage. #3 Advanced Marketing Campaign Olivia has suggested that the current business model works well but they simply need to expand marketing. She believes that if more clients came to the business they can improve revenues. Specifically, if the business paid for an advertising agency to help set up an online portal, advertise in the local newspaper, put up social media ads, etc. more people will come to do eye tests. Based on her estimates, Olivia believes that while eye-tests count for a smaller proportion of revenue, they are strongly tied to the sale of prescription glasses, so the business should focus on eye-care rather than retailing sunglasses. Note that the cost of this project is a repeated amount that the business will need to pay every month on top of any existing marketing expenses. Fact Sheet Jan-2019 Feb-2019 Mar-2019 Apr-2019 May-2019 Jun-2019 Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 160 176 1 51 1 26 116 99 84 73 130 160 1 1751 188 Sales Volume - Sunglassses Service Volume - No. of Clie88 97 | 109 121 126 | 113 | 121 139 1 53 1 67 188 I 194 Selling Price - Sunglasses ######## Cost Price - Sunglasses $60.00 Selling Price - Prescriptic ######## Cost Price - Prescription & $80.00 Service Revenue $75.00 Number of Sale Assistants: 2 Wage Rate per Month per Per $4,000 Number of Office Staff: 1 Wage Rate per Month per Per $1,500 Number of Optometrists 2 Wage Rate per Month per Per $6,500 Additional Information for Jan 2019 - Dec 2019: 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 2020. 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. Additionally, all purchases with the current supplier are on a credit basis, with 50% of the amount settled in the same month of purchase and the remaining 50% settled one month after the month of purchase. 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: Specialised optometry equipment to provide the comprehensive eye-tests. The total cost of equipment is $10560 and it is expected to last 4 years. Other office equipment has a historical cost of $30000 and depreciates at 20% per annuin. 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 for Jan 2019 - Dec 2019: Marketing expense of $900 per annum is paid evenly across 12 months. $3000 of annual general business insurance is paid in July every year. 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. Council rates are $600 per year and are usually paid in December each year, t the start of each quarter and works out to be $6400 per month. Water, gas and electricity are combined under on utility expense which adds up $495 per quarter and is usually paid at the end of each quarter. **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 D Selling, General, and Administrative Expense Budget | Jan-20 Feb-20 | Mar-20 Apr-20 May-20 | Jun-20 Jul-20 . Aug-20 Sep-20 Oct-20 | Nov-20 | Dec-20 | TOTAL Selling Expenses Total Selling Expenses L T D General & Administrative Expenses Total General & Admin. Expenses Total Selling & Administrative Expenses ($) Schedule of Expected Cash Collections from Customers Jan-20 Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 Oct-20 Nov-20 Dec-20 Cash Sales Credit Sales TOTAL CASH COLLECTIONS Schedule of Expected Payments to Suppliers Jan-20 Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 Oct-20 Nov-20 Dec-20 Cash Purchases Credit Purchases TOTAL CASH PAYMENTS