Question: I need help with this table! please read the question carefully. thanks End of Chapter Question 9.50 Rainbow Enterprises has presented the following estimates relating

I need help with this table! please read the question carefully.

thanks

I need help with this table! please read the question carefully. thanks

End of Chapter Question 9.50 Rainbow Enterprises has presented the following estimates relating to 2018 activities: Quarter ending 31 March 30 June 30 September 31 December Sales revenue $700,000 $800,000 $900,000 $950,000 Purchases 450,000 420,000 400,000 430,000 Cost of sales 350,000 400,000 450,000 475,000 Marketing and administration expenses 170,000 170,000 170,000 170,000 Occupancy expenses 78,000 78,000 78,000 78,000 Depreciation expense 13,500 13,500 13,500 13,500 Sales in the December quarter of 2017 were $600,000. All sales are on credit, of which 70 per cent are collected in the quarter of sale and 30 per cent in the following quarter. Purchases are on credit, and entity policy is such that all purchases are paid for in the same quarter. The marketing and administration expenses incurred and paid are the same. Occupancy expenses incurred and paid are usually the same, except that the electricity bill (estimated to be $610) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $26,400, to be paid for in cash, is expected in the December quarter. The bank balance at 31 December 2017 was $18,360 (a) Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. (Please leave any answer fields without an entry blank. Enter negative amounts using either a negative sign preceding the number, e.g. -45, or parentheses, e.g. (45).) Rainbow Enterprises Schedule of receipts from accounts receivable for the quarters ending 31 December 2018 Receipts ($) Month Sales March June September December December 2017 $600,000 March $700,000 June $800,000 September $900,000 December 2018 $950,000 Total

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!