Reference no: EM132528380

ITECH1100 Understanding the Digital Revolution Assignment - Holistic Veterinary Care, Federation University, Australia

Overview - For this individual assignment, you will use skills acquired through practical laboratory exercises to automate a business process, and to visualize the impact of the automation.

You should use Microsoft Excel (or equivalent open-source software) for this assessment 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 ?ow and processes;

K8. Outline the basic principles of programming.

Assessment Details - For this assignment, you will complete the following set of tasks using Excel, and create a report to describe your work.

Ensure you submit Excel ?les created for ALL tasks, along with your report. You may use an ePortfolio, a Word document or a PDF for your report submission.

Scenario details - The following scenario is ?ctional, and not based on any real veterinary clinic. It is also highly simpli?ed, and should not be used as a basis for a real business management system.

Holistic Veterinary Care is a small veterinary clinic, working with domestic companion animals. Mostly they work with dogs, cats, and smaller animals such as hamsters and rabbits.

Holistic Veterinary Care is run by a team of two veterinarians, Audrey and Blanche, and one administrative sta? member, Clancy.

Task 1 - Wages and Fixed Costs

Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Holistic Veterinary Care. Only include the above expenses.

Your spreadsheet should be con?gured 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 labour, annual, and monthly costs?

How much income does Holistic Veterinary Care need per month to cover the above costs?

What is the projection of labour costs only for the next year, if both veterinarians were to cost $50 per

hour, but the clinic closed on Wednesday?

Document your ?ndings in your report (approximately 100 words).

Task 2 - History visualization

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

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

How some consultations di?er between veterinarians.

You will need to ?nd a way to use Excel to associate each consultation with a sta? member.

Describe your approach and your ?ndings 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 ?xed for animals of the same type.

Using Excel, analyse the historical data you have available, and create a spreadsheet that allows Clancy 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 Holistic Veterinary Care 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 Holistic Veterinary Care.

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

Attachment:- Assignment File - Holistic Veterinary Care.rar