Question

In: Accounting

QUESTION 4 (20) The following budgeted details for 2020 relate to a product manufactured by Kito...

QUESTION 4 (20)

The following budgeted details for 2020 relate to a product manufactured by Kito Limited:

Sales R50 000 Variable cost per unit sold R7.50 Total fixed cost R12 500 Sales volume 2 500 units Consider the following situations independently:

4.1 Calculate the operating profit. (3)

4.2 Suppose sales increase by R10 000 without changes to any costs. By what amount will contribution margin and operating profit increase? (2)

4.3 Suppose fixed costs increase by R3 000. By how much must sales increase if operating profit was to remain unchanged? (2)

4.4 Would you recommend an advertising programme costing R5 000 that would generate an additional R10 000 of sales? Why? (2)

4.5 Calculate the volume of sales required to achieve an operating profit of R20 000. (3)   

Consider the following situations independently and in each case motivate your answer by doing the relevant calculations:

4.6 Should management consider a drop of R2 per unit in the selling price if sales volume is expected to increase by 200 units? (4)

4.7 Should management adopt the following proposal? Decrease the selling price by R4 and increase marketing costs by R8 000 with the expectation of an increase in sales to 5 000 units. (4)

Solutions

Expert Solution

Here sales = R 50000 and units sold are 2500 units , thus sales price per unit = 50000/2500 = R 20.  

Variable cost per unit = R 7.5 ,thus variable cost = 2500 * 7.5 = R 18750 , fixed cost given = R 12500

Here contribution per unit = Selling price per unit - variable cost per unit = 20 - 7.5 = 12.5

Contribution margin ratio = Contribution margin per unit / sales price per unit = 12.5 / 20 = 62.50%.

Based on the above information the solution will be as follows:

4.1 Operating Profit :  

Particluars Amount
Sales R 50000
Less: Variable Cost 18750
Contribution margin 31250
Less: Fixed cost 12500
Operating Profit R 18750

Operating Profit = R 18750.

4.2   sales increase by R10 000 without changes to any costs. here it is assumed that even variable costs are not increased, as sales in increased due to selling price.. However an alternate solutio is also given for better understanding.

Particluars Amount
Sales R 60000
Less: Variable Cost 18750
Contribution margin 41250
Less: Fixed cost 12500
Operating Profit R 28750

The contributiion margin will become = 41250 i.e an increase by 10000 and Operating profit will become R 28750  increase by R 10000.

However if the variable cost also increases in proportion to the sales , then the contribution margin would be = R 37500 i.e an increase of R 6250. and operating profit will also incraese by R 6250.

.

4.3 fixed costs increase by R3 000. By how much must sales increase if operating profit was to remain unchanged?

operating profit in original case = R 18750 , and Fixed cost increse by R 3000 so fixed cost = 12500 + 3000 = R15500

Desired Sales = ( Desired profit + Fixed cost ) / contribution margin ratio

Desired sales = ( 18750 + 15500 ) / 62.50% = 34250 / 62.50% = R 54800 .

So increase of sales = Desired sales  - Existing sales = 54800 - 50000 = 4800.

sales must increase by R 4800.

4.4 Would you recommend an advertising programme costing R5 000 that would generate an additional R10 000 of sales? Why?

The sales increase by 10000 and fixed cost be 5000 the effect will be as follows:

Particluars Amount
Sales R 60000
Less: Variable Cost 22500
Contribution margin 37500
Less: Fixed cost 17500
Operating Profit R 20000

The Operating profit is Increasing by R 1250, so it is recommended for an advertisig programming, because it will generate an additinal operating profit.

4.5 Calculate the volume of sales required to achieve an operating profit of R20 000

Desired sales =( Target profit + Fixed cost ) / contribution margin ratio

Desired sales = ( R20000 + R12500) / 62.50% = R 32500/62.50%

Thus volume of sales required to achieve an operating profit of R20 000 = R 52000

4.6 Should management consider a drop of R2 per unit in the selling price if sales volume is expected to increase by 200 units

if management drops R 2 per unit the selling price = R 18 , and impact is as follows:

Particluars Amount
Sales 48600
Less: Variable Cost 20250
Contribution margin 28350
Less: Fixed cost 12500
Operating Profit 15850

If the selling price is dropped there is a reduction in operaating profit by R 2900, so it is not recommended.

Should management consider a drop of R2 per unit in the selling price if sales volume is expected to increase by 200 units - No.

4.7 Should management adopt the following proposal? Decrease the selling price by R4 and increase marketing costs by R8 000 with the expectation of an increase in sales to 5 000 units.

The impact will be as follows:

Particluars Amount
Sales R 80000
Less: Variable Cost 37500
Contribution margin 42500
Less: Fixed cost 20500
Operating Profit R 22000

Yes the management should adopt the proposal as the operating profiit is increased by R 3250 than existing,


Related Solutions

