Spreadsheet Assignment Mastering Excel The Pillar Manufacturing Company has three identified levels of authority and responsibility. The organization chart as of December 31, 2007, appears as follows:

Level 1 President Level 2 Marketing Production Finance Vice President Vice President Vice President Level 3 Cutting Finishing Department Department Department Department Supervisors Supervisor Supervisor Supervisors Pertinent expenses for Level 3 follow:

Required

a. Construct a spreadsheet that shows responsibility reports for the finishing department supervisor, the production vice president, and the president.

b. Include formulas in the responsibility reports that illustrate the interrelationships between these reports. For example, changes in the finishing department report should be automatically reflected in the production department report.
Spreadsheet Tip (1) Use the absolute value function [=ABS(value)] in the formulas that calculate the variances