Business Finance Homework Help

V-Intern Task 2: Projected Profit and Loss Statement for eBusiness

Your Virtual Internship Task 2: Develop Projected Profit and Loss Statement for eBusiness

Plan of Approach

Your Internship Coordinator has asked you to develop a Projected Profit and Loss Statement for the company’s eCommerce venture, spanning the course of two years. Additionally, you make recommendations regarding the company’s technical infrastructure and mix of marketing methods.

Task 2 requires you to prepare three deliverables:

2.1 Develop Projected Profit and Loss Statement for your eBusiness

Setup an Excel workbook that includes:

Estimated eBusiness Profit and Loss Statement for two years by quarter

Supplemental data worksheet with assumptions or calculations that support your estimates for each line item in the eBusiness Profit and Loss Statement

2.2 Develop Technical Infrastructure, completed in the Infrastructure Cost Table that includes:

Estimated costs for each relevant cost category for each of the three sourcing options

Recommendations regarding whether your eBusiness should change to a different infrastructure sourcing model and, if so, when this should happen

2.3 Develop Marketing Mix Plan:

An executive summary of a recommended mix of marketing approaches and the staging of those approaches over the next two years in a two to three pages

Total marketing budget allocation for each quarter with a breakdown of the budget allocation for each recommended method over the next eight quarters in an Excel worksheet

Get Started

1. Review the above instruction from your Internship Coordinator to make sure that you understand the details of this task.
2. Download and review the three linked files for Task 2. These documents provide detailed information that you will need to thoroughly understand to complete the deliverables for this task. Take some time to review them carefully.

2.1 Develop Projected Profit and Loss Statement for your eBusiness. Reference this links

https://docs.google.com/spreadsheets/d/1rTFMpMPgF0IDW3Fl-jhfEqBeSANudhq-4uL_G_xxbNE/edit#gid=1995890932

2.2 Develop Technical Infrastructure for your eBusiness.

2.3 Develop Marketing Mix Plan for your eBusiness.