JANUARY FEBRUARY MARCH ABBOT MERCHANDISE Purchases Returns $21,948 $14,576 $12,945 $4,367 $987 $2,398 Discounts $2,000 $100 $1,156 CABOT FARMS Purchases $12,978 $9,567 $14,503 Returns $1,298 $876 $904 Discounts $100 $400 $250 DIVERSITY SERVICES Purchases $18,756 $15,678 $12,987 Returns $257 $125 $359 Discounts $25 $75 $250 displayed information, what was the total amount paid to Diversity Service $46,330

JANUARY FEBRUARY MARCH ABBOT MERCHANDISE Purchases Returns $21,948 $14,576 $12,945 $4,367 $987 $2,398 Discounts $2,000 $100 $1,156 CABOT FARMS Purchases $12,978 $9,567 $14,503 Returns $1,298 $876 $904 Discounts $100 $400 $250 DIVERSITY SERVICES Purchases $18,756 $15,678 $12,987 Returns $257 $125 $359 Discounts $25 $75 $250 displayed information, what was the total amount paid to Diversity Service $46,330

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 12EA: Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the...

See similar textbooks

Similar questions

Month Sales Purchases Cash Expenses Paid May $ 97,000 $ 64,000 $ 23,000 June 119,000 92,000 28,000 July 131,000 115,000 33,500 August 125,000 71,000 30,100 The majority of Martin’s sales (70 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin’s purchases are on account with 40 percent paid in the month of purchase and 60 percent paid the following month. Determine budgeted cash collections for July and August. Determine budgeted cash payments for July and August.
is a retailer. Its accountants are preparing the company's 2nd quarter master budget. The company has the following balance sheet as of March 31. Inc. Balance Sheet March 31 Assets Cash $ 83,000 Accounts receivable Inventory 126,000 69,750 220,000 Plant and equipment, net of depreciation Total assets $ 498,750 Liabilities and Stockholders' Equity Accounts payable Common stock $ 81,000 348,000 69,750 Retained earnings Total liabilities and stockholders' equity $ 498,750 accountants have made the following estimates: 1. Sales for April, May, June, and July will be $310,000, $330,000, $320,000, and $340,000, respectively. 2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April. 3. Each month's ending inventory must equal 30% of next month's cost of goods sold. The cost of goods sold is 75% of sales. The company pays for 40% of its merchandise…
Month Cash Sales Sales on Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month following the sale ii) Expected purchases include monthly cash purchases of 5%. All other purchases are on account. Accounts payable are settled as follows, in accordance with the credit terms –2/30, n60:60% in the month in which the inventory is purchased40% in the following month iii) Fixed operating expenses which accrue evenly throughout the year, are estimated to be $1,680,000 per annum, (including depreciation on non-current assets of $420,000 per annum) and is settled monthly. iv) Wages and salaries are…
What would be the cash disbursements for month 3? Description Month 1 Month 2 Month 3 Month 4 Material Purchases $ 175,000.00 $ 185,000.00 $ 215,000.00 $ 190,000.00 Amount paid in month of purchase 65.00% Amount paid in month after purchase 30.00% Amount paid two months after purchase 5.00% Discounts in month of purchase 3.50% Discount in month after purchase 1.00% Total Cash disbursements in month 3 Show your work below Description Month 1 Month 2 Month 3
Prepare a schedule of 15 The owner of a small mining supply company has requested a cash budget é After examining the records or the company, you find the following: ch Budget ust. a. Cash balance on June 1 is $345. b. Actual sales for April and May are requires develope Overh prod April Мay Cash sales Credit sales Mai $ 10,000 25,000 $35,000 Pov $15,000 25,000 Inc Re Total sales $40,000 c. Credit sales are collected over a three-month period: 50 percent in the month of sale, 30 percent in the second month, and 15 percent in the third month. The sales collected in the third month are subject to a 1.5 percent late fee, but only half of the affected customers pay the late fee, and the owner does not think it ie worth his while to try to collect from the other half. The remaining sales are Requ 1. L 2. uncollectible. d. Inventory purchases average 60 percent of a month's total sales. Of those pur- chases, 40 percent are paid for in the month of purchase. The remaining 60 per- cent are…
Jan Feb March Purchases on account $260,000 $293,000 $330,000 The vendors have required the following terms of payment: Month of purchase 30% First month after the purchase 35% Second month after the purchase 35% Calculate the total payment on account for the month of March.
Forecast Sales Jan Feb Mar Apr $200,000 $160,000 $180,000 $45,000 Balance Sheet Data December 31,2010 Cash $80,000 Account receivable: 45000 50000 54000 27000 November sales December sales Inventory Account payable(merchandise) Other data are as follows • Sales are on credit with 60% of sales collected in the same month after sale ,40% in the second month after sale • Cost of goods sold is 50% of sales • Other variables costs are 30% of sales paid in the month incurred Inventories are to be 80% of next month's budgeted sales requirements Fixed expenses are $15000 per month, all require cash Credit time period for purchases are 30 days On basis of above information answer following questions Calculate estimated closing inventory in the month of February 2011? Note: No need to enter answer with comma
Year 1 Apr. 20 Purchased $49,750 of merchandise on credit from Nguyen, terms n/30. May 19 Replaced the April 20 account payable to Nguyen with a 90-day, 8%, $38,000 note payable along with paying $11,750 in cash. July 8 Borrowed $102,000 cash from NMR Bank by signing a 120-day, 10%, $102,000 note payable. Aug. 17 Paid the amount due on the note to Nguyen at the maturity date. Nov. 5 Paid the amount due on the note to NMR Bank at the maturity date. Nov. 28 Borrowed $60,000 cash from Chicago Bank by signing a 60-day, 6%, $60,000 note payable. Dec. 31 Recorded an adjusting entry for accrued interest on the note to Chicago Bank. Year 2 Jan. 27 Paid the amount due on the note to Chicago Bank at the maturity date. 1. Prepare a Calculation of Interest Gonzalez Co. Calculation of interest expense August 17 - Nguyen note: Principal Interest rate Number of days' interest to be recorded…
Question Completion Status: Forecast Sales Jan Feb Mar $200 000 $160.000 $180,000 $45,000 Apr Balance Sheet Data December 31,2010 Cash $80,000 Account receivable: November sales 45000 December sales 50000 Inventory Account payable(merchandise) 54000 27000 Other data are as follows: • Sales are on credit with 60% of sales collected in the same month after sale 40% in the second month after sale • Cost of goods sold is 50% of sales • Other variables costs are 30% of sales paid in the month incurred • Inventories are to be 80% of next month's budgeted sales requirements • Fixed expenses are $15000 per month; all require cash • Credit time period for purchases are 30 days On basis of above information answer following questions Find Net Profit for the ended of March 2011? ^ @ d ENG
Sales Revenue: November December January Total Sales $9,300.00 $ 12,000.00 $ 21,120.00 February Total Expenses $ 14,029.00 NET INCOME -$4,729.00 -$3,710.00 $ 16,080.00 $ 15,710.00 $ 26,637.00 $ 23,721.00 TOTAL $ 58,500.00 $ 80,097.00 -$5,517.00 -$ 7,641.00 -$ 21,597.00 Write down key information or brief description and 2 highlights contained in the chart. What is the trend of net income in the four months of operation?
A credit sale of $3800 is made on April 25, terms 1/10, n/30, on which a return of $300 is granted on April 28. What amount is received as payment in full on May 4? $3465 • $3800 • $3500 Ⓒ $3762
Cash receipts Cash payments For inventory purchases For S&A expenses January $ 107,000 February $113,000 March $ 133,000 93,500 34,500 75,500 35,500 88,500 30,500 Franklin Medical had a cash balance of $11,500 on January 1. The company desires to maintain a cash balance of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent per month. Repayments may be made in any amount available. Franklin pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. Note: Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign. > Answer is complete but not entirely correct. Cash Budget Section 1: Cash Receipts Beginning cash balance January February March $ 11,500 $ 6,700 $ 6,000 Add:…