Axiom Inc. has a sales projection of $600,000 in April, $700,000 in May, $800,000 in June and $1,000,000 inJuly. Axiom's purchases are calculated as 50% of the NEXT MONTH'S sales. 10% of Axiom's purchases are made in cash, 60% of purchases are paid for 1 month after purchase, 30% of purchases are paid for 2 months after purchase. Axiom also pays $16,000 in rent every month and $10,000 in salaries every month.What is the projected cash disbursement for Axiom for June?
April | May | June | July | |
Projected sales | 600000 | 700000 | 800000 | 1000000 |
Purchases [ 50% * Next month's sales ] |
350000 [ 50% * 700000 ] |
400000 [ 50% * 800000 ] |
500000 [ 50% * 1000000 ] |
June | |
Cash disbursement : | |
10% of June's purchases [ 10% * 500000 ] | 50000 |
60% of May's Purchases [ 60% * 400000 ] | 240000 |
30% of April's purchases [ 30% * 350000 ] | 105000 |
Rent | 16000 |
Salaries | 10000 |
Total cash disbursement for June | 421000 |
Axiom Inc. has a sales projection of $600,000 in April, $700,000 in May, $800,000 in June...
Schedule of Projected Cash Disbursements for Maris Brothers, Inc. Feb Mar Apr May Jun Jul Sales $ $ $ Disbursements Purchases $ $ $ Cash $ 1 month delay $ 2 month delay $ Rent $ Wages and salary Fixed $ Variable $ Taxes $ Fixed assets $ Interest $ Cash dividends $ Total Disbursements $ Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here...
Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here and the following information in its preparation. Sales: February $481,000; March $510,000; April $562,000; May $594,000; June $626,000; July $658,000 Purchases: Purchases are calculated as 56% of the next month's sales, 10% of purchases are made in cash, 51% of purchases are paid for 1 month after purchase, and the remaining 39% of purchases are paid...
Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here i and the following information in its preparation. Sales: February $505,000; March $522,000; April $575,000; May $597,000; June $653,000; July $643,000 Purchases: Purchases are calculated as 65% of the next month's sales, 10% of purchases are made in cash, 47% of purchases are paid for 1 month after purchase, and the remaining 43% of purchases are...
Question 9 Prepare a cash disbursement schedule for the months of April, May and June 2019 for Mario Brothers, Inc. based on the following information: a.Sales: February = $500,000; March = $500,000; April = $560,000; May = $610,000; June = $650,000; July = $650,000 b. Purchases are calculated as 60% of the next month's sales, 10% of purchases are made in cash, 50% of purchases are paid for 1 month after purchase, and the remaining 40% of purchases are paid for 2 months...
Question : 1 Budgeted Sales April (Actual) S7200,000 May 8400,000 June 1 020,000 July 1.080,000 August 600,000 September 900,000 Additional information Cash Sales 40% Credit sales (Collected the following month) 60% Prepare Sales Budget and Cash Collection from customers from May to August Solution: Schedule a Sales Budget Code Sales Schedule b. Cash Collection from Customers Collection Price month Tool Collection Question-2: A manufacturing Company provided the following information Budgeted Sales December (Actual) S480,000 January 560,000 February 680,000 March 720,000...
April May June July $ 500,000 $700,000 $400,000 $300,000 350,000 490,000 280,000 210,000 150,000 210,000 120,000 90,000 Sales Coat of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income 70,000 90,000 51,000 30,000 40,000 52, 800 32,000 28.000 110,000 142,800 83,000 58,000 $ 40,000 $ 67,200 $ $7,000 $32,000 "Includes $12,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. c. Sales on account...
Cash budget-Basic Grenoble Enterprises had sales of $49,600 in March and $60,500 in April. Forecast sales for May, June, and July are $70,300, $80,200, and $99,600, respectively. The firm has a cash balance of $4,600 on May 1 and wishes to maintain a minimum cash balance of $4,600. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 25% of sales for cash, 62% are collected in the...
CASH FLOW FORECAST Happy Manufacturing had sales of $65,000 in March and $75,000 in April. Forecast sales for May, June and July are $85,000, $95,000, and $120,000, respectively Given the following data, calculate monthly net cash flow for the months of May, June, and July (1) The firm makes 20% of sales for cash; 30 % are collected in the next month, and the remaining 50% are collected in the second month following the sale. The firm receives other income...
Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: a. Cash balance on June 1 is $1,086. b. Actual sales for April and May are as follows: April May Cash sales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 C. Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and...
Prepare the cash budget for the months of april may and june The following actual and budgeted sales relate to AgriTech Company, a distributor of agricultural products located somewhere in the Midwest. March (actual).... April May. June.. July............................. $50,000 60,000 72,000 90,000 48,000 The company's top executives intend to have 25% of sales as gross margin. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The company's inventory manager informs that...