I'd be grateful if someone could show how to approach this management accounting problem. Thanks in advance.
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Crescent Corporation | ||
Particulars | USD | USD |
Sales | 15,000,000.00 | |
Manufacturing Exp. | ||
Variable | 8,400,000.00 | |
Fixed | 1,400,000.00 | 9,800,000.00 |
Gross Margin | 5,200,000.00 | |
Selling & Administrative Exp. | ||
Commission to agents | 2,850,000.00 | |
Fixed advertising expenses | 400,000.00 | |
Fixed administrative expenses | 1,600,000.00 | 4,850,000.00 |
Net Operating Income | 350,000.00 |
Contribution format income statement | |||
Particulars | USD | ||
Sales | 15,000,000.00 | A | |
Less | Commission to agents | 2,850,000.00 | B |
Net Sales (net of commission) | 12,150,000.00 | C | |
Less | Variable Manufacturing Exp. | 8,400,000.00 | D |
Contribution | 3,750,000.00 | E | |
Less | Fixed costs | ||
Fixed Manufacturing Exp. | 1,400,000.00 | F | |
Fixed advertising expenses | 400,000.00 | G | |
Fixed administrative expenses | 1,600,000.00 | H | |
Net Operating Income | 350,000.00 | I | |
Variable cost to % of sales | 56.00% | J= D/A | |
Contribution to % of sales | 25.00% | K=E/A |
Particulars | USD |
Fixed Manufacturing Exp. | 1,400,000.00 |
Fixed advertising expenses | 400,000.00 |
Fixed administrative expenses | 1,600,000.00 |
Total Fixed cost | 3,400,000.00 |
We know at Break even point Contribution is equal to fixed cost and profit is zero. | |
So contribution needed for breakeven business is $ 3,400,000. | |
Contribution to % of net sales | 25.00% |
So net sales will be contribution/Contribution to % of net sales: | |
Break-even Sales | 13,600,000.00 |
Proof | |
Break-even Sales | 13,600,000.00 |
Commission at 19% | 2,584,000.00 |
Variable Manufacturing Exp. | 7,616,000.00 |
Contribution | 3,400,000.00 |
Total Fixed cost | 3,400,000.00 |
Net Operating Income | - |
Ans to 1 a | 13,600,000.00 |
Particulars | USD |
Fixed Manufacturing Exp. | 1,400,000.00 |
Fixed advertising expenses | 400,000.00 |
Fixed administrative expenses | 1,600,000.00 |
Total Fixed cost | 3,400,000.00 |
We know at Break even point Contribution is equal to fixed cost and profit is zero. | |
So contribution needed for breakeven business is $ 3,400,000. | |
Now here commission increased by 3% so contribution | |
will decrease by 3% as commission has direct impact on contribution. | |
Contribution to % of net sales | 22.00% |
Break-even Sales | 15,454,545.45 |
Proof | |
Break-even Sales | 15,454,545.45 |
Commission at 22% | 3,400,000.00 |
Variable Manufacturing Exp. | 8,654,545.45 |
Contribution | 3,400,000.00 |
Total Fixed cost | 3,400,000.00 |
Net Operating Income | - |
Ans to 1 b | 15,454,545.45 |
Ans to 1 c |
Cost of own sales force | USD |
Annual payroll cost | 350,000.00 |
Travel and entertainment | 200,000.00 |
Sales manager and support staff | 100,000.00 |
Cost of own sales force | 650,000.00 |
Particulars | USD |
Fixed Manufacturing Exp. | 1,400,000.00 |
Fixed advertising expenses | 650,000.00 |
Fixed administrative expenses | 1,600,000.00 |
Cost of own sales force | 650,000.00 |
Total Fixed cost | 4,300,000.00 |
We know at Break even point Contribution is equal to fixed cost and profit is zero. | |
Now here commission is 12% so contribution | |
will increase by 7% as commission has direct impact on contribution. | |
So contribution needed for breakeven business is $ 4,300,000. | |
Contribution to % of net sales | 32.00% |
So net sales will be contribution/Contribution to % of net sales: | |
Break-even Sales | 13,437,500.00 |
Proof | |
Break-even Sales | 13,437,500.00 |
Commission | 1,612,500.00 |
Variable Manufacturing Exp. | 7,525,000.00 |
Contribution | 4,300,000.00 |
Total Fixed cost | 4,300,000.00 |
Net Operating Income | - |
Ans to 1 c | 13,437,500.00 |
Answer 3 | ||
If sales reduced by 10% | ||
Particulars | USD | |
Sales | 13,500,000.00 | This is A*90% |
Commission to agents | 2,565,000.00 | This is sales*19% |
Net Sales (net of commission) | 10,935,000.00 | |
Variable Manufacturing Exp. | 7,560,000.00 | This is D*90% |
Contribution | 3,375,000.00 | |
Fixed costs | ||
Fixed Manufacturing Exp. | 1,400,000.00 | |
Fixed advertising expenses | 400,000.00 | |
Fixed administrative expenses | 1,600,000.00 | |
Net Operating Income | (25,000.00) | |
As net Operating Income is negative so margin of safety is zero. |
Answer 4 | USD |
Operating income when commission was 19% | 350,000.00 |
Total Fixed cost | 4,300,000.00 |
Desired contribution | 4,650,000.00 |
Now here commission is 12% so contribution | |
will increase by 7% as commission has direct impact on contribution. | |
Contribution to % of net sales | 32.00% |
So net sales will be contribution/Contribution to % of net sales: | |
Desired Sales | 14,531,250.00 |
Proof | |
Desired Sales | 14,531,250.00 |
Commission | 1,743,750.00 |
Variable Manufacturing Exp. | 8,137,500.00 |
Contribution | 4,650,000.00 |
Total Fixed cost | 4,300,000.00 |
Net Operating Income | 350,000.00 |
Ans to 4 | 14,531,250.00 |
Ans to 5 | |||
Let Sales value be 100X | |||
Income Statement | 22% Commission | Own Sales Force | |
Sales | 100X | 100X | |
Commission | 22X | 12X | |
Net Sales | 78X | 88X | |
Variable cost | 56X | 56X | 56.00% |
Contribution | 22X | 32X | |
Fixed Cost | 3,400,000.00 | 4,300,000.00 | As per calculation done in Q-1 |
In our case | (22X-3,400,000) is equal to (32X-4,300,000) | ||
By solving for X, we will get USD | 90,000.00 | ||
Breakeven Sales is 100X | 9,000,000.00 | ||
Proof | 22% Commission | Own Sales Force | |
Sales value | 9,000,000.00 | 9,000,000.00 | |
Commission | 1,980,000.00 | 1,080,000.00 | |
Variable Manufacturing Exp. | 5,040,000.00 | 5,040,000.00 | |
Contribution | 1,980,000.00 | 2,880,000.00 | |
Total Fixed cost | 3,400,000.00 | 4,300,000.00 | |
Net Operating Income | (1,420,000.00) | (1,420,000.00) | |
Net Income is same. |
I'd be grateful if someone could show how to approach this management accounting problem. Thanks in...
Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales agents located in the United States and Canada. These sales agents sell a variety of products to hospitals in addition to Marston's disposable thermometer. The sales agents are currently paid an 20% commission on sales, and this commission rate was used when Marston's management prepared the following budgeted absorption income statement for the upcoming year. Marston Corporation Budgeted Income Statement $ 37,000,000 Sales Cost...
Management Accounting I'd be grateful if someone could show how to approach this management accounting problem. Thanks in advance. Gold Nest Company of Hong Kong is a family-owned enterprise that makes souvenirs for the tourist market. The company sells through an extensive network of trading companies that receive commissions on their sales. Transactions occur in Hong Kong dollars ($). The company uses a job-order costing system in which overhead is applied to jobs on the basis of direct labour cost....
Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales agents located in the United States and Canada. These sales agents sell a variety of products to hospitals in addition to Marston's disposable thermometer. The sales agents are currently paid an 18% commission on sales, and this commission rate was used when Marston's management prepared the following budgeted absorption income statement for the upcoming year Marston Corporation Budgeted Income Statement $ 39,000,000 Sales Cost...
I'd be grateful if someone could show how to approach this management accounting problem. Thanks in advance. Soo Office Equipment manufactures and sells metal shelving. It began operations on January 1, 2013. Costs incurred for 2013 are as follows (V stands for variable; F stands for fixed): Direct materials used costs Direct manufacturing labour costs Plant energy costs Indirect manufacturing labour costs Indirect manufacturing labour costs Other indirect manufacturing costs Other indirect manufacturing costs Marketing, distribution, and customer-service costs Marketing,...
I'd be grateful if someone could show how to approach this management accounting problem. Thanks in advance. Linda Nichol is the department heads for the accounting department at a Montreal insurance firm. Linda discovered that there are a number of costs associated with the claims processing. These costs included the salaries of the two paralegals and an accountant; the cost of claims forms, cheques, envelopes, and postage, and depreciation on the office equipment dedicated to alegals' time is spent in...
Management Accounting I'd be grateful if someone could show how to approach this management accounting problem. Thanks in advance. Local Landscaping uses a job-order costing system to track the costs of its landscaping projects. The company provides complete garden design and landscaping services. The following table provides data concerning the three landscaping projects that were in progress during May. There was no work in process at the beginning of May. Designer-hours Direct materials cost Direct labour cost. Williams 200 $4,800...
Management Accounting I'd be grateful if someone could show how to approach this management accounting problem. Thanks in advance. Overhead Apportionment at Timpson Timpson is a UK-based shoe repair and key cutting company, which today is a very large business. It is the UK's leading retail service provider employing over 3,400 colleagues, with 1,325 owned stores and 110 Snappy Snaps franchises throughout the UK and Ireland. Timpson has been established since 1865 and is family owned and run by John...
i need help with 1,2,3, and 4. can you please show me how you arrived at the answers. thanks so much. Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission of 15% for all items sold Barbara Cheney, Pittman's controller, has just prepared the company's budgeted income statement for next...
Management Accounting I'd be grateful if someone could show how to approach this management accounting problem. Thanks in advance. Drew Architectural Design began operations on January 2. The following activity was recorded in the company's Work in Process account for the first month of operations: Work in Process Costs of subcontracted work 90,000 To completed projects 570,000 Direct staff costs 200,000 Studio overhead 320,000 Drew Architectural Design is a service firm, so the names of the accounts it uses are...
Problem 19-06A a-b, c, d (Video) Bramble Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of 20% of sales. The income statement for the year ending December 31, 2020, is as follows. $77,300,000 BRAMBLE BEAUTY CORPORATION Income Statement For the Year Ended December 31, 2020 Sales Cost of goods sold Variable $30,920,000 Fixed 8,760.000 Gross margin Selling and marketing expenses Commissions $15,460,000 Fixed costs 10,000,000 Operating income 39,680,000...