Jack is very excited that his idea is coming to fruition. As he plans the details of the staycation pregamme, he needs to make sure that he can deploy the partner resources cost eiciently. (a) Construct a spreadsheet model in the form of a deployment table to help Jack choose a suitable tour guide: hotel and coach operator for each of the 6 weeks- Your model should compute the cost of each resource (tour guide: hotel, coach) engaged and the total cost of the 6week deployment plan. To ensure that there is no accidental over deployment} your model should also calculate the number of resources engaged per staycatjon Table 3 below shows a possible structure for the deployment table. [12-me Table Mr\" D D D 1 D D D D 1 D D D 1 D D D HI-Il: H-H HDQh-aah-D'DDI: nauucanuooaucuna Table 3: Deployment Table Structure The blue cells are input cells used for selection ne staycation is scheduled for each 1week A resource (Guide: Hotel or Coach] is selected by inputting 1 into the appropriate blue cell You need to apply conditional formatting so that when a resource is selected, the corresponding cell changes 'om blue to yellow. SINGAPORE MMDF ML Ems {SUSS} Page 5 rot-'3