11:21 at .ill 90% i. The college currently has a loan of 200,000 at an interest...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 ||| 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 |||
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
MapleWood Ltd . , a pulp and paper company, has recently appointed a new CEO, SarahRobbins. As her first initiative, Sarah proposed a major capital expenditure program for MapleWood to the board of...
-
Consider the following information: Rate of Return if State Occurs State of Economy Boom :57 Bust of Economy .66 .34 Probability of State Stock A .09 .13 Stock B Stock C .03 .19 .24 -.04 a. What is...
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
A particle is described by the normalized wave function (x, y, z) = Axe-ax2 e -y2 e-yz2', where A, a, , and are all real, positive constants. The probability that the particle will be found in the...
-
Refer to Exercise 4.4. List all the outcomes included in each of the following events. Indicate which are simple and which are compound events. a. Both students suffer from math anxiety. b. Exactly...
-
Define what is meant by a population distribution. What is the relevance of population distributions for variables sampling ?
-
Ethan Corporation had the following transactions related to its delivery truck: Year 1 Jan. 5 Purchased for \(\$ 28,000\) cash a new truck with an estimated useful life of four years and a salvage...
-
A manufacturer is considering replacing a production machine tool. The new machine, costing $3700, would have a life of 4 years and no salvage value , but would save the firm $500 per year in direct...
-
Which statement is NOT true regarding modes? Question content area bottom Part 1 Choose the correct answer below. A. Every data set has at least one mode. B. The mode is the observation that occurs...
-
Do you prefer to buy male stereotypical toys for boys and female stereotypical toys for girls? Why or Why not?
-
Identify and discuss five (5) major disaster risk drivers that contribute to the occurrence of disasters in Botswana. Cite concrete and practical examples
-
Ames Trading Company has the following products in its ending inventory. Cost per Market per Product Quantity Mountain bikes Skateboards Gliders 14 12 30 Unit $ 710 240 910 Unit $ 640 280 870 Compute...
-
Identify two key client objectives Work with the person to identify actions and activities to support these objectives. When discussing objectives and actions and activities, ensure that you are...
-
1. Why is the name of the Industry Standard used to provide a uniform basis for the estimating of building works? Answer: 2. Briefly explain the meaning of 'Request for Tender' in relation to gaining...
-
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments-Molding and Fabrication. It started, completed, and sold...
-
POORS Company has an overdue note payable to BDA Bank of P9,000,000 and recorded accrued interest of P810,000. On December 31, 2020, BDA Bank agreed to the following restructuring agreement: *Reduce...
-
The polar coordinates of a point are given. Find the rectangular coordinates of the point. (-1, - /3)
-
Stenback manufactures coffee mugs that it sells to other companies for customizing with their own logos. Stenback prepares flexible budgets and uses a standard cost system to control manufacturing...
-
SmartSound manufactures headphone cases. During September 2011, the company produced and sold 105,000 cases and recorded the following cost data: Requirements 1. Compute the price and efficiency...
-
McKnight Recliners manufactures leather recliners and uses flexible budgeting and a standard cost system. McKnight allocates overhead based on yards of direct materials. The companys performance...
Study smarter with the SolutionInn App