Question

In: Finance

Maintaining a clean shopping environment is a key success factor for Turner?, a large grocery chain...

Maintaining a clean shopping environment is a key success factor for Turner?, a large grocery chain based in Minnesota. Three of the most costly resources needed to clean a supermarket are? labor, equipment, and cleaning supplies.

The cost driver for all these resources is? "number of times? cleaned." Wages for cleaning laborers? (called porters) and rent for cleaning equipment are the same regardless of the number of times the supermarket is cleaned. Supplies used for each regular daily cleaning and for each special cleaning are about the same. A typical store has 52,000 square feet. Regular cleaning is performed each day from midnight until? 7:00 AM. Special cleaning of floors and fixtures is performed in the various departments as needed. Special cleaning varies from 10 to 30 times a month depending on the amount of traffic through the store. ? Thus, the number of times a store is cleaned varies from 40 to 60 times a month.

Suppose that in one of Turner?'s stores in? Minneapolis, cleaning was performed 60 times during March. For the? month, the cost of labor and rent on equipment was $ 21,000 and cleaning supplies used cost $ 9,600. The sales budget for the next quarter? (April through? June) and better weather conditions indicate that the store will need to be cleaned 50?, 48?, and 35 times in? April, May, and June respectively.

Requirement 1. Prepare a table that shows how labor? cost, rent, cleaning supplies? cost, total? cost, and total cost per cleaning changes in response to the number of times the store is cleaned. Show costs for 35?, 40?, 45?, 50?, 55?, and 60 cleanings. What is the predicted total cost of cleaning the Minneapolis store for the next? quarter? ?(Round the cost per cleaning amounts to two decimal? places.

Prepare a table that shows how labor cost, rent, cleaning supplies cost, total cost, and total cost per cleaning changes in response to the number of times the store is cleaned. Show costs for 35, 40, 45, 50, 55, and 60 cleanings. What is the predicted total cost of cleaning the Minneapolis store for the next quarter?

2. Prepare a single graph that can be used to predict the fixed, variable, and total cleaning cost of the Turner store.

3. Suppose the manager of the Turner store can hire an outside cleaning company to clean the store as needed. The charge rate is $ 680 per cleaning. If the outside cleaning company is hired, Turner can lay off the workers who are now cleaning the store, eliminate the need for equipment rent, and stop purchasing cleaning supplies. Will Turner save money with the outside cleaning company over the next quarter? Prepare a schedule that supports your answer.

Solutions

Expert Solution

We identify the Fixed and the variable cost as below-

Fixed Costs- These are fixed because they are the same regardless of the number of times the supermarket is cleaned.

  • Wages for cleaning laborers, say $W per month

  • Rent for cleaning equipment, say $R per month

Variable Cost- Cost of Supplies

This vary and depends on the number of times it is cleaned. However, Supplies used for each regular daily cleaning and for each special cleaning are about the same and thus we assume that cost of supply per cleaning= $s

Now if n= number of times it is cleaned per month

Total Cost per month T= W + R + n x s

As per the data given for March

W+ R= 21000

n x s= 9600

n= 60

Solving, s= $160 per cleaning

(1) The table below shows how labour cost, rent, cleaning supplies cost, total cost, and total cost per cleaning changes in response to the number of times the store is cleaned.

The predicted total cost of cleaning the Minneapolis store for the next quarter= $84280

Refer table below for calculation

2. A graph to predict the fixed, variable, and total cleaning cost of the Turner store is as below-


Related Solutions

Which are in your opinion the key success factor in the Supply Chain model of INDITEX?...
Which are in your opinion the key success factor in the Supply Chain model of INDITEX? ▪ Flow chart Supply Chain of Inditex ▪ Plant locations of Inditex ▪ Logistics Model ▪ Purchase & suppliers strategy ▪ Store Management (identify different brands and highlight KSF on retail distribution) ▪ Quality control system, how does it works at INDITEX ▪ Identify Management production system at INDITEX
Maintaining a clean working environment is important to Life is Great​, an industrial parts manufacturer. Cleaning...
Maintaining a clean working environment is important to Life is Great​, an industrial parts manufacturer. Cleaning the plant is the responsibility of the maintenance department. The 80,000 square foot plant is thoroughly cleaned from four to eight times a month depending on the level and stage of production. For the most recent​ month, March, the plant was cleaned four times. The production schedule for the next quarter​ (April through​ June) indicates that the plant will need to be cleaned​ five,...
Supply chain integration is a major contributing factor to organizational success. The goal of supply chain...
Supply chain integration is a major contributing factor to organizational success. The goal of supply chain integration is alignment within the supply chain. As a business leader, how can you achieve greater supply chain integration with suppliers and customers? Amazon is a prime example of a company that has successfully managed its supply chain to achieve growth and profitability. Research the progression of Amazon's supply chain integration. Write a 1,000-1,250-word paper that address the following questions: How do sales and...
According to various lectures and videos on Prosperity and Success, what key factor is cited for...
According to various lectures and videos on Prosperity and Success, what key factor is cited for Mexico's economy underperforming relative to the US economy?  
A national chain of women’s clothing stores with locations in the large shopping malls thinks that...
A national chain of women’s clothing stores with locations in the large shopping malls thinks that it can do a better job of planning more renovations and expansions if it understands what variables impact sales. It plans a small pilot study on stores in 25 different mall locations. The data it collects consist of monthly sales, store size (sq. ft), number of linear feet of window display, number of competitors located in mall, size of the mall (sq. ft),and distance...
A national chain of women’s clothing stores with locations in the large shopping malls thinks that...
A national chain of women’s clothing stores with locations in the large shopping malls thinks that it can do a better job of planning more renovations and expansions if it understands what variables impact sales. It plans a small pilot study on stores in 25 different mall locations. The data it collects consist of monthly sales, store size (sq. ft), number of linear feet of window display, number of competitors located in mall, size of the mall (sq. ft),and distance...
Customers of a large grocery chain who are members of the chain's incentives program spend an...
Customers of a large grocery chain who are members of the chain's incentives program spend an average of $45 per visit to the grocery. In an attempt to try and increase the amount spent by these regular customers at their stores, the chain institutes a new feature of the incentives program where customers receive an extra 5% discount on groceries when they spend $50 or more. A sample of 100 customers in the program is randomly selected and it is...
The management for a large grocery store chain would like to determine if a new cash...
The management for a large grocery store chain would like to determine if a new cash register will enable cashiers to process a larger number of items on average than the cash register they are currently using. Seven cashiers are randomly selected, and the number of grocery items they can process in three minutes is measured for both the old cash register and the new cash register. The results of the test are as follows: Cashier Old Cash Register Old...
DC's has been approached by a large grocery store chain that wants to sell their award...
DC's has been approached by a large grocery store chain that wants to sell their award winning BBQ sauce. Determine the selling price based on the following information: Fixed costs for production will be $400,000 of which $150,000 is for selling and admin expenses. Variable costs will be $15 per case. Variable selling expenses are $3 per case. Anticipated sales are 100,000 cases. DC's desires a $350,000 profit. What does the selling price per case need to be? After visiting...
Is humankind dangerously harming the environment? Many key industries are dominated by a handful of large...
Is humankind dangerously harming the environment? Many key industries are dominated by a handful of large firms. This tendency has been increasingly evident in recent years, as many separate firms have merged into larger ones. How might this trend affect technological innovation? Could it pose a threat to the overall development of the economy?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT