Given Information: 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 superannuation, 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.

A) Complete the following table provided by the marketing department. You are required to complete the BUDGET column under 2021 only.

Marketing Department 2020 2021 Activities Budget ($) Actual ($) Budget ($) Actual ($) Market Research $25,000 $22,000 Owned Media $32,000 $28,000 (homepage, blog) Video advertising (You Tube) $150,000 $167,000 Social Media N/A N/A Advertisement 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