introduction to business problems solving class

Project description
Homework 1
Due – Monday, 6/16/14, Start of Class, 12 noon
Submit via Canvas

To Do
Answer all questions and perform all tasks
Use the Data File “ISMG2050 SUM14 – Assignment 1 Data” located in the Assignments Section of Canvas.
Perform all calculations, analysis, etc. using Excel, showing all work and formulas.
Write a 1 page summary using Word.
Submit Excel and Word files via Canvas by 12 (no late work).

Setting
Your grades and GPA have put you at the top of the list of all students at the UCD Business School. You are able to find a paid internship in the summer at Dish Network. Not only will you make $3,000 per month, you will get free satellite T.V. service every month for one year. Instead of taking a trip to travel around Europe, you decide to do the right thing for your career and take the internship. Your job is in the Finance Department for the first two weeks. You have been asked by your supervisor to work with some financial data to answer a few questions. In addition, the CFO will ultimately receive your report and Excel file as backup to what you write in your report.
The CFO likes things done very efficiently, no spelling errors, concise answers with sufficient backup arguments, rational logic and arguments, clarity, good formatting in Excel (ex., all text shown in cell, consistent formatting across all worksheets and cells, etc.). In addition to the content of your answers, your answers and writing will be graded with the above in mind. You have to learn how to prepare professional documents in addition to compiling and analyzing data.

Questions and Tasks.
1. In Microsoft Excel
a. You are to combine all data for all regions and all years into a new worksheet.
b. For each region, calculate its revenue by product, revenue by year, and its total revenue by year.
c. In a new worksheet, copy the revenue data for all regions (by product, by year). For the entire firm, calculate the total revenue by product, revenue by year, and overall.
2. In Microsoft Word
a. Analyze the numbers above and write-up a 1 page summary in a Word Document which discusses the following.
i. What Region is the best performing? Explain
ii. What Region is the worst performing? Explain
iii. How is the firm doing as a whole? Explain
iv. Which product or products do you think you should drop? Why?