Lyric Dinner Theatre Case Study Solution
Ratio Analysis
The ratio analysis in the appendic-3 further clarifies the Lyric Dinner Theaters’ financial position.
A.Gross Profit Margin
The gross profit margin has increased substantially in the year to date indicating that the business is now making enough profits after deducting the cost of sales to pay-off its expenses which is a good sign. Increasing gross profits depicts that the customers are increasing which increases the sales of the business.
B.Operating Profit and Net Profit Margin:
The operating profit margin and the net profit margin is almost same in both years. Operating profit margin is 2% indicating that after deducting the expenses only 2% of gross profit remains. This percentage should increase with the passage of time as having less operating profit means that profit for the investors is very low. The increasing expenses are taking all the profits and there is not much left for the investors and owners. Although the operating and net profit is low still it is better than 2009 as in 2009 it was operating loss and net profit loss not even profit. So it is increasing with the passage of time.
Note: The balance sheet of 2010 was not given that is why the further ratio analysis is of year 2008 and 2009.
C.Current and Quick Ratio:
The current and quick ratio of the business in both the years was very low indicating that the business is unable to pay off its current liabilities and the suppliers are not in good terms with the business that means business liquidity position was at risk
D.Cash Operating Cycle:
The liquidity position of the business can further analyzed through the receivable, payable and inventory days (i.e. cash operating cycle of the business) which is unfavorable in every possible way for the business and thus it can be concluded that the liquidity position of the business was worst also justifying the fact the owners was thinking to shut it down.
Recommendations
The company is recommended to bring change by using Kotter’s 8-step Change Model. Firstly, Rivka Belzer need to create a sense of urgency within the staff as the staff have low morale and confidence about the business. Thus a sense of urgency through staff meeting or motivational speech will work for the change. Secondly, form a powerful coalition among the staff and the board member that the change is necessary and lead them so that they gain their confidence. Thirdly, create a vision for a change that the staff and the team members can grasp easily. Also communicate that vision to the team members and staff so that their concerns may be resolved on the spot. Then while working on the vision, remove any obstacles that comes in a way of fulfilling the overall objective. Further, create short term wins so that the already demoralized staff of Lyric Dinner Theaters will not be aggressive about any changes and try to work hard. With the small progress do not consider it as a final success instead work hard constantly until Lyric Dinner theaters build its reputation in the market (i.e. build on the change) and finally, Rivka Belzer need to make above changes a core part of the business to sustain its position in the market and to be profitable in the remaining years of the business.
Appendices
Appendix-1: Horizontal Analysis 2005-2009
HORIZONTAL ANALYSIS
INCOME STATEMENT (YEAR END DEC,31)
|
||||||
2005 | 2006 | 2007 | 2008 | 2009 | GROWTH | |
Income | ||||||
Box Office Sales | $685,616 | $878,588 | $956,991 | $1,071,063 | $777,061 | 3% |
Liquor Sales | 155,033 | 169,806 | 180,245 | 159,753 | 130,391 | -4% |
Total Income | $840,649 | $1,048,394 | $1,137,236 | $1,230,816 | $907,452 | 2% |
Cost of Sales | ||||||
Food Purchased | 233,675 | 292,213 | 291,799 | 328,327 | 222,560 | -1% |
Liquor Purchased | 44,646 | 55,894 | 57,227 | 46,847 | 30,494 | -9% |
Leased Equipment | 6,187 | 8,537 | 7,699 | 5,599 | 4,263 | -9% |
Royalties | 46,448 | 28.190 | 19. | 55,532 | 5,775 | -41% |
Salaries and Contracts | 403,723 | 363,903 | 434,265 | 484,336 | 366,072 | -2% |
Supplies | 80,436 | 81,060 | 88,295 | 81,980 | 75,453 | -2% |
Comps and Coupons | 24,268 | 34,056 | 39,472 | 50,486 | 37,174 | 11% |
Total Cost of Sales | $839,383 | $863,853 | $937,758 | $1,053,107 | $741,791 | -3% |
Gross Profit | 1,266 | 184,541 | 199,478 | 177,709 | 165,661 | 238% |
General Expenses | ||||||
Advertising | 29,379 | 48,808 | 62,557 | 79,050 | 48,462 | 13% |
Depreciation and Amortization | 36,857 | 38,268 | 39,633 | 44,054 | 51,278 | 9% |
Bad Debts | 0 | 0 | 332 | 964 | 145 | |
Interest | 5,366 | 9,234 | 8,715 | 6,084 | 3,440 | -11% |
Legal and Audit | 12,722 | 9,202 | 8,999 | 10. | 4,166 | -24% |
License and Permits | 3,830 | 2,079 | 2,722 | 2,486 | 2,659 | -9% |
Office Expenses | 10,532 | 3,316 | 1,411 | 3,133 | 1,873 | -35% |
Rent | 23,562 | 42,678 | 54,766 | 54,938 | 39,089 | 13% |
Repairs and Maintenance | 31,418 | 24,583 | 21,659 | 23,791 | 18,092 | -13% |
Utilities | 23,489 | 30,746 | 34,262 | 40,226 | 38,949 | 13% |
Travel and Promotion | 6,483 | 9,070 | 8,639 | 4,572 | 1,665 | -29% |
Insurance | 2,125 | 7,266 | 4,836 | 4,250 | 6. | -77% |
Miscellaneous | 3,335 | 3,648 | 3,158 | 2,726 | 540 | -37% |
Total General Expenses | $189,098 | $228,898 | $251,689 | $276,157 | $261,179 | 8% |
Operating Loss | (187,830) | (44,356) | (52,210) | (98,446) | (50,518) | -28% |
Other Income (Rent) | 22,747 | 34,553 | 37,840 | 22,756 | 5,429 | -30% |
Net Loss | $(165,083) | $(9,803) | $(14,370) | $(75,690) | $(45,089) | -28% |
Appendix-2: Horizontal Analysis 2010
HORIZONTAL ANALYSIS | ||||
Year Ended 2010 | ||||
January | February | YTD February | Growth | |
Income | ||||
Box Office Sales | $103,992 | $132,094 | $236,086 | 127% |
Liquor & Miscellaneous | 19,339 | 24,906 | 44,245 | 129% |
Total | $123,331 | $157,000 | $280,331 | 127% |
Variable Cost of Sales | ||||
Food Purchased | 25,192 | 22,745 | 47,937 | 90% |
Liquor Purchased | 4,181 | 4,740 | 8,921 | 113% |
Supplies | 8,784 | 7,764 | 16,548 | 88% |
Total | $38,157 | $35,249 | $73,406 | 92% |
Contribution Margin | 85,174 | 121,751 | 206,925 | 143% |
Show Expenses | ||||
Leased Equipment | 0 | 804 | 804 | - |
Royalties | 2,020 | 8,373 | 10,393 | 415% |
Salaries and Contracts | 41,660 | 42,412 | 84,071 | 102% |
Set Materials | 2,155 | 3,675 | 5,830 | 171% |
Comps and Coupons | 8,194 | 7,241 | 15,435 | 88% |
Total | $54,029 | $62,505 | $116,533 | 116% |
Gross Profit | 31,145 | 59,246 | 90,392 | 190% |
General Overhead Expenses | ||||
Advertisement | 3,310 | 14,022 | 17,331 | 424% |
Depreciation | 0 | 0 | 0 | - |
Bad Debt | 0 | 0 | 0 | - |
Interest | 1,399 | 869 | 2,268 | 62% |
Legal & Audit | 3,234 | 1,972 | 5,206 | 61% |
License & Permits | 0 | 0 | 0 | |
Office Expenses | 286 | 662 | 947 | 231% |
Rent | 18,253 | 22,762 | 41,015 | 125% |
Repairs & Maintenance | 3,152 | 4,278 | 7,430 | 136% |
Utilities | 4,286 | 4559 | 8,845 | 106% |
Travel & Promotion | 0 | 84 | 84 | |
Insurance | 1,161 | 613 | 1,775 | 53% |
Miscellaneous | 212 | 578 | 790 | 273% |
$35,293 | $50,399 | $85,691 | 143% | |
Operating Profit (Loss) | -4,148 | 8,847 | 4,701 | -213% |
Other Income | 0 | 0 | 0 | |
Net Profit (Loss) | $(4,148) | $8,847 | $4,701 | -213% |
Appendix-3: Ratio Analysis
Ratio Analysis | |||
Income Statement Ratios | |||
2009 | 2010 (YTD) | ||
GROSS PROFIT MARGIN | (Revenue-COGS)/Revenue | 18% | 32% |
OPERATING MARGIN | (Operating (profit/loss)/ revenue) | -6% | 2% |
NET PROFIT MARGIN | (Net profit or loss /Revenue) | -5% | 2% |
BALANCE SHEET RATIOS | |||
2008 | 2009 | ||
CURRENT RATIO | (Current Assets/Current Liabilities) | 0.30 | 0.28 |
QUICK RATIO | (current assets–inventories)/current liabilities | 0.22 | 0.22 |
PAYABALE DAYS | (Trade Payable/ Cost of Sales)*365 | 15 | 20 |
RECEIVABALE DAYS | (Trade Receivables/Revenue)*365 | 4 | 6 |
INVENTOPRY DAYS | (Inventory/COGS)*365 | 2 | 2 |
This is just a sample partical work. Please place the order on the website to get your own originally done case solution.