Concept explainers
BTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’
All sales are made on credit and collected as follows:
• 40% in the month of the sale;
• 35% in the month after the sale;
• 15% in the second month after the sale;
• 10% will be written off as
All purchases are made on credit and paid for as follows:
• 60% in the month of the purchase and
• 40% in the month after the purchase.
Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal instalments from August to October 2022. Cash on hand on 1st July 2022 is expected to be zero, however the company has agreed to maintain a minimum cash balance of R28 000 at all times with immediate effect.
Actual sales were R180 000 for May and R130 000 for June 2022. The estimated sales are R140 000 for July, R120 000 for August, R100 000 for September and R110 000 for October. Purchases for June 2022 were R75 000. The estimated purchases are R80 000 for July, R65 000 for August, R40 000 for September and R50 000 for October.
Required:
(a) Determine the total cash receipts for the month of July
Step by stepSolved in 2 steps
- Iguana, Incorporated, manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month's sales. Ending direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: \table[[March, 350], [April, 400], [May, 450], [June, 550], [July, 525], [August, 575]] Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual fixed manufacturing overhead is estimated to be $10,800 ($900 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $950 per month plus $0.60 per unit sold. Iguana, Incorporated, had $11,900 cash on hand on April 1. Of its sales, 80 percent is in…arrow_forwardwhat is the budgeted margin of safety in sales dollars?arrow_forwardThe directors of Hamble Ltd have asked you, as a recently employed assistant management accountant, to prepare and review their cash budget. The bookkeeper started the cash budget but was unable to complete it due to ill health. In addition, Hamble Ltd requires you to evaluate the different funding options for its expansion plans. Estimated sales and purchases for each of the nine months to September are given below: Jan £,000 Feb £,000 Mar £,000 April £,000 May £,000 June £,000 July £,000 Aug £,000 Sept £,000 Credit sales 9,500 8,000 6,000 11,000 12,350 14,000 13,250 4,500 12,500 Cash sales 250 350 800 600 620 900 500 350 800 Credit purchases 6,000 5,200 5,800 8,000 8,700 6,300 5,200 5,000 5,100 Trade Receivables: Credit sales are to be collected two months after the date they have been sold. Trade Payables: Credit purchases are to be paid one month after the date they have been…arrow_forward
- Question 3. Please fill in the blanks the same way as the questionarrow_forwardplease help mearrow_forwardPrepare schedules for cash receipts and cash payments, and determine the ending balances for the relevant balance sheet accounts. E10.30 (LO 4, 5) Service Environmental Landscaping Inc. is preparing its budget for the first quarter of 2022. The next step is to prepare a cash receipts schedule and a cash payments schedule. The following information has been collected: 1. Clients usually pay 50% of their fee in the month when the service is provided, 40% the next month, and 10% in the second month after receiving the service. 2. Actual service revenues for 2021 and expected service revenues for 2022 are as follows: November 2021, $90,000; December 2021, $70,000; January 2022, $110,000; February 2022, $120,000; and March 2022, $130,000. 3. The company pays for purchases of landscaping supplies (direct materials) 60% in the month of purchase and 40% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $14,000; January 2022, $13,000; February…arrow_forward
- Hi, I need help solving the following problem. The cells requiring input are highlighted in red. Thank you.arrow_forwardClassical Furniture is a manufacturer of reproduction antique furniture. It is owned by Helen Sutton as a sole trader business. There are four employees and annual sales revenue is approximately £200,000 per year. You are required to: (a) Explain two benefits of budgetary control to Helen Sutton. (b) Suggest three budgets which Helen could use in the business to provide an adequate system of budgetary control. (c) Advise Helen of the relevant factors to consider when implementing budgetary control.arrow_forwardThe Asian Garden, a local Thai restaurant, expects sales to be $720,000 in January. Its average customer restaurant bill is $45. Only 20% of the restaurant bills are paid with cash; 70% are paid with credit cards and 10% w cards. The transaction fees charged by the credit and debit card issuers are as follows: Credit cards: S0.40 per transaction + 2% of the amount charged Debit cards: $0.35 per transaction + 1% of the amount charged Read the requirements. Requirement 1. How much of the total sales revenue is expected to be paid in cash? The total sales revenue expected to be paid in cash isarrow_forward
- BTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forwardThe president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $24,000. Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible. Past experience shows that30% of a month’s sales are collected in the month of sale, 60% in the month followingsale, and 8% in the second month following sale. The other 2% represents bad debts that are never collected. Budgeted sales and expenses for the…arrow_forwardYour fast food restaurant is located in a busy shopping mall. You are approaching the holiday season, which is known for increased foot traffic and sales due to shoppers and families looking for quick and convenient meals while shopping for gifts. Your budget activity is 500 orders, while the actual orders are 650. Revenue: RM65 (Q) Wages and salaries: RM4,000 + RM25(Q) Gasoline and supplies: RM8 (Q) Equipment maintenance: RM2.50 (Q) Some expenses are not directly related to the number of orders served. They are the fixed costs: office and shop utilities, RM800; office and shop rent, RM1,500; equipment depreciation, RM2,000; and insurance, RM800. by using flexible budget, determine whether your restaurant is doing well or not. Discuss thoroughly.arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education