Interpret and Construct Representations of Business Data Flow - IT Computer Science Assignment Help

Assignment Task :

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. 

Important: This assignment specification is generated just for you, 30381980. Do not distribute this specification. If your personal specification is made publicly available online, academic misconduct charges may be applied. 

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 business. It is also highly simplified, and should not be used as a basis for a real business management system. 

Best Friend Vets is a small veterinary clinic, working with domestic companion animals. Mostly they work with dogs, cats, and smaller animals such as hamsters and rabbits. 

Best Friend Vets is run by a team of two veterinarians, Albert and Bhaljeet, and one administrative staff member, Caitlin.

Task 1 - Wages and Fixed Costs 

Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Best Friend Vets. 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 labour, annual, and monthly costs? How much income does Best Friend Vets 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 $45 per hour, but the clinic closed on Fridays? 

This IT Computer Science Assignment has been solved by our IT Computer Science 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.