Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please slove task 4 for me Include your visualizations as images. Be sure to use appropriate titles and labels. Task 4 - Price consistency The
please slove task 4 for me
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
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