Hi, I can't answer the 2nd question. I would appreciate it if you could help me solve it. I have added the information given in the front section. It is at the bottom of the page.

Case Study: Scenario AFC Sharing is a transportation sharing company based in Australia. It runs electric scooters, electric bikes, and car-sharing systems in various cities in Australia. This company has been operating successfully for the last two years; however, the level of competition in the market is expected to increase due to new entrants in the market. Therefore, AFC Sharing decided to initiate the following - Marketing department: is engaged with social media marketing and, each month, different sales promotions will be conducted through the social media networks. - Five more employees will be employed and be placed in the marketing department to support their activities. I The budgets for the marketing department are expected to increase by 20%. - For social media marketing, relevant training will be organised and provided. 0 Accounting department: aims to support the marketing department by promptly approving the budgets and reimbursements and analysing efficiency for the marketing activities. The marketing department activities were conducted last year as follows: Marketing Department 2020 2021 Activities Budget ($1 Actual {5} Budget (5} Actual [$1 Market Research $25,000 $22,000 Owned Media $2.000 $28, 000 (homepage, blog) Video advertising (YouTube) $150,000 $167,000 333213233\": \"M W Creative Design $60,000 $70,000 Marketing software $120,000 $124,000 Equipment purchases $210,000 $215,000 Staff Salary $550,000 $590,000 Staff training $35,000 $44,000 Sales support tools $100,000 $210,000 New Service Development $120,000 $140,000 Total $1,452,000 $1,610,000 You have been appointed as the Accounting Department Manager. One of your tasks is to complete the budgeting for the Marketing department for the year 2021. After the consultation with the Marketing department manager, the marketing department manager has set up the goals and objectives for the marketing department for the year 2021 as follows: The goal: - Increased the number of service users {customers} by 15% more than the previous year by the end of 2021. \fThe objectives: . Gather 1 million followers at the social media network . Increase customer satisfaction rate by 10% - (currently 8.2 out of 10) Increased the service awareness by the sales promotions (targeted no of visitors in total: 800,000) Therefore, you and the marketing department manager have decided the following: . Due to the increased number of marketing activities in 2021, the budgets for the marketing department will be increased by 20% more than the actual spending in the year 2020. . Marketing software is to be subscribed from the year 2021, and the estimated subscription is $31,000 per annum. . Five full-time staff to be employed, and their total remuneration package, including the superannuateon, is $55,000 per employee. Staff training costs will be increased by $42,000 from the actual spending in 2020 as more training is planned. The creative design team will have the same budget as the one in 2020. Social Media Advertisement costs are estimated at $250,000. All other activities are estimated to be the same as the actual spending in 2020. Budgeting for the marketing department Question 1: In the first place, complete the following table provided by the marketing department. You are required to complete the BUDGET column under 2021 only! (PC 1.1 PE 1, KE 1, 6.1, 6.3) Marketing Department 2020 2021 Activities Budget ($) Actual ($) Budget ($) Actual ($) Market Research $25,000 $22,000 Owned Media (homepage, blog) $32,000 $28,000 Video advertising $150,000 $167,000 (YouTube) Social Media N/A Advertisement N/A Creative Design $60,000 $70,000 Marketing software $120,000 $124,000 Equipment purchases $210,000 $215,000 Staff Salary $550,000 $590,000 Staff training $85,000 $44,000 Sales support tools $100,000 $210,000 New Service Development $120,000 $140,000 Total $1,452,000 $1,610,000 Question 2: You are required to calculate the maximum funds (budgets) available for the marketing department in accordance with the scenario. (PC 1.2 PE 2, PE 6)