Henrietta’s Pine Bakery Background You are an Analyst for the professional servi
ID: 2424082 • Letter: H
Question
Henrietta’s Pine Bakery
Background
You are an Analyst for the professional service firm, BUSI 1043 LLP. Your firm specializes in providing a wide variety of internal business solutions for different clients. Given the outstanding feedback you received on your first engagement working for Big Spenders Inc., a Senior Manager in the Financial Advisory group requested your support on a compilation engagement.
Additional Information
Henrietta’s was established in 1963 when it first opened its doors in Dwight, Muskoka on highway 60. Over the past 50 years, there have been four owners and is currently owned by Carine & Geoff Harris who incorporated and took over the store on January 1, 2013. Their sons, Kyle and Nicholas have been an intricate part of the business from dishwashing to head bakers. Henrietta's has grown over the years with the addition of new items all the time, but the "Sticky Buns and Clouds" remain the most popular items amongst the 150 varieties of breads and pastries.
Henrietta’s runs out of 90 square meters (1,000 share feet) of space. It has one entrance into the bakery and doors leading out to highway 60. Henrietta’s pays $5,000 per month for the rental of the space. Carine and Geoff were able to negotiate with the landlord and were not required to pay the first month’s rend in advance. All of the rental payments are current and up to date. For the last two years, Henrietta’s has had a very reliable accountant prepare its year-end financial statements and everything has been correct. This year, Henrietta’s accountant retired and Geoff did the best he could recording his own financial information. For the information he was not sure about, he kept all of the required supporting documentation. Geoff hired your firm, BUSI 1043 LLP to prepare his financial statements for the year. Geoff supplied you with his unadjusted trial balance and the information in Exhibit I to assist you.
Supplementary information:
o The amount currently sitting in prepaids arose due the insurance policy last year. Geoff didn’t know how to correct it, so he left it. This year’s insurance policy was purchased on November 1 for $9,000. The policy runs from November 1 to October 31 of each year.
o Geoff has a note that he owed $900 in wages to his employees for the period ending December 31st.
o The loan was incurred when the bakery was opened. The loan carried an interest rate of 8%. The interest is payable two months after year end and the principal is due in 2019.
o Henrietta’s will sometimes book special events with small organizations that are allowed to pay after the event has taken place. On December 29th, a small company had a gathering at the bakery. The company was billed $1,089 and has 30 days to pay it. Geoff has not yet recorded this in his financial records.
o Henrietta’s declared a dividend of $5,000 on December 30th.
o Geoff didn’t know how to record amortization for the year and so left it for you to record. Amortization for all assets is charged using a straight-line method by taking the cost of the asset and dividing it by its expected useful life. The assets have expected useful lives as follows:
o Computer: 5 years
o Bakery equipment: 10 years
o Furniture and fixtures: 20 years
o Furniture and fixtures: 20 years
o The information shows that Henrietta’s owes $400 for a telephone bill and #400 for electricity for December. These amounts have not been recorded yet.
Adjusted Trial Balance
Account Name
Debit
Credit
Debit
Credit
cash
$ 35,000.00
$ 35,000.00
accounts receivable
$ 5,600.00
$ 6,689.00
food inventory
$ 21,000.00
$ 21,000.00
merchandise inventory
$ 62,500.00
$ 62,500.00
prepaids
$ 3,400.00
$ 7,500.00
computers
$ 30,000.00
$ 30,000.00
accumulated amort-computers
$ 12,000.00
$ 18,000.00
bakery equipment
$ 90,000.00
$ 90,000.00
accumulated amort-bakery eqpmt
$ 18,000.00
$ 27,000.00
furniture & fixtures
$ 150,000.00
$ 150,000.00
accumulated amort-furniture
$ 15,000.00
$ 22,500.00
accounts payable
$ 18,000.00
$ 18,000.00
accrued liabilities
$ 1,700.00
interest payable
$ 17,600.00
dividend payable
$ 5,000.00
long term loan
$ 220,000.00
$ 220,000.00
common shares
$ 50,000.00
$ 50,000.00
retained earnings
$ 22,000.00
$ 22,000.00
food revenue
$ 468,500.00
$ 469,589.00
internet revenue
$ 127,000.00
$ 127,000.00
merchandise revenue
$ 103,000.00
$ 103,000.00
food expense
$ 240,000.00
$ 240,000.00
internet expense
$ 54,000.00
$ 54,000.00
electricity expense
$ 65,000.00
$ 65,400.00
telephone expense
$ 20,000.00
$ 20,400.00
interest expense
$ 17,600.00
salary expense
$ 200,000.00
$ 200,900.00
insurance expense
$ 9,000.00
$ 4,900.00
supplies expense
$ 8,000.00
$ 8,000.00
depreciation expense
$ 22,500.00
rent expense
$ 60,000.00
$ 60,000.00
dividend expense
$ 5,000.00
$ 1,053,500.00
$1,053,500.00
$1,101,389.00
$1,101,389.00
INCOME STATEMENT
Income:
food revenue
$ 469,589.00
internet revenue
$ 127,000.00
merchandise revenue
$ 103,000.00
$699,589.00
Expenses:
food expense
$ 240,000.00
internet expense
$ 54,000.00
electricity expense
$ 65,400.00
telephone expense
$ 20,400.00
salary expense
$ 200,900.00
insurance expense
$ 4,900.00
supplies expense
$ 8,000.00
depreciation expense
$ 22,500.00
rent expense
$ 60,000.00
$676,100.00
Operating Income
$ 23,489.00
Interest expense
$ 17,600.00
Net Income
$ 5,889.00
BALANCE SHEET
ASSETS
LIABILITIES
Current Assets:
Current liabilities:
Cash
$ 35,000.00
Accounts payable
$18,000.00
Accounts receivable
$ 6,689.00
accrued liabilities
$ 1,700.00
Food inventory
$ 21,000.00
interest payable
$17,600.00
Merchandise inventory
$ 62,500.00
dividend payable
$ 5,000.00
$ 42,300.00
Prepaids
$ 7,500.00
$132,689.00
Long term liabilities:
Fixed Assets:
Long term loan
$220,000.00
Computers
$ 30,000.00
Equity:
Less accumulated depn
$ 18,000.00
$ 12,000.00
Common Shares
$50,000.00
Bakery equipment
$ 90,000.00
Retained earnings
$22,889.00
$ 72,889.00
Less accumulated depn
$ 27,000.00
$ 63,000.00
Furniture and fixtures
$150,000.00
Less accumulated depn
$ 22,500.00
$127,500.00
$335,189.00
$335,189.00
o assess the financial reporting landscape, considering the user needs, constraints, and business environment;
o identify the issues;
o analyze the issues (qualitatively and quantitatively); and
o provide a recommendation for each issue identified in the case.
Adjusted Trial Balance
Account Name
Debit
Credit
Debit
Credit
cash
$ 35,000.00
$ 35,000.00
accounts receivable
$ 5,600.00
$ 6,689.00
food inventory
$ 21,000.00
$ 21,000.00
merchandise inventory
$ 62,500.00
$ 62,500.00
prepaids
$ 3,400.00
$ 7,500.00
computers
$ 30,000.00
$ 30,000.00
accumulated amort-computers
$ 12,000.00
$ 18,000.00
bakery equipment
$ 90,000.00
$ 90,000.00
accumulated amort-bakery eqpmt
$ 18,000.00
$ 27,000.00
furniture & fixtures
$ 150,000.00
$ 150,000.00
accumulated amort-furniture
$ 15,000.00
$ 22,500.00
accounts payable
$ 18,000.00
$ 18,000.00
accrued liabilities
$ 1,700.00
interest payable
$ 17,600.00
dividend payable
$ 5,000.00
long term loan
$ 220,000.00
$ 220,000.00
common shares
$ 50,000.00
$ 50,000.00
retained earnings
$ 22,000.00
$ 22,000.00
food revenue
$ 468,500.00
$ 469,589.00
internet revenue
$ 127,000.00
$ 127,000.00
merchandise revenue
$ 103,000.00
$ 103,000.00
food expense
$ 240,000.00
$ 240,000.00
internet expense
$ 54,000.00
$ 54,000.00
electricity expense
$ 65,000.00
$ 65,400.00
telephone expense
$ 20,000.00
$ 20,400.00
interest expense
$ 17,600.00
salary expense
$ 200,000.00
$ 200,900.00
insurance expense
$ 9,000.00
$ 4,900.00
supplies expense
$ 8,000.00
$ 8,000.00
depreciation expense
$ 22,500.00
rent expense
$ 60,000.00
$ 60,000.00
dividend expense
$ 5,000.00
$ 1,053,500.00
$1,053,500.00
$1,101,389.00
$1,101,389.00
INCOME STATEMENT
Income:
food revenue
$ 469,589.00
internet revenue
$ 127,000.00
merchandise revenue
$ 103,000.00
$699,589.00
Expenses:
food expense
$ 240,000.00
internet expense
$ 54,000.00
electricity expense
$ 65,400.00
telephone expense
$ 20,400.00
salary expense
$ 200,900.00
insurance expense
$ 4,900.00
supplies expense
$ 8,000.00
depreciation expense
$ 22,500.00
rent expense
$ 60,000.00
$676,100.00
Operating Income
$ 23,489.00
Interest expense
$ 17,600.00
Net Income
$ 5,889.00
Explanation / Answer
The first step is to prepare an adjusted Trial Balance as below:
adjustments Adjusted Trial Balance Account Name Debit Credit debit credit Debit Credit cash 35000 35000 accounts receivable 5600 1089 6689 food inventory 21000 21000 merchandise inventory 62500 62500 prepaids 3400 7500 3400 7500 computers 30000 30000 accumulated amort-computers 12000 6000 18000 bakery equipment 90000 90000 accumulated amort-bakery eqpmt 18000 9000 27000 furniture & fixtures 150000 150000 accumulated amort-furniture 15000 7500 22500 accounts payable 18000 18000 accrued liabilities 1700 1700 interest payable 17600 17600 dividend payable 5000 5000 long term loan 220000 220000 common shares 50000 50000 retained earnings 22000 22000 food revenue 468500 1089 469589 internet revenue 127000 127000 merchandise revenue 103000 103000 food expense 240000 240000 internet expense 54000 54000 electricity exp 65000 400 65400 telephone exp 20000 400 20400 interest exp 17600 17600 salary exp 200000 900 200900 insurance exp 9000 3400 7500 4900 supplies exp 8000 8000 depreciation exp 22500 22500 rent exp 60000 60000 dividend expense 5000 5000 1053500 1053500 58789 58789 1101389 1101389Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.