Question

In: Accounting

Edwina Haskell was an accomplished high school student who looked forward to attending Southern New England...

Edwina Haskell was an accomplished high school student who looked forward to attending Southern New England University (SNEU). SNEU was unique in that it operated on a trimester basis, its policy was to actively foster independent development among the students. Edwina’s mother and father each own their own small businesses. Soon after freshman orientation at SNEU, Edwina recognized a need among the students that could be the basis for developing a small business. Freshman students could not bring their cars on the campus. In effect, they were confined to the dorm; if they wished to travel, they had to take school-provided buses that operated on a fixed schedule. Further, the university’s cafeteria closed at eight in the evening. Students who wanted to have some food or snacks after 8:00 p.m. had to call local restaurants that delivered. The few restaurants in the neighborhood around SNEU that had delivery services often were late in their deliveries, and hot food, such as pizza, was frequently delivered cold.

Edwina felt that there was a niche market on the campus. She believed that students would be interested in ordering sandwiches, snacks, and sodas from a fellow student provided that the food could be delivered in a timely fashion. After talking with several students in her dorm complex, she believed that offering a package of a sandwich, a soda, and a small snack, such as potato chips, for $5 and a guaranteed delivery of 15 minutes or less would be a winner. Because her dorm complex consisted of four large adjoining buildings that house nearly 1,600 students, she felt that there would be sufficient demand to make the concept profitable. She talked about this concept with her roommates and with her parents. Her roommates were willing to help prepare the sandwiches and deliver them. She planned on paying each of them $250 per trimester for taking orders, making sandwiches, and delivering them. All three roommates, whom she knew from high school, were willing to be paid at the end of the trimester.

Edwina recognized that for this business plan to work, she would have to have a sufficient inventory of cold cuts, lettuce, tomatoes, soda, chips, and condiments to be able to meet student demands. The small refrigerators in the dorm rooms would not be sufficient. After talking to her parents, they were willing to help her set up her business. They would lend her $1,000 to buy a larger refrigerator to place in her dorm room. She did not have to repay this loan until she graduated in four years, but her parents wanted her to appreciate the challenges of operating a small business. They set up several conditions. First, although she did not have to pay back the $1,000 for the refrigerator for four years, she had to pay interest on this “loan.” She had to repay 3 percent of this loan each trimester. Further, they reminded her that although she could pay her friends at the end of the semester, she would need funds to buy the cold cuts, bread, rolls, soda, snacks, condiments, and supplies such as foil to wrap the sandwiches, plus plates and paper bags. Although Edwina was putting $500 of her own money into her business, her parents felt that she might need an infusion of cash during the first year (i.e., the first three trimesters). They were willing to operate as her bank—lending her money, if needed, during the trimesters. However, she had to pay the loan(s) back by the end of the year. They also agreed that the loan(s) would be at a rate of 2 percent per trimester.

Within the first three weeks of her first trimester at SNEU, Edwina purchased the $1,000 refrigerator with the money provided by her parents and installed it in her dorm. She also went out and purchased $180 worth of supplies consisting of paper bags; paper plates; and plastic knives, spoons, and forks. She paid for these supplies out of her original $500 personal investment. She and her roommates would go out once or twice a week, using the SNEU bus system to buy what they thought would be the required amount of cold cuts, bread, rolls, and condiments. The first few weeks’ worth of supplies were purchased out of the remainder of the $500. Students paid in cash for the sandwiches. After the first two weeks, Edwina would pay for the food supplies out of the cash from sales.

In the first trimester, Edwina and her roommates sold 640 sandwich packages, generating revenue of $3,200. During this first trimester, she purchased $1,710 worth of food supplies. She used $1,660 to make the 640 sandwich packages. Fortunately, the $50 of supplies were condiments and therefore would last during the two-week break between the trimesters. Only $80 worth of the paper products were used for the 640 sandwich packages. Edwina spent $75 putting up posters and flyers around the campus promoting her new business. She anticipated that the tax rate would be approximately 35 percent of her earnings before taxes. She estimated this number at the end of the first trimester and put that money away so as to be able to pay her tax bill.

