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...
-
Identify the major techniques that regulators use to monitor insurance company solvency.
-
A homeowner is using a personal loan to borrow $18,000 to replace the roof. The loan offers the option of making no payments for the first 12 months, during which the interest is compounded monthly...
-
Consider the gasoline mileage data in Table B.3. a. Fit a multiple linear regression model relatmg gasoline mileage $y$ (miles per gallon) to engine displacement $x_{1}$ and the number of carburetor...
-
Moe Green estimates the cost of future projects for a large contracting firm. Mr. Green uses precisely the same techniques to estimate the costs of every potential job, and formulates bids by adding...
-
How does ethical leadership transcend traditional paradigms of authority, emphasizing moral principles and values to inspire trust, foster transparency, and cultivate a culture of integrity within...
-
The following account balances are for Lisa Assaad, Certified Public Accountant, as of April 30, 20X1. INSTRUCTIONS Using the accounting equation form, determine the balance for Lisa Assaad, Capital,...
-
b) Where on the road and how will you as a Highway Design Engineer ensure that the driver of a vehicle always has an adequate distance to stop whenever a hazard is encountered?
-
What types of problems are more common among people who do not have their finances under control?
-
An office building has two floors of rentable space with a single tenant on each floor. All leases in the building are structured as NNN ("Triple Net") leases, and all operating expenses can be...
-
Marie's Magic Shoppe provides the following information about its single product. Targeted operating income $38,000 Selling price per unit $25.00 Variable product cost per unit $6.00 Variable...
-
You must search for 2 bibliographic materials using the Proquest platform (the material must be related to your research topic). You must prepare two paraphrase citations: one with a narrative format...
-
Can you explain the integration of COSO framework components with financial management assertions?
-
Why must you be careful when applying current to the platinum wire? a. If the wire gets too hot it can break b. The wire is sensitive and can break easily c. All options are correct d. Platinum is...
-
Let (X. A. p) be a measure space. Show that for any A,B A, we have the equality: (AUB)+(An B) = (A) + (B).
-
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...
-
Cress Trust owns houses in Marion County, for whom Rainbow Realty Group, Inc., sells, rents, and manages. The same person serves as Rainbows president and Cresss corporate trustee. Cress offers four...
-
Genevieve and William Timmons began their tenancy of a ground-floor apartment at Cobblestone Square in September 2011. Kingsley-Johnston, Inc., is a property management company responsible for...
-
Linda Miller rented 35 acres of pastureland in Wabaunsee County, Kansas, from William Burnett for $1,000 per year. Miller and her husband used the land to grow and harvest brome grass for their...
Study smarter with the SolutionInn App