Hock, Inc 2013 2014 Sales 7,250 8,120 COGS 5,200 5,615 Gross Profit 2,050 2,504 Projected...

Hock, Inc	2013	2014
Sales	7,250	8,120
COGS	5,200	5,615
Gross Profit	2,050	2,504

Projected sales for 2015 are 8,932. Determine the variable and fixed cost components of COGS and then project the gross profit for 2015.

a. 2,754

b. 2,831

c. 2,928

d. 2,864

Expert Solution

jeff jeffy answered 5 months ago

If Gross Profit Margin is 55%, what is COGS %?

In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as...

In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as specified and without creating a helper column, using Filters, or Pivot Tables. Date Product Region SalesRep Customer Sales COGS Gross Profit 4/19/2020 Product3 Region3 SalesRep2 Customer16 $ 14,046 $ 5,337 All products: 4/19/2020 Product7 Region4 SalesRep15 Customer72 $ 2,504 $ 1,703 Product9 only: 4/19/2020 Product2 Region4 SalesRep18 Customer71 $ 1,505 $ 843 Product3 and SalesRep16 only: 4/19/2020 Product6 Region4 SalesRep14 Customer88 $ 4,232 $ ...

Ratios 2016 2015 2014 2013 Profit margin 19% 17.8% 17.3% 19.9% Gross Profit Margin 41.4% 38.5%...

Ratios 2016 2015 2014 2013 Profit margin 19% 17.8% 17.3% 19.9% Gross Profit Margin 41.4% 38.5% 38.1% 38.8% Current Ratio 1.4 : 1 3.3 : 1 1.5 : 1 1.6 : 1 Quick Ration 0.8 : 1 3 : 1 1.2 : 1 1.3 : 1 Working Capital (in millions) $1,380.3 $6,692.6 $1,437.6 $1,880.1 Accounts Receivable Turnover (times per year) 17.8 20.1 21.7 20.9 Accounts Receivable Days Outstanding (days) 21.9 18.7 16.2 17.1 Inventory Turnover (times per year) 181.3 148.8...

The Brenmar Sales Company had a gross profit margin (gross profit/sales) of 28% and sales of...

The Brenmar Sales Company had a gross profit margin (gross profit/sales) of 28% and sales of $8.6 million last year. 70% of the firm’s sales are in credit, and the remainder are cash sales. Brenmar’s current assets equal $1.4 million, its current liabilities equal $299,000, and it has $106,000 in cash plus marketable securities. A. If Brenmar’s accounts receivable equal $562,600, what is its average collection period? B. If Brenmar reduces its average collection period is 25 days, what will...

income statement for year ended in ded 31 2014 sales 755,000 cogs 543,000 gros profit 212,00...

income statement for year ended in ded 31 2014 sales 755,000 cogs 543,000 gros profit 212,00 operating expenses selling expenses 52,000 Admin exp 141,000 net income 71,000 addl info 1 a/ r decreaded by 63,000 2 inventory increased 38,000 3 prepaid expensed increased 12,000 4 a/p increased 25,000 5 accrued expense payable 6,000 6 admin expenses include deprecation expenses of 20,000 Instruction: Prepare the operating section of the cash flow statement using the indirect method. account name sign +/- $amount...

1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following:...

1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following: Yr. 1 Revenues 500 COGS 400 Gross Profit 100 Gross Margin 20% Sales rise 5%, 3% due to increase in volume and 2% due to increase in price. COGS is 80% variable. 2. What is the primary driver of sales growth for the following company? Explain. Assume COGS is 60% variable. Yr. 1 Yr. 2 Revenues 800 850 COGS 500 519 Gross Profit...

The most recent financial statements for Retro Machine, Inc., follow. Sales for 2014 are projected to...

The most recent financial statements for Retro Machine, Inc., follow. Sales for 2014 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. RETRO MACHINE, INC. 2013 Income Statement Sales $ 725,000 Costs 591,000 Other expenses 12,000 Earnings before interest and taxes $ 122,000 Interest paid 14,000 Taxable income $ 108,000 Taxes...

Distinguish between gross profit as a percentage of cost and gross profit as a percentage of sales price.

Distinguish between gross profit as a percentage of cost and gross profit as a percentage of sales price. Convert the following gross profit percentages based on cost to gross profit percentages based on sales price: 25% and 33 1 /3%. Convert the following gross profit percentages based on sales price to gross profit percentages based on cost: 33 1 /3% and 60%.

The Brenmar Sales Company had a gross profit margin (gross profits / sales) of 28% and sales...

The Brenmar Sales Company had a gross profit margin (gross profits / sales) of 28% and sales of $8.3 million last year. 73% of the firm's sales are on credit, and the remainder are cash sales. Bertram's current assets equal $1.4 million, its current liabilities equal $299,999, and it has $108,000 in cash plus marketable securities. A. If Brenmar's accounts receivable equal $563,100, what is its average collection period? B. If Brenmar reduces its average collection period to 20 days, what...

MONTGOMERY INC. Comparative Balance Sheets December 31, 2014 and 2013 2014 2013 Assets Cash $ 30,400...

MONTGOMERY INC. Comparative Balance Sheets December 31, 2014 and 2013 2014 2013 Assets Cash $ 30,400 $ 30,550 Accounts receivable, net 10,050 12,150 Inventory 90,100 70,150 Equipment 49,900 41,500 Accum. depreciation—Equipment (22,500 ) (15,300 ) Total assets $ 157,950 $ 139,050 Liabilities and Equity Accounts payable $ 23,900 $ 25,400 Salaries payable 500 600 Common stock, no par value 110,000 100,000 Retained earnings 23,550 13,050 Total liabilities and equity $ 157,950 $ 139,050 MONTGOMERY INC. Income Statement For Year Ended...

Question