Budgeting Cash Collections Lowell Consulting, which sells on terms 2/10, n/30, had credit sales for March and April of $90,000 and $75,000, respectively. Analysis of Lowell's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales) In month of sale in month of following sale Uncollectible accounts, returns, and allowances Receiving Discount Beyond Discount Period Totals 40% 20% 60% 15% 20% 35% 5% 100% Determine the estimated cash collected on customers' accounts in April.
Q: Culinary Enterprises manufactures cookware sets and sells the sets to department stores. Culinary…
A: The budget is prepared to estimate the requirements for the future. A sales budget must be prepared…
Q: 1. 2. 3. You have been engaged to review the financial statements of Bonita Corporation. In the…
A: Correcting journal entries rectify errors in previously recorded financial transactions. They ensure…
Q: Mr. Stanhope has an MBA degree from Stanford University and has successfully operated a business for…
A: Taxation is the process of collecting taxes from citizens for the use of services provided by the…
Q: Additional information from the accounting records a. Annual payments of $20,000 on the finance…
A: A cash flow statement is a financial statement that provides data regarding all cash inflows that a…
Q: Determine the net present value of the investment in the machine. (Negative amounts Round your final…
A: now12345Purchase of machine-26000Reduced operating costs65006500650065006500Total cash…
Q: On July 8, Jones Inc. issued an $67,200, 9%, 120-day note payable to Miller Company. Assume that the…
A: The objective of the question is to calculate the amount of interest expense recognized by Jones…
Q: Boins Corporation, a calendar year relai S Corporation, incurred the following Section 1250…
A: The amount of a taxpayer's income that is not subject to a separate computation at the individual…
Q: Brando Company's fiscal year runs from July 1 to June 30. The company uses job order accounting…
A: Lets understand the basics.Factory overhead is a all indirect cost incurred behind production of…
Q: Optilux is considering investing in an automated manufacturing system. The system requires an…
A: Internal rate of return is the rate of return earned by the project. At IRR, present value of cash…
Q: E7-3 (Algo) Inferring Missing Amounts Based on Income Statement Relationships LO7-1 Enter the…
A: The gross profit is calculated as the difference between sales and cost of goods sold. The net…
Q: Wildhorse Corporation issued 106,000 shares of $20 par value, cumulative, 9% preferred stock on…
A: A dividend is a distribution of profits by a company to its shareholders, usually in the form of…
Q: Shoppit Co manufactures components. On 1 March 20X8 it had in stock 2,000 components which cost…
A: IAS 2, or the International Accounting Standard 2, is a standard issued by the International…
Q: Annual Amounts Sales of new product Expenses es provided.) Materials, labor, and overhead (except…
A: Businesses, investors, and creditors use cash flow as a crucial metric to evaluate a company's…
Q: During the month of March, Sandhill Co's employees earned wages of $68,000. Withholdings related to…
A: Payroll tax expense = State unemployment-tax payable + FICA taxes payable. Salaries and wages…
Q: Harris Corporation is a technology start-up in its second year of operations. The company didn't…
A: The amount of a fixed asset that is deemed consumed in the current period is known as depreciation…
Q: A retail product has the following standard costs established: • Direct Material per unit - 2 pounds…
A: As per the Honor code of Bartleby we are bound to give the answer of the first three sub parts only,…
Q: Mosaic Company applies overhead using machine hours and shows the following information. Actual…
A: Variable overhead variance is the difference between standard variable overhead cost for actual…
Q: Jose purchased a delivery van for his business through an online auction. His winning bid for the…
A: The cost basis of an asset is the original value of an asset for tax purposes, including any…
Q: The condensed form of Nordstrop Company's flexible budget for manufacturing overhead follows:…
A: Variable overhead spending variation is the difference between what variable production overheads…
Q: Partner A contributed a building with a tax basis of $6,250,000 and a book value of $9,000,000 to…
A: To calculate the Code Sec. 704(b) minimum gain, you need to determine the minimum gain that would be…
Q: A partnership has the following account balances: Cash, $84,000; Other Assets, $610,000;…
A: "Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: The Bathtub Division of Flint Plumbing Corporation has recently approached the Faucet Division with…
A: Minimum transfer price is the minimum price per unit that the Faucet division should charge the…
Q: Farmer and Taylor formed a partnership with capital contributions of $245,000 and $295,000,…
A: Total share of income = Salary allowance + Share in balance of incomeThe journal entry to allocate…
Q: Dennis contributed business assets to a new business in exchange for stock in the company. The…
A: The Income Taxes are employed for handling deferred tax, specifically highlighting that references…
Q: Accounts Cash Supplies Inventory Prepaid Insurance Machinery Acc. Depreciation Accounts payable Mr.…
A: Ledger means the account prepared where the entries related to one particular account is posted at…
Q: Gunnar Company gathered the following reconciling information in preparing its September bank…
A: The objective of the question is to determine the adjusted cash balance that would appear in the…
Q: Trenton attends the University of Wyoming. He is an undergraduate student in Animal and Veterinary…
A: The objective of the question is to calculate the maximum qualifying expense that Trenton can claim…
Q: A company issues bonds with a par value of $300,000. The bonds mature in 5 years and pay 8% annual…
A: A bond is a debt security where an investor loans money to an entity, typically a government or…
Q: Sales value and physical value allocation To-Go produces milk and sour cream from a jont process.…
A: Joint costing is one of important concept used in cost accounting. Joint costing is used where more…
Q: Question 13 On November 1, Fastly Co. sold goods and accepted a note of $72,000, six-month, with…
A: The journal entries are prepared to record the transactions on regular basis. The adjustment entries…
Q: Which of the following statements regarding a business segment is false? Multiple Choice A business…
A: The concept of a company segment and its essential needs for financial reporting.The principal…
Q: Terry owns a single member LLC. For Tax Year 2022, Terry's business had net earnings of $387,450.…
A: A Simplified Employee Pension (SEP) serves as a retirement plan designed for self-employed…
Q: On August 1, 2020, Peterson Corp. acquired 10, $ 1,000, 8% bonds at 95 plus accrued interest. The…
A: Investment can be defined as allocation of excess fund for generating returns in future. The…
Q: Determine Julie's basis in her partnership interest and tax return effects. Also, determine Julie's…
A: The basis for participation in a partnership is the owner's financial investment in the partnership.…
Q: Initial investment (for two hot air balloons) Useful life Salvage value Annual net income generated…
A: Payback Period = Initial Investment/ACFNet Present Value = Total Present Value - Initial…
Q: Retained earnings at December 31 will be: The cash balance at the end of December would be:
A: For Purpose of Determining the Retained Earning First We need the Profit and Loss Account :Miles…
Q: Which of the following statements about the capital acquisitions ratio is incorrect? Group of answer…
A: Capital Acquisition Ratio is calculated with the help of following formula Capital Acquisition Ratio…
Q: Nash Inc. is the only player in the classy snow shovel market. The variety of shovel designs…
A: Operating income is calculated by deducting all operating expenses.Operating income = Sales - Total…
Q: Hi-Tek Labs performs steroid testing services to high schools, colleges, and universities. Because…
A: What are VariancesA variance compares your budget that was set before the project started and what…
Q: Best Finance Corporation has an Italian subsidiary (Keith Solutions). In the remeasurement of the…
A: The cost of goods sold is cost incurred on the goods that are sold. It is deducted from the sales…
Q: Sato Awards has had a request for a special order of 10 silver-plated trophies from the pr normal…
A: Incremental Costing:- Under incremental costing only those costs which are relevant for taking…
Q: The plant manager of the Ohio factory is responsib for the Ohio factory (incomplete) and for the…
A: Variable costs are costs that vary with the change in the level of output whereas fixed costs are…
Q: Nature of uncollectible accounts The XYZ Corporation owns and operates hotels and casinos including…
A: Allowance for doubtful debt -There are two approaches to managing doubtful accountsa. Direct Write…
Q: Required information [The following information applies to the questions displayed below.) Income…
A: Financial Ratios: These are defined as the numbers that represent the state or health of the…
Q: A customer paid a total of $7700 for a purchase, including 13% HST (Harmonized Sales Tax). How much…
A: The federal Goods and Services Tax (GST) and provincial sales taxes from several Canadian provinces…
Q: Cherokee Incorporated is a merchandiser that provided the following information: Amount Number of…
A: Traditional Income Statement: The traditional income statement begins with sales revenue. Cost of…
Q: Oriole Enterprises Ltd. has entered into a contract beginning in February 2023 to build two…
A: Percentage of Completion MethodThis method is used to determine the revenue from the ongoing…
Q: Exercise 19-19 (Algo) EPS; stock dividend; nonconvertible preferred stock; treasury shares; shares…
A: Earnings per share is calculated by dividing the earnings available for distribution by total number…
Q: Question 4: (2 pts) Company C receives on November 8th, 2018, an invoice for the acquisition of 5…
A: The main idea is to record, in accounting entries, the purchase of elevators (assets) and related…
Q: Cullumber Company wishes to liquidate the firm by distributing the company's cash to the three…
A: A partnership is a formal arrangement by two or more parties to manage and operate a business and…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?Budgeting Cash Collections. Spencer Consulting, which invoices its clients on terms 2/10, n/30, had credit sales for May and June of $150,000 and $170,000, respectively. Analysis of Spencer's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales): In month of sale In month of following sale Uncollectible accounts, returns, and allowances Beyond Receiving Discount Discount 50% 10% Period Totals 25% 75% 10% 20% 5% 100% Determine the estimated cash collected on customers' accounts in June.NOT GRADED Budgeting Cash CollectionsSpencer Consulting, which invoices its clients on terms 2/10, n/30, had credit sales for May and June of $175,000 and $200,000, respectively. Analysis of Spencer's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales): Receiving Discount Beyond Discount Period Totals In month of sale 50% 20% 70% In month of following sale 15% 10% 25% Uncollectible accounts, returns, and allowances 5% 100% Determine the estimated cash collected on customers' accounts in June. $Answer
- Schedule of Cash Collections on Accounts Receivable and Cash BudgetBennett Inc. found that about 15% of its sales during the month were forcash. Bennett has the following accounts receivable collectionexperience: Percent collected in the month of sale Percent collected in the month after the sale Percent collected in the second month after the sale 25 68 5 Bennett's anticipated sales for the next few months are as follows: AprilMayJuneJulyAugust $250,000290,000280,000295,000300,000 (Note: Round all amounts to the nearest dollar.) Required:1. Calculate credit sales for May, June, July, and August.2. Prepare a schedule of cash receipts for July and August.CASH BUDGET; REQUIRED: Prepare a schedule showing cash collections during October. Prepare cash disbursements (payments) during October. Assuming that company had $150,000 cash balance as of October 1, calculate cash balance as of October 31. Company’s accounts receivable collection experience is as follows: Cash collected from current month’s sales; terms 1/10 n/30: 20% Cash collected from prior month’s sales (no discount) 65% Cash collected from sales two months ago: 13% Uncollectible receivables 2% Company’s estimated credit sales (company has no cash sales): July $480,000 August 420,000 September 370,000 October 350,000 November 400,000 Company’s…Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customer while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remainim 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October November December $109,000 136,000 199,000 The Accounts Receivable balance on September 30 was $73,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dolla OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 November Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: October…
- chedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $115,000 November 144,000 December 210,000 The Accounts Receivable balance on September 30 was $77,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $ $ $ September sales on account: Collected in October October sales on account:…Schedule of cash collections of accounts receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October November December $121,000 151,000 221,000 The Accounts Receivable balance on September 30 was $81,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 Line Item Description October November December Receipts from cash sales: Cash sales 30,250 37,750 55,250 September sales on account: Collected in October 81,000 October sales on account: Collected…Use the information given below to prepare the following for Altech Limited for July and August 2021:1.1 Debtors Collection Schedule 1.2 Cash Budget Note: Provide separate monetary columns for each month. Where applicable, round off amounts to the nearest Rand.Information:Extract of Statement of Comprehensive Income for the month ended 30 June 2021RSales 200 000Cost of sales 100 000Rent income 8 000Advertising 4 000Salaries and wages 10 000Rates and taxes 1 200Electricity 3 000Other operating expenses 9 000Additional information:1. The business uses a fixed mark-up of 100% on cost.2. Sales are expected to increase by 10% each month.3. Thirty percent (30%) of the sales are for cash and the balance is on credit. Collections from credit sales are as follows: 40% in the month of the sale, and these customers are entitled to a 2% discount; 55% one month after the sale. The balance is usually written off as bad debts.4. Closing Inventories are kept at a constant level. 50% of purchases…
- Budgeting-Create a forecasted balance sheet from the following information. I need an explanation on how to get the accounts receivable, ending merchandise inventory, accounts payable, and owner's equity columns for the balance sheet. Data Section: Actual and Budgeted Unit Sales: April 1,500 May 1,000 June 1,600 July 1,400 August 1,500 September 1,200 Balance Sheet, May 31, 19X5 Cash $8,000 Accounts receivable 107,800 Merchandise inventory 52,800 Fixed assets (net) 130,000 -------- Total assets $298,600 ======== Accounts payable (merchandise) $74,800 Owner's equity 223,800 -------- Total liabilities & equity $298,600 ======== Average selling price $98 Average purchase cost per unit $55 Desired ending inventory (% of next…Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. Office Mart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October November December $110,000 138,000 201,000 The Accounts Receivable balance on September 30 was $74,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales…Using a separate columnar worksheet or Excel worksheet, prepare a Cash Budget by month for the quarter ending September 30, 2021, from the following data obtained from the CONSCIOÜNESS Company. Support your solution with schedules of estimated receipts and payments. August P 16,000 150,000 July September Cash Sales P 12,000 P 18,000 Credit Sales Purchases 110,000 120,000 90,000 120,000 110,000 Operating expenses Interest expense 15,000 18,000 16,000 2,000 Credit sales are collected 50% in the month of sales, 40% on the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000, respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in the month following. Purchases for June are estimated at P80,000. Expenses include depreciation of P2,000 monthly, and are paid in the month incurred. Cash balance on June 30, 2021.