Business Analysis

Business Analysis | Section 038 Week 5 Assignment Help | Georgia State University   

Module 5: Making a Profit: Profit Models Webex Activity: The Profit Model

Webex: Creating a Profit Model using Excel

In this week's Webex Exercise, we will continue to work on our Excel skills. We will create a profit model. You will get lots of practice copying formulas in your spreadsheet, so please review the following videos from Module 1:

1.      Copy

2.      $ locking cell

You will also be graphing your results, so please review the Charts Section from Module 1.

You may find it useful to refer back to the example videos about Creating Profit/Revenue/Expenses table for various quantities in Excel opens in new window as you work with your instructor to complete the Module 5 Webex Excel Activity.

1.        What is the breakeven point for Donuts to Go (assume each customer buys one donut and one coffee)?                                                                                

2.       Using Goal seek, if you want to achieve profit of $2000, how many donuts and coffee do you need to sell?                                                                                                                                                                                                          

3.       What is the contribution margin of each sale of a Coffee and Donut?                                                

4.       What is the Profit at the break even?                                                                     

5.       What is the breakeven point for Muffins to Go (assume each customer buys one muffin and one coffee)?                                                                                            

6.       What is the contribution margin of each sale of a Muffin and Donut?                                                

7.       What is the Profit at the break even?  Solve by Graph

8.       Using Goal seek, if you want to achieve profit of $4000, how many donuts and coffee do you need to sell?  

9.       What is the cross over point for the two alternatives? (solve by equation and confirm on graph).  Enter quantity in cell below round to two decimal places                                                                                

 10.       What is the Profit at the cross over point?(solve by equation and confirm on graph) Enter profit in cell below round to two decimal places 4142.86=X

Excel Activity for Module 5: Creating a Profit Model

To help you complete this activity, there is a pre-made Excel Spreadsheet attached below the video on the page in CSePub. I recommend that you open this sheet as you watch the video to prepare for our meeting.