This essay has been submitted by a student. This is not an example of the work written by professional essay writers.
Uncategorized

Gale Force Surfing

Pssst… we can write an original essay just for you.

Any subject. Any type of essay. We’ll even meet a 3-hour deadline.

GET YOUR PRICE

writers online

 

 

 

 

 

 

 

 

 

 

 

Gale Force Surfing

 

 

 

During mid-September 2015, the top managers of the Gale Force Corporation, a leading manufacturer of windsurfing equipment and surfboards, 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 margin, 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 Baggit, 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. Look here, 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 margin ratio would have been 4.01 percent, which is higher than 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 to deplete when sales pick up. That fluctuating inventory causes all sorts of problems, including the excessive amount of borrowing we have to do to finance the inventory accumulation.” (See Tables 1 through 5 for details of Gale Force’s current operations based on equal monthly production.)

 

Table 1Sales Forecast (in units)
First QuarterSecond QuarterThird QuarterFourth Quarter
October 2014…… 150January………………….   0April…………………….  500July……………………. 1,000
November………..  75February………………..   0May…………………….. 1,000August…………………  500
December…………  25March…………………… 300June…………………….. 1,000September…………….  250

 

Table 2Production Schedule and Inventory (equal monthly production)
 Beginning

Inventory

Production

This

Month

SalesEnd

Inventory

Inventory

($2,000

per unit)

October 2014……………………………………………………………………………………..400+          400–           150=          650$1,300,000
November………………………………………………………………………………………….650400759751,950,000
December…………………………………………………………………………………………..975400251,3502,700,000
January………………………………………………………………………………………………1,35040001,7503,500,000
February…………………………………………………………………………………………….1,75040002,1504,300,000
March………………………………………………………………………………………………..2,1504003002,2504,500,000
April………………………………………………………………………………………………….2,2504005002,1504,300,000
May…………………………………………………………………………………………………..2,1504001,0001,5503,100,000
June…………………………………………………………………………………………………..1,5504001,0009501,900,000
July…………………………………………………………………………………………………..9504001,000350700,000
August………………………………………………………………………………………………350400500250500,000
September………………………………………………………………………………………….250400250400800,000

 

Table 3

Sales Forecast, Cash Receipts and Payments, and Cash Budget

 October

2014

NovemberDecemberJanuaryFebruaryMarch

Sales Forecast

Sales (units)……………………………………………………………………………………..150752500300
Sales (unit price: $3,000)……………………………………………………………………$  450,000$  225,000$   75,00000$  900,000
Cash Receipts Schedule
50% cash…………………………………………………………………………………………$  225,000$  112,500$   37,500$  450,000
50% from prior month’s sales*…………………………………………………………..$  375,000$  225,000$  112,500$   37,500          0          0
   Total cash receipts……………………………………………………………………….$  600,000$  337,500$  150,000$   37,5000$  450,000

Cash Payments Schedule

Production in units…………………………………………………………………………….400400400400400400
Production costs (each = $2,000)…………………………………………………………$  800,000$  800,000$  800,000$  800,000$  800,000$  800,000
Overhead…………………………………………………………………………………………$  200,000$  200,000$  200,000$  200,000$  200,000$  200,000
Dividends and interest……………………………………………………………………….000000
Taxes………………………………………………………………………………………………$  150,000         0         0$  150,000         0         0
   Total cash payments…………………………………………………………………….$1,150,000$ 1,000,000$ 1,000,000$ 1,150,000$ 1,000,000$ 1,000,000

Cash Budget; Required Minimum Balance is $125,000

Cash flow…………………………………………………………………………………………$ –550,000–662,500–850,000–1,112,500–1,000,000–550,000
Beginning cash………………………………………………………………………………….   125,000   125,000   125,000   125,000   125,000   125,000
Cumulative cash balance…………………………………………………………………….–425,000–537,500–725,000–987,500–875,000–425,000
Monthly loan or (repayment)………………………………………………………………$  550,000$  662,500$  850,000$1,112,500$1,000,000$  550,000
Cumulative loan………………………………………………………………………………..$  550,000$ 1,212,500$ 2,062,500$3,175,000$4,175,000$4,725,000
Ending cash balance…………………………………………………………………………..$  125,000$  125,000$  125,000$ 125,000$ 125,000$  125,000
*September sales assumed to be $750,000.

“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 other issues Pop is concerned about and then make a decision on which alternative is better for the firm.”

 

Table 3

(continued)

 AprilMayJuneJulyAugustSeptember

Sales Forecast

