please use any schedule, format or templete. Thank You

to) Question Help Maintaining a clean working environment is important to Boeing, an industrial parts manufacturer. Cleaning the plant is the responsibility of the maintenance department. The 100,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, six, and eight times respectively. Two of the resources needed to clean the plant are labor and cleaning supplies. The cost driver for both resources is number of times the plant is cleaned. Plant cleaning laborers are full-time employees who are paid the same wages regardless of the number of times the plant is cleaned. Cleaning supplies is a variable cost. The March cost of labor was $26,000 and cleaning supplies used cost $4,000 Read the requirements. Requirement 1. Prepare a table that shows how labor cost, cleaning supplies cost, total cost, and total cost per cleaning changes in response to the numbe of times the plant is cleaned. What is the predicted total cost of plant cleaning for the next quarter? Begin by preparing a table that shows how labor cost, cleaning supplies cost, total cost, and total cost per cleaning changes in response to the number of times the plant is cleaned. (Do not round until the final answer for the cost per cleaning. Then round to the nearest whole dollar) Number of Square Cleaning Times Plant Feet Labor Supplies Total Cost per Is Cleaned Cleaned Cost Cost Cost Cleaning 4 5 6 7 8 Enter any number in the edit fields and then click Check Answer Check Answer Clear All parts 3 remaining MacBook Pro i Requirements 1. Prepare a table that shows how labor cost, cleaning supplies cost, total cost, and total cost per cleaning changes in response to the number of times the plant is cleaned. What is the predicted total cost of plant cleaning for the next quarter? 2. Suppose Boeing can hire an outside cleaning company to clean the plant as needed. The charge rate for cleaning is $5,500 per plant cleaning. If the outside cleaning company is hired, Boeing can lay off the workers who are now cleaning the plant and will sbend nothing for cleaning supplies. Will Boeing save money with outside cleaning company over the next quarter? Prepare a schedule that supports your answer. Print Done the edit fields and then click Check Answer. Check Clear All