Jolene's Trucking Company prepared monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: Required: Expected cash balance on March 1 $ 50,000 Time left 1:48:44 February $ 200,000 $ March 350,000 $ April 450,000 Credit Sales (all sales are on account) Month of 50% Month after 50% Collection pattern from customers credit sales Description Cash payments for expenses Equipment purchase (in cash) Collection of notes receivable Proceeds from sale of land $ $ $ $ March 300,000 $ 50,000 $ 25,000 $ $ April 375,000 50,000 30,000 20,000 Minimum cash balance at the end of each month $ 70,000 Any borrowings and repayments are done in increments of $1000. Interest can be ignored. Part A. Prepare a schedule of expected cash collections from customers for March and April (8 marks) (DO NOT ENTER ANY Dollar signs "s" or commas ", " PLEASE ENTER NUMBERS AS 123456 and where 2 decimals Indicated enter number like 123456.78) Jolene's Trucking Company Schedule of Expected Cash Collections For the two months ended April 30 March April February S March S $ $ $ April Cash collected from customers (use in cash budget in PART B) $ (DO NOT ENTER ANY Dollar signs "S" or commas PLEASE ENTER NUMBERS AS 123456 and where 2 decimals Required: Cash Hudget PART B: Using the question data and your response to part a prepare a cash budget for March and April using columns for each month. Also include a summary column for the two-month period, March 1st - April 30th. (20 marks) Time left 1:48:16 Jolene's Trucking Company Cash Budget For the two months ended April 30 April Summary March 1st to April 30th March $50000 Cash balance, beginning Cash collections: (Must bo listed alphabetically) Choose... Choose... . Choose.. Total available cash: March Continued April Continued Summary March 1st to April 30th Excess (deficiency) Financing Borrowings: Repayments (show as negative) Total Financing Cash balance, ending BONUS QUESTIONS: (1 mark each) What is the accounts receivable balance as at April 30th? How much of the loan is outstanding at April 30th