Excel Task Instructions - Assignment Example

- Additionally, management also forecasts that the sale of units will increase by 9% in each passing month. Again, calculate this using the correct formula to reflect this in the “Units Sold” for the 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 the 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 $400, it should display “Not Met”. If the “Net Income” is more than $400, it should display “Met”. (Note: use a single IF statement).
- Add conditional formatting to “Result-(IF-Statement)” under “Highlight Cell Rules” using “Text That Contains” criteria. If the Text contains “Not 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 (centre section), INFS 3100 Spring 2015 (right section), and Excel Assignment # 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.
- Submit hard copies of your work. There will be 2 pages. (Staple the pages together).
- Save your file. You may need to use it again for another assignment. (I may also request to see the file electronically). Read More