Hi there! Please answer this question in much details as possible. Thanks!

May was Amelia's first month in business. It provided the following cash budget information: Cash collection and disbursement activity May June July August September October Sales revenue $85,100 $62,900 $67,100 $49,200 $50,800 $68,200 Purchases of raw material $7,664 $7,240 $7,500 $6,850 $6,900 $7,575 Conversion costs $2,022 $1,904 $2,323 $2,377 $1,327 $1,475 Direct labour wages $30,360 $22,440 $23,958 $17,556 $18,150 $24,354 Management salaries $25,417 $25,417 $25,417 $25,417 $25,417 $25,417 General operating expenses $2,390 $2,390 $2,390 $2,390 $2,390 $2,390Cash collections: Cash sales Credit collections: Amount collected in month of sale Amount collected in month following sale Amount collected in second month following sale Uncollectable Cash disbursements: Conversion costs 100% Raw materials 60% 40% Direct labour 50% 50% Remaining expenses 100% Additional notes: Depreciation included in monthly general operating expenses Annual dividend payment to the shareholders, paid in August Paid in month incurred Paid in month incurred Paid in month following Paid in month incurred Paid in month following Paid in month incurred Expected July 1 beginning cash balance Amelia can borrow funds from its bank in $1,000 increments. The company wants to maintain a minimum balance in the bank of $5,000. Interest is paid the following month on the balance due the previous month at a rate of 1.5% per month and any loans are paid in $1,000 increments as soon as the company is able to while still maintaining the $5,000 minimum balance. Required: Prepare a cash budget for the six-month period. 25% 50% 30% 15% 5% $ 196 $8,000 $5,000