Calculating Operating Costs And Book Pricing At Parchment Graveyard Bookshop

Albert and Beatrice are the semi-retired co-owners of the bookshop, and do not take a salary. Courtney, however, is a part-time employee, with total employment costs of $22 per hour. Courtney 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.

Costs of operating the business
Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Parchment Graveyard.Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily.
Obtaining BooThroughout the day, customers come to Parchment Graveyard to buy books, and occasionally to sell them.When people bring in books to sell to Parchment Graveyard, the staff member on duty will review the books and make an offer for each one individually.Currently, the process for determining how much the book shop will pay for a book is entirely subjective. Staff members offer an amount per book based on the quality of the book, and how popular they think it is, and how they are feeling at the time.