Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
INSTRUCTIONS: Prepare a data input section in the exact order as given below. Naming of the input 'sheet' should be INPUT. Do NOT cellprotect the
INSTRUCTIONS: 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 entered as not Your input should be placed in the following Rows Columns AB with the heading INPUT SECTION centered over all columns to which it relates: tableCFG OUTPUT SECTION Shcedule of COGS,,Income Statement"Heading" Line "Heading" Line Item Name Company Name MLB Inc. Item Amount $ Inventory, $ Purchases Adjustments $ FreightIN $ Operating Income $ Common Dividends $ Item Amount Net Purchases as a of Purchases Inventory, as a of Cost of Goods Sold Tax as a of Inventory, Tax Rate Net Income as a of Net Sales Sales Adjustments as a of Sales Total Dividends as a of Preferred Dividends Retained Earnings, as a of Cost of Goods Available Item Amount shares Weighted Average Common Shares Outstanding
INSTRUCTIONS:
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 entered as not Your input should be placed in the following Rows Columns AB with the heading INPUT SECTION centered over all columns to which it relates: tableCFG OUTPUT SECTION Shcedule of COGS,,Income Statement"Heading" Line "Heading" Line Item Name
Company Name MLB Inc.
Item Amount $
Inventory, $
Purchases Adjustments $
FreightIN $
Operating Income $
Common Dividends $
Item Amount
Net Purchases as a of Purchases
Inventory, as a of Cost of Goods Sold
Tax as a of Inventory,
Tax Rate
Net Income as a of Net Sales
Sales Adjustments as a of Sales
Total Dividends as a of Preferred Dividends
Retained Earnings, as a of Cost of Goods Available
Item Amount shares
Weighted Average Common Shares Outstanding
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started