Franklin Products Limited manufactures and distributes a number of products to retailers. One of these products, SuperStick, requires four kilograms of material D236 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter-July, August, and September. Peak sales of SuperStick occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: points a. The finished goods inventory on hand at the end of each month must be equal to 8,200 units plus 20% of the next month's sales. The finished goods inventory on June 30 is budgeted to be 22,240 units. b. The raw materials inventory on hand at the end of each month must be equal to 40% of the following month's production needs for raw materials. The raw materials inventory on June 30 for material D236 is budgeted to be 129,800 kilograms. C. The company maintains no work in process inventories. ( 8 01:59:03 A sales budget for SuperStick for the last six months of the year follows: July August September October November December Budgeted Sales in Units 60,400 75,200 105,400 53,200 30, 200 15,080 Severo S.A. of Sao Paulo, Brazil, is organized into two divisions. The company's contribution format segmented income statement (in terms of the Brazilian currency, the real, R) for last month is given below: Divisions Total Company R4,420,000 2,103,500 10 Sales Variable expenses cloth R 2,600,000 1,110,000 Leather R1,820,000 993,500 points Contribution margin 2,316,500 1,490,000 826,500 8 01:53:46 Traceable fixed expenses: Advertising Selling and administrative Depreciation 708,000 592,000 259,000 450,000 360,000 130,000 258,000 232,000 129,000 Total traceable fixed expenses 1,559,000 940,000 619,000 Divisional segment margin 757,500 R 550,000 R 207,500 Common fixed expenses 405,000 Operating income R 352,500 24 Top management can't understand why the Leather Division has such a low segment margin when its sales are only 30% less than sales in the Cloth Division. As one step in isolating the problem, management has directed that the Leather Division be further segmented into product lines. The following information is available on the product lines in the Leather Division: Leather Division Product Lines 10 points Garments R650,000 Shoes R800,000 Handbags R370,000 8 01:53:39 Sales Traceable fixed expenses: Advertising Selling and administrative Depreciation Variable expenses as a percentage of sales R 70,000 R 45,000 R 34,000 60% R 86,000 R 50,000 R 71,000 50% R102,000 R 69,000 R 24,000 55% Analysis shows that R68,000 of the Leather Division's selling and administrative expenses are common to the product lines. Analysis shows that R68,000 of the Leather Division's selling and administrative expenses are common to the product lines. Required: 1. Prepare a contribution format segmented income statement for the Leather Division, with segments defined as product lines. Product Line 10 points Leather Division Garments Shoes Handbags RO ( 8 01:53:35 Traceable fixed expenses: Total traceable fixed expenses Common fixed expenses: RT 24 2. Management is surprised by the handbag product line's poor showing and would like to have the product line segmented by market. The following information is available about the markets in which the handbag line is sold: Handbag Markets 10 points Domestic R300,000 Foreign R70,000 Sales Traceable fixed expenses: Advertising Variable expenses as a percentage of sales (8 01:53:30 R 55,000 48% R47,000 85% All of the handbag product line's selling and administrative expenses and depreciation are common to the markets in which the product is sold. Prepare a contribution format segmented income statement for the handbag product line with segments defined as markets. Sales Market Domestic Handbags Foreign Traceable fixed expenses: Common fixed expenses: Total common fixed expenses 3. Refer to the statement prepared in (1) above. The sales manager wants to run a special promotional campaign on one of the product lines over the next month. A marketing study indicates that such a campaign would increase sales of the Garments product line by R215,000 or sales of the shoes product line by R160,000. The campaign would cost R30,000. a. Compute the increased operating income for these product lines for the expected increased sales. Shoes Garments Increased operating income RI RI b. Based on the above results, which product line should be chosen? O Shoes O Garments