Applejack Fine Dining has 970 restaurants across the United States. Maintaining a clean environment for customers is a key success factor at Applejack. Each restaurant is cleaned regularly after closing. In addition to regular cleaning, from 5 to 20 times a month, depending on various factors including the amount of business, a special treatment is given to the floors consisting of breaking down the old wax and rewaxing. So the total number of times a restaurant is cleaned varies from 35 to 50 times a month.

The two most costly resources needed to clean an Applejack restaurant are labor and supplies. The cost driver for both resources is number of times a restaurant is cleaned. Cleaning laborers are paid the same wages regardless of the number of times a restaurant is cleaned. Cleaning supplies is a variable cost. The cost of supplies used per regular cleaning and per special cleaning is about the same.

Suppose one of the local Applejack restaurants in Orlando has 6,000 square feet. In October, the restaurant was cleaned 35 times. The cost of cleaning labor was $21,000 for October, and cleaning supplies cost $16,800. The months of November and December are typically much busier, so the restaurant manager expects to clean 45 times and 50 times in November and December, respectively.

1. Prepare a table that shows how labor cost, cleaning supplies cost, total cost, and total cost per cleaning changes in response to number of times the restaurant is cleaned. Use volumes of 35, 40, 45, and 50 times cleaned. What is the predicted total cost of cleaning for November and December?

2. Suppose Applejack can hire an outside cleaning company to clean the restaurant as needed. The charge rate for cleaning is $.25 per square foot. If the outside cleaning company is hired, Applejack can lay off the workers who are now cleaning and will spend nothing on cleaning supplies. Will Applejack save money with the outside cleaning company over the next two months? Prepare a schedule that supports your answer. What information would you need to make a recommendation about hiring the outside cleaning company on a permanent basis?