11:21 at .ill 90% i. The college currently has a loan of 200,000 at an interest rate of 6% per annum. Interest paid quarterly and will be due in September and December. j. The opening cash balance as at 1 July 2024 is expected to be 50,000 Questions to be answered on the online quiz 1 Number of courses offered in 2023 2 Total Sales revenue for proposal i 3 Total variable costs for proposal i 4 Total contribution for proposal i 5 Profit for proposal i 6 Total Sales revenue for proposal ii 7 Total variable costs for proposal ii 8 Total contribution for proposal ii 9 Profit for proposal ii 10 Break even for proposal i 11 Break even for proposal ii 12 Number of courses to achieve 450k target profit in proposal ii 13 What is the total cash inflow in July 2024 based on the cash budget 14 How much loan interest was paid in September 2024 15 What is the cash outflow for excel training in September 2024 16 How much is cash outflow for the variable cost for day courses in July 2024 17 How much is the inflow from excel training in August 2024 18 What is the closing cash balance in July 2024 19 What is the cash outflow for excel training in August 2024 20 What is the total cash outflow for December 2024 ||| 11:21 ..ill 90% TASK William College Ltd provides day courses for businesses. During 2023, the courses were offered at 80 each and the variable cost was 50. The profit for the year was 300,000, after allowing fixed costs of 240,000. In 2024, it is anticipated that the variable cost per course will increase by 4, due to an increase in lecturer's remuneration. Fixed costs are also expecte to increase by 20,000. The management has heard that its main competitor, Kate College Ltd, is likely to increase the price of its courses in 2024. As demand for these business courses is always very high, the management believes that 2024 would be a good time to increase the price of William College Ltd's course fee too. The following proposals are being considered: - (i) Increase the price of course fee to 90 and demand is expected to increase by 5%. (ii) Increase the price of course fee by 6 and demand is anticipated to increase by 20%. 1. Prepare a contribution margin statement for each proposal. Contribution margin statement sample Less Sales Variable costs Contribution Less Fixed Costs Profit (Hint: Calculate the number of courses offered in 2023 using the Target profit formula.) (Number of courses offered in 2023 = (Total Fixed costs+ profit)/Contribution per unit). 2. Calculate the break-even point in units for each proposal. 3. Using proposal (ii), how many courses the college would need to book to earn a profit of 450,000? 4. Prepare the cash budget for Williams college from July to December 2024 using the following information. a. The college expects to run 1,750-day courses per month at 82 per course. Income will be received in the month the course is offered. b. In addition to the day courses offered to businesses, the college also runs Excel training for individuals every 6 weeks. This training will hold in July, August, October and November. The training costs 300 per individual and it is expected that each training will have 150 participants. The income will be received in the month the |||