Someone please help with A,B,C. Please read all of the instructions.

Preparation of cash budget. Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2020 to make sure they can cover their expenditures during the period. Sam and Suzy have been preparing budgets for the past several years and have been able to identify the percentage of ther income that they pay for most of for their cash outflows. These percentages are based on their take-home pay (e.g., monthly utilities normally run 5.1% of monthly take-home pay). The information here : can be used to create their fourth-quarter budget for 2020 a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2020 b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December 2020? X Data table Income (Click on the icon located on the top-right comer of the data table below in order to Take-home pay copy its contents into a spreadsheet.) Expenses Percent Income Housing 30.4% $ Monthly take-home pay $4,920 5 1% $ Expenses Utilities Housing 30.4% Food 10.4% S Utilities 5 1% Transportation 6.8% $ Food 10.4% Transportation 6.8% Medical/ Dental 0.6% S Medical/dental 0.6% Clothing 2.7% S Clothing for October & November 2 7% $448 Property taxes 11.6% $ Clothing for December Property taxes (November only) 11.6% Appliances 1.3% $ Appliances 1.356 Personal care 2,3% $ Personal Care 2.3% Entertainment for October & November 5.6% Entertainment 5.6% $ Entertainment for December $1,461 Savings 7.6% $ Savings 7.6% Other 5.29% Other 5.2% $ Excess in cash 4.2% Excess cash 4.2% S Total expenses $ Cash surplus or (deficit) Print Done Cumulative cash surplus or (deficit)