Question: please show me how to solve using excel 1. Gabriela Manufacturing must decide whether to insource or outsource a new toxic-free miracle carpet cleaner that

please show me how to solve using excel
please show me how to solve using excel 1. Gabriela Manufacturing must

1. Gabriela Manufacturing must decide whether to insource 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 $250,000 of annual fixed costs and \$1.25 per unit of variable costs. If it is outsourced, a supplier has offered to make it for an annual fixed cost of $90,000 and a variable cost of $2.05 per unit in variable costs. a. Given these two alternatives, deternine the indifference point (where total costs are equal). IndifferencePoint:TotalCostofInsourcing=TotalCostofOutsourcingTotalCost=FC+VC(Q)250,000+125(Q)=90,000+2.05(Q)Q=200,000units b. If the expected demand for the new miracle cleaner is 400,000 units, what would you recommend that Gabriela Manufacturing do? 1. Gabriela Manufacturing must decide whether to insource 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 $250,000 of annual fixed costs and \$1.25 per unit of variable costs. If it is outsourced, a supplier has offered to make it for an annual fixed cost of $90,000 and a variable cost of $2.05 per unit in variable costs. a. Given these two alternatives, deternine the indifference point (where total costs are equal). IndifferencePoint:TotalCostofInsourcing=TotalCostofOutsourcingTotalCost=FC+VC(Q)250,000+125(Q)=90,000+2.05(Q)Q=200,000units b. If the expected demand for the new miracle cleaner is 400,000 units, what would you recommend that Gabriela Manufacturing do

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!