Case Study – Chapter 2

Morden Shapiro

Prorating as a Management Tool

Background

Bill is general manager of Everything Retail Inc. (ERI). ERI is organized by Departments. Each Department has a Department Manager whose compensation is directly linked to the Company’s calculation of (their) Departmental profit.

ERI operates from a single large bricks and mortar storefront. Two of the most significant Departments are Jewelry and Sporting Goods. The Department Heads are George – Jewelry, and Monica – Sporting Goods. George and Monica have recently come to Bill to discuss a heated issue between them. Assume that the “other” Departments are a collection of smaller operations whose Department Heads are not involved in this issue.

The Issue

One of ERI’s major expenses is the monthly rent of $25,000. When calculating departmental profit, Bill has allocated the monthly rent cost to each Department, prorated based on the following data (which is not in dispute):

Department Monthly sales
Jewelry $90,000
Sporting Goods $60,000
Others $25,000

George is quite unhappy. He argues that it is unfair for his Department (Jewelry) to bear almost 50% of the cost of space. He has produced the following space related data and argues that he should only be burdened with the relative cost of the space occupied by his department.

Department Space occupied
Jewelry 600 square feet
Sporting Goods 2500 square feet
Others 1000 square feet

Assignment 1

  1. In mathematical terms express the monthly share of rent assigned to each Department group under Bill’s approach and under George’s approach. Your formula should produce the differential impact of each approach on each Department group in terms of rent share as a percentage of Departmental monthly sales.
  2. Create an Excel spreadsheet with appropriate formulas that calculate the allocation of rent costs and the differential impact to each Department based on the two approaches.

 Assignment 2

Prepare a written response to the following argument:

“Bill’s approach is the more defensible one because it reflects the true state of affairs. Jewelry has the greatest sales and so is best able to afford its computed share of the rent cost. As a result, proration reflects the reality and should be relied upon.”

Challenge

If you were determined to find a peaceful resolution to this conflict, how would you use the concept of proration to move past this conflict?

 

Attribution: Case study by Morden Shapiro (Ontario Tech University), published under Creative Commons Attribution-NonCommercial-ShareAlike licence (CC-BY-NC-SA)

Any modifications to this case study may affect its solvability and caution is advised.

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Case Study - Chapter 2 by Morden Shapiro is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book