Create a good dashboard for given assignment

Reference no: EM131150050

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 inception¬to-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 Excel Dashboard that will address the Sales Manager's request for Print it Green, Inc.

create a good Dashboard for this assignment. The functions that should be used are the TREND function, VLOOKUP, IF, HLOOKUP, Carts and Pivot Tables. I will tip very generously if the assignment is not simply copied and pasted from another source.

Reference no: EM131150050

Questions Cloud

Rewrite this function in terms of dimensionless parameters : Verify that the exact solution from Prob. P4.80 is consistent with your result in part (a).

One of the operating budget is : When using the net present value method to evaluate capital spending on a new project, the discount rate is:- one of the operating budget is ?

How many calories are in the tortilla chip : A chunk of ice of mass m on the Ravenel Bridge breaks off at a height h. What is the proper expression for the velocity of the ice before it hits the water? In other words, solve for velocity in terms of gravity and height using the law of conserv..

What are your thoughts about parenting : What are your thoughts about Parenting if it impacts children even when they are adults in the workforce check rationale for not obtaining informed consent

Create a good dashboard for given assignment : create a good Dashboard for this assignment. The functions that should be used are the TREND function, VLOOKUP, IF, HLOOKUP, Carts and Pivot Tables.

Compare and contrast the value of strategic alliances : Compare and contrast the value of strategic alliances, mergers, and acquisitions as options for a company to expand their international operations in a successful way

Explain the principle value of two vision statements : Within your essay, include the following: Explain the principle value of two vision statements. Explain the principle value of two mission statements. Compare and contrast vision statements of each organization in terms of composition and importance

How many types of antibodies are there in the human body : How many different 'types' of Antibodies are there in the human body? What is the name given to the chemicals which disrupt viral replication? Which chemical released by white blood cells causes capillaries to leak?

What is the yield of the above bonds if interest coupon paid : What is the yield of the above bonds if interest (coupon) is paid monthly?

User Account

All Pages