Question

Question Rainbow Fnterprises has presented tha following estimates relating to 2018 activities: Quarter ending 31 March $110,don 460,000 355,000 172,000 9,000 13,500 30 June 810,dot) 421,000 405 000 172,000 79,000 13,500 30 September 31 December $60,000 431,000 190,000 172,000 79,000 13,600 Salcs revenue Purchases Cost of sales 401,000 155,000 172,000 79.000 13,600 Marketing and administration expenses Depredation expense Sales in the December quarter ef 2017 were s610,000. All sales are on credit, of which 65 per cent are collected in the quarter of sale and 15 per cent in the tollowing quarter. Purchases are on credit, and entty policy is such that all purchases are paid for in the same quarter. The markeing and administration expenses incurred and paid are the same. Occupancy expenses incurred and paid are usually the same, except that the electridty b (estimated to be $620) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of宰26,500, to be paid for in cash. is expected in the December quarter. The bank balance at 31 December 2017 was $18,370. Prepare 5chedu o receipts from accounts recer ablu showing cash collections for each quarter parentheses, e.g. (45).) 2018 P ease eave ny answer te ds wit out sn entry blank. Enter ne atrve amounts using eit era negative sugri preceding the number, e. 45 or Schedule of receipts from accounts recelvable for the quarters ending 31 December 2018 Recelpts ($) Month Sales March June September December 2017 510,000 March 5/1,Duo 810,000 $910,000 September December 2018 $960,000 Total Attempts: 0 of 1 used SAVE FOR LATER

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution a:

Rainbow Enterprises
Schedule of receipts from accounts receivable for the quarters ending 31 December 2018
Quarter Sales Receipts
March June September December
December. 2017 $6,10,000 $2,13,500
March $7,10,000 $4,61,500 $2,48,500
June $8,10,000 $5,26,500 $2,83,500
September $9,10,000 $5,91,500 $3,18,500
December. 2018 $9,60,000 $6,24,000
Total $6,75,000 $7,75,000 $8,75,000 $9,42,500
Add a comment
Know the answer?
Add Answer to:
Question Rainbow Fnterprises has presented tha following estimates relating to 2018 activities: Quarter ending 31 March...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • iew History Bookmarks People Window Help ylti/main.uni igen.wlleypiua.w.mene Assessment to accompany Birt, Accounting: Business reporting for...

    iew History Bookmarks People Window Help ylti/main.uni igen.wlleypiua.w.mene Assessment to accompany Birt, Accounting: Business reporting for decision making, 6e (AUS) Help I System Announcements :04:21 PM/ Remaining: 70 min. Question i Rainbow Enterprises has presented the following estimates relating to 2018 activities: Quarter ending 31 March 30 June 30 September 31 Decem Sales revenue $850,000 $950,000 $1,050,000 $1,100,000 Purchases 546,000 435,000 445,000 415,000 Cost of sales 425,000 475,000 525,000 550,000 Marketing and administration expenses 200,000 200,000 200,000 200,000 Occupancy expenses...

  • Required Prepare a cash budget month by month for the quarter ending 31 March 2019. Student...

    Required Prepare a cash budget month by month for the quarter ending 31 March 2019. Student Enterprises has the following business transaction estimates relating to the first quarter of 2019. JAN. FEB March Credit Sales Cash Sales Receipts from Accounts Receivable '1. Wages Office Furniture Prepayments Administrative Expense Depreciation on Office Furniture Receipt of Loan Credit Purchases Payments of Accounts Payable 2. Accrued Expenses Notes 120000 35000 calculate 35000 5000 140000 40000 calculate 35000 7000 160000 43000 calculate 35000 0...

  • ang Company has provided the following budget information for the first quarter of 2018: Click the...

    ang Company has provided the following budget information for the first quarter of 2018: Click the icon to view the budget information.) Additional data related to the first quarter of 2018 for Vang Company (Click the icon to view the data.) Read Х More Info Requirement 1. Prepare Vang Company's schedule of cash receipts from customers and schedule of cash payments for th Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018 Cash...

  • haney company has provided the following budget information for the first quarter of 2018: Haney Company...

    haney company has provided the following budget information for the first quarter of 2018: Haney Company has provided the following budget information for the first quarter of 2018 (Click the loon to view the budget information.) Additional data related to the first quarter of 2018 for Haney Company (Click the icon to view the data.) Read the requirements Requirement 1. Prepare Haney Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018...

  • Sharpe Company has provided the following budget information for the first quarter of 2018​: Total sales...

    Sharpe Company has provided the following budget information for the first quarter of 2018​: Total sales $218,000 Budgeted purchases of direct materials 40,300 Budgeted direct labor cost 37,000 Budgeted manufacturing overhead costs: Variable manufacturing overhead 1,125 Depreciation 1,100 Insurance and property taxes 6,750 Budgeted selling and administrative expenses: Salaries expense 12,000 Rent expense 4,500 Insurance expense 1,400 Depreciation expense 100 Supplies expense 10,900 Requirement 1. Prepare Sharpe Company's schedule of cash receipts from customers and schedule of cash payments for...

  • MPQ Corporation is in the process of assembling its budget for the quarter ending March 31. Please see the following sal...

    MPQ Corporation is in the process of assembling its budget for the quarter ending March 31. Please see the following sales data: Sales Price = $28 per unit January Sales In Units = 1,650 February Sales In Units = 1,400 March Sales In Units = 1,550 Budgeted sales are 30% cash and 70% credit Accounts Receivable, December 31 is $14,000. The $14,000 represents the uncollected portion of December sales. The company prefers inventory equal to 27% of the net month’s...

  • MPQ Corporation is in the process of assembling its budget for the quarter ending March 31. Please see the following sal...

    MPQ Corporation is in the process of assembling its budget for the quarter ending March 31. Please see the following sales data: Sales Price = $28 per unit January Sales In Units = 1,650 February Sales In Units = 1,400 March Sales In Units = 1,550 Budgeted sales are 30% cash and 70% credit Accounts Receivable, December 31 is $14,000. The $14,000 represents the uncollected portion of December sales. The company prefers inventory equal to 27% of the net month’s...

  • P22-40A (book/static) Bradley Company has the following post-dosing trial balance on December 31 2018 11! (Click...

    P22-40A (book/static) Bradley Company has the following post-dosing trial balance on December 31 2018 11! (Click the icon to view the post-closing trial balance) The company's accounting department has gathered the following budgeting information for the first quarter of 2019 Click the icon to view the budgeting information ) Additional information a Direct materials purchases are paid 70% in the quarter purchased and 30% in the next quarter b. Direct labor, manufacturing overhead, selling and administrative costs, and income tax...

  • Kling Company Budgeted Income Statement For the Quarter Ended March 31, 2018 January February March Total...

    Kling Company Budgeted Income Statement For the Quarter Ended March 31, 2018 January February March Total (20% increase per month) Net Sales Revenue 25,000 $ 30,000 S 38,000 S 91,000 Cost of Goods Sold (60% of sales) 15,000 18,000 21,600 54,800 Gross Profit 10,000 12,000 14,400 38,400 ($2,200 8% of sales) 5,080 S and A Expenses 4,200 4,800 13,880 5,800 Operating Income 7.400 9,320 22,520 Income Tax Expense (10 % of operating income) 580 740 932 2,252 5,220 $ 6,660...

  • Direct Labor Budget For the Year Ended December 31, 2019 First Second Third Quarter Quarter Quarter...

    Direct Labor Budget For the Year Ended December 31, 2019 First Second Third Quarter Quarter Quarter Fourth Quarter Total Direct labor hours needed for production Budgeted direct labor cost i - X More Info (Unless otherwise noted, assume all of the following events occurred during 2018 and that any balances given are stated as of December 31, 2018.) a. Budgeted sales are 1,100 tires for the first quarter and expected to increase by 250 tires per quarter. Cash sales are...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT