Please show clearly answer choice (MCQs) and your calculations

Please use EXCEL (if possible) for your answers

306 SU 6: Managerial Accounting 6.2 Cost Behavior and Relevant Range the 4. An assembly plant accumulates its variable and fixed manufacturing overhead costs in a single cost pool, which is then applied to work in process using a single application base. The assembly plant management wants to estimate the magnitude of total r manufacturing overhead costs for different volume levels of the application activity base using a flexible budget formula If there is an increase in the application activity base that is within the relevant range of activity for the assembly plant, which one of the following relationships regarding variable and fixed costs is true? A The variable cost per unit is constant, and the total fixed costs decrease B. The variable cost per unit is constant, and the total fixed costs increase C The variable cost per unit and the total fixed costs remain constant D. The variable cost per unit increases, and the total fixed costs remain constant 5. A company is attempting to determine if there is a cause-and-effect relationship between scrap value and output produced. The following exhibit presents the company's scrap data for the last fiscal year Scrap as a Percent of Standard Monetary Value of Output Produced Standard Monetary Percent Month Scrap (5) 45 Nov Year Dec Year 7 Value of Output US $1.500.000 1,650,000 1,600,000 25 Jan Year 8 3.0 1,550,000 25 1.650.000 1.5 1,500,000 Feb Year 8 Mar Year 8 Apr Year 8 May Year 8 Jun Year 8 Jul Year 8 1,400.000 1.300.000 3.5 1,650,000 5.5 Aug Year 8 Sep Year 8 1,000,000 1,400,000 1,600,000 3.5 Oct Year 8 25 The company's scrap value in relation to the standard monetary value of output produced appears to be A A variable cost B. A fixed cost C. A semi-fixed cost. D. Unrelated to the standard monetary value of output SU & Managerial Accounting 6.3 Absorption (Full) vs. Variable (Direct) Costing Questions 6 and 7 are based on the following information. A company manufactures and sells a single product. Planned and actual production in its first year of operation was 100,000 units Planned and actual costs for that year were as follows Variable Fixed Manufacturing Nonmanufacturing US $500,000 US $600,000 300,000 400.000 The company sold 85.000 units of product at a selling price of US $30 per unit 6. Using absorption costing, the company's operating profit was A US $750,000 8. US $900.000 C. US $975,000 D. US $1,020,000 7. Using variable costing, the company's operating profit was A US $750.000 BUS $840,000 C. US $915,000 D. US $975.000