6-4 in google sheet or excel doc please

We ede w Variable Coving and Strand Reporting tools to Manager 207 Asume that we the an ewwe Aumeshat the company en meng Compre com o PIRCISE - vertete coming home tank tation teren in O3 weet perpused by the company set for lest your paw Neler the best Sotha Karya Commy The vertice contingut LOG ) - Sales Cost of good Gros Selings Netting income $150 157.500 33.750 214.500 S9250 oduced duced will tinder absorption conting how much food acting wat onded the company inventory the end of last year 2. Prepare an income statement for styring blog Explained operating income lietween the two conting methods EXERCISE 6-3 Reconciliation of Absorption and Corting Met Operating comes 06-3 Jorgersen Lighting, Inc., manufactures heavy-duty treet lighting for the company uses variable costing for internal management reports and absorption coin forester sal reports to shareholders, creditors, and the government. The company has pended the follow and su its Neu You Yout wald Inventories Beginning units Ending units Vintable conting net opino 200 170 150 180 220 $1.090.400 51032.400 5001400 170 of The company's fixed munuchin the per unit w 5.560 fot years. Required 1 Calcutate each year's en bosting net operating income Presenter in the fornar a reconciliation report Assume in Year that the company variable costing net operating income was 94.400 and is absorption costing her broting income was 1.012.400 Did inventories incroc decrease dating Year 47 h. How much fixed manufacturing overhead cost was deferred or released from inoy durine Year 47 EXERCISE 6-4 Base Segmented Income Statement 064 Royal Lancare Company produces and sells two packaged products -- Weedban and Greengrow Revenue and cost information relating to the products follow Product Weedbar Greengrow 5600 $750 $240 $5.25 $45.000 521,000 Selling price per und Variable expenses per unit Traceable ned expenses per par Chapter 6 Cound the South and 15.000 units of Word 2.000 units of Crecrow Meguret Prepare cortina France statement semented by product lines Pedro Contests business Into North and Sooth. The com EXERCHE - Comprwide and see Break Even Analysis 08-5 prepared the contributioned income statement shown below Tot 30.000 Sales Variable expenses Corbution margin Traceabile ed even Segmentar Common repenses Net operating income Company North South $600.000 $400,000 $200,000 360000 280.000 240,000 120.000 120.000 120,000 60.000 60.000 120,000 $60.000 $ 60,000 50.000 $ 70,000 Arquired Compute the company wide bak even pent in dollar sales 2 Compute the break even point in dollar sales for the North region 3 Computer the break even point in dollar sales for the South region EXERCISE 6-6 Variable and Absorption Costing Unit Product Costs and income Statements LOG-06-2 Lynch Company matures and dis a single product. The following costs were incurred during the company's first year of operations Variable costs per unit Manufacturing Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Food costs per year Fixed manufacturing overhead Pred selling and adve $6 99 SOOS $300.000 $190.000 During the year, the company produced 25.000 units and sold 20,000 units. The selling price of the company's product is $50 per unit. Required 1. Assume that the company ass absorption costing Compute the unit product cost Prepare an income statement for the year 2. Assume that the company uses variable costing Comple the unit product cost Prepare an income Stalcment for the year. EXERCISE 6-7 Segmented Income Statement 06-4 Shannon Company segments its income statement into its North and South Divisions. The com punys overall sales, contribution margin ratio, and net operating income are 5500.000, 65, $10.000. repectively. The North Division's contribution margin and contribution margina $150,000 and 50%, respectively. The South Division's segment margin is $30,000. The company has 591,000 of common fixed expenses that cannot be traced to either division