Question
ACCOUNTING QUESTION: Complete the budgeted income statement based on the scenario below (URGENT PLEASE) In this assignment, you need to produce a budget report for
ACCOUNTING QUESTION: Complete the budgeted income statement based on the scenario below (URGENT PLEASE)
In this assignment, you need to produce a budget report for a business based on one of the three proposals you choose. This assignment includes preparing a budgeted income statement. The case study is described in detail below.
You (and your team) work in a boutique firm called Business Advisory Pty. Ltd., a business that provides strategic and financial advice to other businesses. Your role in the firm is that of a business consultant. To this end, you are often required to produce financial forecasts and budget reports for clients. Mr. James Hunter and Dr. Olivia Ng (Optometrist) are business partners who have approached your firm looking for business advice. Given the current global COVID-19 pandemic, business has been slow and so the clients would like to take this opportunity and take their business to the next level. Their business is an optometry business trading under the name i-Optometry. The business is a brick-and-mortar store located in Burwood and retails eyewear, that is, sunglasses and prescription glasses.
They also provide optometry services to customers in the form of comprehensive eye-tests. As part of their business operations, i-Optometry retails the following types of eyewear:
Sunglasses retail for $200 each. It costs $60 each and the business purchases them from a local supplier.
Prescription glasses retail for $150 each. It costs $80 each to buy them from the same local supplier who provides the sunglasses.
i-Optometry also provide comprehensive eye-tests to customers who wish to assess eye health. The selling price of one comprehensive eye-test is $75.
James suggests that selling prescription glasses does not produce enough margin. He has proposed that they focus on sunglasses sales and further increase the margin by changing the supplier. The new supplier will provide slightly inferior products but will be much cheaper than the current supplier. James would also like to introduce several other cost-cutting initiatives such as reducing wages of some staff, getting rid of some features on the insurance policy, and reducing utility costs by going green which could also improve public image.
Additional Notes: Note that for the purposes of the financial forecasts and budgets, you can assume all items are GST free. Due to COVID-19, i-Optometry is effectively shut down and the owners are planning to reopen on 1st January 2021. This effectively means the year 2020 is a write-off and you can assume there to be no sales, costs, or purchases in December 2020.
your manager would like you and your team to complete the budgeted income statement for the cost management your team has selected and for the period between January 2021 to December 2021 inclusive.
-
To assist with your financial forecasts, the owners have provided you with information on 2019s figures as it is probably the most accurate representation of their normal business activities.
CASH BUDGET (ALREADY COMPLETED FOR REFERENCE)
Chosen Project: Cost Management Strategy Cost of Project: $ 0 Cash Balance at 31 Dec 2020: 422,604 By switching suppliers, the unit cost to purchase sunglasses will drop by 30% while the unit cost of prescription glasses will remain the same. James would like to keep the selling price of sunglasses the same. Due to the slightly less well known branding of the glasses, James believes that sales volume for the sunglasses will fall by 20% for each month in 2021 compared to the corresponding month in 2019. (e.g. Jan 2021's growth/decline is based on Jan 2019, Feb 2021's growth/decline is based on Feb 2019 etc). James believes that the prescription glasses don't make enough margin and so he would like to increase the selling price on prescription glasses by 10%. James believes that due to the increase in selling price, prescription glasses sale volume will decrease by 10% for each month in 2021 compared to the corresponding month in 2019. As a result of the decrease in prescription glasses demand, James estimates the eye-test service volume will also decrease by 20% for each month in 2021 compared to the corresponding month in 2019. The selling price of eye-tests will remain the same. The catch with the new supplier is that there will be a more stringent credit term in purchases of inventory. All purchases with the new supplier are still on a credit basis, however, 90% of the amount needs to be settled in the same month of purchase with the remaining 10% settled one month later. For credit term in sales of glasses, the business plans to continue its instore credit policy for their customers. To further reduce costs, James would like to reduce the salary of some staff. Specifically, he would like to reduce the office staff's and sale assistants' salary by 10%. The business will also be implementing 'green' measures to reduce the utilities consumption of water, gas and electricity by 20%. James also believes the business insurance has been a waste of money as they have never needed to make a claim. He plans to change the insurance policy to reduce the annual premium by 50%. All these increases/decreases are relative to 2019 amounts All other fixed costs will decrease by 10% based on 2019 amounts. After the 1st year of the new project, in 2022, both the service volume and sales volume are expcted to increase by 5% for each month in 2022 compared to the corresponding month in 2021. FactSheet - Data on 2019 Financial Year Jan-2019 184 89 81 Feb-2019 193 94 85 Mar-2019 168 99 90 Apr-2019 179 86 78 May-2019 169 97 88 Jun-2019 222 151 137 Jul-2019 213 144 131 Aug 2019 184 116 105 Sep-2019 134 105 95 Oct-2019 164 99 90 Nov-2019 179 132 120 Dec-2019 192 139 126 Sales Volume Sunglasses Sales Volume - Prescription glasses Service Volume - No. of Eye-tests Selling Price - Sunglasses Cost Price - Sunglasses 200.00 $ $ 60.00 Selling Price - Prescription glasses Cost Price - Prescription classes $ $ 150.00 80.00 Service Revenue per eye-test $ 75.00 Number of Sale Assistants: Wage Rate per Employee per Month 2 4,000 TE Number of Office Staff: Wage Rate per Employee per Month 1 4,500 5 Number of Optometrists Wage Rate per Employee per Month 2 6,500 $ Additional Information: Both James and Olivia are owners within the business and each of them draws an amount of $1879 per month. Each owner plans on increasing the drawings to $3758 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 the beginning inventory for Jan 2021 to be units for both sunglasses and prescription glasses All purchases of inventory 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 of sunglasses and prescription glasses as cash, with the remaining 20% on credit. Of the credit sales, 70% is collected in the month of sales, 20% is collected one month after the sales, and 10% is collected two months after the sales. You can assume that all credit amounts for sale of inventory prior to January 2021 have been settled All customers coming in for an eye-test pay for the service in cash 100% of the time. . The business has the following non-current assets: In 2019, the business purchased specialised optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13800 and it is expected to last 5 years. Other office equipment has a total cost of $30720 and depreciates at 20% per annum Shop fittings were originally purchased at $65520 and depreciate at 10% per annum. All non-current assets have 50 residual value and are depreciated using the straight-line method of depreciation. Other Fixed Costs: Marketing expense of $950 per annum is paid evenly across 12 months |$3120 of general business Insurance is paid in July every year. This insurance covers the period 1st Jan to 31st Dec every year. (100% office) Bank fees works out to be $78 per month and are paid at the start of each quarter . On average, the office supplies are purchased, paid and expensed every month to the amount of $110. General council rates are $852 per year and are usually paid in December every year. The rates cover the period 1st Jan to 31st Dec every year. (50% store: 50% office) Rent is paid at the start of each quarter and works out to be $6470 per month. (80% store; 20% office) Water, gas and electricity are combined under utility expense which adds up to $516 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 ; 1 - ; 3 4 CASH BUDGET TOTAL Jan 21 422,6040 Feb-21 406,613.0 Mar 21 410,445.0 Apr 21 412,407.0 May-21 396,694.0 Jun-21 398,866.0 Jul 21 413,925.0 Aug-21 408.286.0 Sep 21 415,059.c OPENING CASH BALANCE CASH INFLOWS: Oct 21 413,886.0 Nov 21 397,988.0 Dec 21 405.745.0 Cash Sales Credit Sales Collected 38,985.2 5,971.9 40,9712 7,983.7 38,665.2 8,4681 37,808.8 83576 38,435.6 8.290.3 54,574.8 10,598.1 52,2312 10,9116 43,632.8 9,910.7 35,326.0 8,160.5 38,153.2 8.146.4 45,793,6 9,132.2 48,649.2 10,063.9 513,2268 105,995.0 TOTAL CASH AVAILABLE: 467,561.0 455,568.0 457.578.0 458,574.0 443.420.0 464,039.0 477,068.0 461 829.0 458,545.0 460,185.0 452,914.0 464,459.0 619,222.0 11.331.4 72.0 0.0 CASH OUTFLOWS Payment to suppliers Marketing Expenses Insurance Bank Fees Office Supplies General Council Rate Rent Utilities Salary of Office Staff Salary of Sales Assistant Salary of optometrist Drawings 210.6 99.0 0.0 17,469.0 00 4,050.0 7,200.0 13,000.0 7,516.0 13.186.6 72.0 0.0 DD 99.0 0.0 0.0 00 4,050.0 7,200.0 13,000.0 7,516,0 12.820.8 72.0 0.0 00 99.0 0.0 0.0 4128 4,050.0 7,200.0 13,000.0 7,5160 12.263.0 72.0 0.0 210.6 99.0 0.0 17.469.0 0.0 4.050.0 7,200.0 13,000.0 7,516,0 12,616.8 72.0 0.0 0.0 99,0 0.0 0.0 0.0 4,050.0 7,200.0 13,000.0 7,516,0 17,764.3 72.0 0.0 0.0 99.0 0.0 0.0 412.8 4,050.0 7,200.0 13,000.0 7,516.0 17.605.4 4 72.0 1,5600 2106 99.0 0.0 17,469.0 00 4,050.0 7,200.0 13,000.0 7,516,0 14,8334 720 0.0 00 990 0.0 0.0 00 4,050.0 7,200.0 13,000.0 7,5160 12.309.6 72.0 0.0 0.0 99.0 0.0 0.0 4128 4,050.0 7,200.0 13,000.0 7,516,0 12.580.8 72.0 0.0 210.6 99.0 0.0 17 469.0 0.0 4,050.0 7,200.0 13,000.0 7,516,0 15.230.4 72.0 0.0 0.0 99.0 0.0 0.0 0.0 4,050.0 7,200.0 13,000.0 7,516,0 16.365.1 72.0 0.0 0.0 99.0 766.8 0.0 412.8 4,050.0 7,200.0 13,000.0 7,516.0 168.907.7 864.0 1,5600 8424 1.1880 766.8 69.8760 1,651 48,600.0 86,400.0 156,000.0 90,1920 626,848 Total Outflow CLOSING CASH BALANCE 60,948.0 406,613.0 45,1236 410,445.0 45,170.6 412,407.0 61,879.6 396,694.0 44,553.8 398,866.0 50,114.1 413,925.0 68,7820 408,286.0 46,7704 415,059.0 44,659.4 413,886.0 62,197.4 397,988.0 47,167.4 405,746.0 49,481.7 414,978.0 BUDGETED INCOME STATEMENT TO BE FILLED IN BUDGETED INCOME STATEMENT Jan 21 Feb-21 Mar-21 Apr-21 May 21 Jun-21 Jul-21 Aug-21 Sep-21 Oct 21 Now 21 Dec 21 TOTAL Gross Profit Other Income: Operating Expenses: Selling Expenses General & Administrative Expenses Total Operating Expense Net Operating Profit Non-Operating Income and Expenses Profit (Loss) before income tax Chosen Project: Cost Management Strategy Cost of Project: $ 0 Cash Balance at 31 Dec 2020: 422,604 By switching suppliers, the unit cost to purchase sunglasses will drop by 30% while the unit cost of prescription glasses will remain the same. James would like to keep the selling price of sunglasses the same. Due to the slightly less well known branding of the glasses, James believes that sales volume for the sunglasses will fall by 20% for each month in 2021 compared to the corresponding month in 2019. (e.g. Jan 2021's growth/decline is based on Jan 2019, Feb 2021's growth/decline is based on Feb 2019 etc). James believes that the prescription glasses don't make enough margin and so he would like to increase the selling price on prescription glasses by 10%. James believes that due to the increase in selling price, prescription glasses sale volume will decrease by 10% for each month in 2021 compared to the corresponding month in 2019. As a result of the decrease in prescription glasses demand, James estimates the eye-test service volume will also decrease by 20% for each month in 2021 compared to the corresponding month in 2019. The selling price of eye-tests will remain the same. The catch with the new supplier is that there will be a more stringent credit term in purchases of inventory. All purchases with the new supplier are still on a credit basis, however, 90% of the amount needs to be settled in the same month of purchase with the remaining 10% settled one month later. For credit term in sales of glasses, the business plans to continue its instore credit policy for their customers. To further reduce costs, James would like to reduce the salary of some staff. Specifically, he would like to reduce the office staff's and sale assistants' salary by 10%. The business will also be implementing 'green' measures to reduce the utilities consumption of water, gas and electricity by 20%. James also believes the business insurance has been a waste of money as they have never needed to make a claim. He plans to change the insurance policy to reduce the annual premium by 50%. All these increases/decreases are relative to 2019 amounts All other fixed costs will decrease by 10% based on 2019 amounts. After the 1st year of the new project, in 2022, both the service volume and sales volume are expcted to increase by 5% for each month in 2022 compared to the corresponding month in 2021. FactSheet - Data on 2019 Financial Year Jan-2019 184 89 81 Feb-2019 193 94 85 Mar-2019 168 99 90 Apr-2019 179 86 78 May-2019 169 97 88 Jun-2019 222 151 137 Jul-2019 213 144 131 Aug 2019 184 116 105 Sep-2019 134 105 95 Oct-2019 164 99 90 Nov-2019 179 132 120 Dec-2019 192 139 126 Sales Volume Sunglasses Sales Volume - Prescription glasses Service Volume - No. of Eye-tests Selling Price - Sunglasses Cost Price - Sunglasses 200.00 $ $ 60.00 Selling Price - Prescription glasses Cost Price - Prescription classes $ $ 150.00 80.00 Service Revenue per eye-test $ 75.00 Number of Sale Assistants: Wage Rate per Employee per Month 2 4,000 TE Number of Office Staff: Wage Rate per Employee per Month 1 4,500 5 Number of Optometrists Wage Rate per Employee per Month 2 6,500 $ Additional Information: Both James and Olivia are owners within the business and each of them draws an amount of $1879 per month. Each owner plans on increasing the drawings to $3758 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 the beginning inventory for Jan 2021 to be units for both sunglasses and prescription glasses All purchases of inventory 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 of sunglasses and prescription glasses as cash, with the remaining 20% on credit. Of the credit sales, 70% is collected in the month of sales, 20% is collected one month after the sales, and 10% is collected two months after the sales. You can assume that all credit amounts for sale of inventory prior to January 2021 have been settled All customers coming in for an eye-test pay for the service in cash 100% of the time. . The business has the following non-current assets: In 2019, the business purchased specialised optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13800 and it is expected to last 5 years. Other office equipment has a total cost of $30720 and depreciates at 20% per annum Shop fittings were originally purchased at $65520 and depreciate at 10% per annum. All non-current assets have 50 residual value and are depreciated using the straight-line method of depreciation. Other Fixed Costs: Marketing expense of $950 per annum is paid evenly across 12 months |$3120 of general business Insurance is paid in July every year. This insurance covers the period 1st Jan to 31st Dec every year. (100% office) Bank fees works out to be $78 per month and are paid at the start of each quarter . On average, the office supplies are purchased, paid and expensed every month to the amount of $110. General council rates are $852 per year and are usually paid in December every year. The rates cover the period 1st Jan to 31st Dec every year. (50% store: 50% office) Rent is paid at the start of each quarter and works out to be $6470 per month. (80% store; 20% office) Water, gas and electricity are combined under utility expense which adds up to $516 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 ; 1 - ; 3 4 CASH BUDGET TOTAL Jan 21 422,6040 Feb-21 406,613.0 Mar 21 410,445.0 Apr 21 412,407.0 May-21 396,694.0 Jun-21 398,866.0 Jul 21 413,925.0 Aug-21 408.286.0 Sep 21 415,059.c OPENING CASH BALANCE CASH INFLOWS: Oct 21 413,886.0 Nov 21 397,988.0 Dec 21 405.745.0 Cash Sales Credit Sales Collected 38,985.2 5,971.9 40,9712 7,983.7 38,665.2 8,4681 37,808.8 83576 38,435.6 8.290.3 54,574.8 10,598.1 52,2312 10,9116 43,632.8 9,910.7 35,326.0 8,160.5 38,153.2 8.146.4 45,793,6 9,132.2 48,649.2 10,063.9 513,2268 105,995.0 TOTAL CASH AVAILABLE: 467,561.0 455,568.0 457.578.0 458,574.0 443.420.0 464,039.0 477,068.0 461 829.0 458,545.0 460,185.0 452,914.0 464,459.0 619,222.0 11.331.4 72.0 0.0 CASH OUTFLOWS Payment to suppliers Marketing Expenses Insurance Bank Fees Office Supplies General Council Rate Rent Utilities Salary of Office Staff Salary of Sales Assistant Salary of optometrist Drawings 210.6 99.0 0.0 17,469.0 00 4,050.0 7,200.0 13,000.0 7,516.0 13.186.6 72.0 0.0 DD 99.0 0.0 0.0 00 4,050.0 7,200.0 13,000.0 7,516,0 12.820.8 72.0 0.0 00 99.0 0.0 0.0 4128 4,050.0 7,200.0 13,000.0 7,5160 12.263.0 72.0 0.0 210.6 99.0 0.0 17.469.0 0.0 4.050.0 7,200.0 13,000.0 7,516,0 12,616.8 72.0 0.0 0.0 99,0 0.0 0.0 0.0 4,050.0 7,200.0 13,000.0 7,516,0 17,764.3 72.0 0.0 0.0 99.0 0.0 0.0 412.8 4,050.0 7,200.0 13,000.0 7,516.0 17.605.4 4 72.0 1,5600 2106 99.0 0.0 17,469.0 00 4,050.0 7,200.0 13,000.0 7,516,0 14,8334 720 0.0 00 990 0.0 0.0 00 4,050.0 7,200.0 13,000.0 7,5160 12.309.6 72.0 0.0 0.0 99.0 0.0 0.0 4128 4,050.0 7,200.0 13,000.0 7,516,0 12.580.8 72.0 0.0 210.6 99.0 0.0 17 469.0 0.0 4,050.0 7,200.0 13,000.0 7,516,0 15.230.4 72.0 0.0 0.0 99.0 0.0 0.0 0.0 4,050.0 7,200.0 13,000.0 7,516,0 16.365.1 72.0 0.0 0.0 99.0 766.8 0.0 412.8 4,050.0 7,200.0 13,000.0 7,516.0 168.907.7 864.0 1,5600 8424 1.1880 766.8 69.8760 1,651 48,600.0 86,400.0 156,000.0 90,1920 626,848 Total Outflow CLOSING CASH BALANCE 60,948.0 406,613.0 45,1236 410,445.0 45,170.6 412,407.0 61,879.6 396,694.0 44,553.8 398,866.0 50,114.1 413,925.0 68,7820 408,286.0 46,7704 415,059.0 44,659.4 413,886.0 62,197.4 397,988.0 47,167.4 405,746.0 49,481.7 414,978.0 BUDGETED INCOME STATEMENT TO BE FILLED IN BUDGETED INCOME STATEMENT Jan 21 Feb-21 Mar-21 Apr-21 May 21 Jun-21 Jul-21 Aug-21 Sep-21 Oct 21 Now 21 Dec 21 TOTAL Gross Profit Other Income: Operating Expenses: Selling Expenses General & Administrative Expenses Total Operating Expense Net Operating Profit Non-Operating Income and Expenses Profit (Loss) before income taxStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started