ITECH1100 - The Digital Revolution, Practical Laboratory, Automate Business Process - Animal Clinic Case Study & Report Writing - IT Assignment Help

Assignment Task -                 
 

Learning Outcomes Assessed 

The following course learning outcomes are assessed by completing this assessment: 

A1. Prepare a basic solution to a business problem; 

A2. Select appropriate IT solutions for business functions; 

A3. Apply business information software for data visualization and analysis purposes. S1. Write basic programming logic; 

S3. Interpret and construct representations of business data flow and processes; 

K8. Outline the basic principles of programming. 

 

Scenario details 

The following scenario is fictional, and not based on any real veterinary clinic. It is also highly simplified, and should not be used as a basis for a real business management system. 

Complete Animal Clinic is a small veterinary clinic, working with domestic companion animals. Mostly they work with dogs, cats, and smaller animals such as hamsters and rabbits. 

Complete Animal Clinic is run by a team of two veterinarians, Amanda and Bhavesh, and one administrative staff member, Caesar.

 

Team hours 

Most of the time, team members work the following shifts at Complete Animal Clinic: 

Amanda works 7.5 hours on Mondays, Tuesdays, and Wednesdays; 

Bhavesh works 7.5 hours on Thursdays and Fridays; and 

Caesar works 6.5 hours every weekday. 

Costs 

Amanda, as the most experienced veterinarian, costs $50 per hour to employ. 

Bhavesh, as a veterinarian, costs $42 per hour to employ. 

Caesar costs $27 per hour to employ. 

These rates take into account other costs related to employment, you don't need to add any additional offsets. 

All staff are also entitled to four weeks of paid annual leave, during which casual replacements are required at a cost of $54 per hour for the veterinarians and $35 per hour for Caesar. 

During these four weeks, Amanda, Bhavesh, and Caesar continue to be paid. 

Fixed costs such as permits, rent, and insurance are $18000 per year, and monthly utility costs (such as electricity and gas) are $460 per month. 

 

Task 1 - Wages and Fixed Costs 

Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Complete Animal Clinic. Only include the above expenses. 

Your spreadsheet should be configured such that the working hours, hourly rates, and annual and monthly costs can be varied easily. 

After building the spreadsheet, use it to answer the following questions in your report: 

What is the projection of total costs for the next year, including labor, annual, and monthly costs? How much income does Complete Animal Clinic need per month to cover the above costs? What is the projection of labor costs only for the next year, if both veterinarians were to cost $50 per hour, but the clinic closed on Wednesday? 

Document your findings in your report (approximately 100 words). 

 

History data 

When customers attend Complete Animal Clinic, they have a consultation with whichever veterinarian is available that day. 

In order to improve their business processes, Caesar has been keeping records of each consultation for several months in a spreadsheet. 

This data includes a date, the consultation type, the animal type, the expenses incurred (such as tests, protective equipment, and so on) and the price charged.

 

Task 2 - History visualization 

Using Excel, process the history spreadsheet and use any appropriate charts to visualize: 

How one aspect of the business has changed over time (for example, prices, expenses, types of consultation, frequency of each animal, etc) and 

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 250-400 words). Include your visualizations as images. Be sure to use appropriate titles and labels. 

Task 3 - Price consistency 

For vaccinations and check-ups, the team would like to standardize costs, so that the price for each is fixed for animals of the same type. 

Using Excel, analyze the historical data you have available, and create a spreadsheet that allows Caesar to enter the animal type and consultation type, and gives a quote amount for vaccinations and check-ups. 

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 Complete Animal Clinic team (or by a University lecturer). 

It is up to you to determine an appropriate quoting method. 

Describe and justify your approach, including how you tested your solution, in your report (approximately 150 words). 

Task 4 - 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 3 can be applied to improve the processes at Complete Animal Clinic. 

Justify your approach in your report (approximately 150 words). 

 

This ITECH1100 - IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.