Question: please slove task 4 for me Include your visualizations as images. Be sure to use appropriate titles and labels. Task 4 - Price consistency The
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 avallable, 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
