Sales = 11996.6 COGS = 7695 Profit = 4302 If the company wants to increase the...

Sales = 11996.6

COGS = 7695

Profit = 4302

If the company wants to increase the profit by 10% what should the sales and cogs be?

Expert Solution

If the company wants to increase the profits by 10% then sales and cost of goods sold (COGS) should also be increased by 10%.

Let's prove it -

Profit after 10% increase is $4,731.76 ($4,301.6*110/100)

* Profit is $4,301.6 = $11,996.6 - $7,695

Sales after 10% increase is $13,196.26 ($11,996.6*110/100)

Cost of goods sold (COGS) after 10% increase is $8,464.50 ($7,695*110/100).

Therefore, profit is $4,731.76 ($13,196.26 - $8,464.50).

Thus, the sales are $13,196.26 and COGS is $8,464.50 when profits increases by 10%.

ekkarill92 answered 2 years ago

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 $ ...

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

Company A owns 100% of the common stock of Company B. Total Sales and COGS for...

Company A owns 100% of the common stock of Company B. Total Sales and COGS for both companies are as follows: Company A Company B Sales $800,000 $50,000 COGS $600,000 $36,000 GP $200,000 $14,000 During the year Company A sold merchandise costing $60,000 to Company B for $80,000. At the end of the year Company B still possessed 30% of this inventory. Compute consolidated Sales Compute consolidated COGS Company A Company B Entry TI Entry G Consolidated Sales $800,000 ($50,000)...

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...

Question 5: XYZ Company has sales of $4,800,000, COGS is 40% of sales, operating expenses are...

Question 5: XYZ Company has sales of $4,800,000, COGS is 40% of sales, operating expenses are $2,100,000, interest expense $20,000 and depreciation 30,000. Tax rate 40%. Construct their income statement and answer the below. They have a 50-50 target capital structure of debt/equity. Their stated bank loan rate is 6% and rs = 12%. WACC is 7.8%. If the cost of capital for this project is determined to be equal to their WACC (reference question #5) instead, what is the...

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...

Your firm wants to increase sales by 12% in 2020. 2019 sales were $1,800,000. The firm...

Your firm wants to increase sales by 12% in 2020. 2019 sales were $1,800,000. The firm has $4,500,000 in total assets. The firm has $600,000 in accounts payable on its balance sheet, along with $250,000 in accruals. The firm has a 6% profit margin, and the firm typically pays out 10% of its net income. How much of the additional funds, if any, will be sourced from debt?

Below is selected financial data on Peter Parker Insect Control Company. Net profit margin: 14.15% COGS &

Below is selected financial data on Peter Parker Insect Control Company. Net profit margin: 14.15% COGS $4,000,000 Addition to retained earnings: $435,400 Current ratio: 1.9 Price-earnings ratio: 12 Current liabilities: $480,000 Fixed asset turnover: 1.6 Gross margin: 22% Equity multiplier: 1.95 Common shares: 125,000 Determine the following (show all calculations): a. Fixed assets (2 points)- round to nearest $ b. Total assets (2 points)- round to nearest $ c. Total liabilities (2 points)- round to nearest $ d. Return on...

Below is selected financial data on Peter Parker Insect Control Company. Net profit margin: 8.6% COGS...

Below is selected financial data on Peter Parker Insect Control Company. Net profit margin: 8.6% COGS $3,700,000 Addition to retained earnings: $115,000 Current ratio: 2.5 Price-earnings ratio: 15.2 Current liabilities: $400,000 Fixed asset turnover: 1.5 Gross margin: 26% Equity multiplier: 1.75 Common shares: 650,000 Determine the following (show all calculations): a. Fixed assets (2 points) - round to nearest $ b. Total assets (2 points) - round to nearest $ c. Total liabilities (2 points) - round to nearest $...

ABC Company reports the following comparative income statement: 2017 Revenue $100,000 COGS 42,000 Gross Profit 58,000...

ABC Company reports the following comparative income statement: 2017 Revenue $100,000 COGS 42,000 Gross Profit 58,000 SGA Expenses 25,000 Income before tax 33,000 Income tax expense. 11,000 Net Income 22,000 2016 Revenue $70,000 COGS 25,000 Gross Profit 45,000 SGA Expenses 28,000 Income before tax 17,000 Income tax expense. 6,000 Net Income 11,000 Prepare a vertical and horizontal analysis for ABC Company and then calculate the profit margin for ABC Company

Question