complete the assigned problems in Microsoft excel 40,41,42

Problem 2-42 Cost Terminology The following cost data for the year just ended pertain to Sentiments, Inc., a greeting card manufacturer. (LO 2-2, 2-5, 2-10) Direct material $2,100,000 1(a). Total prime Advertising expense 99.000 costs $2,680.000 Depreciation on factory building 115,000 1(b). Manufacturing overhead 485,000 $534,000 Direct labor: wages Cast of finished goods inventory at year-end 115,000 Indirect labor. wages 140,000 Production supervisor's salary 45,000 Service department casts" 100,000 Direct labor: fringe benefits 95,000 Indirect labor: fringe benefits 30,000 Fringe benefits for production supervisor 9.000 Total overtime premiums paid 55,000 Cost of idle time: production employees' 40,000 Administrative costs 150,000 Rental of office space for sales personnel" 15,000 Sales commissions 5,000 Product promotion costs 10,000 "All services are provided to manufacturing departments. Cost of idle time is an overhead item, it is not included in the direct-labor wages given above "The rental of sales space was made necessary when the sales offices were converted to storage space for faw material Required: 1. Compute each of the following costs for the year just ended: (a) total prime costs, (b) total manufac turing overhead costs, (c) total conversion costs. (d) total product costs, and (e) total period costs. 2. One of the costs listed above is an opportunity cost. Identify this cost, and explain why it is an opportunity cost.Case A Case B Case C Beg inventory, raw material 20.000 15,000 End inventory, raw material 90.000 30,000 Purchases of raw material 100.000 85.000 Direct material 70,000 95.000 solve for DM before purchases of RM Direct labor 100.000 125,000 Manufacturing overhead 250,000 160,000 Total manufacturing costs 520,000 345.000 340,000 Beg inventory, work in process 35.000 20.000 End inventory, work in process 35,000 5,000 Cost of goods manufactured 525,000 350.000 Beg inventory, finished goods 50,000 40.000 Cost of goods available for sale 370,000 End inventory, finished goods 25,000 Cost of goods sold 545,000 330.000 Sales 480,000 Gross margin 255,000 170.000 Selling and administrative exp 75.000 Income before taxes 150,000 90,000 Income tax expense 40.000 45.000 Net income 55,000Determine the missing amounts in each of the following independent cases. l Problem 2-41 Incomplete Data: Case A Case B Case C Manufacturing Costs Beginning inventory, raw material (LO 2-2. 2-5) $20 000 $15,000 Ending inventory, raw material $90 000 $30 000 Purchases of raw material 100 000 85 000 EX Direct material 70 000 95 000 This icon indicates that Direct labor 100 000 125.000 Excel spreadsheet temple Manufacturing overhead 250,000 160,000 (continued 70 Chapter 2 Basic Cost Management Concepts Case A Case B Case C Total manufacturing costs 520 000 345.000 340 000 Beginning inventory, work in process 35 000 20 000 Ending inventory, work in process . 35 000 5.000 Cost of goods manufactured 525,000 350 1000 Beginning inventory, finished goods 50 000 40 000 Cost of goods available for sale 370,000 Ending inventory, finished goods 25 000 Cost of goods sold 545.000 330 000 Sales 480 000 Gross margin 255,000 170,000 Selling and administrative expenses 75.000 Income before taxes 150,000 90,000 Income tax expense 40.000 45,000 Net income 55.000Problem 2-40 Mason Corporation began operations at the beginning of the current year. One of the company inancial Statement a refrigeration element. sells for $185 per unit. Information related to the current year's activities follows. Elements, Cost Behavior LO 2-5. 2.6. 23 Vanable costs per unit Direct matenal 20 Direct labor 37 Manufacturing overhead 48 Annual fixed costs Manufacturing overhead $600 000 Selling and administr 860 000 Production and Sales a Production (units) 24.000 Sales (units) 20 000 Mason carries its finished-goods inventory at the average unit cost of production and is subject to a 30 percent income tax rate. There was no work in process at year-end. Required: 1. Determine the cost of the December 31 finished-goods inventory 2. Compute Mason's net income for the current year ended December 31. 3. If next year's production decreases to 23.000 units and general cost behavior patterns do not change, what is the likely effect on a. The direct-labor cost of $37 per unit? Why? b. The fixed manufacturing overhead cost of $600.000? Why? c. The fixed selling and administrative cost of $860,000? Why? d. The average unit cost of production? Why