From the following data, prepare a cash budget for the three months ending 31st December,2019 &nbsp

From the following data, prepare a cash budget for the three months ending 31^st December,2019

(1)

Months	Sales (AED)	Materials (AED)	Wages (AED)	Overheads (AED)
September	10000	5000	1000	200
October	20000	4000	1000	200
November	25000	3000	2500	200
December	10000	4200	2000	300

(2) Credit terms are:

(a) sales/debtors- 50% sales are on cash basis, 50% of the credit sales are collected next month.

(b) Creditors

for materials- 1 months
for wages- Same months
for overheads – 1month

(3) Cash balance on ^1st October, 2019 is expected to be AED 5000.

Note: Answers should be Kindly in Word or Excel Format

Solutions

Expert Solution

Hope you understood the solution. If you have any doubt please leave your doubt in the comment section so that I can clarify your doubt.

Thank you.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

From the following data prepare the balance sheet of X Ltd., as on 31st December, 1999....

From the following data prepare the balance sheet of X Ltd., as on 31st December, 1999. Current ratio 2.5; Quick ratio 1.5; Net working capital Rs.3,00,000 Gross profi t ratio 20% Fixed Assets turnover ratio 2 times Stock turnover ratio (Cost of sales/ Closing stock) 6 times. Average Collection period 2 months Super quick ratio .25 Fixed Assets to shareholders equity .8 Reserves and surpluses to share capital .5 Debt equity ratio .2

Prepare a Statement of Cash Flow for the year ending 2019 from the following information. 2018...

Prepare a Statement of Cash Flow for the year ending 2019 from the following information. 2018 2019 Cash 85,000 27,000 Accounts Receivable 95,000 80,000 inventory 130,000 134,000 prepaid expenses 9,500 9,000 land 89,700 130,000 PP&E 295,500 256,700 accumulated depr -30,000 -13,000 total assets 674,700 623,700 accounts payable 98,000 77,000 accrued liabilities 54,000 70,000 bonds payable 110,000 60,000 common stock 100,000 101,000 retained earnings 312,700 315,700 674,700 623,700 PP&E with a historical cost of $50,000 and a net book value of...

Use the following information to prepare a cash budget for December. The cash balance on December...

Use the following information to prepare a cash budget for December. The cash balance on December 1 is $53,400. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 77,000 $ 81,200 $ 87,800 Sales on account $ 435,000 $ 538,000 $ 644,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18%...

Freewheel is in the process of preparing its master budget for the six months ending December...

Freewheel is in the process of preparing its master budget for the six months ending December 19X2. The balance sheet for the year ended 30 June 19X2 is estimated to be as follows: Cost Deprec prov NBV Fixed assets 140.000 14.000 126.000 Current assets Stock 25.000 Trade debtors 24.600 Bank 3.000 Net current liabilities 52.600 Creditors Amount falling due within one year Trade creditors 25.000 Other creditors 9.000 34.000 Net current assets 18.600 Total assets less current liabilities 144.600 Capital...

text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements...

text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $290,000 $310,000 $280,000 Cash disbursements 270,000 350,000 290,000 The expected cash balance at January 1, 2016, is $72,000. Brewster wants to maintain a cash balance at the end of each month of at least $70,000. Short-term borrowings at...

At the beginning of the 2010 school year, Britney Logan decided to prepare a cash budget for the months of September, October, November, and December.

At the beginning of the 2010 school year, Britney Logan decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:Cash balance, September 1 (from a summer job) . . . . . . . . . . . . . . . . . ....

7aresh company has these accounts on 31st december 2019: Cash of $9,380 Wage Expense of $300...

7aresh company has these accounts on 31st december 2019: Cash of $9,380 Wage Expense of $300 Accounts Payable of $8,900 Cost of Goods Sold of $5,900 Unearned Revenue of $1,170 Gain on Sale of Equipment of $120 Inventory of $6,230 Sales Revenue of $7,510 Interest Expense of $1,280 Common Stock (no par value) of $4,610 Rent Revenue of $1,230 Retained Earnings of $2,030 Depreciation Expense of $365 Prepaid Insurance of $2,100 as of december 31st 2019, provide 7aresh's journal entry

Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...

Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 205,000 April 185,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 80 percent of sales. Payments for merchandise sold are made in the month following the month of...

Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...

Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 205,000 April 190,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of...

Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...

Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 205,000 April 190,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of...

Subjects