attached is the question and the designated spreadsheet. a walkthrough would really help me with this particular question. thank you.

Marsha Hansen, the manager of the flint plant of the michigan company is responsible all of the plant's costs except her own salary. there are two operating departments within the plant, departments A and B.Each department has its own manager. there is also a maintenance department that provides services equally to the two operating departments. the following information is available. Department managers are responsible for the wages and supplies in their department. They are not responsible for their own salary. Building rent, utilities, and maintenance are allocated to each department based on square footage. Required: Complete the responsibility accounting performance reports below that list costs controllable by me nlagcr of Department A. the manager of Department B. and the manager ot the FUnt plant