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...
-
A light bulb has a normally distributed light output with mean 5,000 end foot-candles and standard deviation of 50 end foot-candles. Find a lower specification limit such that only 0.5% of the bulbs...
-
The following is an extract from the Trial Balance of a Bank as on 31st March, 2016: Debit: Bills discounted 51,50,000. Credit: Rebate on bills discounted (1.4.2015) 30,501; Discount received...
-
Yale Corporation issued to Zap Corporation \(\$ 60,000,8 \%\) (cash interest payable semiannually on July 1 and January 1) 10 -year bonds dated and sold on January 1,2020 . If the bonds were sold at...
-
Wempe Co. sold $3,000,000, 8%, 10-year bonds on January 1, 2014. The bonds were dated January 1, 2014, and pay interest on January 1. The company uses straight-line amortization on bond premiums and...
-
Determine the required monthly payments if the $8,900 loan is taken out at First National Bank of Arlington at a fixed rate of 6% per annum, simple interest, in 36-month installments. How would you...
-
In determining automobile mileage ratings, it was found that the mpg in the city for a certain model is normally distributed, with a mean of 24 mpg and a standard deviation of 1.0 mpg. Suppose that...
-
You are analyzing the shares of GoAmateur Corporation to determine whether your fund should add their shares to the portfolio. The following information is the result of your analysis: Risk-free rate...
-
A project is any piece of work, often involving many people, that is planned and organized carefully. At some point of your personal or professional life, you may have been a part of some project. It...
-
The following table shows the key figures of Lehman Brothers Inc. in Millions 2006 2007 Retained earnings 15857 19698 EBIT 5905 6013 book value of equity 19191 22490 sales 17583 19257 total assets...
-
Jean's bedroom is 10 feet by 14 feet. She has chosen a carpet which costs $29.65 per square yard. Determine her cost to carpet her room.
-
Chief Marketing Officers (CMOs) are specifically responsible for planning, developing, implementing, and monitoring the overall marketing strategy. A CMO has been assigned by the president of the...
-
1.What are some sources of privacy rights? 2.Explain the different types of claims that an individual might file that stem from an invasion of privacy under common law. 3.Define the terms notice and...
-
Task 8 Independence TestTest for independence using the runs up and runs downmethod for numbers give in Table 8.1. (Using ?=0.05 and mean=0.50). Table 8.1: Random Numbers0.960.3 2 answers
-
Southwestern Punch was made by Frutayuda, Inc. and sold in 12-ounce cans to benefit victims of Hurricane Zero. The mean number of ounces placed in a can by an automatic fill pump is 11.7 with a...
-
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....
-
What is meant by the cockroach theory of fraud?
-
The FBI estimates that fraud in the United States is annually what amount? a. \(\$ 652\) billion b. \(\$ 1\) trillion c. \(\$ 300\) billion d. \(\$ 400\) billion e. Some other amount
-
In the 2006 Wells Report, what was the third most common way of detecting fraud? a. Tips b. Internal audits c. External audits d. By accident e. Reports from the police
Study smarter with the SolutionInn App