| Course Project—M3 Working Ahead |
| Last module, you received your instructor’s approval of your company and actual planned investment. In this module, you need to begin working on the Cost, Volume, Profit Analysis spreadsheet provided for the project to outline the revenues, costs, expenses, and resulting cash flows. If you selected a manufacturing company and the project deals with a product or change in project, you will need to consider direct and indirect costs. Detail out your costs and cash flows. Make sure these are reasonable for the project you have selected. |
| Before the end of Module 3, you should have all of your revenues, expenses, investments, profit, and resulting cash flows on an Excel worksheet complete with all calculations performed using Excel functions. |
| You will submit this spreadsheet for review by you instructor in Module 4. It will then be included as part of your final project in Module 5 and is worth 220 points, so be sure to get started on it now. |
| If you have any questions about your project, please ask your instructor in the Questions for your Instructor discussion area under Course Home. |
| Review the Course Project Guidelines. |
| | | Sales price per unit | $75.00 | * |
| | | Variable Cost per unit | $67.00 | * |
| | | Fixed Cost | $100,000.00 | * |
| | | Targeted Net Income | $0.00 | * | (assume 0 if you want to calculate breakeven) |
| | | Calculated Volume | 12,500 | calculated |
| | | * inputted by user |
| | CVP for approved project company Apple Inc. below aremy answer |
| **** | 1 | Question : | What is the full legal name of the US public company that you will use in your course project? |
| | | Student Answer: | In my course project, I have will pick Apple Inc. as my company of choice |
| | | Points Received: | 5 of 5 |
| | | Comments: |
| | Question 2. | Question : | What is the stock symbol for the public company you have chosen? |
| | | Student Answer: | The stock symbol for Apple Inc. is AAPL |
| | | Points Received: | 2 of 2 |
| | | Comments: |
| | Question 3. | Question : | Why did you specifically choose this company for your project? Why are you interested in the company? |
| | | Student Answer: | The main reason I specifically chose this company is that I feel inspired by their company culture. In fact, the name itself is a household name for innovation in their products and software applications. The reason I am interested in the company is that I want to identify with their culture which allow employees to work remotely from their comfort zones as long as they remain productive and finish in time their allotted tasks. |
| | | Points Received: | 10 of 10 |
| | | Comments: |
| | Question 4. | Question : | What is the nature of the investment for this company that you are planning? Please explain your investment idea. |
| | | Student Answer: | For this company I plan to invest in the development of an auto responder software technology. It is obvious that Apple inc is a force to reckon with in the app market. So, having an opportunity to invest in a creative idea like the development of an auto responder will give me the opportunity to tap into their expertise, innovation and clientele. Apparently, those consumers using apple products hold those products in high regard. Perhaps that is the reason the prices of most of Apple’s products are quite higher than those of the competition. Apparently, an auto responder software technology is an emailing platform that marketer in the internet space find quite useful. The technology will include lead capture pages and prewritten but customizable email campaigns that users can use to promote and grow their primary businesses. This tool will help users to set up marketing campaigns and lead capture pages of their interest depending on their specific niches, and let the business run on auto pilot. |
| | | Points Received: | 13 of 13 |
| | | Comments: |
uacebird187
cost_volume_profit_analysis_4.xls
