Accounting

 
Introduction: Before responding to this question, please review the relevant sections on accounts receivable in the textbook as well as the video, What is supply chain management? (ASU-WPC-SCM) assigned in this module.
Description: Mario Lopez owns MLWS, a window and siding company that employs installers and an office staff that includes an administrative assistant plus two full time accounts receivable clerks. He would like to reduce his overhead costs so he might outsource his receivables function. His two full time receivables clerks earn $27,000 each plus 25% fringe benefits. Variable costs he estimates at $10. Mario was approached by Accounts Receivable Enterprise (ARE) offering to manage his receivables at a fixed cost of $50,000 per year plus $30 per account receivable. Next year, Mario expects to have 1,500 accounts receivable.

What would be the cost to MLWS of continuing to process accounts receivable in-house?
What would be the cost to MLWS of moving the accounts receivable to ARE?
If you could negotiate one or the other but not both of ARE’s fixed or per account receivable costs, which would you choose, and why?
What other alternatives could Mario consider to reduce costs, and how would those alternatives impact the other company employees?

Format: This assignment is meant to be completed using a spreadsheet. You may submit it as an Excel file, though you may copy and paste your spreadsheet into the Word document and submit it that way if you prefer. Submit this assignment here.