Sales (units)……………………………………………………………………………………..5001,0001,0001,000500250
Sales (unit price: $3,000)……………………………………………………………………$1,500,000$3,000,000$3,000,000$3,000,000$1,500,000$  750,000
Cash Receipts Schedule
50% cash…………………………………………………………………………………………$  750,000$1,500,000$1,500,000$1,500,000$  750,000$  375,000
50% from prior month’s sales…………………………………………………………….$  450,000$  750,000$1,500,000$1,500,000$1,500,000$  750,000
   Total cash receipts……………………………………………………………………….$1,200,000$2,250,000$3,000,000$3,000,000$2,250,000$ 1,125,000

Cash Payments Schedule

Production in units…………………………………………………………………………….400400400400400400
Production costs (each = $2,000)…………………………………………………………$  800,000$  800,000$  800,000$  800,000$  800,000$  800,000
Overhead…………………………………………………………………………………………$  200,000$  200,000$  200,000$  200,000$  200,000$  200,000
Dividends and interest……………………………………………………………………….0000$1,000,0000
Taxes………………………………………………………………………………………………$  150,000        0        0$  300,000        0        0
   Total cash payments…………………………………………………………………….$1,150,000$1,000,000$1,000,000$1,300,000$2,000,000$1,000,000

Cash Budget; Required Minimum Balance is $125,000

Cash flow…………………………………………………………………………………………50,0001,250,0002,000,0001,700,000250,000125,000
Beginning cash………………………………………………………………………………….   125,000   125,000   125,000   125,000   400,000   650,000
Cumulative cash balance…………………………………………………………………….175,0001,375,0002,125,0001,825,000650,000775,000
 Monthly loan or (repayment)…………………………………………………………………($  50,000)($1,250,000)($2,000,000)($1,425,000)00
Cumulative loan………………………………………………………………………………..$4,675,000$3,425,000$1,425,000000
Ending cash balance…………………………………………………………………………..$  125,000$  125,000$  125,000$  400,000$  650,000$  775,000

 

 

 

 

Table 4

Total Current Assets

First Year

CashAccounts

Receivable*

InventoryTotal

Current

Assets

October……………………………………………………………………………………………..$125,000+      $225,000+   $1,300,000=   $1,650,000
November………………………………………………………………………………………….125,000112,5001,950,0002,187,500
December…………………………………………………………………………………………..125,00037,5002,700,0002,862,500
January………………………………………………………………………………………………125,00003,500,0003,625,000
February…………………………………………………………………………………………….125,00004,300,0004,425,000
March………………………………………………………………………………………………..125,000450,0004,500,0005,075,000
April………………………………………………………………………………………………….125,000750,0004,300,0005,175,000
May…………………………………………………………………………………………………..125,0001,500,0003,100,0004,725,000
June…………………………………………………………………………………………………..125,0001,500,0001,900,0003,525,000
July…………………………………………………………………………………………………..400,0001,500,000700,0002,600,000
August………………………………………………………………………………………………650,000750,000500,0001,900,000
September………………………………………………………………………………………….775,000375,000800,0001,950,000
* Equals 50 percent of monthly sales

 

Table 5
Cumulative loan balance and interest expense (1% per month)
OctoberNovemberDecemberJanuaryFebruaryMarch
Cumulative loan balance……………………………………………$550,000$1,212,500$2,062,500$3,175,000$4,175,000$4,725,000
Interest expense at

(prime, 8.0%, + 4.0%) 12.00%…………………………………..

$5,500$12,125$20,625$31,750$41,750$47,250
 AprilMayJuneJulyAugustSeptember
Cumulative loan balance……………………………………………$4,675,000$3,425,000$1,425,000000
Interest expense at

(prime, 8.0%, + 4.0%) 12.00%…………………………………..

$46,750$34,250$14,250000
Total interest expense for the year: $254,250

 

Required

1.      Tables 1 through 5 contain the financial information describing the effects of level production on inventory, cash flow, loan balances, and interest expense. Reproduce these tables if Tim’s suggestion were implemented; that is, change the Production This Month column in Table 2 from 400 each month to 150, 75, 25, and so on, to match Sales in the next column. Then recompute the remainder of Table 2, and Tables 3, 4, and 5 based on the new production numbers. Beginning inventory is still 400 units. Beginning cash is still $125,000 and that remains the minimum required balance.

2.      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?

3.      Up until now, we have not considered any inefficiencies that have been introduced as a result of going from level to seasonal production. Assume that there is an added expense for each sales dollar of .5 percent (.005). Based on this fact and the information computed in question 2, is seasonal production justified?

 

  Remember! This is just a sample.

Save time and get your custom paper from our expert writers

 Get started in just 3 minutes
 Sit back relax and leave the writing to us
 Sources and citations are provided
 100% Plagiarism free
error: Content is protected !!
×
Hi, my name is Jenn 👋

In case you can’t find a sample example, our professional writers are ready to help you with writing your own paper. All you need to do is fill out a short form and submit an order

Check Out the Form
Need Help?
Dont be shy to ask