Hello, do I inculde cost of goods (70% of sales) in operating income? why is it...

Hello,

do I inculde cost of goods (70% of sales) in operating income? why is it not included in tables of budget? how do I make operating income table

Thank you

http://www.chegg.com/homework-help/spreadsheets-sensitivity-analysis-income-statementstudy-appe-chapter-7-problem-41p-solution-9780136102656-exc

Solutions

Expert Solution

Cost of good sold will be included in operating income
Sales - cogs = gross profit less operating expenses = operating income
It should be included in table of budget

SPEEDY-MART STORE, NORTHCENTER MALL
Spreadsheet for Profit Planning, Parts 1 & 2
Table of Budget Data
	June	July	August
Sales forecasts	$375,000.00	$330,000.00	$420,000.00
Sales increase (decrease)	0.00%	0.00%	0.00%
	$375,000.00	$330,000.00	$420,000.00
Cost of goods sold percentage			$0.70
Misc. expense percentage			$0.06
Sales commissions			$0.10
Employee salaries per month			$22,000.00
Rent per month			$6,000.00
Insurance expense per month			$450.00
Depreciation per month			$2,850.00

Disbursements for Operating Expenses (2a)
Cost of goods sold	$262,500.00	$231,000.00	$294,000.00	$787,500.00
Commissions	$37,500.00	$33,000.00	$42,000.00	$112,500.00
Salaries	$22,000.00	$22,000.00	$22,000.00	$66,000.00
Miscellaneous	$22,500.00	$19,800.00	$25,200.00	$67,500.00
Rent	$6,000.00	$6,000.00	$6,000.00	$18,000.00
Total	$350,500.00	$311,800.00	$389,200.00	$1,051,500.00

Operating Income (2b)
	June	July	August	Total
Sales	$375,000.00	$330,000.00	$420,000.00	$1,125,000.00
Cost of goods sold	$262,500.00	$231,000.00	$294,000.00	$787,500.00
Gross margin	$112,500.00	$99,000.00	$126,000.00	$337,500.00
Operating expenses
Commissions	$37,500.00	$33,000.00	$42,000.00	$112,500.00
Salaries	$22,000.00	$22,000.00	$22,000.00	$66,000.00
Miscellaneous	$22,500.00	$19,800.00	$25,200.00	$67,500.00
Rent	$6,000.00	$6,000.00	$6,000.00	$18,000.00
Insurance	$450.00	$450.00	$450.00	$1,350.00
Depreciation	$2,850.00	$2,850.00	$2,850.00	$8,550.00
Total	$91,300.00	$84,100.00	$98,500.00	$273,900.00
Operating income	$21,200.00	$14,900.00	$27,500.00	$63,600.00

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

The computation of operating income for Frisco Company for 2013 follows: Sales $1,800,000 Cost of Goods...

The computation of operating income for Frisco Company for 2013 follows: Sales $1,800,000 Cost of Goods manufactured and sold: Direct mateirals $360,000 Direct Labor 240,000 Variable manufacturing Overhead 120,000 Fixed manufacturing overhead 240,000 960,000 Gross Margin $840,000 Selling Expenses: Variable 132,000 Fixed 168,000 300,000 $540,000 Administrative Exepenses: Variable $156,000 Fixed 192,000 348,000 Net Operating income $192,000 An operating budget is prepared for 2014 with sales forecasted at a 25% increase in volume. Direct materials, direct labor and all costs labeled...

XYZ Company Income Statement Sales $140,000 Cost of Goods Sold 117,000 Gross Profit 23,000 Operating Expenses...

XYZ Company Income Statement Sales $140,000 Cost of Goods Sold 117,000 Gross Profit 23,000 Operating Expenses 12,830 EBIT 10,170 Taxes @39% 2168 Net income 3,392 Dividend 1,018 Addition to Retained Earnings $2,374 XYZ Company Balance Sheet Current Assets Cash $7,500 Accounts Receivable 12,100 Inventory 10,400 Prepaid Items 5,900 Other CA 4,300 Total Current Assets $40,200 Net Plant $ Equipment 82,300 Total Assets $122,500 XYZ Company Balance Sheet Current Liabilities Accounts Payable $7,200 Wages Payable 3,600 Notes payable 5,400 Taxes Payable...

