image 4

Excel—Spreadsheet Basics

image 10

Up the Hill Bakery

Payroll Analysis

EXCEL TEACHING CASE: BEGINNING LEVEL

Submission Instructions Complete Case 10 in Excel. Answer the questions at the end of this case and insert the answers on an Answer Sheet within the Case 10 Excel spreadsheet. Ask your instructor for submission instructions.

Preview As the human resources director for the bakery you will be managing the payroll spreadsheet for the employees at the bakery. The data collected on the employees will help you analyze if the bakery can increase efficiency by improving their operational effectiveness within payroll. As part of the Human Resources department you serve an important role in support activity in the Porter's Value Chain Model.

Skill Set

Format spreadsheet
Absolute reference
Sum, maximum, minimum functions
Date function
Goal seek (question at end of case)
If function
Vlookup table
AutoFilter
Center merge
Chart (question at end of case)

Background Jack and his wife Susan own a small French bakery in Chula Vista, California. Their customers are local residents and other small restaurants around the city. Their store delivers fresh bread and pastries to their customers, and they also serve breakfast and lunch in the bakery.

The restaurant is fully staffed ...

Get MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.