Now that My Assistant has completed its first full year of operations, W.T. is ready to budget for the upcoming year. He'd like to concentrate on the first quarter (July-September) before examining the entire year. W.T. has already completed projections for estimated jobs. My Assistant Services Revenue Projections July 1 - September 30, Year 2 July August September Proiected Jobs: Paypal 80 84 88 On Account 48 52 56 Prepaid 4 4 Total 132 140 148 He knows that one thing he'll need to do is complete a cash budget for the quarter. In order to complete the cash budget, he'll need to work with the schedules that follow. Your task is to complete them. Service Revenue Budget. Based on the projects completed by W.T. (above), compute the amount of sales revenue My Assistant should collect each month. Evaluate gross fees only (e.g. do not deduct the PayPal fee at this point). Recall that different customers receive different rates: those paying by PayPal and on account are charged $15 per job. The customer that pays in advance pays for three months' of service and is charged $14.50 per job. That customer last paid in June for service to be provided in June, July, and August (4 jobs completed per month). Also, recall that fees received through PayPal are received at job completion. Accounts Receivable are due the month following the month in which the service is provided. On June 30. the balance in Accounts Receivable was $600. My Assistant Services Revenue Budget July 1 - September 30, Year 2 July August September Projected Service Revenue: PayPal On Account Prepaid Total Budgeted Revenue Schedule of Cash Receipts: PayPal On Account Prepaid Total Budgeted Collections Supplies Purchases and Payments Budget. To ensure that he has an adequate amount of supplies on hand, W.T. would like to maintain an ending supplies balance equal to 50% of the estimated supplies expense for the following month. October's budgeted supplies expense is $60. Recall that My Assistant had $30 of supplies on hand at June 30. Effective July 1, My Assistant's supplier now requires that 80% of purchases on account be paid in the month of purchase the remaining 20% are paid in the month following the month of purchase. At June 30, My Assistant owed the supplier $25. My Assistant Supplies Purchases Budget July 1 - September 30. Year 2 July August $40 September $50 $30 Budgeted supplies expense Plus: Desired ending supplies Supplies needed Less: Beginning supplies Required purchases (on account) August My Assistant Schedule of Payments for Supplies July 1-September 30, Year 2 July Payment for current month purchases Payment for previous month purchases Total budgeted payments to supplier September What is the amount of Accounts Payable My Assistant will report on its pro forma balance sheet at the end of the first quarter (September 30) Selling and Administrative Expense Budget. In addition to the supplies expense estimated above, My Assistant will continue to have the following selling and administrative costs: PayPal fee $0.75 periob Gas expense Estimated of $250 per job thot W.1. completes. Social Media $100 per month Manager $1 per PayPal job scheduled W.1. estimates that 10% of her scheduling fee will still be due at the end of each month Contract worker $12 per job, paid upon job completion Doyments forlobs W.1. estimates 30 lobs per month will be completed this way W.T.'s salary $400 per month Advertising $100 per month paid 6 months in advance. Balance in Prepaid Advertising was $300 at 6/30. The next payment is due October 1. W.T. also knows he'l need to account for the equipment of $500 he purchased in June. Since he'l be using the equipment to generate revenue, he knows he needs to match its cost against the revenue that's generated. He's leamed that the process of expensing long-term assets such as equipment is known as depreciation, but he's unsure how to record this. He has been told that the equipment should last five years and will be worthless at the end of that time period. W.T. expects to use the equipment equally in every month. Based on this, what would be a reasonable amount of Depreciation Expense each month Round your computations to the nearest whole dolar. Based on the above, prepare an expense and poyments budget for these items for July Budgeted Budgeted Expense Poyment Collection (PayPal) expense Gas expense Scheduling expense-social media manager Delivery expense-contract workers (friends) W.T.'s salary Advertising expense Depreciation expense Total $ $ What is the amount of fees payable that My Assistant will report on the July 31 pro forma balance sheet? What is the amount of Prepaid Advertising that My Assistant wil report on the July 31. pro foma balance sheet Based on your estimates above, what is the amount of Depreciation Expense that My Assistant will report for ol of Year 23 $