Question
Tennessee Company is geographically segmented into two divisions East and West. The companys income statement for the last month is presented below: Total Company %
Tennessee Company is geographically segmented into two divisions East and West. The companys income statement for the last month is presented below: Total Company % of sales west % of sales East % of sales
Sales $8,500,000 $3,825,000
Variable expenses 3,395,750 1,636,250 1,759,500
Contribution margin $5,104,250 60% $3,038,750 65% $2,065,500 54%
Total Fixed expenses 3,825,000 45% 1912500 41% 1912500 50%
Net income $1,279,250 15% $1,126,250 24% $153,000 4%
Management is concerned with the reported results, especially the East Divisions net income results in relation to the net income results of the West Division. They have asked you to examine the East Division in relation to West Division and further to examine the East Division to determine if any of the three product lines are causing the low level of profitability in that division.
You have been provided the following additional information:
Of the total fixed expenses reported above, management has determined that 30% are traceable the East Division, 55% are traceable to the West Division. The remaining fixed expenses are common to both divisions.
The East provided the following respecting the three product lines:
Product Line
Cola Fruit Drinks Flavoured Water
Sales $1,147,500 $1,721,250 $956,250
Traceable fixed expenses
Administration 103,275 103,275 51,638
Advertising 255,606 139,421 69,711
Depreciation 123,930 154,913 30,983
Variable Expenses 351,900 615,825 791,775
The remaining fixed costs for the East Division are common to all product lines.
Required:
1. Prepare segmented income statements for:
a. total company broken down between the two divisions,
b. the East Division broken down by product line.
Show both amount and percent columns for all information.
2. What observations and recommendations would you make to management based on your analysis? Be sure to integrate your analysis.
QUESTION II LO 7 Cash Budget (12 Marks)
Note to students as this is an open-book assignment (as opposed to a Final exam), students will need to develop the budgets template is not provided.
Cummings Inc., has been accumulating operating data in order to prepare an annual budget. They have determined that a minimum cash balance of $150,000 is required. Any required borrowings take place in increments of $1,000 with annual interest of 8%. Repayment of borrowed funds is also made in increments of $1,000. Assume that borrowings are made on the first day of the month in which the cash is required, and the repayments are made on the last day of a month in which cash is available. On March 1, the cash balance will be $320,000.
Details regarding sales for the first six months of the year are as follows:
January $1,200,000
February 1,300,000
March 1,400,000
April 1,250,000
May 1,440,000
June 1,600,000
Twenty percent (20%) of the above sales are cash sales and 80% are credit sales.
Accounts receivable collection experience is 30% the month of the sale, 40% the month following and 25% the second month following the sale. The remaining receivables are deemed uncollectable for planning purposes.
Budgeted inventory purchases are as follows:
January $480,000
February 520,000
March 560,000
April 500,000
Cummings Inc. pays 50% of their inventory purchases the month of the purchase and 50% the following month.
Budgeted expenses for March and April are as follows:
March April
Advertising 72,000 60,000
Payroll 648,000 518,400
Depreciation 110,000 110,000
Insurance 120,000
Property taxes 80,000
A new truck was required to replace their aging truck. The new truck costing $40,000 was received in March and paid for in cash. They were successful in finding a buyer for their old truck in April and received $15,000 cash.
REQUIRED:
Prepare a cash budget for Cummings Inc. for the months of March and April. Include the calculations that you used to arrive at your entry
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started