Fairways is a wholesale distributor of auto spare parts in UAE. Thus, peak sales occur in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Fairways is a wholesale distributor of auto spare parts in UAE. Thus, peak sales occur in August due to Ramadan as shown in the company's sales budget for the third quarter, given below: Jul Aug Sept Budgeted Sales (All on account in AED) 600,000 750,000 500,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. May sales totaled $450,000, and June sales totaled AED 550,000. Required: Prepare a schedule of expected cash collections from sales by month. (July, August, and September). Ajman Products, Inc., is a merchandising company that sells school supplies. The company is planning its cash needs for the third quarter. In the past, Ajman Products had to borrow money during the third quarter to support peak sales of back-to-school materials, which occurs during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. The Total cash collections and disbursement for purchases are as follows (All amounts are in dollars): Jul Aug Sept Total Cash collection 80,000 47,760 59,600 Total Cash disbursed for purchases 95,000 31,250 30,375 Selling and administrative expenses will be incurred as follows: Selling expenses 7,200 9,700 8,500 5,600 Administrative expenses 6,100 7,200 b. Land costing $4,500 will be purchased in July. c. Dividends of $5,000 will be declared and paid in September. d. The cash balance on July 1st is $9,500; the company must maintain a cash balance of at least $10,000 at the end of each month. e. The company has an agreement with a local bank that allows it to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 12% per year. The company would repay the loan plus accumulated interest at the end of the quarter. Required: Prepare a cash budget for July, August and September. 1. A schedule of expected cash collections (15 marks) 2. A cash budget (20 marks) Fairways is a wholesale distributor of auto spare parts in UAE. Thus, peak sales occur in August due to Ramadan as shown in the company's sales budget for the third quarter, given below: Jul Aug Sept Budgeted Sales (All on account in AED) 600,000 750,000 500,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. May sales totaled $450,000, and June sales totaled AED 550,000. Required: Prepare a schedule of expected cash collections from sales by month. (July, August, and September). Ajman Products, Inc., is a merchandising company that sells school supplies. The company is planning its cash needs for the third quarter. In the past, Ajman Products had to borrow money during the third quarter to support peak sales of back-to-school materials, which occurs during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. The Total cash collections and disbursement for purchases are as follows (All amounts are in dollars): Jul Aug Sept Total Cash collection 80,000 47,760 59,600 Total Cash disbursed for purchases 95,000 31,250 30,375 Selling and administrative expenses will be incurred as follows: Selling expenses 7,200 9,700 8,500 5,600 Administrative expenses 6,100 7,200 b. Land costing $4,500 will be purchased in July. c. Dividends of $5,000 will be declared and paid in September. d. The cash balance on July 1st is $9,500; the company must maintain a cash balance of at least $10,000 at the end of each month. e. The company has an agreement with a local bank that allows it to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 12% per year. The company would repay the loan plus accumulated interest at the end of the quarter. Required: Prepare a cash budget for July, August and September. 1. A schedule of expected cash collections (15 marks) 2. A cash budget (20 marks)
Expert Answer:
Answer rating: 100% (QA)
1 2 Schedule of expected cash collection July May S... View the full answer
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
Peak sales for Midwest Products, a wholesale distributor of leaf rakes, occur in August. The companys sales budget for the third quarter showing these peak sales is given below: From past experience,...
-
The Allen Company is a wholesale distributor of automotive replacement parts. Initial amounts taken from Allens accounting records are as follows: Inventory at December 31, 2007 (based on physical...
-
The treasurer of Westmark Industrial, Inc., a wholesale distributor of household appliances, wants to estimate his companys cash balances for the first three months of 2015. Using the information...
-
After their divorce, Brian Bermudez and Amanda Schmidt shared custody of their son. Schmidt suspected Bermudez of abusing the child, so she refused to let him visit. Bermudez filed a petition...
-
Excel project: using benfords law to detect potential disbursements fraud.* Required Read the article using spreadsheets and benfords law to test accounting data, By mark g. Simkin in the isaca...
-
Here is a question that a panel of judges decided: Can a company patent how it makes a peanut butter and jelly sandwich? More specifically, in this instance, judges considered whether J. M. Smuckers...
-
A design group has two possible wing designs \((A\) and \(B\) ) for an airplane wing. The planform area of either wing is \(130 \mathrm{~m}^{2}\) and each must provide a lift of \(1,550,000...
-
Frate Company was formed on January 1, 2014. The following information is available from Frates inventory records for Product Ply: .:. A physical inventory on December 31, 2014, shows 1,600 units on...
-
Based on an aging of accounts receivables, management assigned 1% to the $100,000 of receivables 0-30 days outstanding, 5% to the $10,000 receivables 31-60 days and 20% to the $1,000 of receivables...
-
Design a class hierarchy to represent syntax trees for the CFG of Figure 4.5. Provide a method in each class to return the value of a node. Provide constructors that play the role of the make_leaf,...
-
Medical notes must be signed by the physician Question 22 options: True False
-
Discuss the 4-Vs and how they relate to the company's current state and how the proposed Desron opportunity would change them
-
Design a model with methods and procedures for analyzing diversity and how you would implement the results in a cultural diversity training program.
-
What is productivity and how does it affect transportation economics? Again, look at what productivity is and choose what topic about productivity you are driven to and apply that to how it affects...
-
When the judge rendered his opinion on a property fraud case, he told the defendant "he was a liar and a cheat and the maximum civil sentence would be imposed on him under the law." This statement by...
-
According to the Agile Manifesto, how often should a team reflect on how to become more effective?
-
Can you recall a time you worked on a project with multiple people? What was the project? What was the outcome?
-
Use of the contraceptive Depo Provera appears to triple women's risk of infection with chlamydia and gonorrhea , a study reports today. An estimated 20 million to 30 million women worldwide use Depo...
-
Shirts Unlimited operates a chain of shirt stores around the country. The stores carry many styles of shirts that are all sold at the same price. To encourage sales personnel to be aggressive in...
-
CompuDesk, Inc., makes an oak desk specially designed for personal computers. The desk sells for $200. Data for last years operations follow: Units in beginning inventory . . . . . . . . . . . . . ....
-
Tundra Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below: Sales...
-
Is employee selection an unbiased process? Why?
-
Explain the methods of inequity resolution.
-
Is impression management negative or positive? Why?
Study smarter with the SolutionInn App