Hello Team,
I'm looking for an excel model that is built for an education organisation that provide courses to students, so basically the organisation will incur costs to provide the service and receive income from the student in the form of fees. the costs involved will be fixed(i.e salaries paid to lectures,Admin office,software licences for IT access to students) and variable cost( i.e contractors to provide part time lectures, any costs that is not fixed.) , also some costs would be unallocated to a specific costs and would need to be reallocated base across all courses based on the number of student that go through the stage at each month end .the model should provide the total costs and income provide to the student population and also the costs per student so that when we quote future prices for next academic year we know the costs already incurred and we will decide the price. also we need breakdown of the courses provided by modules and we can work out the costs per module of a particular course per per student. could someone please network from teach excel network and confirm whether someone already has this type of model or is willing to build it for me, please let me know. Thanks