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 |
pleSe i need it in 5 mins please urgent 1 Use the following information to prepare...
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 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 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 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 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 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. 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 $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 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 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...