Hardy Company’s cost of goods sold is consistently 70% of sales. The company plans ending merchandise...

Hardy Company’s cost of goods sold is consistently 70% of sales. The company plans ending merchandise inventory for each month equal to 30% of the next month’s budgeted cost of goods sold. All merchandise is purchased on credit, and 40% of the purchases made during a month is paid for in that month. Another 45% is paid for during the first month after purchase, and the remaining 15% is paid for during the second month after purchase. Expected sales are:...

For Absorption Costing, I will calculate the Cost of Goods Sold by multiplying the Sales and...

For Absorption Costing, I will calculate the Cost of Goods Sold by multiplying the Sales and (Fixed Manufacturing cost per unit + Variable Manufacturing Cost per unit). The reconciliation should be done using this formula: Net Income (Absorption Costing) - Net Income (Variable Costing) = Fixed Overhead in ending balance - Fixed Overhead in opening balance. Thank you. Medina Corp produces bicycle helmets. Each helmet is sold for $100. Planned and actual production was the same for May and June....

Calculate net sales: Cost of goods sold $74,500 Sales revenue $112,800 Operating expenses $23,600 Sales returns...

Calculate net sales: Cost of goods sold $74,500 Sales revenue $112,800 Operating expenses $23,600 Sales returns $4,600 Sales discounts $6,700 Inventory purchases $80,530

Precision Manufacturing had the following operating results for 2014: sales = $36,942; cost of goods sold...

Precision Manufacturing had the following operating results for 2014: sales = $36,942; cost of goods sold = $24,600; depreciation expense = $1,700; interest expense = $1,400; dividends paid = $1,000. At the beginning of the year, net fixed assets were $14,300, current assets were $8,700, and current liabilities were $6,600. At the end of the year, net fixed assets were $13,900, current assets were $9,200, and current liabilities were $7,400. The tax rate for 2014 was 34 percent. What is...

Nanticoke Industries had the following operating results for 2018: sales $29,000; cost of goods sold =...

Nanticoke Industries had the following operating results for 2018: sales $29,000; cost of goods sold = $19,710; depreciation expense = $5,220; interest expense = $2,640; dividends paid = $1,400. At the beginning of the year, net fixed assets were $17,330, current assets were $5,850, and current liabilities were $3,300. At the end of the year, net fixed assets were $20,610, current assets were $7,150, and current liabilities were $3,970. The tax rate for 2018 was 30 %. a) net income...

Titan Football Manufacturing had the following operating results for 2014: sales = $19,950; cost of goods...

Titan Football Manufacturing had the following operating results for 2014: sales = $19,950; cost of goods sold = $13,810; depreciation expense = $2,200; interest expense = $260; dividends paid = $720. At the beginning of the year, net fixed assets were $22,300, current assets were $3,110, and current liabilities were $1,900. At the end of the year, net fixed assets were $26,540, current assets were $3,620, and current liabilities were $1,990. The tax rate for 2014 was 40 percent. (Enter...

Cusic Industries had the following operating results for 2015: sales = $28,560; cost of goods sold...

Cusic Industries had the following operating results for 2015: sales = $28,560; cost of goods sold = $19,460; depreciation expense = $5,020; interest expense = $2,340; dividends paid = $1,150. At the beginning of the year, net fixed assets were $16,980, current assets were $5,800, and current liabilities were $3,280. At the end of the year, net fixed assets were $20,360, current assets were $7,360, and current liabilities were $3,900. The tax rate for 2015 was 30 percent. a....

Cardinal Industries had the following operating results for 2018: Sales = $33,510; Cost of goods sold...

Cardinal Industries had the following operating results for 2018: Sales = $33,510; Cost of goods sold = $23,820; Depreciation expense = $5,917; Interest expense = $2,670; Dividends paid = $1,924. At the beginning of the year, net fixed assets were $19,860, current assets were $6,998, and current liabilities were $3,944. At the end of the year, net fixed assets were $24,430, current assets were $8,636, and current liabilities were $4,601. The tax rate for 2018 was 24 percent. a....

Subjects