Question

1 Use the following information to prepare a cash budget for months 1 & 2 only: -Expected sales for the following months 1,2,
pleSe i need it in 5 mins please urgent
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Particulars 1st Month 2nd Month 3rd Month
Sales 100000 120000 150000
Cash Sales @ 50% (A) 50000 60000 75000
Another 50% received in next months (B) 50000 60000
Total Cash Collected (A+B = P) 50000 110000 135000
Purchases @ 60% of next month sales (X) 72000 90000 120000
Cash Expenses @ 20% of current Month sales (Y) 20000 24000 30000
Total Cash Disbursed (X+Y = Q) 92000 114000 150000
Net cash Flow(P-Q = C) -42000 -4000 -15000
Opening Cash Balance ( E) 12000 10000 10000
Cash Budget (D-C-E) 40000 4000 15000
Closing Cash Balance 10000 10000 10000
Add a comment
Know the answer?
Add Answer to:
pleSe i need it in 5 mins please urgent 1 Use the following information to prepare...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Please prepare the master budget, but please use template i provided. The template is the last...

    Please prepare the master budget, but please use template i provided. The template is the last 3 pages i attached and the steps are numbered.The first page is the actual question. Thank you ...) Oxford, Inc., is preparing its master budget for the quarter ended June 30. It sells a single product for $40 each. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. At March 31. the balance in...

  • please help with these questions, managerial cost accounting.. thank you You have been asked to prepare...

    please help with these questions, managerial cost accounting.. thank you You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $58,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 73,200 $ 78,000 $ 92,000 $ 485,000 $ 568,000 $...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $51,400. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 71, 600 S 80,200 $ BB, 600 $ 120,000 $$80,000 $ 652,000 Sales on account are collected over a three-month...

  • Precise Speed Inc., a laser printer manufacturer, has the following forecasted sales for 2018: January February...

    Precise Speed Inc., a laser printer manufacturer, has the following forecasted sales for 2018: January February March April May June July $200,000 $350,000 $400,000 $350,000 $250,000 $250,000 $300,000 Actual sales in November and December 2017 were $375,000 and 266,667, respectively. Sixty percent of sales are on credit. The firm collects 60% of these credit sales during the first after the sale and the remainder during the following second month. Purchases constitute 60% of the next month's sales. The company pays...

  • 1: Prepare a sales budget, including a schedule of expected cash collections. 2: prepare a merchandise...

    1: Prepare a sales budget, including a schedule of expected cash collections. 2: prepare a merchandise purchase budget, including a schedule of expected cash disbursements for merchandise, and a selling and administrative budget. 3: prepare a cash budget. MOST LIKELY NUMBERS AND ASSUMPTIONS SALES MANAGER PRIVATE INFORMATION October Most likely sales 600,000 910,000 475,000 385,000 PURCHASING MANAGER PRIVATE INFORMATION Most likely cost of merchandise as a % of sales Desired ending inventory as a percentage of next month's cost of...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The foll...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: points a. The cash balance on December 1 is $56,600. b. Actual sales for October and November and expected sales for December are as follows: eBook Cash sales Sales on account October November December $ 71,200 $ 73,400 $ 86,200 $ 440,000 $ 576,000 $ 639,000 Print Sales on account are collected over...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. Th...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $40,000, b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 65,000 $ 400,000 November $ 70,000 5 525,eee December $ 83,000 $ 600,000 Sales on account are collected over a three-month period...

  • PLEASE HELP I HAVE TO HAVE THIS DONE SOON Cash budget—Basic Grenoble Enterprises had sales of...

    PLEASE HELP I HAVE TO HAVE THIS DONE SOON Cash budget—Basic Grenoble Enterprises had sales of $50,200 in March and $59,800 in April. Forecast sales for​ May, June, and July are $70,300​, $79,900​, and $100,500​, respectively. The firm has a cash balance of $5,100 on May 1 and wishes to maintain a minimum cash balance of $5,100. Given the following​ data, prepare and interpret a cash budget for the months of​ May, June, and July. (1) The firm makes 16%...

  • Please make sure answers are correct. The following data was obtained from the 2019 budget for...

    Please make sure answers are correct. The following data was obtained from the 2019 budget for Yik Yak Basecamp Supplies Co. Operating Month July Sales Purchases Expenses $112,000 $49,400 $41,600 August$125,000 $53,000 $42,250 September $150,000 $57,000 $43,000 October$%180,000 $59,600 $42,900 November $185,000 $68,600 $42,750 December $170,000 $40,400 $42,000 All sales are made on credit. Collections on customer accounts are: 5% in the month of sale; 65% one month after sale, and 30% two months after sale. All purchases are made...

  • Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed...

    Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by...

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
ADVERTISEMENT