I need Help with this small excell project. Please follow the instruction bellow carefully.

 

Excel project 1

 

Class Project - New Products

 

You are an accountant who works for a clothing manufacturer. Create a worksheet

that lists 5 different clothing products your company sells (don't forget to include the

Company name and the date as a title row). Enter the product name in one column

and the revenue received from each product for the months January through June.

Add a column at the end that totals the sales for each month and another column to

find out the average sales for each month. Include a total row at the bottom of the

worksheet that sums the values for each month. Name this worksheet

Actuals .This worksheet will include actual sales for your products.

 

Create a second worksheet (in the same workbook) that includes the same products

as the first sheet (an easy way to do this would be to make a copy of the Actuals

worksheet and change the values). Instead of revenue for each month, include a

projected sales column (with different numbers from the first sheet) for each month.

Name this worksheet Forecast. The worksheet will include your projected revenue for each product for each month.

 

Create a third worksheet that calculates the difference between the Actuals total

 (in the Actuals worksheet) and the Forecast total (in the Forecast worksheet) for each

product for each month. Name this worksheet Variance. This worksheet will

include the difference between your projected sales values and your actual sales

values.

 

Format all the numbers as currency with two decimal places. Add any other

formatting (bold, colors, etc) that you like. Add your company name and the page

number to the footer of each worksheet. Make sure all your columns and rows are

wide enough to display your data.

 

Save your project file with the name "Excel_1_Project"

SophiaPretty

(5)

Status NEW Posted 18 Nov 2017 11:11 AM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer