Exercise 15-7 Algo GenX is a career training company that offers both online and on-campus weekend...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Exercise 15-7 Algo GenX is a career training company that offers both online and on-campus weekend training courses on web development, data science, coding, and digital marketing. The accompanying data file shows the courses that will be offered next month by GenX. The data set contains course name (Course), whether the course is offered online or on-campus (Mode), current enrollment (Enrollment), tuition per student (Tuition), cost of instructors (instructor costs), facility costs (Facility costs), technical service costs (Technical services), and historical cancellation rate for the course (Cancellation rate). Only on-campus courses incur facility costs. Online courses carry much higher costs for technical services than on-campus courses. The historical cancellation rate is used to project the actual enrollments of the courses. GenX would like to develop a spreadsheet model that calculates the projected revenue and profit for the month. Click here for the Excel Data File a. Build a spreadsheet model to find out the projected total revenue and profit for GenX next month. Note: Round your answers to the nearest whole number. Total revenue Profit b. What is the impact on GenX's revenue and profit if the facility costs increase by 20% due to a rent increase? 20% increase in facility costs will profits by c. Will a 20% decrease in technical service costs be enough to offset the increase in facility costs described in part b? O Yes O NO F1 A B 1 Course Mode 2 Web Dev. Online 3 Web Dev. Campus Online 4 Data Sci. Data Sci. 5 6 Coding 7 8 9 Dig. Mikt. Campus Campus Online fx Facility costs D E G Enrollment Tuition Instructor costs Facility costs Technical services Cancellation rate $4,000 0 $3,000 $3,500 $4,000 1587 55 $200 $250 66 $300 74 $350 32 $300 63 $250 $2,000 $3,000 $5,000 0 $5,000 $3,000 $0 $3,000 $500 $3,000 $500 $500 $3,000 H 20% 14% 16% 13% 13 % 17% Exercise 15-7 Algo GenX is a career training company that offers both online and on-campus weekend training courses on web development, data science, coding, and digital marketing. The accompanying data file shows the courses that will be offered next month by GenX. The data set contains course name (Course), whether the course is offered online or on-campus (Mode), current enrollment (Enrollment), tuition per student (Tuition), cost of instructors (instructor costs), facility costs (Facility costs), technical service costs (Technical services), and historical cancellation rate for the course (Cancellation rate). Only on-campus courses incur facility costs. Online courses carry much higher costs for technical services than on-campus courses. The historical cancellation rate is used to project the actual enrollments of the courses. GenX would like to develop a spreadsheet model that calculates the projected revenue and profit for the month. Click here for the Excel Data File a. Build a spreadsheet model to find out the projected total revenue and profit for GenX next month. Note: Round your answers to the nearest whole number. Total revenue Profit b. What is the impact on GenX's revenue and profit if the facility costs increase by 20% due to a rent increase? 20% increase in facility costs will profits by Exercise 15-7 Algo GenX is a career training company that offers both online and on-campus weekend training courses on web development, data science, coding, and digital marketing. The accompanying data file shows the courses that will be offered next month by GenX. The data set contains course name (Course), whether the course is offered online or on-campus (Mode), current enrollment (Enrollment), tuition per student (Tuition), cost of instructors (instructor costs), facility costs (Facility costs), technical service costs (Technical services), and historical cancellation rate for the course (Cancellation rate). Only on-campus courses incur facility costs. Online courses carry much higher costs for technical services than on-campus courses. The historical cancellation rate is used to project the actual enrollments of the courses. GenX would like to develop a spreadsheet model that calculates the projected revenue and profit for the month. Click here for the Excel Data File a. Build a spreadsheet model to find out the projected total revenue and profit for GenX next month. Note: Round your answers to the nearest whole number. Total revenue Profit b. What is the impact on GenX's revenue and profit if the facility costs increase by 20% due to a rent increase? 20% increase in facility costs will profits by c. Will a 20% decrease in technical service costs be enough to offset the increase in facility costs described in part b? O Yes O NO c. Will a 20% decrease in technical service costs be enough to offset the increase in facility costs described in part b? O Yes O NO F1 A B 1 Course Mode 2 Web Dev. Online 3 Web Dev. Campus Online 4 Data Sci. Data Sci. 5 6 Coding 7 8 9 Dig. Mikt. Campus Campus Online fx Facility costs D E G Enrollment Tuition Instructor costs Facility costs Technical services Cancellation rate $4,000 0 $3,000 $3,500 $4,000 1587 55 $200 $250 66 $300 74 $350 32 $300 63 $250 $2,000 $3,000 $5,000 0 $5,000 $3,000 $0 $3,000 $500 $3,000 $500 $500 $3,000 H 20% 14% 16% 13% 13 % 17% F1 A B 1 Course Mode 2 Web Dev. Online 3 Web Dev. Campus Online 4 Data Sci. Data Sci. 5 6 Coding 7 8 9 Dig. Mikt. Campus Campus Online fx Facility costs D E G Enrollment Tuition Instructor costs Facility costs Technical services Cancellation rate $4,000 0 $3,000 $3,500 $4,000 1587 55 $200 $250 66 $300 74 $350 32 $300 63 $250 $2,000 $3,000 $5,000 0 $5,000 $3,000 $0 $3,000 $500 $3,000 $500 $500 $3,000 H 20% 14% 16% 13% 13 % 17%
Expert Answer:
Answer rating: 100% (QA)
The exercise provided involves building a spreadsheet model to calculate projected total revenue and profit for GenX next month considering various costs enrollments and a cancellation rate for its co... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Design a difference amplifier to have a gain of 4 and a common-mode input resistance of 20 k at each input.
-
Collectors of vintage lightning rods formerly had to drift from antique store to antique store hoping to find a lightning rod for sale. The invention of the Internet reduced the cost of finding...
-
Gotham Company purchased a new machine on October 1, 2022, at a cost of $90,000. The company estimated that the machine has a salvage value of $8,100. The machine is expected to be used for 70,000...
-
Explain the specific internal accounting control objectives for the functions identified in (1) above.
-
The Allwardt Trust is a simple trust that correctly uses the calendar year for tax purposes. Its income beneficiaries (Lucy and Ethel) are entitled to the trust's annual accounting income in shares...
-
Interview of a person from another generation It should be apparent to you by now that Native Americans value their ancestors. After all, the wisdom of generations resides with our older relatives....
-
On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and...
-
Foxy Logic Inc, is purchasing a new piece of equipment for their manufacturing line. What type of business event would this be considered?
-
Six years ago, Junk Removal Services (JRS) issued high-yield bonds at par with a maturity of 12 years and a face value of $1,000. Today, the bonds just paid their semi-annual coupons of $70. 20. At...
-
Gogo Inc. produces and sells projectors and has a relevant range between 1,000 units and 2,000 units per year. Manufacturing overhead costs range from $1,000,000 to $1,250,000 at the low and high...
-
a) Draw a flow net b) Calculate the seepage flow 6m c) Calculate the total head at points a & b. d) Check of boiling 3m b Ya9 kN/m K=4x10 cm/sec [1.5m 6m
-
The variance ratio (VR) can be used to determine whether returns satisfy the efficient market hypothesis (EMH). Let n = 5 and r5,t be the five period log return at time t, where t = 1,2,..., T. 1....
-
1234567 The table below presents the variance - covariance matrix and the mean returns for six different stocks of financial institutions, based on their monthly data. A FRE WM STT JPM GS C B FRE C...
-
Please calculate BCWP, BCWS, EAC, SV, and CV of the project with the following information Five-month project . Current time: End of third month Current cost: $102,000 Activity Status as of now (End...
-
Consider the combustion of methanol below. If 64 grams of methanol reacts with 160 grams of oxygen, what is the CHANGE in volume at STP. 2CH3OH(g) + 3O2(g) 2CO2(g) + 4H2O(1) The volume decreases by...
-
Volte Corporation produces small electric appliances. The following information is available for the most recent period of operations: Volte never has any work-in-process inventories and began the...
-
The records of Heritage Home Supplies show the following for July: Required Compute the direct labor and variable overhead price and efficiency variances. Standard direct labor-hours allowed per unit...
-
Richards Events provides catering services, among other services. The company has adopted activity-based costing (ABC) for the catering services. The ABC system classifies activities into two groups...
-
Is the nature of the coupling dependent on the coordinates used?
-
How many degrees of freedom does an airplane in flight have if it is treated as (a) a rigid body, and (b) an elastic body?
-
What are principal coordinates? What is their use?
Study smarter with the SolutionInn App