During the two weeks off between the first and second trimester, Edwina and her roommates talked about how they could improve business operations. Several students had asked about the possibility of having warm sandwiches. Edwina decided that she would purchase two Panini makers. So at the beginning of the second trimester, she tapped into her parents’ line of credit for two Panini grills, which in total cost $150. To make sure that the sandwiches would be delivered warm, she and her roommates spent $100 on insulated wrappings. The $100 came from cash. The second trimester proved to be even more successful. The business sold 808 sandwiches, generating revenue of $4,040. During this second trimester, the business purchased $2,100 worth of food supplies, using $2,020 of that to actually create the 808 sandwich packages. They estimated that during the second trimester, they used $101 worth of supplies in creating the sandwich packages.

There was only a one-week break between the second and third trimesters, and the young women were quite busy in developing ideas on how to further expand the business. One of the first decisions was to raise the semester salary of each roommate to $300 apiece. More and more students had been asking for a greater selection of warm sandwiches. Edwina and her roommates decided to do some cooking in the dorms so as to be able to provide meatball and sausage sandwiches. Edwina once again tapped into her parents’ line of credit to purchase $275 worth of cooking supplies. One of the problems they noticed was that sometimes students would place calls to order a sandwich package, but the phones were busy. Edwina hired a fellow student to develop a website where students could place an order and select the time that they would like a sandwich package to be delivered. The cost of creating and operating this website for this third trimester was $300.

This last semester of Edwina’s freshman year proved to be the most successful in terms of sales. They were able to fulfill orders for 1,105 sandwich packages, generating revenue of $5,525. Edwina determined that the direct cost of food for these sandwich packages came out to be $2,928.25. The direct cost of paper supplies was $165.75. At the end of her freshman year, Edwina repaid her parents the $425 that came from her credit line that was used to purchase the Panini makers and the cooking utensils.

  1. Prepare balance sheets for the end of each semester. (unfortunately there is no graphic to it)

Solutions

Expert Solution

I
Balance Sheet                                        1                                    2                                  3
Non-Current Assets
Refrigerator                                1,000                            1,000                          1,000
Supplies                                      25                                  24                              134
(180-80-75) (25+100-101) (24+275-165)
Panini Grils                                       -                                  150                              150
Inventory                                      50                                130                                50
(1710-1660) (50+2100-2020) (130-80)
                               1,075                            1,304                          1,334
Current Assets
Cash                                1,030                            2,087                          3,029
(500-180+3200-1710-750-30) (1030+-100+4040-2100-750-33) (2087+-300+5525-2928-900-425-30)
                               1,030                            2,087                          3,029
Total Assets                                2,105                            3,391                          4,363
Current Liabilities
Provison for Tax                                    212                                609                          1,002
                                   212                                609                          1,002
Net Current Assets                                    818                            1,478                          2,027
Total assets less current liabilities                                1,893                            2,782                          3,361
Non-Current liabilities
Loan Payable                                1,000                            1,150                          1,000
(1000+150) (1150++275-425)
Total Net Assets                                    893                            1,632                          2,361
Capital and Reserves
Capital                                    500                                500                              500
Retained Profit                                    393                            1,132                          1,861
(393+738) (393+738+729)
Equity                                    893                            1,632                          2,361
Profit and Loss Account
Sales                                3,200 4040 5525
Less Cost of Sales                              -1,740                          -2,121                        -3,173
(1660+80) (2020+101) (80+2928+165)
Gross Profit                                1,460                            1,919                          2,352
Less Adverting Expense                                    -75                                   -  
Less Fees                                  -750                              -750                            -900
(250*3) (250*3) (300*3)
Less Interest                                    -30                                -33                              -30
(1000*3%) (1000*3%+150*2%) (1000*3%)
Less Website                            -300
Net Profit before Tax                                    605                            1,136                          1,122
Less: Tax(35%)                                  -212                              -398                            -393
Net Profit                                    393                                738                              729