A company that manufactures a single product supplied the following budgeted details: Budgeted production and factory...
A company that manufactures a single product supplied the following budgeted details: Budgeted production and factory overheads costs were 4 000 units and N$80 000, respectively. selling price per unit is N$150, variable cost per unit: Direct material N$30, Direct labour N$ 40, Variable overheads N$20, fixed overheads per month N$60 000. During the past month 3000 units were manufactured while only 600 units were on hand. The profit for the month according to the absorption costing method was:
PDR Co. manufactures 4 products using the same machinery. The following details relate to its 4...
PDR Co. manufactures 4 products using the same machinery. The following details relate to its 4 products. Product A Product B Product C Product D $ per unit $ per unit $ per unit $ per unit Selling price 28 30 45 42 Direct material 5 6 8 6 Direct labor 4 4 8 8 Variable overhead 3 3 6 6 Fixed overhead * 8 8 16 16 Profit 8 9 7 6 Labour hrs.per unit 1 1 2 2...
The following details are for questions 16–20. Each individual question will appear below the details. Caterpillar...
The following details are for questions 16–20. Each individual question will appear below the details. Caterpillar Inc (CAT) has the following excerpts from their financial statements: CAT Financial Statements Item December 31, 2016 December 31, 2015 December 31, 2014 Inventory (in $ Millions) 9,615 9,700 12,205 Net Income (in $ Millions) (67) 2,512 2,452 Inventories are stated at the lower of cost or market. Cost is principally determined using the last-in, first-out (LIFO) method. The value of inventories on the...
ABC Inc. produces a single product and manufactured 20,000 units last year. The company budgeted the...
ABC Inc. produces a single product and manufactured 20,000 units last year. The company budgeted the following overhead costs for the year: Indirect Factory Wages:$100,000Factory Utilities:$ 40,000Factory Depreciation:$ 60,000 Direct manufacturing costs per unit are $50. The company uses an activity-based costing system which compiles costs into 3 cost pools, machining, milling and assembly. The costs allocated to these activity cost pools break down as follows: Usage: Cost:MachiningMillingAssemblyIndirect Factory Wages:50%30%20%Factory Utilities:40%40%20%Factory Depreciation:10%90%0% The following cost drivers are used for each...
QUESTION ONE The following information relates to the only product manufactured and sold by Namwela limited....
QUESTION ONE The following information relates to the only product manufactured and sold by Namwela limited. K per Unit Selling price 50 Direct Material cost 14 Direct labour cost 16 Variable production overhead 10 Fixed production overhead 1.80 Variable sales and marketing overhead 1.00 The following level of activity took place over the first two years of the product’s life: Sales ( units) production ( units) Year 1 13,000 14,000 Year 2 12,500 11,500 ADDITIONAL INFORMATION 1. Budgeted fixed production...
Question 2: Budget (20 marks in total) Lulu Company has the following budgeted sales for the...
Question 2: Budget (20 marks in total) Lulu Company has the following budgeted sales for the next six-month period: Month Unit Sales January 48,000 February 84,000 March 60,000 April 72,000 May 48,000 June 80,000 There were 69,000 units of finished goods in inventory at the beginning of January. Plans are to have an inventory of finished products that equals 100% of the following month sales plus 25% of the second month sales. Two kilograms of raw materials are required for...
A manufactured product has the following information for June.
A manufactured product has the following information for June.StandardActualDirect materials(6 lbs. @ $8 per lb.)48,500lbs. @ $8.10 per lb.Direct labor(2 hrs. @ $16 per hr.)15,700hrs. @ $16.50 per hr.Overhead(2 hrs. @ $12 per hr.)$198,000Units manufactured8,0001. Compute the standard cost per unit.2. Compute the total cost variance for June. Indicate whether the cost variance is favorable or unfavorable.
A manufactured product has the following information for June.
[The following information applies to the questions displayed below.]A manufactured product has the following information for June.StandardActualDirect materials6 lbs. @ $7 per lb.49,000lbs. @ $7.20 per lb.Direct labor3 hrs. @ $16 per hr.24,000hrs. @ $16.50 per hr.Overhead3 hrs. @ $12 per hr.$298,000Units manufactured8,100(1) Compute the standard cost per unit.(2) Compute the total cost variance for June.
Part B The following details are for questions 16–20. Each individual question will appear below the...
Part B The following details are for questions 16–20. Each individual question will appear below the details. Caterpillar Inc (CAT) has the following excerpts from their financial statements: Interest Period December 31, 2016 December 31, 2015 December 31, 2014 Inventory (in $ Millions) 9,615 9,700 12,205 Net Income (in $ Millions) (67) 2,512 2,452 Inventories are stated at the lower of cost or market. Cost is principally determined using the last-in, first-out (LIFO) method. The value of inventories on the...
The following data relate to a manufacturing department for a period: Budgeted data for the coming...
The following data relate to a manufacturing department for a period: Budgeted data for the coming year are as follows: Direct labour hours 60,000 hours Direct labour cost $110,000 Direct material cost $125,000 Production overhead $70,400 Actual data for the period are as follows: Direct labour hours 55,500 hours Direct labour cost $125,000 Direct material cost $150,000 Production overhead $67,800 Required: (7A) Calculate the production overhead absorption rate predetermined for the period based on : Percentage of direct material cost;...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT