AnnaHollyCCP.xlsxBITS211FinalProjectProposalInstructions xBITS211CCProjectRubric
 

• Type of paperEssay (Any Type)
• SubjectOther
• Number of pages2
• Format of citationOther
• Number of cited resources0
• Type of serviceEditing

The Assignment is an Excel Spreadsheet. I started working on most of it. Formulas and information needs to be entered into the spreadsheet for this Comprehensive Course Project. I′ve attached My Starter File and the Assignment instructions.

2

>Documentation Sheet Title: Allison

‘s Lipsticks Author: Anna

Holly Date: 22

-May-

1 8 Purpose:

The purpose is the

Inventory

of different types of Lipsticks. I’ll show Whole Sale Prices,

Item

Name

s, Give a Budget and so forth.

(Expand as necessary) Project Elements Explanation
**Feel free to utilize more space for explanation then what is provided by stretching the rows or wrapping the text. Location (Sheet Tab and Cell References hyperlinks) Data Sheets Formulas/Functions
(list each) Formula #1 Multiplied markup percent by the wholesale price to find the

Markup Cost Formula #2 Added the

Wholesale Cost

and Markup cost to get the

Retail Cost Formula #

3 IF-function Filtered List Conditional Formatting Chart #1 Chart #2 Lookup Table
w/Lookup Function Data Validation w/ error message Pivot Table with chart Pick one of two One-Variable Data Table Goal Seek Pick two of four Macro Two-Variable Data Table Scenario Manager Solver Additional Included Functionalities

Inventory

Wholesale Cost Markup Cost Retail Cost

1

5

.

.25

2 Allison

10 6

.5

.5

3 Anna

10

.5

10 6

5

15 11

.75

6

Matte

10 6 7.5 13.5

7

Gloss

10 5

8

Gloss

10 5 6.25

Shimmer

10 7

10

Sheen

10 8 10

11

Matte

10 6 7.5 13.5

12

Gloss

11 13.75 24.75

13

Matte

10 6 7.5 13.5

Shimmer

10 7 8.75 15.75

15

Shimmer

10 7 8.75 15.75

Sheen

10 8 10 18

Glitter

10 5 6.25 11.25

18

Glitter

10 5 6.25 11.25

Matte

10 6 7.5 13.5

20

Matte

10 6 7.5 13.5

Matte

11 11 13.75 24.75

22

Shimmer

10 7 8.75 15.75

Glitter

10 6 7.5 13.5

24

Sheen

10 8 10 18

25

Gloss

10 5 6.25 11.25

Mark up %

1.2

5

Product Number

Item Name

Finish

Color

On Hand

Need to Order

Angel

Gloss

Coral

10

6

25

11

Matte

Light Pink

7

13

Sheen

Rose

15

12

22.5

4

Adore

Glitter

Peach

7.5

13.5

WheelPretty

Shimmer

Salmon

13.75

24

Gabrielle

Crepe

Satin

Lavendar

6.25

1

1.25

Silk

Magenta

11.25

9

Lace

Lilac

8.75

15.75

Vintage

Plum

18

Tailored

Orchid

Bella

Violet

20

Brave

Lemonade

14

Innocence

Nude

Fairy

Pink Nude

16

Romance

Red

17

Elegance

Wine Red

ShowStopper

Cherry Red

19

Millionaire

Ruby Red

Yonce

Crimson Red

21

Queen B

Candy Red

Partition

Orange

23

Yes

Blue

Tempting

Black

Pretty Woman

Blush

Order Form

Name

Allison’s Lipsticks

Order Sheet

Address

City

State

Zip

Email

Item Number

Total

Sub Total

Filtered Sheet

Mark up % 1.25
Product Number Item Name Finish Color On Hand Wholesale Cost Markup Cost Retail Cost Need to Order

1 Angel Gloss 10 5 6.25 11.25
2 Allison Matte 10 5 6.25
3 Anna Sheen
4 Adore Glitter
5 WheelPretty Shimmer
6 Gabrielle Matte
7 Satin Gloss
8 Silk Gloss
9 Lace Shimmer
10 Vintage Sheen
11 Tailored Matte
12 Bella Gloss
13 Brave Matte
14 Innocence Shimmer
15 Fairy Shimmer
16 Romance Sheen
17 Elegance Glitter
18 ShowStopper Glitter
19 Millionaire Matte
20 Yonce Matte
21 Queen B Matte
22 Partition Shimmer
23 Yes Glitter
24 Tempting Sheen
25 Pretty Woman Gloss

BITS211 CCP Proposal Assignment

Complete and submit as your Final Project Proposal

1. Download the Final Project Starter File from Blackboard

2. Add a blank worksheet and on that blank worksheet create a range of data that contains a minimum of:

a. 6 fields with labels (1 field must be numeric, ie: cost, quantity, total, etc…)

b. The first field in must be a unique value (ie: ID#, part #, etc…)

c. 20 records (rows)

d. Total of 3 functions and/or formulas

3. Format the data as a table

4. Create 1 chart from the data

a. Chart must have a title, data labels and a legend

5. Provide explanations for the following items on the Documentation Sheet:

a. The overall purpose of your project (this needs to be a good paragraph)

b. Each of your three formulas

c. Chart #1

NOTE: You do not need active hyperlinks at this time.

NOTE: You may include additional project requirements in your proposal if you would like to, for example the IF function, VLOOKUP, a second chart, etc… Feedback will be given for any additional requirements which you choose to include.

Item

Total Points

Possible

Required Elements Presented

(See points below per element)

Elements logically

applied; adds value

to the application

(Does the element

solve a business

problem?)

Consistency of element

formatting (including

number formatting)

Thorough

explanation of

purpose for

elements are

defined on the

documentation

sheet for users

Total

Points

Earned

Documentation sheet with

justification and hyperlinks to an

element and back to the Doc

sheet

10

Use doc sheet template provided by

instructor

-Fill in all fields for name,

purpose

and date (5

points)

-provide locations of all functions (5

points)

Worksheet data

10

Data must have multiple data types

with a minimum of :

Two different worksheets of data (4

points)

At least one text type

(3 points)

At least one numeric or currency type

(3 points)

Formatting of worksheet data

10

Number or currency

must have consistent

decimal places

(5 points)

A consistent formatting

theme must be used

throughout the workbook

(5 points)

Formulas & functions

25

Minimum of 3 required formulas or

functions (6 points)

AND

1 required IF function (may be a

conditional IF) (5 points)

IF Function must

provide value to the

application

(5 points)

All results must be

appropriately formatted

(currency should be 2 or

0 decimals)

(4 points)

If function

explanation must

be defined on

the doc sheet (5

points)

Filtered list

10

A filter must be applied to a column

of the worksheet data

(3 points)

This filter must

answer a business

question

(2 points)

Explanation on

doc sheet should

define the

purpose of the

filter (5 points)

Conditional Formatting

10

The conditional format must be

applied to a column of the worksheet

data (3 points)

This conditional

format must answer

a business question

(2 points)
Explanation on
doc sheet should
define the
purpose of the

format (5

points)

Chart 1

10 Chart created

(2.5 points)

Appropriate chart

has elements that

will define the data

(legend or data

labels, proper title,

axis labels, etc)

(2.5 points)

All elements will be

formatted attractively

and in colors that allow

easily readable data

(2.5 points)

Doc sheet

explains the

chart’s purpose

and data being

analyzed

(2.5 points)

Chart 2

10 Chart created (2.5 points)

Appropriate chart
has elements that
will define the data
(legend or data
labels, proper title,
axis labels, etc)
(2.5 points)
All elements will be
formatted attractively
and in colors that allow

easily readable data (2.5

points)
Doc sheet
explains the
chart’s purpose
and data being
analyzed
(2.5 points)

Lookup table and lookup

function

15

Vlookup or Hlookup function used

from either already provided data or

additional data (5 points)

Function provides a

solution (5 points)

Explanation of

purpose (5

points)

Data validation and error

message

12

Data validation Settings and

corresponding error message setup (2

points)

The data validation

application works

and is not applied to

a formula cell

(5 points)

All necessary cells have

the same data validation

(full column if

necessary) (2 points)

Doc sheet has

purpose

explained

(3 points)

Pivot Table with Pivotchart

23

Pivot table added (5 points)

PivotChart added (3 points)

Does the pivot table

present data in a new

way that adds value?

(5 points)

All necessary data is

attractively formatted

(titles added, colors

complement

spreadsheet, proper

number formatting)

(5 points)

Pivot Table and

Pivot Chart are

properly

documented and

defined on doc

sheet (5 points)

Pick one of the following

Student Chooses: 15

One Variable Data Table

Table

created (5 points)

Does the data table

presented data in a

way that adds value?
(4 points)

Numbers are formatted

and table is attractively

formatted (2 points)

Table purpose

explained on doc

sheet (4 points)

Goal-seek

Goal seek created and print screen

provided to show the function in

action (5 points)

Does the goal-seek

solve a business

problem adequately?

(5 points)

Explanation and

purpose of goal

seek; define why

goal seek and

not another

application such

as scenarios

(5 points)

Pick two of the following

Student chooses:

[20 pts each] 40

Macro
macro implemented with button

and/or shortcut–check code

(5 points)

macro runs correctly (5 points)

Does it add value? (5

points)
Explanation of

purpose defined

(5 points)

Two Variable Data Table

Table created (5 points)
Does the data table
presented data in a
way that adds value?
(5 points)
Numbers are formatted
and table is attractively

formatted (5 points)

Table purpose
explained on doc
sheet (5 points)

Scenario manager

Scenarios and scenario summary

created–minimum of 2 scenarios

created (5 points)

Do the scenarios add

value and solve a

business problem? (5

points)

Numbers formatted

appropriately and all cell

references named on

report (5 points)

Scenario

purpose defined

on doc sheet (5

points)

Solver

Solver implemented (4 points)

answer report provided (4 points)

minimum of one constraint applied (4

points)

Does the solver app

add value and solve

a business problem?

(4 points)

Solver purpose

defined on doc
sheet (4 points)

Total 200 0

0.00%

Final Total Score

Total Percentage