Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected...
Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing
costs of running Precise Veterinary 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 labour, annual, and monthly costs?
How much income does Precise Veterinary Clinic 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 findings in your report (approximately 100 words).