# information system excel

## Project Description:

helpful hint: don’t forget to “lock cells” (use absolute cell references) as needed when doing calculations for this task.

instructions: (use formulas or functions unless otherwise noted)

download and open the template found on d2l. (filename: 3100 excel task 1 outline fall 2015)

set the value of the january “beg. of month inventory” equal to the “initial inventory” cell.

set the value of january “production” equal to the “initial production” cell.

set the value of january “units sold” equal to the “initial units sold” cell.

management predicts that production from feb-june will increase by 14% each month. using a formula, calculate this to reflect the correct “production” for each month. (use absolute cell references when needed.)

additionally, management also forecasts that the sale of units will increase by 8% in each passing month. again, calculate this using the correct formula to reflect this in the “units sold” for months feb-june. (use absolute cell references when needed.)

calculate “end of month inventory.” (note: this involves “beg. of month inventory,” “production” and “units sold.”)

calculate the totals using the sum function.

calculate “revenue” using a formula. (note: use “unit selling cost” and “units sold” for your calculations.) (use absolute cell references when needed.)

calculate “cost of goods sold” using formula. (note: use “unit production cost” and “units sold” for your calculations.) (use absolute cell references when needed.)

enter the given fixed cost for each month. (use absolute cell references when needed.)

calculate “net income.”

calculate the “total” using the sum function.

under “result-(if-statement)” calculate using an if statement function. if the “net income” is less than \$500, it should display “not met.” if the “net income” is more than \$500, it should display “met.” (note: use a single if statement.)

add conditional formatting to “result-(if-statement)” under “highlight cell rules” using “cell value” criteria equals to “met” then choose “light red fill.”

calculate the “analysis” portion using the max, min and average functions.

page orientation landscape; create a header to include your name (center section), infs 3100 fall 2015 (right section), and excel task # 1 (left section). (use the header function.)

print a copy of your completed worksheet. (no row or column borders, e.g., a, b, c, 1, 2, 3)

print a copy of your cell formulas. (to show formulas press: ctrl ~ or click: formulas: show formulas on the toolbar)

submit hardcopies of your work. there will be 2 pages. (staple the pages together.)
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: \$0 to \$10
Completed
Total Proposals: 5
1 Current viewersl
35 Total views
Project posted by:

### Proposals

Proposals Reputation Price offered
• 4.9
227 Jobs 83 Reviews
\$75 in 2 Days
• 4.9
949 Jobs 486 Reviews
\$70 in 2 Days
• 4.8
175 Jobs 91 Reviews
\$65 in 2 Days
• 5.0
9 Jobs 2 Reviews
\$50 in 2 Days
• 5.0
141 Jobs 112 Reviews
\$40 in 2 Days