read question before answering please

i just need part B done ive done all calculation

please ready the question they aren't the same with previous ones

i need the answer as soon as possible thank you

Background: Neptune Cleaning Services (NCS) is a local business in the Tri-cities area. It provides cleaning services to residential households and commercial establishments. Both households and businesses sign contracts with NCS. As the contractor, NCS dispatches its crew to the locations. The crew performs the cleaning as per the contracts and reports back to the company main desk. The main desk then prepares the invoice and sends them to the clients. Clients have one day to pay the invoice. Sales volume can vary from one quarter to the next. In terms of expenses, the main expense for NCS relates to labour. They pay crew members competitivewages and benefits. The wage rate is calculated on an hourly basis and is fixed for the entire year. The next expense item is cleaning supplies. NCS accounts for cleaning supplies relative to the hours worked. For example, they estimate that cleaning supplies are consumed at a rate of 0.2 litres per labour hour. This is a good measure because the longer it takes for a site to be cleaned, the more the consumption of cleaning supplies. Cleaning supplies are procured from a prominent vendor and the cost is fixed for the entire year. Sometimes clients are not happy about the cleaning services and register a complaint. In that case, the crew is dispatched again for a second cleaning. The hours accruing from such scenarios are not billed to the client as this constitutes a 'service recovery.' However, the crew is paid for such hours. NCS maintains arecord of these hours and classifies them as "unproductive hours," or "unbilled hours. This is calculated as a percentage of revenue earning hours (e.g., 10% of revenue generating hours). For this assignment, assume that there is no consumption of cleaning materials when this second cleaning is being done. Fixed overhead: To support the cleaning operations, there are four items of expenditure. These are designated as overheads and their budgeted expenses are as follows: Receptionist: Budgeted expense is $4,500 per quarter and is the same for all four quarters. Depreciation: This relates to the depreciation of vehicles used to transport employees to client locations. Budgeted expense is $8,700 per quarter and is the same for all four quarters. Covid related: Budgeted expenditure on this item is $6,100 and is the same for all four quarters. Maintenance: Budgeted expenditure on Maintenance related is $2,300 per quarter and is the same for all four quarters. Actual results for the year 2021. It is now January 7, 2022, and Neptune Clean Services (NCS) is comparing the actual expenses against their budget. Here is what they found. Revenue: For 2021, the actual sales hours were: For 2021, the actual hourly revenue was: Required: Part A: For this part you will use the template provided in Excel Workbook format. Complete the following steps Fixed overhead: To support the cleaning operations, there are four items of expenditure. These are designated as overheads and their budgeted expenses are as follows: Receptionist: Budgeted expense is $4,500 per quarter and is the same for all four quarters. Depreciation: This relates to the depreciation of vehicles used to transport employees to client locations. Budgeted expense is $8,700 per quarter and is the same for all four quarters. Covid related: Budgeted expenditure on this item is $6,100 and is the same for all four quarters. Maintenance: Budgeted expenditure on Maintenance related is $2,300 per quarter and is the same for all four quarters. Actual results for the year 2021 . It is now January 7, 2022, and Neptune Clean Services (NCS) is comparing the actual expenses against their budget. Here is what they found. Revenue: For 2021 , the actual sales hours were: For 2021 , the actual hourly revenue was: 5|Pa \& e Direct Labour erpense Nes paid its employees an hourfy rate of 330 tor the entire yeat. The actual stage was 0.34htre f labour hour foe the commercial segment and 0.30 inref iabour hour for the residential secment. This aas conatant for the entire year; Cleaning supply expense; Actual eagense was $5.90 per lter for the entire year. fued worhead, To support the cleaning opetations, there are four iterns of expectiture. Theie are sesierated as overheads and their budgeted expenses are as follows: Pecegiontrit Actual expense per auarter was as follows: Depreciation; This telates to the decreclation of vehicles used to trangort employees to clent locationi. Actual expense was 59,000 per quartet and was the sarne for all four quarters. Coyid wiated: Mrtual exisence ner thuarter was as bollowt Mairtenamse: Artual evisnce ner nuartee was as Anillies Clearing crewt had to work 14\%, ovee the tevenue reterating houts 10 addreis complaints and do a second deaning. These hours were not birable to clients. but Neptune Clean Services (Sacs) would pay the employees for this tire they worked. for this awignment, assume that there is no contumption of cleaning materials when this secend cleaning was deete. Pithen guidnitrenforerala fart bir 4 Sorkiare thit thener - Mentar rierestr Deirverables: 4 Conpeted focel mintina. 4 M MrTo in Mr dond forn ak Bwowerve Markinif Kery and Fiubrir Background: Neptune Cleaning Services (NCS) is a local business in the Tri-cities area. It provides cleaning services to residential households and commercial establishments. Both households and businesses sign contracts with NCS. As the contractor, NCS dispatches its crew to the locations. The crew performs the cleaning as per the contracts and reports back to the company main desk. The main desk then prepares the invoice and sends them to the clients. Clients have one day to pay the invoice. Sales volume can vary from one quarter to the next. In terms of expenses, the main expense for NCS relates to labour. They pay crew members competitivewages and benefits. The wage rate is calculated on an hourly basis and is fixed for the entire year. The next expense item is cleaning supplies. NCS accounts for cleaning supplies relative to the hours worked. For example, they estimate that cleaning supplies are consumed at a rate of 0.2 litres per labour hour. This is a good measure because the longer it takes for a site to be cleaned, the more the consumption of cleaning supplies. Cleaning supplies are procured from a prominent vendor and the cost is fixed for the entire year. Sometimes clients are not happy about the cleaning services and register a complaint. In that case, the crew is dispatched again for a second cleaning. The hours accruing from such scenarios are not billed to the client as this constitutes a 'service recovery.' However, the crew is paid for such hours. NCS maintains arecord of these hours and classifies them as "unproductive hours," or "unbilled hours. This is calculated as a percentage of revenue earning hours (e.g., 10% of revenue generating hours). For this assignment, assume that there is no consumption of cleaning materials when this second cleaning is being done. Fixed overhead: To support the cleaning operations, there are four items of expenditure. These are designated as overheads and their budgeted expenses are as follows: Receptionist: Budgeted expense is $4,500 per quarter and is the same for all four quarters. Depreciation: This relates to the depreciation of vehicles used to transport employees to client locations. Budgeted expense is $8,700 per quarter and is the same for all four quarters. Covid related: Budgeted expenditure on this item is $6,100 and is the same for all four quarters. Maintenance: Budgeted expenditure on Maintenance related is $2,300 per quarter and is the same for all four quarters. Actual results for the year 2021. It is now January 7, 2022, and Neptune Clean Services (NCS) is comparing the actual expenses against their budget. Here is what they found. Revenue: For 2021, the actual sales hours were: For 2021, the actual hourly revenue was: Required: Part A: For this part you will use the template provided in Excel Workbook format. Complete the following steps Fixed overhead: To support the cleaning operations, there are four items of expenditure. These are designated as overheads and their budgeted expenses are as follows: Receptionist: Budgeted expense is $4,500 per quarter and is the same for all four quarters. Depreciation: This relates to the depreciation of vehicles used to transport employees to client locations. Budgeted expense is $8,700 per quarter and is the same for all four quarters. Covid related: Budgeted expenditure on this item is $6,100 and is the same for all four quarters. Maintenance: Budgeted expenditure on Maintenance related is $2,300 per quarter and is the same for all four quarters. Actual results for the year 2021 . It is now January 7, 2022, and Neptune Clean Services (NCS) is comparing the actual expenses against their budget. Here is what they found. Revenue: For 2021 , the actual sales hours were: For 2021 , the actual hourly revenue was: 5|Pa \& e Direct Labour erpense Nes paid its employees an hourfy rate of 330 tor the entire yeat. The actual stage was 0.34htre f labour hour foe the commercial segment and 0.30 inref iabour hour for the residential secment. This aas conatant for the entire year; Cleaning supply expense; Actual eagense was $5.90 per lter for the entire year. fued worhead, To support the cleaning opetations, there are four iterns of expectiture. Theie are sesierated as overheads and their budgeted expenses are as follows: Pecegiontrit Actual expense per auarter was as follows: Depreciation; This telates to the decreclation of vehicles used to trangort employees to clent locationi. Actual expense was 59,000 per quartet and was the sarne for all four quarters. Coyid wiated: Mrtual exisence ner thuarter was as bollowt Mairtenamse: Artual evisnce ner nuartee was as Anillies Clearing crewt had to work 14\%, ovee the tevenue reterating houts 10 addreis complaints and do a second deaning. These hours were not birable to clients. but Neptune Clean Services (Sacs) would pay the employees for this tire they worked. for this awignment, assume that there is no contumption of cleaning materials when this secend cleaning was deete. Pithen guidnitrenforerala fart bir 4 Sorkiare thit thener - Mentar rierestr Deirverables: 4 Conpeted focel mintina. 4 M MrTo in Mr dond forn ak Bwowerve Markinif Kery and Fiubrir