Essay About Mr. Homer Simpson And Increase Sales

Homers Dilemma
HOMER’S DILEMMASIMPSONS LTD. is a private company owned by Mr. Homer Simpson which specialized in producing machined Persian Carpets. The carpets had good demand in the market but over the years the number of competitors had increased, increasing the efforts required to market the carpets. Homer had only one dream and he knew the time to live it was arriving soon. The demand for Persian carpets was expected to peak out within next three years. Homer had decided to leave Simpsons Ltd. at the end of three years and go off to the Hawaiian Islands to spend his remaining life schooning, boozing and sleeping. He had decide to sell Simpsons Ltd. and use the proceeds to sustain his Hawaiian life style. Homer wanted highest price for his business if he sold it at the end of three years. In order to achieve this target he had approached his banker who advised him the following for the next three years:To increase sales at a growth rate of 25% per anum for the next three years.The current plant capacity will reach 100% once the sales are increased by 25% in the next year.To support further sales he has two options:He intends to support further production required in the later two years through outsourcing. The additional carpets will be procured at 80% of the expected sale price. He intends to support further production by setting up additional plant and machinery of Rs.1000000/- in two equal stages in the year 2013 and 2014. This additional capacity will be enough to continue production for next 5 years wherein the total capacity will again reach its peak.Marketing expenses will increase from 5% to 8% of sales.Homer was also advised to achieve the following:To reduce average collection period from 36 days to 24 days.To reduce days of inventory holding from 36 days to 30 days.To reduce cash levels from 5% of sales to 2%. To increase average payment period from 36 days to 48 days.To achieve the above levels of sales Homer intends to maintain the prices for next three years. As Simpsons is achieving economies of scale the raw material costs will increase at same rate per anum even though prices are maintained constant.Other Important Information:Depreciation is WDV method at 10%.Bank borrowings are short-term borrowings and are related to sales.In case of sale the land will be sold at at-least 3 times its book-value.The expected growth rate once the demand has peaked up is a stable growth of 5%.The expected cost of financing for the investor will be 10%.Secured loan is repaid by Rs.100000 every year till feasible (i.e. retained earnings are able to replenish it).Investments generate a return of 10% which is reinvested in the same securities unless needed otherwise. Net capex and additional working capital are financed through investments. At the same time additional revenue/ retained earnings are invested in the investments. Which option should Homer agree for?   Income StatementYear20082009201020112012Sales (Units)700850100011501300Price20002200240026002800Total Sales14000001870000240000029900003640000LessCOGS7700001028500132000016445002002000=Gross Profit630000841500108000013455001638000AddCommission100000105000115000125000135000AddInterest Income346504900059372.579638.6107538.3=Total Revenue764650995500125437315501391880538Labor Costs105000127500150000172500195000Marketing Costs7000093500120000149500182000Admin & General Expenses5000050000500005000050000R&D Costs0100000000LessTotal Operating Expenses225000371000320000372000427000=Operating Profit539650624500934372.511781391453538LessDepreciation111111100000900008100072900=PBIT428539524500844372.510971391380638LessInterest114950107000993509200084950=PBT313589417500745022.510051391295688LessTax @ 30%94077125250223506.8301541.6388706.5=PAT219512292250521516703597906982LessDividend Payout @ 50%109756146125260758351799453491Transfer to Reserves109756146125260758351799453491Balance Sheet20082009201020112012Account Receivables140000187000240000299000364000Inventory77000102850132000164450200200Cash7000093500120000149500182000Total CA287000383350492000612950746200Land10000001000000100000010000001000000Plant & Machinery1000000900000810000729000656100Investments49000059372579638610753831442271Total Assets27770002877075309838634173333844571Bank Borrowings7000093500120000149500182000Account Payables77000102850132000164450200200Accrued Expenses2250027100320003720042700Total CL169500223450284000351150424900Secured Loan1000000900000800000700000600000Paid up Share Capital500000500000500000500000500000Reserves and Surplus11075001253625151438318661812319672Total Liabilities27770002877075309838634173333844571