IDEAS home Printed from https://ideas.repec.org/a/eee/advacc/v38y2017icp99-105.html
   My bibliography  Save this article

Lattice allocations: A better way to do cost allocations

Author

Listed:
  • Bent, Kirke
  • Caplan, Dennis

Abstract

This paper describes a new cost allocation technique that we call “lattice allocation.” The technique uses matrix algebra operations such as in standard spreadsheet software to perform complex cost allocations. To illustrate the power and versatility of the technique, we provide two examples. First, we show how lattice allocations can allocate service department costs to fully recognize mutual services among service departments, similar to the reciprocal method but without the complexity of solving a set of linear equations. Second, we show how lattice allocations can implement two-stage activity-based costing in a single step. The lattice allocation method is easy to apply, requires no special software for small organizations, easily scales up to medium and large organizations, and provides managers better information about the origins of allocated costs. Also, lattice allocations are likely to produce more accurate results than traditional techniques and are well-suited as a pedagogical tool for cost accounting courses. The paper suggests future research topics, including the implications of lattice allocations for Fast Close, Continuous Reporting, and government contractor cost accounting requirements.

Suggested Citation

  • Bent, Kirke & Caplan, Dennis, 2017. "Lattice allocations: A better way to do cost allocations," Advances in accounting, Elsevier, vol. 38(C), pages 99-105.
  • Handle: RePEc:eee:advacc:v:38:y:2017:i:c:p:99-105
    DOI: 10.1016/j.adiac.2017.07.008
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0882611017300937
    Download Restriction: Full text for ScienceDirect subscribers only

    File URL: https://libkey.io/10.1016/j.adiac.2017.07.008?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Keller, Anthony Craig, 2015. "Service department cost allocations using the net services model and the MDTERM function in Excel," Journal of Accounting Education, Elsevier, vol. 33(3), pages 241-255.
    2. Bradbard, David A. & Alvis, Charles & Morris, Richard, 2014. "Spreadsheet usage by management accountants: An exploratory study," Journal of Accounting Education, Elsevier, vol. 32(4), pages 24-30.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Apostolou, Barbara & Dorminey, Jack W. & Hassell, John M. & Rebele, James E., 2015. "Accounting education literature review (2013–2014)," Journal of Accounting Education, Elsevier, vol. 33(2), pages 69-127.
    2. Francesca Culasso & Elisa Giacosa & Edoardo Crocco & Daniele Giordino, 2023. "Modern day Management Accountants: A latent Dirichlet allocation investigation," MANAGEMENT CONTROL, FrancoAngeli Editore, vol. 2023(2 Suppl.), pages 11-36.
    3. Sledgianowski, Deb & Gomaa, Mohamed & Tan, Christine, 2017. "Toward integration of Big Data, technology and information systems competencies into the accounting curriculum," Journal of Accounting Education, Elsevier, vol. 38(C), pages 81-93.
    4. Lin Mei Tan & Fawzi Laswad, 2018. "Professional skills required of accountants: what do job advertisements tell us?," Accounting Education, Taylor & Francis Journals, vol. 27(4), pages 403-432, July.
    5. Parra, Fernando & Jacobs, Aimee & Trevino, Laura L., 2021. "Shippy Express: Augmenting accounting education with Google Sheets," Journal of Accounting Education, Elsevier, vol. 56(C).
    6. Najihah Jusoh & Hanyza Ahmad, 2019. "Usage Of Microsoft Excel Spreadsheet As Accounting Tools In Sme Company," INWASCON Technology Magazine(i-TECH MAG), Zibeline International Publishing, vol. 1, pages 23-25, September.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:advacc:v:38:y:2017:i:c:p:99-105. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: https://www.journals.elsevier.com/advances-in-accounting/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.