Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

تمرين 4

WHAT-IF ANALYSIS
The sales manager for the Apparel department maintains that rent should be allocated on the basis of net sales rather than on floor space. The manager thinks this is fairer since the Supplies department occupies more "prime location" floor space than does the Apparel department. Alter FORMULA1 and FORMULA2 (cells B40 and C40, respectively) on the worksheet to see what effect this "fairer" allocation would have on each department's operating income. Save the revision as DEPT4. Print the worksheet when done.