Share
Explore BrainMass

Big Pig Gig & Jig Restaurant

Need to know how to calculate the attached problems.

Big Pig Gig & Jig (BPGJ) is an incorporated (2005) restaurant for big eaters and has a room specially reinforced for line dancing. As you can imagine the specialty at BPGJ is BBQ pork, and when the house band, Slim Jim, plays their specialty number, Stay offa my feet 'cause I can't dance when I'm crawlin', the place really bounces, literally.

Business has been great at BPGJ for the past three years, but profits have been declining, and the owner, Happi G. O'Lucky, is worried. His banker, Bags O. Money, has warned Happi that his loans are going to get more expensive unless he can bring BPGJ profitability back up to the standards they agreed upon when Bags gave Happi money to buy his first hogs. Happi had no recourse but to hire an accountant, Shades O.F. Gray, his wife's brother's nephew, a graduate of the University of Phoenix, who had just passed the C.P.A. exam.

Happi asked Shades to look at his finances, because while Happi could cook pork hundreds of different ways, he couldn't cook the books enough to make Bags O. Money sympathetic with his cash flow problem. Shades asked Happi for the BPGJ books so he could analyze the financial statements and see where Happi was going wrong. Here's what he found:

2005 2006 2007
Sales - Restaurant $550,000 $750,000 $1,050,000
Cost of sales (COS-R) $400,000 $600,000 $900,000
Gross Profit from Restaurant $150,000 $150,000 $150,000
Sales - Entertainment $200,000 $350,000 $475,000
Cost of Sales (COS-E) $100,000 $175,000 $250,000
Gross Profit from Entertainment $100,000 $175,000 $225,000
Total Sales
Total Cost of Sales
Gross Profit
Interest Expense
Depreciation
Overhead Expense
Income before Tax
Income Tax (35%)
Income after Tax
Analysis of COS-R:
Salaries $75,000 $85,000 $120,000
Hogs 225,000 315,000 480,000
Other 100,000 200,000 300,000

Selected Balance Sheet Data:
Fixed Assets $500,000 $500,000 $500,000
Inventory - Hogs $100,000 $200,000 $600,000
Notes Payable - Current $200,000 $400,000 $800,000
Current Assets $500,000 $750,000 $1,000,000
Current Liabilities $300,000 $650,000 $1,100,000
Total Assets $1,000,000 $1,250,000 $1,500,000
Total Liabilities $500,000 $800,000 $1,250,000
ASSUMPTIONS:
COS-R = Cost of Sales - Restaurant
COS-E = Cost of Sales - Entertainment
Interest expense = 10% of Notes Payable
Depreciation = 10% of Fixed Assets
Overhead Expense = 5% of Total Sales
Tax Rate = 35%

With these statistics, Shades could now analyze the financial statements and advise Happi how to reverse his declining fortunes. You are asked to help in this endeavor.

a. Calculate BPJG's Income Before Tax for the years 2005-2007.

b. Calculate the Income After Tax assuming a tax rate of 35% for these same years.

c. Why is inventory control important?

d. Shades saw a problem with the BPGJ inventory that could be a prime cause of COS-R problems. He asks you to calculate inventory turns and the average age of the inventory for 2006 and 2007. What will be the financial impact of the change in inventory turns and aging if the trends between the two years continue? Use average inventories for the calculation.

e. What was Happi's initial investment to start the restaurant?

f. What is the owner's equity at the end of each year?

g. Calculate the current ratio for each year. What might Happi do to reverse the current ratio trend? [There are both balance sheet and income statements actions that can be taken.)

h. What are your financial recommendations to Shades that he can tell Happi that will correct the downturn of BPGJ's fortunes?

Attachments

Solution Preview

Please see the attached files

Big Pig Gig & Jig (BPGJ) is an incorporated (2005) restaurant for big eaters and has a room specially reinforced for line dancing. As you can imagine the specialty at BPGJ is BBQ pork, and when the house band, Slim Jim, plays their specialty number, Stay offa my feet 'cause I can't dance when I'm crawlin', the place really bounces, literally.

Business has been great at BPGJ for the past three years, but profits have been declining, and the owner, Happi G. O'Lucky, is worried. His banker, Bags O. Money, has warned Happi that his loans are going to get more expensive unless he can bring BPGJ profitability back up to the standards they agreed upon when Bags gave Happi money to buy his first hogs. Happi had no recourse but to hire an accountant, Shades O.F. Gray, his wife's brother's nephew, a graduate of the University of Phoenix, who had just passed the C.P.A. exam.

Happi asked Shades to look at his finances, because while Happi could cook pork hundreds of different ways, he couldn't cook the books enough to make Bags O. Money sympathetic with his cash flow problem. Shades asked Happi for the BPGJ books so he could analyze the financial statements and see where Happi was going wrong. Here's what he found:

2005 2006 2007
Sales - Restaurant $550,000 $750,000 $1,050,000
Cost of sales (COS-R) $400,000 $600,000 $900,000
Gross Profit from Restaurant $150,000 $150,000 $150,000
Sales - Entertainment $200,000 $350,000 $475,000
Cost of Sales (COS-E) $100,000 $175,000 $250,000
Gross Profit from Entertainment $100,000 $175,000 $225,000
Total Sales
Total Cost of Sales
Gross Profit
Interest Expense
Depreciation
Overhead Expense
Income before Tax
Income Tax (35%)
Income after Tax
Analysis of COS-R:
Salaries $75,000 $85,000 $120,000
Hogs 225,000 315,000 480,000
Other 100,000 200,000 300,000

Selected Balance Sheet Data:
Fixed Assets $500,000 $500,000 $500,000
Inventory - Hogs $100,000 $200,000 $600,000
Notes Payable - Current $200,000 $400,000 $800,000
Current Assets $500,000 $750,000 $1,000,000
Current Liabilities $300,000 $650,000 $1,100,000
Total Assets $1,000,000 $1,250,000 $1,500,000
Total Liabilities $500,000 $800,000 $1,250,000
ASSUMPTIONS:
COS-R = Cost of Sales - Restaurant
COS-E = Cost of Sales - Entertainment
Interest expense = 10% of Notes Payable
Depreciation ...

Solution Summary

The solution has profitability analysis and recommendations for Big Pig Gig & Jig (BPGJ) restaurant

$2.19