Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started