Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What are the comments on the budgeted cash position? And what are suggestions of ways the monthly budgeted cash balances could be improved? City Ltd.

What are the comments on the budgeted cash position?

And what are suggestions of ways the monthly budgeted cash balances could be improved?

image text in transcribed

City Ltd. Assignment Hjem Sett inn Tegn Sideoppsett Formler Data Se gjennom Visning X Calibri (Brad.... 12 A- A- Q Sek i ark 2+ Del . AY Q: Format Sorter Sak att ag filtrar og marke Bryt takst Standard TX Lim in . FK K D.. A + Sl sammen og midtstill . % 900 Slatt Sett inn , Betinget Formater Callastilor formatering sem tabell 033 A B D E F G H K L N 1 E c M Cash Budget 2 2 for the year ended March 31, 2021 3 April May June July August September October November December January February IMarch Year 4 Begginning Cash Balance 13 066 - 271 132 236 138 - 167 114 - 107 780 42 844 209 818 364 522 554 026 796 660 1 002 334 5 Cash Collection from Sales 33 000 E 38 500 E 338 250 E 398 750 E 426 250 E 525 250 E 552 750 E 555 500 E 574 750 594 000 544 500 497 750 5 079 250 6 Cash from issue of Ordinary shares E 140 000 140 000 7 Total Cash Available 173 000 25 434 67 118 E 162 612 259 136 417 470 595 594 765 318 939 272 1 148 026 1 341 160 1 500 084 ES 219 250 8 Less: Cash Disbursements 9 For Purchases f 100 500 E 105 750 E 115 500 143 250 E 150 000 150 750 158 250 163 500 148 500 E 135 000 135 750 1 506 750 10 For Direct Labour 80 400 84600 73 920 91 680 96 000 96 480 101 280 104 640 95040 86 400 86 880 90 240 1 087 560 11 For Manufactoring Overhead 89 983 94 183 E 83 503 E 101 263 E 105 583 E 106 063 E 110 863 E 114 223 104 623 E 104 623 95 983 96 463 E 99 823 E1 202 560 12 For Admin and Distribution Expense 15 683 E 17283 E 18 083 21 283 22 083 22 083 22 883 23 683 22 083 22 083 20 483 20 483 21 283 E 247 400 13 For Purchase of Equipment 22 000 22 000 14 Total Cash Disbursements 186066 E 296 566 E 303 256 E 329 726 E 366 916 E 374 626 E 385 776 E 400 796 E 385 246 351 366 338 826 347 096 E4066 262 15 16 Ending Cash Balance 13 066 - 271 132 - 236 138 -E 167 114 - 107 780 E 42 844 E 209 818 E 364 522 554 026 E 796 660 E1 002 334 1 152 988 E1 152 988 17 18 19 20 21 22 23 24 25 26 27 -E

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions