Would you please provide me with a step by step solution to solving this problem? Can you also show me how to do it step by step in Excel? I am not good at Excel. Thank you so much in advance for all your help!MARRIOTT ROOMS FORECASTING Linda Snow Snows responsibility to prepare a forecast on Tuesday afternoon of the number of rooms that would be occupied each day of the next week $($Saturday through Friday$).$ Overbooking Snow needed her forecast to know how to treat an opportunity that was developing for next Saturday. It was Tuesday, August $18,1987,$ and Snows forecasts were due by midafternoon for Saturday, August $22$ through Friday, August $28.$ Although $1,839$ rooms were already reserved for Saturday,