how do i do each solution through the excel with explanation -) e Secure l https

Question

how do i do each solution through the excel with explanation

-) e Secure l https://newconnect.mheducation.com/flow/connect.html Ch 20 Excel Sims Help Save & Exit Submit Saved Cash Budget with Supporting Cash Collections and Disbursements Schedules 1. Prepare a sales budget, Including a schedule of expected cash collections. 2. Prepare a direct materiais budget, including a schedule of expected cash disbursements for purchases of materials 3. Prepare a cash budget 10 Cash rting Cash Collections and Disbur 5Schedules-Excel ? FILE OME: INSERT PEL OUT FORMULAS ! , REVIEW VE Pfint B I UA Alignment Number Conditina ,C ll S&P; Enterprises needs a cash budget for March. The following information is 1 IS & PEnte needs a cash budget for March. The following Information is avalable 3 Data 1,600 $ 3,750 $ 5,10o 30 000 5 Sales on account

Explanation / Answer

1) Expected Cash collections for March (Amounts in $)

2) Calculation of Payment to Suppliers (Amounts in $)

3)   S&P Enterprises

Cash Budget For the month of March (Amounts in $)

Working Notes:-

1) As there is a negative cash preliminary balance of $3,800 and minimum cash balance required is $10,000, the additonal loan required to be obtained in the month of march is $13,800 ($3,800+$10,000).

March Cash sales collections 5,100 March collections on account: January Sales (22% of Jan sales in March) ($25,000*22%) 5,500 February Sales (60% of Feb sales in March) ($30,000*60%) 18,000 March sales (15% of March Sales) ($40,000*15%) 6,000 Total Cash Collections 34,600

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.