Question: begin{tabular}{|l|r|r|r|r|r|r|r|} multicolumn{1}{|c}{ A } & multicolumn{1}{c}{ C } & multicolumn{1}{c}{ D } & multicolumn{1}{c}{ E } & multicolumn{1}{c}{ F } & multicolumn{1}{c}{ G }

$\begin{tabular}{|l|r|r|r|r|r|r|r|} \multicolumn{1}{|c}{ A } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c}{ D$

$} & \multicolumn{1}{c}{ E } & \multicolumn{1}{c}{ F } & \multicolumn{1}{c}{ G$

\begin{tabular}{|l|r|r|r|r|r|r|r|} \multicolumn{1}{|c}{ A } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c}{ D } & \multicolumn{1}{c}{ E } & \multicolumn{1}{c}{ F } & \multicolumn{1}{c}{ G } \\ \hline Course & Mode & Enrollment & Tuition & Instructor costs Facility cost Technical service Cancellation rate \\ \hline Web Dev. Online & 78 & $200 & $4,000 & 0 & $3,000 & 30% \\ \hline Web Dev. Campus & 55 & $250 & $3,000 & $5,000 & $500 & 7% \\ \hline Data Sci. & Online & 66 & $300 & $3,500 & 0 & $3,000 & 11% \\ \hline Data Sci. & Campus & 74 & $350 & $4,000 & $5,000 & $500 & 11% \\ \hline Coding & Campus & 32 & $300 & $2,000 & $3,000 & $500 & 12% \\ \hline Dig. Mkt. Online & 63 & $250 & $3,000 & $0 & $3,000 & 16% \\ \hline \end{tabular} 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. 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. b. What is the impact on GenX's revenue and profit if the facility costs increase by 20% due to a rent increase

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

What are (broadly speaking) the five stages of the research process?

Required a . October sales are estimated to be \ ( \ $ 3 9 0 , 0 0 0 \ ) , of which 4 0 percent will be cash and 6 0 percent will be credit. The company expects sales to increase at the rate of 2 0...

The following table lists the components needed to assemble an end item, lead times, and quantities on hand. a. If 23 units of the end item are to be assembled, how many additional units of E are...

\begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{1}{|c|}{ B } & \multicolumn{2}{c|}{ C } & \multicolumn{1}{c|}{ D } \\ \hline \hline 2 & Write yes or no in each one of these boxes. & & \\ \hline 3...

Requirement 1a. Allocate the two support departments' costs to the two operating departments using the reciprocal method. First, determine the linear equations for each support department. AS= 1S=...

b Adjusted \begin{tabular}{|l|cr|} \hline \multicolumn{2}{|c|}{ ONPOINT } \\ \hline \multicolumn{2}{|c|}{ Statement of Retained Earnings } \\ \hline \multicolumn{2}{|c|}{ For Three Months Ended...

Required: Compute the net pay for Eve Khan and Marn Hart. Assume that they are paid a $2,680 salary blweekly, subject to federal income tax (use the wage-bracket method) in Appendix C and FICA taxes,...

Common-Size Financial Statement Analysis Using Excel Completing this activity will help you learn to: 1. create Excel formulas using cell references. 2. create absolute cell references to perform...

The Kelmer Performing Arts Center offers a series of four programs from a list that includes jazz, bluegrass, folk, classical, and comedy. The Program Coordinator needs to determine which acts to...

please tell me what im missing and correct whats wrong General Ledger Account Post-closing GREATADVENTURES, INCORPORATED Trial Balance December 31,2025 Requirement General Ledger...

Tommy's Box Cars - Large Pro forma Income Statement or the Fiscal Year Ended June 30, 202 During 2022-2023 fiscal year, the average selling price for large box cars is expected to be (1) $70 per car....

Pick an organization and determine one of its goals and tire associated strategy. Its strategy may be discerned from its strategic actions

Describe service firms that are likely to have a job costing-like system; a process costing-like system.

3. Each memory location listed in the parameterList in the procedure header is referred to as . a. an address b. a constraint c. a parameter d. a value

You have exams in economics and chemistry coming up, and you have 5 hours available for studying. The following table shows the trade-offs you face in allocating the time you will spend studying each...

On May 15, Year 1, Moran Inc. approved a plan to dispose of a component of its business. It is expected that the sale will occur on February 1, Year 2, at a selling price of $ 500,000, which was the...

What is a pvalue? How is it used to reach a conclusion about a hypothesis test?

Steve Drake sells a rental house on January 1, 2015, and receives $120,000 cash and a note for $45,000 at 10 percent interest. The purchaser also assumes the mortgage on the property of $35,000....

Allison Corporations current year income from continuing operations before taxes was $ 1,000,000 before taking the following items into consideration: Depreciation was understated by $ 100,000. A...

A good project charter is succinct and accessible for leaders who are often not experts in project management Question 3 options: True False

4. You have been given the opportunity to complete an online assessment of your communication style (see page 64). After completion of this assessment you were provided with a profile that indicates...

2. Explain how the Self-Talk Endless Loop in Figure 4.1 can help individuals like Vickie Stringer.

2. Lets assume you are a marketing representative for the Southwestern Region of the American Red Cross. You plan to schedule separate meetings with Gates and Ballmer to solicit major funding for...