# Thaifoon Restaurant Case

Good Essays
2432 Words
Grammar
Plagiarism
Writing
Score
Thaifoon Restaurant Case
Bo Zhang
EEE451 Case 4 Questions
September 11, 2012

Case 4 THAIFOON RESTAURANT

* Prepare a spreadsheet for the restaurateur to project his net profits.
From exhibit 3, Thaifoon restaurant forecast that there would be 18 turns (5 lunch turns and 13 dinner turns) each week. And the owner planed to have 30 or fewer seats in order to meet the legal regulations and design. So it means there are 30 seats for each turn. Daily Turnover Ratio | | Lunch | Dinner | Revenue | \$12.00 | \$25.00 | Monday | 1 | 1.5 | Tuesday | 1 | 1.5 | Wednesday | 1 | 1.5 | Thursday | 1 | 1.5 | Friday | 1 | 2.5 | Saturday | 0 | 2.5 | Sunday | 0 | 2 | Number of Seats | 30 | |

Moreover, the restaurant would open 52 weeks annually. Lunch bill would amount to \$12 while dinner would amount to \$25 per person. Therefore, for the seats of 30, the restaurant would have revenue of \$360 (\$12*30) for lunch per turn; and \$750 (\$25*30) for dinner per turn. Thus, the annual revenue would be \$600,600 (\$360*5*52+\$750*13*52). Total Sales | | | | | | Day | Lunch | Dinner | Total Profit | Total Sales | Monday | \$18,720.00 | \$58,500.00 | \$77,220.00 | | Tuesday | \$18,720.00 | \$58,500.00 | \$77,220.00 | | Wednesday | \$18,720.00 | \$58,500.00 | \$77,220.00 | | Thursday | \$18,720.00 | \$58,500.00 | \$77,220.00 | | Friday | \$18,720.00 | \$97,500.00 | \$116,220.00 | | Saturday | \$0.00 | \$97,500.00 | \$97,500.00 | | Sunday | \$0.00 | \$78,000.00 | \$78,000.00 | \$600,600.00 |

For the fixed cost, from exhibit 4, I subtract amortization from the total projected annual cost, and add one month deposit paid to the landlord, which is 87,789-19,414= \$68,375. Then variable cost based on the sales, which in total equals \$397,371. So gross profit would be revenue- total cost (fixed cost+ variable cost)= \$134,854. Then subtract amortization from gross profit, EBIT= \$115,440.

Since the restaurant is owned by Mr. Phimphrachanh alone, so I

## You May Also Find These Documents Helpful

• Satisfactory Essays

Monthly expenses are as follows: commissions, \$13,050; rent, \$2,150; other expenses (excluding depreciation), 7% of sales. Assume that these expenses are paid monthly. Depreciation is \$2,500 for the quarter and includes depreciation on new assets acquired during the quarter.…

• 434 Words
• 4 Pages
Satisfactory Essays
• Good Essays

45,000 meals – 43,992 meals = 1008 meals x \$1.84 revenue per meal = \$1,854.72 profit.…

• 514 Words
• 2 Pages
Good Essays
• Satisfactory Essays

Monthly 50% Monthly Rooms \$2,956,500 \$2,217,375 \$1,478,250 Leases \$180,000 \$135,000 \$90,000 TOTAL REVENUE \$3,136,500 \$2,352,375 \$1,568,250 Expences TOTAL VARIABLE COSTS \$454,000 \$340,500 \$227,000 TOTAL FIXED COSTS \$1,403,000 \$1,403,001 \$1,403,002 TOTAL EXPENSE BEFORE IT \$1,857,000 \$1,743,501 \$1,630,002 EBIT \$1,279,500 \$608,874 -\$61,752 Depreciation \$320,000 \$320,001 \$320,002 EBITDA \$1,599,500 \$928,875 \$258,250 Furnishing Interest \$110,000 \$110,000 \$110,000 TOTAL INTEREST \$110,000 \$110,000 \$110,000 TAXES (40%) \$467,800.00 \$199,549.60 -\$68,700.80 Furnishing Principal \$180,160 \$180,160 \$180,160 20yr Mortgage Principal \$49,713…

