PLEASE USE EXCEL TO COMPLETE BOTH QUESTIONS AND INCLUDE THE EQUATIONS. Thank You.

1. Gabriela Manufacturing must decide whether to in-source or outsource a new toxic-free miracle carpet cleaner that works with its Miracle Carpet Cleaning Machine. If it decides to insource the product, the process would incur $300,000 of annual fixed costs and $1.50 per unit of variable costs. If it is outsourced, a supplier has offered to make it for an annual fixed cost of $120,000 and a variable cost of $2.25 per unit in variable costs. (a) Given these two alternatives, determine the indifference point (where total costs are equal). (b) If the expected demand for the new miracle cleaner is 300,000 units, what would you recommend that Gabriela Manufacturing do? 2. Cal's Carpentry is considering outsourcing its accounts receivable function. Currently, Cal employs two full-time clerks and one part-time clerk to manage accounts receivable. Each full- time clerk has an annual salary of $36,000 plus fringe benefits costing 30 percent of the salary. The part-time clerk makes $18,000 per year but has no fringe benefits. Total salary plus fringe cost is $111,600. Cal estimates that each account receivable incurs a $10 variable cost. The Small Business Accounts Receivables Group (SBARG) specializes in handling accounts receivable for small to medium-size companies. Doris Roberts from SBARG has offered to do the accounts receivable for Cal's Carpentry at a fixed cost of $75,000 per year plus $30 per account receivable. Next year, Cal expects to have 2000 accounts receivable. (a) Calculate the cost for Cal's Carpentry to continue doing accounts receivable in-house. (b) Calculate the cost for Cal's Carpentry to use SBARG to handle the accounts receivable. (c) If the fixed annual cost offered by SBARG is non-negotiable but it is willing to negotiate the variable cost, what variable cost from SBARG would make Cal indifferent to the two options? (d) What other alternatives might Cal consider in terms of his current staffing for accounts receivable? le) What additional criteria should Cal consider before outsourcing the accounts receivable