Intel Corporation
Income Statement ($ millions)
Dec-16 Dec-15 Dec-14 Dec-13 Dec-12
Sales 59387 55355 55870 52708 53341
Cost of Goods Sold-
(COGS) incl. D&A 23425 20651 20522 21418 20507
Gross Income ? ? ? ? ?
SG&A Expense 21149 19835 19693 18729 18117
EBIT-
(Operating Income) 14813 14869 15655 12561 14717
Nonoperating-
Income - Net 533 -51 224 595 463
Interest Expense 733 337 192 244 90
Unusual Expense - Net 1677 269 -114 301 217
Pretax Income ? ? ? ? ?
Income Taxes ? ? ? ? ?
Net Income 10316 11420 11704 9620 11005

(a) Create the required formulas to calculate the missing variables, and format the results to match the other numbers.
(b) Calculate the average tax rate, the gross profit margin, and the net profit margin for 2012-2016. Format the results as percentages with two decimal places.
(c) Create a line chart showing the gross profit margin and the net profit margin for 2012-2016. Make sure to title the chart and label the axes.
(d) Create a copy of the income statement and replace each item with a formula that shows it as a percentage of sales. You should only use one formula that can be copied and pasted to the rest of the income statement.

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.

Plastic and steel are substitutes in the production of body panels for certain automobiles. if the price of plastic increases, with other things remaining the same, we would expect: a) the demand curve for plastic to shift to the left. b) the price of steel to fall. c) the demand curve for steel to shift to the left d) nothing to happen to steel because it is only a substitute for plastic. e) the demand curve for steel to shift to the right

The notarial evidence form is completed by