Form ID Number: Inventory Worksheet

5.    Prepare any necessary adjusting entries to reflect the Inventory count at year end. These must be hand written.

|SALES AND COST OF GOODS SOLD BY PRODUCT LINE | | | |Date: | | | |

BALANCE SHEET |Dec 1990 |Jan |Feb |Mar |Apr |May |June |July |Aug |Sept |Oct |Nov |Dec | |Cash |175 |556 |724 |175 |175 |175 |175 |175 |175 |175 |175 |175 |175 | |Accts receivable |2,628 |958 |234 |271 |270 |250 |250 |270 |1,603 |3,113 |3,580 |3,982 |3.063 | |Inventory |530 |948 |1,355 |1,749 |2,157 |2,564 |2,971 |3,365 |2,904 |2.314 |1,549 |697 |530 | |Net P/E |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 | |Total Assets |4,403 |3,533 |3,383 |3,265 |3,672 |4,059 |4,466

Second, this design maximizes the visual and informational presentation for the financial data. Given this design, the user of the information can readily identify what items belong to a certain department, and how many items were in to arrive at the total cost for a particular item for the period. Third, given the presentation of the total amount and quantity on hand for an item, the information user can easily calculate the effective average purchase price for an item. Recommend improvements to the data table The data tables, specifically the Pivot table, may be improved on by arranging the codes chronologically; sort the data by compiling

Accounts receivable, net . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 646,339 558,851

Name: ________________________________ Date: _________________ [1]BASIC BANK01 - BAT 003 Which of the following statements is true? A. An asset account is increased by a credit B. An expense account is increase by a credit C. A revenue account is decreased by a credit D. An equity account is decreased by a debit [2]BASIC BANK02 - BAT 010 The Income Summary account contains: A. Total revenues and total expenses for the year B. Total assets and total liabilities at year end C. Total revenues, expenses, assets, and liabilities

LARGE Units sold (excluding specials) Units sold Units embroidered Units dyed Number of orders Number of shipments Number of invoices Sales dollars Acc. Bal. > 60 days 99.770 100.250 5.959 20.536 133 147 112 308.762 1

1. Cash (Exhibit 7-11)............................................ $1,875 2. Gross sales revenue (Exhibit 7-9)................... $7,491 Less: Sales discounts (Exhibit 7-9)................ (35) Net sales revenue............................................. $7,456 3. Purchased furniture on account— Purchases journal p. 8 (Exhibit 7-10) 4. City Office Supply November 30 balance (Exhibit 7-11)............... $ 543

10. A segment of a business enterprise is to be reported separately when the revenues of the segment exceed 10 percent of the

Milligan’s Backyard Storage Kits, a mail order company, sells a variety of backyard storage unit kits and landscaping decorations to its customers. Although the company makes a profit, David Milligan, the company’s owner, realizes that he can improve his company’s operations if he better manages his inventory. Mr. Milligan requests your help in preparing an Inventory Analysis worksheet. The Inventory Analysis worksheet provides Mr. Milligan with information about his annual sales, cost of goods sold, gross profit, and markup on this products. Preparing the worksheet for Mr. Milligan requires you to insert columns, use several functions, and apply proper formatting to the

119,625 Table 4.1 Pro-forma Income Statements (2017-2019) Proforma Balance Sheet (From 2017 to 2019,

Milligan’s Backyard Storage Kits, a mail order company, sells a variety of backyard storage unit kits and landscaping decorations to its customers. Although the company makes a profit, David Milligan, the company’s owner, realizes that he can improve his company’s operations if he better manages his inventory. Mr. Milligan requests your help in preparing an Inventory Analysis worksheet. The Inventory Analysis worksheet provides Mr. Milligan with information about his annual sales, cost of goods sold, gross profit, and markup on this products. Preparing the worksheet for Mr. Milligan requires you to insert columns, use several functions, and apply proper formatting to the

Transition: Now that we know our ingredients, we can begin with our steps to making the recipe.

Tampa Foundry began operations during the current year, manufacturing various products for industrial use. One such product is light-gauge aluminum, which the company sells for $36 per roll. Cost information for the year just ended follows.

March 31, 2012 (audited) US$’000 33,131 2,328,104 2,361,235 86,734 – 2,447,969 – 291,111 381,593 204,818 83,594 641,986 1,603,102 4,050,272 127,315 49,253 7,074,196 310,159 135,530 62,952 11,809,677 13,412,779 15,860,748 10,723 4,051,071