(5/5)

Hire Me
(5/5)

Hire Me
(4/5)

Hire Me
(5/5)

Hire Me
(5/5)

# Bao Phan is a financial analyst for Victoria Streaming Service (VSS), a website that streams movies and TV shows to subscribers in the United States

INSTRUCTIONS TO CANDIDATES

PROJECT STEPS

1. Bao Phan is a financial analyst for Victoria Streaming Service (VSS), a website that streams movies and TV shows to subscribers in the United States, Canada, and the United Kingdom. He is tracking sales for the year and asks for your help in projecting future sales and visualizing the sales data.

The U.S., Canada, and U.K. worksheets have the same structure and contain similar data. Group the U.S., Canada, and U.K. worksheets to make changes to the three worksheets at the same time. The first change is to display today's date.

In cell H1 of the U.S. worksheet, enter a formula using the TODAY function to display today's date.

2. Use the text in cell H5 to fill the range I5:K5 with the names of the remaining quarters in the year.

3. VSS has applied a goal of increasing revenue to \$90,000 in the fourth quarter of next year. For Quarter 1, Bao estimates \$84,309 in revenue, which is the average revenue per quarter from the current year.

Project the revenue in Quarters 2 and 3 by filling the series for the first projection (range H7:K7) with a linear trend.

4. Bao is confident that revenue will increase by at least 2 percent per quarter next year. He wants to calculate these revenue goals in a second projection.

Project next year's revenue in the second projection (range H9:K9) based on a growth series using 1.02 as the step value.

5. Bao wants to consolidate the sales data in the U.S., Canada, and U.K. worksheets on the All Locations worksheet.

Ungroup the worksheets, go to the All Locations worksheet, and then consolidate the data as follows:

a. In cell B6, enter a formula using the SUM function and a 3D reference to total the revenue from Action movies in Quarter 1 (cell B6) in the U.S., Canada, and U.K.

b. Copy the formula in cell B6 to calculate the revenue from the other types of movies for all four quarters (range B7:B11 and C6:E11), pasting the formula only.

6. Bao wants to round the total sales values so that they are easier to remember.

a. In cell B12, add the ROUNDUP function to display the total sales for Quarter 1 rounded up to 0 decimal places.

b. Fill the range C12:F12 with the formula in cell B12.

7. In cell F14, Bao wants to display the total revenue from the previous year. This data is stored in another workbook. Insert the total as follows:

a. Open the file Support_EX19_CS4-7a_Revenue.xlsx.

b. In cell F14 of Bao's workbook, insert a formula using an external reference to the total revenue (cell F12) in the All Locations worksheet in the Support_EX19_CS4-7a_Revenue.xlsx workbook.

8. Bao wants to visualize how the revenue for each type of media contributed to the total revenue for the four quarters.

Create a chart as follows to illustrate this information:

a. Create a 3-D Pie chart that shows how the revenue from each type of media (range A6:A11) contributed to the total revenue (range F6:F11).

b. Move and resize the chart so that the upper-left corner is in cell A15 and the lower-right corner is in cell E30.

(5/5)

## Related Questions

##### . The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

##### . Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

##### . The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

##### . Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

##### . The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

277 Experts Online