5. Budgeting (1): 15 marks Megatron started his own book-dealing business a few years ago. His business is a combination of retailing and wholesaling, that is, not only individual customers but also other book shops purchase books from him. This year, Megatron expects the sales revenue will be: Month April May June July August September Sales revenue $14,000 $15,500 $18,500 $20,000 $22,250 $23,250 On average, 30% of total sales are contributed by individual customers who purchase books and pay cash immediately, all the sales to book shops are credit sales, and 60% will pay one month later and 10% pay two months after the date of sales. Actual sales for March were $12,500 and $11,250 for February. The average selling price of $25 per book has remained constant this year. For budgeting purpose, Megatron estimates that cost of goods sold is 72% of sales. Megatron has a policy that the ending inventory of each month should be sufficient to cover 30% of the next month's projected sales. All the purchases are credit purchases and suppliers allow Megatron to pay one month after the date of purchase. The amount owing to suppliers at the end of March is $9,324. The closing inventory balance at the end of March is $3,024. Megatron expects to incur the following expenses each month: Rent $600; General overheads $950 (this includes Depreciation of $250); Advertising $250 and Salaries $1,000. The expenses are paid in the month they are incurred. The closing cash balance at the end of March is $3,000. Megatron intends to refurbish the front area of his shop in June at a cost of $8,000, payable at the end of that month, the refurbishment will be reported as a fixed asset and depreciated in the following months. Required: (Round up all calculations to the nearest dollar) (a) Complete the following template and prepare a schedule of budgeted cash receipts for Megatron's Book Shop for April, May and June, April May June Sales Revenue Budget $14,000 $15,500 $18,500 Cash Receipts Budget Cash sales 30% From last month 60% From 2 months ago 10% Total Budgeted Collections ($) $12,825 $14,300 $16,250