Cost Accounting Problem in excel:

Please read the problem below. You can use the green cells to perform your calculations. The yellow cells pull the totals from the green cells. The answers in the yellow cells will be graded by the GA. Each correct response is worth 0.3 points. You can earn 3.9 points at most on this assignment. The following costs are for a company that manufactures leather shoes. Variable Cost Note: 50% of the Factory Overhead is variable. 40% of Selling Costs are variable. 30% of General & Admin Costs are variable. Direct Cost Note: 35% of Selling Costs are direct. 25% of General & Admin Costs are direct. Based on the information provided, compute the following costs