• 1302 Words
• 21 Pages
Satisfactory Essays
• Satisfactory Essays

1,008 revenue 1,008 meals at \$5.77-\$5,816.16 for total cost per meal 1,008 at \$3.971.44 for a total profit of \$5,816.16-\$3961.44=\$1854.72…

• 123 Words
• 1 Page
Satisfactory Essays
• Satisfactory Essays

4. How much profit will the program earn if it completes its 45,000 – meal contract with the City of Westchester?…

• 324 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

3. Using the average check, forecasted occupancy and number of seats, identify the revenue expectations for this restaurant for one year. Use the guideline…

• 512 Words
• 3 Pages
Satisfactory Essays
• Powerful Essays

Total profit is calculated from subtracting the combined total fixed and variable costs from the total revenue generated. Total costs are derived from the fixed cost of \$9,000 in addition to calculating the average variable cost formula provided by the regression analysis multiplied by the profit-maximizing average daily production capacity calculated at each price level.…

• 1521 Words
• 7 Pages
Powerful Essays
• Powerful Essays

2. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour. Jan 1,546 7,896 9,442 329 28.70 0.03 Feb 1,485 7,584 9,069 316 28.70 0.03 Mar 1,697 8,664 10,361 361 28.70 (costs/hours) 0.03 (hours/costs)…

• 923 Words
• 4 Pages
Powerful Essays
• Good Essays

Based on the above LP model, Julie is expected to earn a profit of \$2,250.00. After paying for rental lease, she has earned a net profit of \$1250.00. The model suggests that she rents the booth and sell only pizza and Hotdog due to her spacing constraints. This will be the best option to achieve optimal results.…

• 517 Words
• 3 Pages
Good Essays
• Satisfactory Essays

Billy 's Gut Busting Buffet - Billy is opening a new buffet restaurant and wants to use Excel to build a weekly budget forecast and estimate his profit. He has inputs and assumptions for revenue and expenses in the spreadsheet. Now he needs to set up his weekly budget forecast to show the profit he can expect based on the input he has provided. Research conducted has indicated that the number of customers Billy can expect in a week is directly tied to the price of an individual buffet meal (see "Buffet Price and associated number of customers" data in Inputs and Assumptions section of start file spreadsheet). All customers will be charged the same meal price, Billy must determine what price to charge for a meal (\$12, \$15, \$18).…

• 837 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

Built on the above LP model, Julia is estimated that she will earn a profit of \$2,250.00. After paying for the rental lease, she has earned a net profit of \$1,250.00. The model suggests that she rents the booth and sell only pizza and hotdog due to her spacing constraints. This is Julia best optimal results.…

• 690 Words
• 3 Pages
Satisfactory Essays
• Good Essays

Virginia’s optimal investment in the restaurant is \$3 million, which give her a total of \$5,150,943 at the end of year 1. This is approximately a 29% increase in her wealth.…

• 575 Words
• 3 Pages
Good Essays
• Powerful Essays

Morgan State University University Calendar *All dates are subject to change WINTER 2014 MINIMESTER JANUARY 2014 1 Wednesday 2 2-3 6 Thursday Thursday-Friday Monday 20 Monday 22 23 24 27 Wednesday Thursday Friday Monday Residence Halls open for 2014 Minimester FAFSA Application opens 2014 MINIMESTER CLASSES BEGIN 2014 Minimester Late Registration/(Drop/Add) Last day to withdraw from minimester classes (with grade of “W”)…

• 1540 Words
• 23 Pages
Powerful Essays
• Satisfactory Essays

A) Explicit Costs = rent 25000 + business taxes 15 000 + products to sell 350 000 = \$390 000…

• 362 Words
• 2 Pages
Satisfactory Essays