Related Solutions

Prepare balance sheets for end of each semester. Edwina Haskell was an accomplished high school student...
Prepare balance sheets for end of each semester. Edwina Haskell was an accomplished high school student who looked forward to attending Southern New England University (SNEU). SNEU was unique in that it operated on a trimester basis, its policy was to actively foster independent development among the students. Edwina’s mother and father each own their own small businesses. Soon after freshman orientation at SNEU, Edwina recognized a need among the students that could be the basis for developing a small...
Consider a high school student who is given $3 every school day by her parents as...
Consider a high school student who is given $3 every school day by her parents as “lunch money”. The student works a part time job after school, earning a small amount of “spending cash”. In addition to her lunch money, the student spends $5 from her own earnings each week on lunch. Suppose her parents reduced her lunch money by $2 per day but that she simultaneously receives a $10 per week raise at her job, requiring no extra effort...
A loan company wants to design a database to track student loans. Each student attending school...
A loan company wants to design a database to track student loans. Each student attending school is eligible for a loan. A student may have more than one loan. A student may be registered, possibly at different times, in more than one school. Each loan should belong to only one bank. Each bank can approve as many loans as it desires. For each loan, the loan company will track: the student’s SSN, name, address, amount of loan, date of the...
A loan company wants to design a database to track student loans. Each student attending school...
A loan company wants to design a database to track student loans. Each student attending school is eligible for a loan. A student may have more than one loan. A student may be registered, possibly at different times, in more than one school. Each loan should belong to only one bank. Each bank can approve as many loans as it desires. For each loan, the loan company will track: the student’s SSN, name, address, amount of loan, date of the...
We are interested in studying the effects of attending a private high school on the probability...
We are interested in studying the effects of attending a private high school on the probability of attending college. For concreteness, let college be a binary variable equal to one if a student attends college, and zero otherwise. Let PrivateHS be a binary variable equal to one if the student attends a private high school. A linear probability model is: college=B0+B1PrivateHS+other factors+u where the other factors include gender, race, family income, and parental education. (v) Propose an alternative instrument for...
CJ is a 16-year-old high school student who is in the clinic for a sports physical...
CJ is a 16-year-old high school student who is in the clinic for a sports physical prior to beginning basketball practice. He has no known significant medical history, takes no medications, and has no allergies. Subjective data reveal only that CJ is short of breath earlier than most boys on the team. He attributes this to needing to get into better physical condition. The physical is unremarkable except for a grade III systolic murmur heard over the entire precordium. An...
Briefly explain to a high school student who has just finished their first year of biology...
Briefly explain to a high school student who has just finished their first year of biology why antibiotics can have harmful as well as have helpful effects.
Assume that the alternative to attending college was to work right after high school. Find the...
Assume that the alternative to attending college was to work right after high school. Find the average wage of someone with a high school diploma, but keep in mind that the opportunity costs include only the income you are losing, so if you currently work part-time then the opportunity costs = Income working full time – Income working part-time. Be sure to explicitly state your assumptions. What is the Present Values of costs and benefits?
Compare and contrast the regional differences (New England, Mid Atlantic, and southern) in the colonial economy...
Compare and contrast the regional differences (New England, Mid Atlantic, and southern) in the colonial economy of British North America between 1607 and 1750. What factors account for such divergent experiences? Please be specific.
In a certain high school, uniforms are optional. A study shows that high school students who...
In a certain high school, uniforms are optional. A study shows that high school students who wear uniforms have a lower grade average than students who don't wear uniforms. From this study, the school administration claims that they should not require the students to wear uniforms because that is the cause of the lowering grades. Another possible explanation is that students who wear uniforms are poorer than the students who don't wear uniforms and the economic situation of their parents...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT