Question

Suzanne had a summer job working in the business office of Blast-It TV and Stereo, a local chain of home electronics stores. When Michael Jacobssen, the owner of the chain, heard she had completed one year of business courses, he asked Suzanne to calculate the profitability of two new large-screen televisions. He plans to offer a special payment plan for the two new models to attract customers to his stores. He wants to heavily promote the more profitable TV.

When Michael gave Suzanne the information about the two TVs, he told her to ignore all taxes when making her calculations. The cost of television A to the company is $1950 and the cost of television B to the company is $2160, after all trade discounts have been applied. The company plans to sell television A for a $500 down payment and $230 per month for 12 months, beginning 1 month from the date of the purchase. The company plans to sell television B for a $100 down payment and $260 per month for 18 months, beginning 1 month from the date of purchase. The monthly payments for both TVs reflect an interest rate of 15.5% compounded monthly.

Michael wants Suzanne to calculate the profit of television A and television B as a percent of the TV’s cost to the company. To calculate profit, Michael deducts overhead (which he calculates as 15% of cost) and the cost of the item from the selling price of the item. When he sells items that are paid for at a later time, he calculates the selling price as the cash value of the item. (Remember that cash value equals the down payment plus the present value of the periodic payments.)

Suzanne realized that she could calculate the profitability of each television by using her knowledge of ordinary annuities. She went to work on her assignment to provide Michael with the information he requested.

Questions:

a. What is the cash value of television A? Round your answer to the nearest dollar.

b. What is the cash value of television B? Round your answer to the nearest dollar.

c. Given Michael’s system of calculations, how much overhead should be assigned to television A?

d. How much overhead should be assigned to television B?

e. According to Michael’s system of calculations, what is the profit of television A as a percent of its cost?

f. What is the profit of television B as a percent of its cost?

g. Which TV should Suzanne recommend be more heavily promoted?

Three months later, due to Blast-It’s successful sales of television A and television B, the suppliers of each model gave the company new volume discounts. For television A, Blast-It received a discount of 9% off its current cost, and for television B one of 6%. The special payment plans for television A and television B will stay the same. Under these new conditions, which TV should Suzanne recommend be more heavily promoted?

Answer 1

Remark	SR No	Descriptions	Explanation	Product A	Product B	Answer
	1	Cost of TV		1950	2160
	2	Down Payment		500	100
	3	EMI		230	260
	4	No Of EMIs		12	18
	5	Interest Rate		15.50%	15.50%
	6	Total Cash inflow		3260	4780
Formula A*	7	EMI value in Cash	Present Value	2574	4206
	8	Total Cash inflow	Present Value	3074	4306
	9	Interest Amount	(6-8)	186	474	Answer to a & b
	10	Contribution	(8-1)	1124	2146	Answer to c & d
	11	Overhead	15% on cost (1)	292.5	324	Answer to e & f
	12	Profit	(10-1)	832	1822	Recomends TV B
Formula A*		EMI = [P x R x (1+R)^N]/[(1+R)^N-1],

After input cost discount @ 9% and 6% on TV A and TV B

Remark	SR No	Descriptions	Explanation	Product A	Product B	Answer
	1	Cost of TV		1774.5	2030.4
	2	Down Payment		500	100
	3	EMI		230	260
	4	No Of EMIs		12	18
	5	Interest Rate		15.50%	15.50%
	6	Total Cash inflow		3260	4780
Formula A*	7	EMI value in Cash	Present Value	2574	4206
	8	Total Cash inflow	Present Value	3074	4306
	9	Interest Amount	(6-8)	186	474	Answer to a & b
	10	Contribution	(8-1)	1300	2275	Answer to c & d
	11	Overhead	15% on cost (1)	266.175	304.56	Answer to e & f
	12	Profit	(10-1)	1034	1971	Recomends TV B
Formula A*		EMI = [P x R x (1+R)^N]/[(1+R)^N-1],