HELP!

Gale Force Corporation During mid October 20XX, the top managers of the Gale Force Corporation, a leading manufacturer of kite-surfing equipment, were gathered in the president's conference room reviewing the results of the company's operations during the past fiscal year (which runs from October 1 to September 30 ). "Not a bad year, on the whole," remarked the president, 32 year old Charles (Chuck) Jamison. "Sales were up, profits were up, and our return on equity was a respectable 15 percent. In fact," he continued, "the only dark spot I can find in our whole annual report is the profit on sales ratio, which is only 2.25 percent. Seems like we ought to be making more than that, don't you think, Tim?" He looked across the table at the vice president for finance, Timothy Baggitt, age 28. "I agree," replied Tim, "and I'm glad you brought it up, because I have a suggestion on how to improve that situation." He leaned forward in his chair as he realized he had captured the interest of the others. "The problem is, we have too many expenses on our income statement that are eating up the profits. Now I've done some checking, and the expenses all seem to be legitimate except for interest expense. We paid over $250,000 last year to the bank just to finance our short term borrowing. If we could have kept that money instead, our profit on sales ratio would have been 4.01 percent, which is higher than that of any other firm in the industry." "But, Tim, we have to borrow like that," responded Roy ("Pop") Thomas, age 35, the vice president for production. "After all, our sales are seasonal, with almost all occurring between March and September. Since we don't have much money coming in from October to February, we have to borrow to keep the production line going." "Right," Tim replied, "and it's the production line that's the problem. We produce the same number of products every month, no matter what we expect sales to be. This causes inventory to build up when sales are slow and begin to deplete when sales pick up. That fluctuating inventory causes all sorts of problems, not the least of which is the excessive amount of borrowing we have to do to finance the inventory accumulation." (See 4 Tables 1 through 5 for details of Gale Force's current operations based on equal monthly production.) Page210 Table 1, Part 1 Sales forecast, cash recelpts and payments, and cash budget "Note: September sales assumed to be $750,000. Table 2 Sales forecast (in units) Table 3 Production schedule and inventory (equal monthly production) Table 4 Total current assets, first year "Equals 50 percent of monthly sales. Table 5 Cumulative loan balance and interest expense ( 1% per month) "Now, here's my idea," said Tim. "Instead of producing 400 items a month, every month, we match the production schedule with the sales forecast. For example, if we expect to sell 150 windsurfers in October, then we only make 150. That way we avoid borrowing to make the 250 more that we don't expect to sell, anyway. Over the course of an entire year, the savings in interest expense could really add up." "Hold on, now," Pop responded, feeling that his territory was being threatened. "That kind of scheduling really fouls up things in the shop where it counts. It causes a feast or famine environment-nothing to do for one month, then a deluge the next. It's terrible for the employees, not to mention the supervisors who are trying to run an efficient operation. Your idea may make the income statements look good for now, but the whole company will suffer in the long run." Chuck intervened. "OK, you guys, calm down. Tim may have a good idea or he may not, but at least it's worth looking into. I propose that you all work up two sets of figures, one assuming level production and one matching production with sales. We'll look at them both and see if Tim's idea really does produce better results. If it does, we'll check it further against the other issues Pop is concerned about and then make a decision on which alternative is better for the firm." a. Tables 1 through 45 contain the financial information describing the effects of level production on inventory, cash flow, loan balances, and interest expense. Reproduce these tables as if Tim's suggestion were implemented; that is, change the "Production This Month" column in [ Table 3 from 400 each month to 150,75,25, and so on, to match "Sales" in the next column. Then, inventory is still 400 units. Beginning cash is still $125,000 and that remains the minimum required balance. b. Given that Gale Force is charged 12 percent annual interest (1 percent a month) on its cumulative loan balance each month ( (. Table 5), how much would Tim's suggestion save in interest expense in a year? c. Until now we have not considered any inefficiencies that have been introduced as a result of going from level to seasonal production. Assume there is an added expense for each sales dollar of 0.5 percent ( 0.005). On the basis of this fact and the information computed in part b, is seasonal production justified? Additional Information: As a result of changing to matching production, the employees will have minimal hours in November and December. The employees will be laid off during January and February. When production restarts in March, many previous employees will have found other jobs with more full-time permanent hours. Due to delays in hiring new production staff and slowing down due to training and turnaround, production for March to July could be reduced by 25%. The demand was still there, so the sales will remain the same when possible. As a result of the change to matching sales production, there could be an increase of 10% on production costs for the whole year due to inefficiencies in production. Gale Force is concerned that they have not considered all of the factors or possible solutions to decreasing their interest expense and increasing their Net Income. Gale Force has hired your accounting firm to provide them with some analysis and recommendations. Upon receiving their forecasts using level production, you have clarified the following information: - Tax payments on the cash payments schedule relate to payments being made to last-year income tax expense (so paying down an income tax payable account). - The current Tax rate is 30% - The line Dividends & Interest relate to a Dividend payment only. Students in groups will create a video presentation that will include: - Introduction - An Income statement comparing - Original level production - Matching sales production - Worst case scenario ( 25% reduction and 10% increase in production) - Provide two alternatives that could decrease interest costs without changing production to matching sales. - Include projected Income statement numbers - Include the risks associated with each alternative. - Provide a recommendation