Kwaysar Limited sells television satellite dishes Doth to retail outlets and directly to the public. The balance sheet is as follows:

In the second half of the financial year ended May 31, 2010, the business generated a net income of $62,400 and sales of $525,000. It is believed that this level of performance will be repeated in the forthcoming six-month period, provided the business does not implement any changes to its marketing strategy. The business is determined to increase its market share, however, and is considering the adoption of a new marketing strategy that has been developed by the marketing department. The main elements of the new strategy are as follows:
1. The selling price of each satellite dish will be reduced to $90. At present each dish is sold for $120.
2. There will be an increase in the amount of advertising costs incurred by the business. Advertising costs will increase from $6,500 per month to $12,000 per month.
3. Retail outlets will be allowed to pay for satellite dishes three months after delivery. At present, customers are allowed one month's credit. Those retail outlets that continue to pay within one month will, for future sales, be given a 2% discount.
The marketing department believes that, due to the new strategy, sales in each of the first three months to retail outlets will rise to 1,000 units and sales to the public will rise to 300 units. Thereafter, sales each month will be 1,200 units and 400 units respectively.
Assuming the strategy is adopted, the following forecast information is available:
1. The purchase of satellite dishes will be made at the beginning of each month and will be sufficient to meet that month's sales. Each satellite dish costs $50. Suppliers are paid one month after the month of purchase.
2. Depreciation will be charged on buildings at 2% per year on cost and for furniture and fixtures at 15% per year on cost.
3. Motor vehicles costing $80,000 will be acquired and paid for immediately. These are required to implement the new strategy and will be depreciated at 30% per year on cost.
4. Wages will be $18,000 per month and will be paid in the month in which they are incurred.
5. Advertising costs will be paid for in the month incurred.
6. Other overhead costs (excluding costs mentioned above) will be $14,000 per month and will continue to be paid for one month after the month in which they are incurred.
7. The loan of $48,000 will be repaid in July 2010.
8. Sales direct to the public will continue to be paid for in cash. No credit will be allowed.
9. It is estimated that 50% of retail sales will continue to be on one month's credit and 50% will be on three months' credit. Ignore taxation.
Required:
Assuming that the new marketing strategy is adopted:
(a) Prepare a pro forma income statement for the six-month period ended November 30, 2010. (A monthly breakdown of profit is not required.)
(b) Prepare a projected cash budget for the six-month period ended November 30, 2010. (A monthly breakdown of cash flows is not required.)
(c) Comment on the financial results of Kwaysar Limited for the six-month period to November 30, 2010.

Transcribed Image Text:

Kwaysar Limited Balance Sheet as at May 31, 2010 (in $ thousands) Current assets Cash Accounts receivable Inventory Total current assets Property, plant, and equipment Land Buildings Less: Accumulated depreciation Furniture and fixtures Less: Accumulated depreciation Total property, plant, and equipment Total assets Current liabilities Accounts payable Accrued overhead Long-term liabilities Bank loan payable Total liabilities Shareholders' equity Common shares Contributed capital Retained earnings Total shareholders equity Total liabilities and shareholders' equity 120 52 216 75 215 38 275 80 42 328 32 12 92 200 172 452 544