HomeworkLib
Question

Axiom Inc. has a sales projection of $600,000 in April, $700,000 in May, $800,000 in June...

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?

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1
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
0 0
Add a comment
Know the answer?
Add Answer to:
Axiom Inc. has a sales projection of $600,000 in April, $700,000 in May, $800,000 in June...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Schedule of Projected Cash Disbursements for Maris Brothers, Inc. Feb Mar Apr May Jun Jul Sales...

    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,...

    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,...

    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 a. Prepare a cash disbursement schedule for the months of April, May and June...

    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...

    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...

    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...

    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 Budget The owner of a building supply company has requested a cash budget for June....

    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...

  • CASH FLOW FORECAST Happy Manufacturing had sales of $65,000 in March and $75,000 in April. Forecast...

    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...

  • Sherman has budgeted sales for the upcoming quarter as follows: April May June Units 1,600 1,900...

    Sherman has budgeted sales for the upcoming quarter as follows: April May June Units 1,600 1,900 1,750 The desired ending finished goods inventory for each month is one-half of next month's budgeted sales. Three pounds of direct material are required for each unit produced. If direct material costs $5 per pound, and must be paid for in the month of purchase, the budgeted direct materials purchases (in dollars) for April are:

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT