Need all questions Answered please. AJ Ventures Ltd is a company engaged in the
ID: 2791366 • Letter: N
Question
Need all questions Answered please.
AJ Ventures Ltd is a company engaged in the manufacture of water bottles which are bought mainly for sporting activities. Present sales are direct to retailers, but in recent years there has been a steady decline in output because of increasing foreign competition. In the last business year (2017) the company produced its lowest profit in ten (10) years. The forecast for 2018 indicates that the present deterioration in profits is likely to continue.
The company considers that a profit of $80,000 should be achieved to provide an adequate return on capital. The managing director has asked that a review be made of the present pricing and marketing policies. The marketing director has completed this review, and passes the proposals on to you for evaluation and recommendation, together with the Income statement for the year ending December 31, 2017 (see below).
AJ Ventures limited.
INCOME STATEMENT
For the Year Ending, December 31, 2017
Sales Revenue (100,000 Bottles at $10)
$1,000,000
Cost of goods sold
Direct Materials
$100,000
Direct Labour
350,000
Variable Manufacturing overheads
60,000
Fixed Manufacturing overheads
220,000
$730,000
Administrative Overhead
140,000
Selling and Distribution Overhead
Sales commission (2% of sales)
20,000
Delivery cost (variable per unit sold)
50,000
Fixed costs
40,000
110,000
$980,000
Income
$20,000
The information to be submitted to the managing director includes the following three proposals:
(i) To proceed on the basis of analyses of market research studies that indicate that the demand for the bottles is such that a 10% reduction in selling price would increase demand by 40 %.
(ii) To proceed with an enquiry that the marketing director has had from a mail order company about the possibility of purchasing 50,000 bottles annually if the selling price is right. The mail order company would transport the bottles from AJ ventures to its own warehouse, and no sales commission would be paid on these sales by AJ ventures. However, if an acceptable price can be negotiated, AJ ventures would be expected to contribute $60,000 per annum towards the cost of producing the mail order catalogue. It would also be necessary for AJ ventures to provide special additional packaging at a cost of $0.50 per bottle. The marketing director considers that in 2016 the sales from existing business would remain unchanged at 100,000 bottles, based on a selling price of $10 if the mail order contract is undertaken.
(iii) To proceed on the basis of a view held by the marketing director that a 10% price reduction, together with a national advertising campaign costing $30,000, may increase sales to the maximum capacity of 160,000 bottles.
Required
a. The calculation of break-even sales value based on the 2017 results.
(1 Marks)
b. A financial evaluation of proposal (i)
(3 Marks)
c. A calculation (under proposal (i)) of the number of bottles AJ ventures would need to sell at $9 each to earn the target profit of $80.000.
(2 Marks)
d. A calculation of the minimum prices that would have to be quoted to the mail order company to
1. I. ensure that AJ ventures would at least break even on the mail order contract
(2 Marks)
1. II. ensure that the same overall profit is earned as in proposal (i) from the mail order contract.
(2 Marks)
1. III. Ensure that the overall target profit is earned, from the mail order contract.
(2 Marks)
e. A financial evaluation of proposal (iii)
(3 Marks)
Sales Revenue (100,000 Bottles at $10)
$1,000,000
Cost of goods sold
Direct Materials
$100,000
Direct Labour
350,000
Variable Manufacturing overheads
60,000
Fixed Manufacturing overheads
220,000
$730,000
Administrative Overhead
140,000
Selling and Distribution Overhead
Sales commission (2% of sales)
20,000
Delivery cost (variable per unit sold)
50,000
Fixed costs
40,000
110,000
$980,000
Income
$20,000
Explanation / Answer
a. Total Variable Cost = $ ( 100,000 + 350,000 + 60,000 + 20,000 + 50,000) = $ 580,000
Contribution Margin Ratio = $ ( 1,000,000 - 580,000) / $ 1,000,000 * 100 = 42 %
Break-even sales value ( as per 2017 results) = Total Fixed Cost / Contribution Margin Ratio = $ (220,000 + 140,000 + 40,000) / 0.42 = $ 952,380.95 or $ 952,381
b. Financial Evaluation of Proposal ( i):
c. Variable cost per unit under proposal (i) = $ 809,200 / 140,000 = $ 5.78.
Contribution margin per unit = $ 9.00 - $ 5.78 = $ 3.22
Number of bottles needed to be sold to earn the target profit of $ 80,000 = $ ( 400,000 + 80,000) / $ 3.22 = 149,068.32 bottles.
d. i. Total variable cost per unit on the mail order contract:
There is a fixed cost of $ 60,000 per annum for the mail order contract.
Let the contribution margin per unit be C.
At break-even , 50,000 C = $ 60,000
C = $ 60,000 / 50,000 = $ 1.20
Minimum selling price = Unit Variable Cost + Unit Contribution Margin = $ 5.60 + $ 1.20 = $ 6.80
ii. To ensure that a profit of $ 20,000 is earned from the mail order contract,
Unit contribution margin = $ ( 60,000 + 20,000) / 50,000 = $ 1.60
Minimum selling price = $ 5.60 + $ 1.60 = $ 7.20
iii. To ensure that the overall target profit is earned, the mail order contract has to give a profit of $ 60,000.
Therefore, minimum selling price = $ ( 60,000 + 60,000) / 50,000 + $ 5.60 = $ 8.00
e. A financial evaluation of proposal (iii):
$ Sales ( 140,000 units at $ 9 per unit) 1,260,000 Variable Cost Direct Materials 140,000 Direct Labor 490,000 Variable Manufacturing Overhead 84,000 Sales Commission 25,200 Delivery Cost 70,000 809,200 Contribution Margin 450,800 Less: Total Fixed Cost 400,000 Income from Operations $ 50,800Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.