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 febjune 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 febjune. (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(ifstatement)” 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(ifstatement)” 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.)
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 febjune 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 febjune. (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(ifstatement)” 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(ifstatement)” 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
37 Total views
Project posted by:
Proposals
Proposals
Reputation
Price offered

i have vast knowledge in financial information systems. hit my inbox and let me help you with this.242 Jobs 94 Reviews $75 in 2 Days
 1133 Jobs 596 Reviews $70 in 2 Days

Ready for the task and deliver a master piece. Please let me assist175 Jobs 91 Reviews $65 in 2 Days

Hi. I can complete all steps. Please message to get started ASAP9 Jobs 2 Reviews $50 in 2 Days

I can perform this information system excel task with great comprehension and analysis. I am an expe...more148 Jobs 118 Reviews $40 in 2 Days