Prepare a data input section in the exact order as given below. Naming of the input 'sheet' should be "INPUT". Do NOT cellprotect the numeric data of this section, as you must allow for the possibility of change to this information. Use the amounts given as a test of your output. Enter Pct as the %, not decimal (80% entered as 80, not 0.80). Your input should be placed in the following rows/columns (the heading "INPUT SECTION" should be centered over all columns to which it relates):

Prepare an output section that produces the following items: 1) "COGS Schedule", and 2) "Income Statement". The reporting period is for the calendar year of 2021. The output items should be placed on a separate 'sheet' (the heading "OUTPUT SECTION" should be centered over all columns to which it relates: [A1..G1]). Naming of the output 'sheet' should be "OUTPUT". No number (dollar amount, shares, or percentage) or company name (the company name should be shown in a "script" font) should be typed (hard coded) directly into any cell in the output section, as this would prevent your output from being correct when the input is changed. Instead, the output section must reference the appropriate amounts (shares, dollars, and percents) and name from the input and/or output sections. Your output should be placed in the following spreadsheet rows/columns, using the color scheme as shown, where $$$ represent dollar amounts (the "SHADED" cells should be blank, but don't shade them):

Do NOT cellprotect any portion of the output section. Use good form with respect to the creation of the output. This includes heading rules; appearance; alignment; proper use of commas, rulings, $; etc. All dollar amounts should be ROUNDED to the nearest dollar (see note below) and FORMATTED to show whole dollars only (no cents). Exception is for EPS in cell [G20], which should be ROUNDED to nearest tenth of a cent: ($$$.$$$). COGS should be computed one time, in cell [C18], and then transferred to cell [G11]. The caption "OTHER: Rev/Gain/Exp/Loss", which includes other revenues/expenses/gains/losses, could be a net positive or negative, and thus should be shown as such. Refer to the CLASSROOM:HANDOUTS link on class webpage for help with the COGS Schedule and CHAPTER 4 in the text for help with the income statement.

A schedule's and statement's "HEADING" should be centered over all columns in the output for which it relates, and shown in BOLD, ITALICS, and in RED; both the Names and amounts ($$$) that are taken from the input section should be shown in BOLD, ITALICS, and in BLUE. The captions "Add:" and "Less:" should be shown in BOLD, ITALICS, and in RED, with the amounts associated with the caption "Less:" shown as positive numbers, and then subtracted. (see above)

All labels in columns "A" and column "E" are to be left-aligned, except for the descriptions shown "indented". The amounts shown in columns "B", "C", "F", and "G" are to be right-aligned. The "Headings" [A3..C5] and [E3..G5] should all be centered.

No item should be shown on the speadsheet in a "box" (no grid lines). The diagram above is an illustration showing in what CELL [row/col] items are to be place, and which cells should be blank.

This is all that I have so far:

A B . 1 .. INPUT SECTION ... 2 3 Item Name 4 Company Name World Series, Inc. 5 6 Item Amount ($) 7 Net Purchases $499,100 8 Inventory, 12/31/21 $536,400 9 Tax $132,600 10 OTHER: Rev/Exp/Gain Loss (+/-) - $74,700 11 12 Item Amount (%) 12.5 13 Purchases Adjustments as a % of Purchases 14 % CHANGE in Inventory FYE 12/31/21 (+/-) 15 Cost of Goods Available as a % of Cost of Goods Sold - 25.0 175.0 16 Tax Rate 40.0 17 "Profit Margin %" 10.0 55.0 18 Sales Adjustments as a % of Freight-In 19 Preferred Stock Dividends as a % of Sales 1.0 20 21 Item Amount (shares) 22 Weighted Average Common Shares Outstanding 47,900 B C D E F G 1 OUTPUT SECTION ... 2 3 Put Put 4 "Heading" "Heading" Here Here 6 7 Inventory, 1/1/21 SSS SSS.S$$ Sales SSS SSSSSS 8 Purchases SSS.S$$.$$s Less: 9 Less: Sales Adjustments SSS,$S$.$$$ 10 Purchases Adjustments SSSSSSSSS Net Sales SS$,S$$,$$$ 11 Net Purchases SSS SSS SSS COGS SS$,$$$,$S$ 12 Add: Gross Profit SS$,S$$,$$$ 13 Freight-In $S$,$$$,$$$ Operating Expenses SSS.S$$,$$$ 14 COGPurchased SSS SSS SSS Operating Income SSS.S$$.$$$ 15 COGAvailable SSS SSS SSS OTHER: Rev/Exp/Gain Loss SSS, SSS,SSS 16 Less: Income Before Tax SSS SSS SSS 17 Inventory, 12/31/21 SSS, SSS,SSS Tax SSSSSSSSS 18 COGS SSS SSS SSS Net Income SSS SSS,$S$ 19 20 EPS: SSS.SSS A B E F G H 1 ... OUTPUT SECTION ... 4 5 COGS Schedule Income Statement 6 $ 670,500 Sales Less: Sales Adjustments Net Sales $1,989,000 $ 499,100 COGS Gross Profit 7 Inventory, 1/1/21 8 Purchases 9 Less: 10 Purchase Adjustments 11 Net Purchases 12 Add: 13 Freight-In 14 COGPurchased 15 COGAvailable 16 Less: 17 Inventory, 12/31/21 18 COGS Operating Expenses Operating Income OTHER: Rev/Exp/Gain/Loss Income Before Tax $ (74,700) $ 331,500 $ 132,600 $ 198,900 $ 536,400 Tax Net Income 19 20 EPS: 21 22