Why convert a range of data into an excel table

Ida sidha karya company is a family-owned company located on the island of bali in indonesia. the company produces a handcrafted balinese musical instrument called a gamelan that is similar to a xylophone. the gamelans are sold for $860. selected data for the company’s operations last year follow: units in beginning inventory 0 units produced 320 units sold 285 units in ending inventory 35 variable costs per unit: direct materials $ 135 direct labor $ 355 variable manufacturing overhead $ 30 variable selling and administrative $ 15 fixed costs: fixed manufacturing overhead $ 64,000 fixed selling and administrative $ 27,000 the absorption costing income statement prepared by the company’s accountant for last year appears below: sales $ 245,100 cost of goods sold 205,200 gross margin 39,900 selling and administrative expense 31,275 net operating income $ 8,625 required: 1. under absorption costing, how much fixed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. prepare an income statement for last year using variable costing. what is the amount of the difference in net operating income between the two costing methods?

Jallouk corporation has two different bonds currently outstanding. bond m has a face value of $50,000 and matures in 20 years. the bond makes no payments for the first six years, then pays $2,100 every six months over the subsequent eight years, and finally pays $2,400 every six months over the last six years. bond n also has a face value of $50,000 and a maturity of 20 years; it makes no coupon payments over the life of the bond. the required return on both these bonds is 10 percent compounded semiannually. what is the current price of bond m and bond n?

Required information problem 15-1a production costs computed and recorded; reports prepared lo c2, p1, p2, p3, p4 [the following information applies to the questions displayed below. marcelino co.'s march 31 inventory of raw materials is $84,000. raw materials purchases in april are $540,000, and factory payroll cost in april is $364,000. overhead costs incurred in april are: indirect materials, $59,000; indirect labor, $26,000; factory rent, $38,000; factory utilities, $19,000; and factory equipment depreciation, $58,000. the predetermined overhead rate is 50% of direct labor cost. job 306 is sold for $670,000 cash in april. costs of the three jobs worked on in april follow. job 306 job 307 job 308 balances on march 31 direct materials $30,000 $36,000 direct labor 25,000 14,000 applied overhead 12,500 7,000 costs during april direct materials 133,000 210,000 $100,000 direct labor 105,000 150,000 101,000 applied overhead ? ? ? status on april 30 finished (sold) finished in process (unsold) required: 1. determine the total of each production cost incurred for april (direct labor, direct materials, and applied overhead), and the total cost assigned to each job (including the balances from march 31). a-materials purchases (on credit). b-direct materials used in production. c-direct labor paid and assigned to work in process inventory. d-indirect labor paid and assigned to factory overhead. e-overhead costs applied to work in process inventory. f-actual overhead costs incurred, including indirect materials. (factory rent and utilities are paid in cash.) g-transfer of jobs 306 and 307 to finished goods inventory. h-cost of goods sold for job 306. i-revenue from the sale of job 306. j-assignment of any underapplied or overapplied overhead to the cost of goods sold account. (the amount is not material.) 2. prepare journal entries for the month of april to record the above transactions. 3. prepare a schedule of cost of goods manufactured. 4.1 compute gross profit for april. 4.2 show how to present the inventories on the april 30 balance sheet.