Team hours

Most of the time, team members work the following shifts at Holistic Pet Haven: Alexa works 6.5 hours on Mondays, Wednesdays and Fridays; Barnardo works 6.5 hours on Tuesdays and Thursdays; and Charlyn works 3.5 hours every weekday.

Costs

Alexa, as the most experienced veterinarian, costs $45 per hour to employ. Barnardo, as a veterinarian, costs $38 per hour to employ. Charlyn costs $30 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 $49 per hour for the veterinarians and $39 per hour for Charlyn. During their leave weeks, Alexa, Barnardo, and Charlyn continue to be paid. Fixed costs such as permits, rent, and insurance are $16384 per year, and monthly utility costs (such as electricity and gas) are $390 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 Holistic Pet Haven. 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 Holistic Pet Haven 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? Document your findings in your report (approximately 100 words).