Details of this Paper

FIN 615 Excel Dashboard Assignment - Print it Green, Inc.

Description

solution


Question

Question;In this assignment, you are required to create an Excel Dashboard by using at least three of the Excel functions and/or capabilities that we have learned in class. The details of the case and the raw data from which to work are in the attached Excel workbook. Since this is raw data, there may be analysis steps that you have to perform to prepare the data for its final presentation on your dashboard.Print it Green, Inc. is a manufacturer of recycled printing supplies. The company began operations on 10/1/2008 and is dedicated to producing sustainable green printing products. Print it Green, Inc. provides recycled laser toner cartridges, recycled ink jet cartridges as well as cases of recycled copy paper to a variety of customers across the United States.Upper management created several detailed sales forecasts for FY 2010. Now that Print it Green, Inc. is beginning the final quarter of their year, management has requested that a detailed analysis be performed as to whether the company is expected to achieve the forecasted results.Print it Green's Sales Manager has pulled together the detailed sales forecasts for FY 2010 as well as the inceptionto-date sales data from their accounting system (see the additional tabs below). She has requested that an Excel Dashboard be created to illustrate on a detailed basis whether or not the company is expected to achieve total forecasted sales of $1,006,000 for FY 2010.Using at least three of the Excel functions and/or capabilities that we have learned in class, create an ExcelDashboard that will address the Sales Manager's request for Print it Green, Inc.

 

Paper#48166 | Written in 18-Jul-2015

Price : $35
SiteLock