A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After examining...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After examining the records of the company, you find the following: 1. Cash balance on 1 August is RM43,280. 2. Actual sales for June and July are as follows: Cash sales Credit sales Total sales June RM 10,200 26,100 36,300 Ho July RM 3. Credit sales are collected over three months: 30% in the month of sales, 40% in the second month, and 25% in the third month. The customers who paid in the month of sales are qualified for 3% discounts on the amount owed. While the sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. iii. 14,700 33,900 48,600 4. Inventory purchases average 80% of a month's total sales. Of those purchases, 60% are paid for in the month of purchase. The remaining 40% is paid for in the following month. 5. Salaries and wages total RM13,800 per month. 6. The company received interest from the fixed deposit accounts of RM30,000 in August 7. Taxes to be paid in August are RM5,200. 8. During August, an old piece of furniture has been sold for RM3,400 and the new one has been purchased for RM5,200, 9. Rental expenses are RM3,400 per month. 10. The administrative expense for August is RM15,000 including RM1,800 for depreciation. The owner also tells you that he expects cash sales of RM19,800 and credit sales of RM44,800 for August. No minimum cash balance is required. The owner of the company doesn't have access to short-term loans. Required: Using the information above, prepare 1. A schedule of collections received from customers. A schedule of payments to suppliers A Cash Budget. (5 marks) (5 marks) (10 marks) A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After examining the records of the company, you find the following: 1. Cash balance on 1 August is RM43,280. 2. Actual sales for June and July are as follows: Cash sales Credit sales Total sales June RM 10,200 26,100 36,300 Ho July RM 3. Credit sales are collected over three months: 30% in the month of sales, 40% in the second month, and 25% in the third month. The customers who paid in the month of sales are qualified for 3% discounts on the amount owed. While the sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. iii. 14,700 33,900 48,600 4. Inventory purchases average 80% of a month's total sales. Of those purchases, 60% are paid for in the month of purchase. The remaining 40% is paid for in the following month. 5. Salaries and wages total RM13,800 per month. 6. The company received interest from the fixed deposit accounts of RM30,000 in August 7. Taxes to be paid in August are RM5,200. 8. During August, an old piece of furniture has been sold for RM3,400 and the new one has been purchased for RM5,200, 9. Rental expenses are RM3,400 per month. 10. The administrative expense for August is RM15,000 including RM1,800 for depreciation. The owner also tells you that he expects cash sales of RM19,800 and credit sales of RM44,800 for August. No minimum cash balance is required. The owner of the company doesn't have access to short-term loans. Required: Using the information above, prepare 1. A schedule of collections received from customers. A schedule of payments to suppliers A Cash Budget. (5 marks) (5 marks) (10 marks)
Expert Answer:
Answer rating: 100% (QA)
1 ii RIELX AND CHILL COFFEE SHOP CASH COLLECTION BUDGET FOR AUGUST Cash sales Credit sales Total Sal... View the full answer
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-1111879044
2nd edition
Authors: Rich, Jeff Jones, Dan Heitger, Maryanne Mowen, Don Hansen
Posted Date:
Students also viewed these accounting questions
-
The purpose of this assignment is to make sure that the students can work with the fork, pipe, and dup system calls. It should also grant some insight into how the shell makes input/output...
-
Write a blog post of no more than 800 words . The blog post should include five elements; particularly, it should -have a title and an image -have a logical structure and be targeted for a specific...
-
The purpose of this assignment is to conduct research related to how a specific company utilizes information related to consumer behavior, product mix or service processes, and pricing to create...
-
A study in Batu Pahat General Hospital's on patient account division has compiled data on the age of accounts receivables. The data collected indicates that the age of the accounts follows a normal...
-
How is file size a disadvantage in a database environment?
-
The expected period of time that will elapse between the date of a capital investment and the complete recovery of the amount of cash invested is called the: a. average rate of return period. b. cash...
-
Find f0.05 for F8,18.
-
Michael McNamee is the proprietor of a property management company, Apartment Exchange, near the campus of Pensacola State College. The business has cash of $ 8,000 and furniture that cost $ 9,000...
-
Convert the integrals to polar coordinates and evaluate them. (1) Lo (2) .3 L S 9-x2 So = (x + y) dx dy .2 0 4-y (x + y) dx dy
-
InstraMatronics, a distributor of electrical monitoring equipment, is looking to reduce inventory costs. Hal, the new materials manager, is considering the inventory policy for HS008, a popular...
-
The next three questions pertain to the following information You just came back from Bali, Indonesia, where the Indonesian Rupiah (IDR) was worth $.00007. You still have IDR4,000,000 from your trip...
-
Allocation is based on the principle of ballarice and both that there is a relationship between land value and total property value. For example, if properties sell for an average of $167,600 and the...
-
The book value of equity of a company in 2020 is $1,000 million. This company's ROE is 20% and the payout ratio is 40%. Both are expected to remain constant in the future. i) What are the net...
-
Abed says he has written a system of two linear equations that has an infinite number of solutions. One of the equations of the system is y=3x-1. What could be the other equation?
-
Three external forces are applied to a truss as shown. The truss is supported by a pin at F and a roller at G. Determine the force in members BD, CD and CE of the truss. If the member is in...
-
A Corp. and B Corp. exchange equipment in a transaction lacking commercial substance. The equipment relinquished by A Corp. has a book value of $80,000 (original cost of $140,000 with accumulated...
-
Calculate the Net Present Value and the Profitability Index for the following cash flows assuming Saif Company's cost of capital is 8%. Is the project acceptable? Cash Flow (Dollars) End of Year 0 1...
-
Why do CPA firms sometimes use a combination of positive and negative confirmations on the same audit?
-
Carson Corporation reported the following amounts for assets and liabilities at the beginning and end of a recent year. Required: Calculate Carsons net income or net loss for the year in each of the...
-
Smithson Products sells shoes and accessories to retail stores. Gross sales in 2011 were $1,500,250 (Smithsons list price) on terms 4/10, n/30. Customers paid for $1,200,000 (Smithsons list price) of...
-
The Lubbock plant of Morrils Small Motor Division produces a major subassembly for a 6.0 horsepower motor for lawn mowers. The plant uses a standard costing system for production costing and control....
-
Discuss the approach you would take to building a system for playing Scrabble or another word game of the sort. What limitations does your system have? How likely do you think it is that your system...
-
Discuss the current state of the art of game-playing computer systems in relation to the following games: chess, checkers, Go, bridge, Othello, tic-tac-toe. What advances are likely in the near...
-
Show the steps that would be taken in running the Minimax algorithm on the game tree in Figure 6.7. Now run through the same tree using alpha-beta pruning. How do the two compare? data from figure...
Study smarter with the SolutionInn App