CACULATED IN DETAIL PLS AND DONT COPY ANSWER IN PREVIOUS CHEGG

HGA Ltd is a merchandiser. The company has a bank overdraft (khon thu chi ngn hng) of $20,000 at the beginning of October and an overdraft limit (hn mc thu chi) of $ 50,000. The directors are worried about its liquidity situation (tnh hnh thanh khon) over the last months. As a result, they have recently decided to review their plans for the next three months of the year 2021. Sales and purchases are as follows: September October November December (actual) (expected) (expected) (expected) Sales revenue $ 240,000 $ 250,000 $ 280,000 $ 330,000 Purchases $ 120,000 $ 130,000 $ 150,000 $ 140,000 a) 30% of sales are for cash, the remainder of sales are on credit terms and collected in the following month. b) Suppliers are paid one month in arrears. c) Staff members will be employed at a cost of $20,000 a month plus 10% of sales revenue which is paid in the month incurred. d) Utilities are forecasted to be $6,000 per month and paid one month in arrears. In e) Rent is $15,000 per month payable quarterly during the first week of each quarter. f) Insurance is $3,000 per month payable annually in advance. - g) The company intends to launch an advertising campaign at a cost of $20,000 in October and $30,000 in November which is paid in the month incurred. h) The company plans to buy new equipment in November for 45,000 cash. 1. Using spreadsheet, prepare a cash budget for HGA. 2. Discuss the benefits and limitations of budgets and budgetary planning and control for HGA