Hours of operation Most of the time, each team member works separate shifts: Amy works 9:00 AM to 12:30 PM, Monday, Tuesday and Wednesday; Blanche…

Hours of operation Most of the time, each team member works separate shifts: Amy works 9:00 AM to 12:30 PM, Monday, Tuesday and Wednesday; Blanche works 9:00 AM to 12:30 PM, Thursday, Friday and Saturday; and Celeste works 12:30 PM to 5:30 PM, Monday to Friday. The shop runs from 9:00 AM to 5:30 PM each day, except Saturday when it closes at 12:30. It is closed entirely on Sundays.

Costs Amy and Blanche are the semi-retired co-owners of the bookshop, and do not take a salary. Celeste, however, is a part-time employee, with total employment costs of $22 per hour. Celeste is also entitled to four weeks of paid annual leave, during which a casual replacement is required at a cost of $33 per hour. Fixed costs such as rent and insurance are $2900 per year, and utilities costs are $140 per month.

Task 1 – Costs of operating the business Using Excel, make a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Literature Resurrection. Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily.