KENDALL SCHOOL OF BUSINESS | ||||||||||||||||||||||||||
ACC272 B1 – Fall 2013 | ||||||||||||||||||||||||||
Comprehensive Accounting Project | ||||||||||||||||||||||||||
Four students from Kendall Hospitality program, decide to start a business and open an icecream shop in the month of June. | ||||||||||||||||||||||||||
The students names are: Victoria, Matt, Jean & Tracy. | ||||||||||||||||||||||||||
They form a company (partnership) and name it “Chicago Summers”. They decide to use the same name for the ice cream shop. | ||||||||||||||||||||||||||
The students divide the duties – Matt and Victoria will make the purchases needed to produce the Ice Creams. They will hire | ||||||||||||||||||||||||||
two helpers to be at the ice cream shop during business hours, prepare and sell the ice cream. Jean will supervise the employees | ||||||||||||||||||||||||||
She also will be in charge of counting the materials at the end of each business day and communicate to Victoria and Matt how | ||||||||||||||||||||||||||
much more they need to purchase. Tracy is in charge of keeping the accounting records of the company as well as preparing the financial | ||||||||||||||||||||||||||
statements for each month | ||||||||||||||||||||||||||
Here are the transactions Chicago Summers company incurs during the month of June & July 2010: | ||||||||||||||||||||||||||
June Transactions | ||||||||||||||||||||||||||
Setting up the shop | ||||||||||||||||||||||||||
6/1 | Each of the students/owners invests $15,000 of cash in the Chicago Summer Company. | |||||||||||||||||||||||||
The students open a business checking account with City Bank and deposit their initial investments. | ||||||||||||||||||||||||||
6/1 | They sign a 2-year lease to rent a space on Michigan Avenue for the Chicago Summers Ice cream shop. | |||||||||||||||||||||||||
Monthly rent of the space is $2000, payable on the first day of each month. | ||||||||||||||||||||||||||
6/2 | They purchase Ice cream Equipments, on account for 12,600, payable in three equal installments, in the next three months | |||||||||||||||||||||||||
The first installment is due for payment in July 2nd. It is estimated that the equipment has a life of 7 years with no | ||||||||||||||||||||||||||
salvage value. | ||||||||||||||||||||||||||
6/2 | They purchase Furniture for the Ice Cream Shop on account for 10,000 on account, payable in 45 days. | |||||||||||||||||||||||||
It is estimated that the furniture will be used for 5 years, with no salvage value. | ||||||||||||||||||||||||||
6/2 | They purchase a laptop for $1200 on account to be used exclusively in keeping track of the accounting records. | |||||||||||||||||||||||||
Payment for the computer is due in 45 days. Estimated life of the laptop is 3 years with no salvage value. | ||||||||||||||||||||||||||
6/2 | They purchase a QuickBooks software, to be used in Accounting, for $1500 on account – payable in 45 days. | |||||||||||||||||||||||||
It is estimated that the software will be used for 10 years. | ||||||||||||||||||||||||||
6/5 | They call a technician to install the Ice Cream equipment. Estimated bill of the technician is $700. At the end of the | |||||||||||||||||||||||||
month, the company has not yet received the bill, however, the technician completed in full his installation work. | ||||||||||||||||||||||||||
6/5 | They hire two employees. Total salary cost for the two employees is $1500 a month, payable at the end of | |||||||||||||||||||||||||
the month. | ||||||||||||||||||||||||||
Starting the Operations | ||||||||||||||||||||||||||
6/5 | Victoria & Matt are in charge of purchasing the key materials to make the ice cream. At the beginning of the month | |||||||||||||||||||||||||
they purchase the following: | ||||||||||||||||||||||||||
Description | Quantity in LB | Price | Total Cost | |||||||||||||||||||||||
Milk | 200 | $ 1.25 | $ 250.00 | |||||||||||||||||||||||
Sugar | 200 | $ 0.75 | $ 150.00 | |||||||||||||||||||||||
Vanilla | 1 | $ 500.00 | $ 500.00 | |||||||||||||||||||||||
Cacao | 200 | $ 3.00 | $ 600.00 | |||||||||||||||||||||||
Butter | 200 | $ 2.00 | $ 400.00 | ######## | ||||||||||||||||||||||
6/5 | They incur freight costs of $50, which they pay in full | |||||||||||||||||||||||||
6/15 | Victoria and Matt purchase additional materials. Because of market changes, they realize that prices for their key | |||||||||||||||||||||||||
ingredients have gone up. | ||||||||||||||||||||||||||
Description | Quantity in LB | Price | Total Cost | |||||||||||||||||||||||
Milk | 200 | $ 1.35 | $ 270.00 | |||||||||||||||||||||||
Sugar | 200 | $ 0.90 | $ 180.00 | |||||||||||||||||||||||
Butter | 100 | $ 2.20 | $ 220.00 | $ 670.00 | ||||||||||||||||||||||
6/30 | Throughout the month, the Chicago Summers ice cream shop is able to generate a total of $6,000 in cash sales. | |||||||||||||||||||||||||
Inventory | ||||||||||||||||||||||||||
6/30 | Jean is in charge of keeping track of key material quantities. She knows that most of the materials purchased | |||||||||||||||||||||||||
during the month have been used in making ice cream. However some quantities still are left unused. These will be | ||||||||||||||||||||||||||
used in the next month’s production of ice cream. At the end of the month, Jean performs a physical count of the | ||||||||||||||||||||||||||
materials left. Below is the result of the count. | ||||||||||||||||||||||||||
Description | Quantity in LB | |||||||||||||||||||||||||
Milk | 50 | |||||||||||||||||||||||||
Sugar | 70 | |||||||||||||||||||||||||
Vanilla | 0.5 | |||||||||||||||||||||||||
Cacao | 50 | |||||||||||||||||||||||||
Butter | 90 | |||||||||||||||||||||||||
June’s financial statement | ||||||||||||||||||||||||||
6/30 | Tracy is in charge of keeping the accounting records. She records all the economic events presented above by doing the following: | |||||||||||||||||||||||||
Preparing the journal entries, | ||||||||||||||||||||||||||
Posting the appropriate journal entries in the T accounts | ||||||||||||||||||||||||||
Preparing the Trial balance for the month of June | ||||||||||||||||||||||||||
Completing the Balance Sheet and Income Statement for the month of June | ||||||||||||||||||||||||||
July Transactions | ||||||||||||||||||||||||||
7/1 | The company paid the monthly rent | |||||||||||||||||||||||||
‘7/1 | Paid on account for an ad in the local radio station for $700 | |||||||||||||||||||||||||
7/2 | Paid the first installment due for the purchase of the Ice Cream Equipment (total $4200) | |||||||||||||||||||||||||
7/5 | Purchased the following inventory items: | |||||||||||||||||||||||||
Description | Quantity in LB | Price | Total Cost | |||||||||||||||||||||||
Milk | 200 | $ 1.30 | $ 260.00 | |||||||||||||||||||||||
Sugar | 200 | $ 0.90 | $ 180.00 | |||||||||||||||||||||||
Cacao | 100 | $ 2.80 | $ 280.00 | |||||||||||||||||||||||
Butter | 100 | $ 1.90 | $ 190.00 | $ 910.00 | ||||||||||||||||||||||
7/5 | Incurred $50 of freight cost, which they paid in cash | |||||||||||||||||||||||||
All the inventory left over from June and purchased July was fully utilized in making the ice creams in July | ||||||||||||||||||||||||||
7/15 | Paid in full the Furniture purchased on account in June. | |||||||||||||||||||||||||
7/15 | Paid in full the cost of the laptop | |||||||||||||||||||||||||
7/15 | Paid in full the cost of the QuickBooks software | |||||||||||||||||||||||||
7/30 | Paid the salaries of the two employees | |||||||||||||||||||||||||
7/30 | Collected $7,000 in cash sales | |||||||||||||||||||||||||
Instructions | ||||||||||||||||||||||||||
I June Financial Statements | ||||||||||||||||||||||||||
Assume you are doing Tracy’s job: | ||||||||||||||||||||||||||
Analyze each of June’s transactions and prepare the journal entries | ||||||||||||||||||||||||||
Calculate the depreciation and amortization expenses for the month of June for the tangible and intangible assets | ||||||||||||||||||||||||||
Calculate Cost of Goods Sold assuming the company uses a periodic inventory system and FIFO for cost method | ||||||||||||||||||||||||||
Post the appropriate journal entries in T accounts | ||||||||||||||||||||||||||
Prepare a trial balance | ||||||||||||||||||||||||||
Prepare the Balance Sheet and Income Statement for the month of June. | ||||||||||||||||||||||||||
II July Financial Statements | ||||||||||||||||||||||||||
Repeat the steps above for July: | ||||||||||||||||||||||||||
Analyze each of July’s transactions and prepare the journal entries | ||||||||||||||||||||||||||
Calculate the depreciation and amortization expenses for the month of July for the tangible and intangible assets | ||||||||||||||||||||||||||
Calculate Cost of Goods Sold assuming the company uses a periodic inventory system and FIFO for cost method | ||||||||||||||||||||||||||
Post the appropriate journal entries in T accounts | ||||||||||||||||||||||||||
Prepare a trial balance | ||||||||||||||||||||||||||
Prepare the Balance Sheet and Income Statement for the month of July | ||||||||||||||||||||||||||
III Analysis of Accounting Records | ||||||||||||||||||||||||||
Prepare a horizontal analysis by comparing June and July balance sheets | ||||||||||||||||||||||||||
Calculate the following ratios: | ||||||||||||||||||||||||||
1 | Current ratio (Liquidity) | |||||||||||||||||||||||||
2 | Return on Assets (Profitability) | |||||||||||||||||||||||||
3 | Debt to Total Assets ratio (Solvency) | |||||||||||||||||||||||||
Assume you are reviewing the Financial Statements and the analysis together with Victoria, Matt and Jean | ||||||||||||||||||||||||||
What are some of the conclusions? What should the company do to stay in business? |
ORDER A SIMILAR ESSAY WRITTEN FROM SCRATCH
Save time and money with our essay writers for hire. If you are in search of a dependable academic support provider that offers more than just typical writing services, you have come to the right place. As a cost-effective essay writing service, we not only assist you in crafting outstanding papers but also provide complimentary features.
We Write Essays For Students
Tell us about your assignment and we will find the best writer for your paper
Write My Essay For Me