Lyric Dinner Theatre Harvard Case Solution & Analysis

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.

Share This

SALE SALE

Save Up To

30%

IN ONLINE CASE STUDY

FOR FREE CASES AND PROJECTS INCLUDING EXCITING DEALS PLEASE REGISTER YOURSELF !!

Register now and save up to 30%.