a$)$ Using the above information, create a cash budget for January to June $2032.$ The cash budget should account for

short$-$term borrowing and payback of outstanding loans. Using Excel$$s outline feature, group the worksheet area

at the top of the cash budget so that the preliminary calculations can be easily hidden or unhidden $($Analysis$,$

Identify and Access Needed Information and use information effectively to accomplish a specific purpose $12$ pts$).$

b$)$ Ms$.$ Elaine Benes, Active Life$$s CFO, is considering three credit proposals from the firm$$s supplier. In the first

proposal the firm will pay $75\%$ of its purchases in the same month and $25\%$ in the following month; in the second

proposal the firm will pay half in the same month and half in the following month; in the third proposal the firm

will pay $25\%$ of its purchases in the same month and $75\%$ in the following month. Suppliers have offered $4\%,$

$3\%,$ and $2\%$ discounts over the payments made during the same month of the purchase if the firm pays according

to the first, second, and third proposals, respectively. The CFO has asked you to use the Scenario Manager to see

which proposal has the lowest total interest cost $($Identify and Access Needed Information $4$ pts$).$

c$)$ Ms$.$ Benes is now considering three credit policies from the firm$$s customers. In the first policy the firm will sell

$60\%$ on cash and will collect $60\%$ of the balance during the first month, and the remaining balance during the

second month. In the second policy, $50\%$ of sales will be on cash, and the firm will collect $50\%,30\%,$ and $20\%$

of credit sales during the first, second, and third months, respectively. The last policy consists of $40\%$ sales on

cash, and $40\%,30\%,$ and $30\%$ of the remaining balance will be collected during the first, second, and third months,

respectively. The CFO has asked you to use the Scenario Manager to see what credit proposal has the lowest total

interest cost $($Identify and Access Needed Information $4$ pt$).$

I NEED HELP USING THE SCENARIO MANAGER FOR PART $($b$)$ and $($c$).$ THANK YOU!!!