1. Create a sales budget and Schedule of Cash Collections based on the following information.
Expected Sales
Basic Cooking Course Course
2 Semesters for the year
3 Courses are offered each semester
Maximum enrolment 32 students
Expected capacity 94%
Tuition $5,000 per student

Customized Cooking Courses
15 Courses
15 Students per course
Course Fee $110,000 per course
Each course is 5 weeks

In order to achieve these goals, the Marketing department needs to spend $350,000 on digital, television and radio advertising as well as increase the sales commission rate from 4% to 6% of revenue.