Outdoor Equipment Company (MER) and Mountain Supplies, Inc. (MFG) both sell tents. MER purchases its tents from a manufacturer for $90 each and sells them for $120. It purchased 10,000 tents last year. MFG produces its own tents; it produced 10,000 tents. Costs were as follows: $535,000 $520,000 260,000 Direct materials purchased Direct materials used Direct labor Indirect manufacturing: Depreciation Indirect labor Other Total cost of production $40,000 50,000 30,000 120.000 $900,000 Assume that MFG had no beginning inventory of direct materials. There was no beginning inventory of finished tents, but ending inventory consisted of 1,000 finished tents. Ending Work In process inventory was negligible. Each company sold 9.000 tents for $1,080.000 last year and incurred the following selling and administrative costs: Sales salaries and commissions Depreciation on retail store Advertising Other Total selling and administrative cost $ 90,000 30,000 20,000 10,000 $150,000 Required On an Excel document, create a data section along with an analysis section that includes an Income Statement for MER and for MFG with detailed Cost of Good Sold and Finished Goods sections. Each worksheet should be properly formatted, with a data section and an analysis