APPLICATION: (SHOW ALL CALCULATIONS) Given the following: Income Statement (End of Year, 2017) In...
APPLICATION: (SHOW ALL CALCULATIONS) Given the following: Income Statement (End of Year, 2017) Industry % of sales Net Sales 500,000 100 Less: Inventory (B) 60,000 12 Gross Purchases 200,000 40 Less: discounts 20,000 4 Net Purchases 180,000 36 Total Goods Available 240,000 48 Less: inventory (E) 75,000 10 Total Cost of Goods Sold 165,000 38 Gross Margin: 335,000 62 Less: Variable Expenses Sales Commissions 130,000 26 Deliveries 5,000 1 135,000 27 Contribution Margin 200,000 35 Less: Fixed Expenses Rent 50,000 10 Salaries 95,000 12 Distribution Rights 5,000 1 150,000 23 Net Profit (BT) 50,000 12
Calculate the firm’s 2017 Breakeven Sales figure. What is the new Breakeven Sales figure if the firm’s management wants to increase next year’s profit margin by 2% of Total Sales? (hint: the 2% increase in sales becomes a target profit).
Homework Answers
| Calculation of firm's 2017 Breakeven Sales | |||||||
| Break even sales = Total Fixed Expenses / Contribution Margin % | |||||||
| Contribution Margin % = Contribution Margin / net sales = $200000/$500000 = 40% | |||||||
| Break even sales = $150000 / 40% | |||||||
| Break even sales for 2017 = $3,75,000 | |||||||
| Calculation of firm's new Breakeven Sales | |||||||
| New Break even sales = [Total Fixed Expenses + Target profit]/ Contribution Margin % | |||||||
| Total Fixed expenses = $150000 | |||||||
| Target profit = Net sales x profit % = $500000 x 12% = $60,000 | |||||||
| New Break even sales = [$150000 + $60000]/ 40% | |||||||
| New Break even sales = $5,25,000 | |||||||
Add Answer to:
APPLICATION: (SHOW ALL CALCULATIONS) Given the following: Income Statement (End of Year, 2017) In...
APPLICATION: (SHOW ALL CALCULATIONS) Given the following: Income Statement (End of Year, 2017) Industry % of...
APPLICATION: (SHOW ALL CALCULATIONS) Given the following: Income Statement (End of Year, 2017) Industry % of sales Net Sales 500,000 100 Less: Inventory (B) 60,000 12 Gross Purchases 200,000 40 Less: discounts 20,000 4 Net Purchases 180,000 36 Total Goods Available 240,000 48 Less: inventory (E) 75,000 10 Total Cost of Goods Sold 165,000 38 Gross Margin: 335,000 62 Less: Variable Expenses Sales Commissions 130,000 26 Deliveries 5,000 1 135,000 27 Contribution Margin 200,000 35 Less: Fixed Expenses Rent 50,000...
Exercise 2 (20 points) APPLICATION 1. The accounting department has rushed the following Income Statement Report...
Exercise 2 (20 points) APPLICATION 1. The accounting department has rushed the following Income Statement Report to you. As you are about to present the figures, you notice a page is missing, but the information provided contains the following: Net Sales $400.000: Total Goods Available $250.000, Inventory (beginning) $40,000: Variable Expenses, $80,000 and Fored Costs, $60,000. Gross Margin is fifty percent of Net Sales. The boss has asked you for an income Statement showing "All Major summary performance category figures...
1. The accounting department has rushed the following Income Statement Report to you. As you are...
1. The accounting department has rushed the following Income Statement Report to you. As you are about to present the figures, you notice a page is missing, but the information provided contains the following: Net Sales, $400,000; Total Goods Available, $250,000; Inventory (beginning), $40,000; Variable Expenses, $80,000 and Fixed Costs, $60,000. Gross Margin is fifty percent of Net Sales. The boss has asked you for an Income Statement showing “All Major” summary performance category figures contained in a marketing income...
Insta Limited Statement of Comprehensive Income For the year ended June 30, 2017 Amount Particulars in...
Insta Limited Statement of Comprehensive Income For the year ended June 30, 2017 Amount Particulars in Rupees) Sales 843,500 Opening Inventory Purchases Factory Expenses Closing Stock Cost of Goods Sold 55,000 465,000 143,000 (79,500) (583,500) Gross Profit 260,000 Office Expenses Selling Expenses Distribution Expenses Provision for Doubtful Debts Depreciation Interest of Debentures 50,000) (30,000) (20,000) (4,000) (16,000) (14,000) Other Income Gain on disposal of vehicle Interest on Investment 20,000 40,000 Net Profit 186,000 Required: Based on the information given, compute...
In its income statement for the year ended December 31, 2017, Blossom Company reported the following...
In its income statement for the year ended December 31, 2017, Blossom Company reported the following condensed data. Salaries and wages expenses Cost of goods sold Interest expense Interest revenue Depreciation expense $450,000 Loss on disposal of plant assets 1,149,500 Sales revenue 65,000 Income tax expense 145,200 Sales discounts 300,000 Utilities expense $83,000 2,210,000 25,000 120,000 100,000 Your answer is partially correct. Prepare a multiple-step income statement. (List other revenues before other expenses.) BLOSSOM COMPANY Income Statement For the Year...
CRANE COMPANY Income Statement For the Year Ended December 31, 2017 Sales Sales Revenue 2,290,000 Less...
CRANE COMPANY Income Statement For the Year Ended December 31, 2017 Sales Sales Revenue 2,290,000 Less +: Sales Discounts 170,000 Net Sales 2,120,000 Cost of Goods Sold 1,038,800 Gross Profit 1,081,200 Operating Expenses 460,000 i Salaries and Wages Expense 320,000 i Depreciation Expense 120,000 i Utilities Expense Total Operating Expenses 900,000 Income From Operations 181,200 Other Revenues and Gains Interest Revenue 57,900 Other Expenses and Losses Interest Expense 67,000 83,500 i Loss on Disposal of Plant Assets 150,500 88,600 Income...
Self-Assessment Quiz Financial Statements Income Statement Sell Assessment Quiz Financial Information All values are end of...
Self-Assessment Quiz Financial Statements Income Statement Sell Assessment Quiz Financial Information All values are end of year unless otherwise stated Accounts Payable 12,000 Accounts Receivable 10,000 Accruals 10,000 Accumulated Depreciation 100,000 Beginning of year Inventory 50,000 Beginning of year Retained Earnings 120.000 Cash 7.000 Common Stock 121,500 Cost of Goods Sold 200,000 Current Portion - Long Term Debt 1,500 Depreciation Expense 25,000 Dividends 40,000 Gross Property, plant, and Equipment 400,000 Interest Expense 15,000 Long Term Debt (excluding current portion) 120,000...
Exercise 3 (25 points) Marketing Scenario for a retailer: You sell a particular product line. Given...
Exercise 3 (25 points) Marketing Scenario for a retailer: You sell a particular product line. Given the information below, answer each of the questions asked. You are given the following information (2017 Annual): Price per Unit $25.00 Advertising $15,000 Packaging per unit $ 5.00 Direct Labor per unit $ 8.00 Depreciation $25,000 Royalties per unit $ 2.00 Plant and Equipment Rent $50,000 Total Units Sold 10,000 Your firm's Total Assets are $400,000 with total equity of $75,000 To answer the...
You are given the following information: PeroEmpat Berhad Income Statement For Year Ended 31 December 2017...
You are given the following information: PeroEmpat Berhad Income Statement For Year Ended 31 December 2017 RM 1200 700 500 250 Sales Cost of goods sold Gross profit Operating expenses Earnings Before Interest and Taxes Interest expenses Earnings Before Taxes Taxes (30%) Net income 250 50 200 60 140 From the above information you are required to answer the questions below. a. Compute: i. Operating Profit Margin ii. Net Profit Margin (6 Marks) b. Based on your calculation in part...
In an effort to increase sales, Marvin's Market has decided to increase it 2018 advertising expenses...
In an effort to increase sales, Marvin's Market has decided to increase it 2018 advertising expenses by 20%. According to Marvin's projections, this will lead to a 12% increase in gross revenue, a 10% increase in returns, an 8% increase in cost of goods sold, and 10% increases in overhead expenses and inventory losses. Given these assumptions and Marvin's 2017 profit and loss statement: Marvin's Market Profit and Loss Statement 2017 $550,987 $45,098 $505,889 $307,888 $198,001 Sale Activities Gross Revenue...
Exercise 2 (20 points) APPLICATION 1. The accounting department has rushed the following Income Statement Report to you. As you are about to present the figures, you notice a page is missing, but the information provided contains the following: Net Sales $400.000: Total Goods Available $250.000, Inventory (beginning) $40,000: Variable Expenses, $80,000 and Fored Costs, $60,000. Gross Margin is fifty percent of Net Sales. The boss has asked you for an income Statement showing "All Major summary performance category figures...
Insta Limited Statement of Comprehensive Income For the year ended June 30, 2017 Amount Particulars in Rupees) Sales 843,500 Opening Inventory Purchases Factory Expenses Closing Stock Cost of Goods Sold 55,000 465,000 143,000 (79,500) (583,500) Gross Profit 260,000 Office Expenses Selling Expenses Distribution Expenses Provision for Doubtful Debts Depreciation Interest of Debentures 50,000) (30,000) (20,000) (4,000) (16,000) (14,000) Other Income Gain on disposal of vehicle Interest on Investment 20,000 40,000 Net Profit 186,000 Required: Based on the information given, compute...
In its income statement for the year ended December 31, 2017, Blossom Company reported the following condensed data. Salaries and wages expenses Cost of goods sold Interest expense Interest revenue Depreciation expense $450,000 Loss on disposal of plant assets 1,149,500 Sales revenue 65,000 Income tax expense 145,200 Sales discounts 300,000 Utilities expense $83,000 2,210,000 25,000 120,000 100,000 Your answer is partially correct. Prepare a multiple-step income statement. (List other revenues before other expenses.) BLOSSOM COMPANY Income Statement For the Year...
CRANE COMPANY Income Statement For the Year Ended December 31, 2017 Sales Sales Revenue 2,290,000 Less +: Sales Discounts 170,000 Net Sales 2,120,000 Cost of Goods Sold 1,038,800 Gross Profit 1,081,200 Operating Expenses 460,000 i Salaries and Wages Expense 320,000 i Depreciation Expense 120,000 i Utilities Expense Total Operating Expenses 900,000 Income From Operations 181,200 Other Revenues and Gains Interest Revenue 57,900 Other Expenses and Losses Interest Expense 67,000 83,500 i Loss on Disposal of Plant Assets 150,500 88,600 Income...
Self-Assessment Quiz Financial Statements Income Statement Sell Assessment Quiz Financial Information All values are end of year unless otherwise stated Accounts Payable 12,000 Accounts Receivable 10,000 Accruals 10,000 Accumulated Depreciation 100,000 Beginning of year Inventory 50,000 Beginning of year Retained Earnings 120.000 Cash 7.000 Common Stock 121,500 Cost of Goods Sold 200,000 Current Portion - Long Term Debt 1,500 Depreciation Expense 25,000 Dividends 40,000 Gross Property, plant, and Equipment 400,000 Interest Expense 15,000 Long Term Debt (excluding current portion) 120,000...
Exercise 3 (25 points) Marketing Scenario for a retailer: You sell a particular product line. Given the information below, answer each of the questions asked. You are given the following information (2017 Annual): Price per Unit $25.00 Advertising $15,000 Packaging per unit $ 5.00 Direct Labor per unit $ 8.00 Depreciation $25,000 Royalties per unit $ 2.00 Plant and Equipment Rent $50,000 Total Units Sold 10,000 Your firm's Total Assets are $400,000 with total equity of $75,000 To answer the...
You are given the following information: PeroEmpat Berhad Income Statement For Year Ended 31 December 2017 RM 1200 700 500 250 Sales Cost of goods sold Gross profit Operating expenses Earnings Before Interest and Taxes Interest expenses Earnings Before Taxes Taxes (30%) Net income 250 50 200 60 140 From the above information you are required to answer the questions below. a. Compute: i. Operating Profit Margin ii. Net Profit Margin (6 Marks) b. Based on your calculation in part...
In an effort to increase sales, Marvin's Market has decided to increase it 2018 advertising expenses by 20%. According to Marvin's projections, this will lead to a 12% increase in gross revenue, a 10% increase in returns, an 8% increase in cost of goods sold, and 10% increases in overhead expenses and inventory losses. Given these assumptions and Marvin's 2017 profit and loss statement: Marvin's Market Profit and Loss Statement 2017 $550,987 $45,098 $505,889 $307,888 $198,001 Sale Activities Gross Revenue...
Most questions answered within 3 hours.
-
The free energy change for the following reaction at 25 °C, when
[Sn2+] = 1.17 M...
asked 49 minutes ago -
An MNE is this kind of industry when competition in one country
is essentially independent of...
asked 2 hours ago -
. For this set of questions, determine what
proportion of a normal distribution is located betweeneach...
asked 2 hours ago -
A college student is employed as a door-to-door newspaper
salesman. Historical data suggests that the student...
asked 3 hours ago -
MATLAB HW 11 problem using Switch Case and Input commands
Write a script file that calculates...
asked 3 hours ago -
Considering gravitational time dilation, calculate the time that
passes in Earth’s surface while 1 hour passes...
asked 4 hours ago -
Minitab Problem: Take the Lake Hume June rainfall data and find
use the processes outlined in...
asked 5 hours ago -
X Company is trying to decide whether to continue using old
equipment to make Product A...
asked 5 hours ago -
IN PYTHON ONLY !! Program 2: Re-work
program #5 (WeeklyHours) from the previous assignment such that...
asked 5 hours ago -
The average length of time between arrivals at a turnpike
toll-booth is 26 seconds. What is...
asked 7 hours ago -
(a) A piston at 6.1 atm contains a gas that occupies a volume of
3.5 L....
asked 8 hours ago -
Please answer true or false. Words
cannot be changed or added in to make it true...
asked 8 hours ago