tswLab-ch1 - are spending on each special project. Special...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
MIS 304 – Management Information Systems Tiffany Sanae Woodbury MIS Lab Exercise Chapter 1: MIS and You The Spreadsheet in Microsoft Excel file Ch1Ex1 contains records of employee activity on special projects. Open this workbook and examine the data that you find in the three spreadsheets it contains. Try to do some simple calculation (either manually or use excel functions) to obtain the answers for the following questions. a) Assume that you manage the Denver plant, and you want to know how much time your employees are spending on each special project. Special Projects Hour s Market Analysis 38 Production Planning 104 Quota Computation 95 Sourcing Review 87 b) You manage the Reno plant, and you want to know how much time your employees
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: are spending on each special project. Special Projects Hours Production Planning 50 Quota Computation 90 Sourcing Review 88 c) You manage the Quota Computation project in Chicago, and you want to know how much time you spent on that project. Special Projects Hours Quota Computation 131 d) You manage the Quota Computation project for all three plants, and you want to know the total time employees have spent on your project. Denver Quota Computation 95 Chicag o Quota Computation 131 MIS 304 Management Information Systems Reno Quota Computation 90 Total for all three 316...
View Full Document

This document was uploaded on 02/16/2011.

Page1 / 2

tswLab-ch1 - are spending on each special project. Special...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online