Task 5 - Process improvement Research the consulation process used in a typical veterinary clinic. Make sure you reference any sources, or indicate if you are basing your work on personal knowledge. Using BPMN swimlane diagrams, show how the spreadsheet you created in Task 4 can be applied to CRICOS Provider No. 00103D Page 3 of 5 ***Federation improve the processes at Happy Mutt Veterinary Hospital. Justify your approach in your report (approximately 150 words). Bonus challenge task (optional!) Disclaimer: This task is 100% optional, and you can receive full marks without attempting or completing it. It is intended to be a challenge if you are interested in such things, and the marks available do not reflect the significant research and effort required to implement it correctly. Tutors will not prioritize assistance for this challenge task. Optional task 5 Reimplement Tasks 1 and 4 using either Python or HTML+JavaScript. Write a brief overview of how to run your solution, and attach a zip file containing your code submission. There are no partial marks awarded for this bonus task - you must complete all features to attain the bonus marks. It is possible to attain full marks for this assignment without completing this challenge task. Task 3 - History visualization Using Excel, process the history spreadsheet and use any appropriate charts to visualize the following: - How consultations differ between animal types; - How prices or expences have changed over time; - How consultations have differed between veterinarians. You will need to find a way to use Excel to associate each consultation with a staff member. Describe your approach and your findings in your report (approximately 200-300 words). Include your visualizations as images. Be sure to use appropriate titles and labels. Task 4 - Price consistency The team are unhappy with some of the differences detected above, and would like to make them more consistent. For vaccinations and check-ups, the team would like to standardize the prices for each is the same for all small animals (birds, rabbits, and hamsters) and the same for all larger animals (dogs and cats). Using Excel, analyse the historical data you have available, and create a spreadsheet that allows Cynthia to enter the animal type and consultation type, and gives a quote amount. Ensure that your spreadsheet is usable - it should be simple and include appropriate text and formatting to make your spreadsheet easy to use by a member of the Happy Mutt Veterinary Hospital team (or by a University lecturer). It is up to you to determine an appropriate quoting method, however it's vital that the new system doesn't lose money compared to the previous approach. Describe and justify your approach in your report (approximately 150 words). Include how you tested your solution, and how you made sure the clinic is not worse off under your new approach. Task 5 - Process improvement Research the consulation process used in a typical veterinary clinic. Make sure you reference any sources, or indicate if you are basing your work on personal knowledge. Using BPMN swimlane diagrams, show how the spreadsheet you created in Task 4 can be applied to