Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Instructions
Learning Objectives:
- Describe the purpose and contents of the income statements and balance sheets.
- Prepare Income Statements and Balance Sheets for a hypothetical business.
Prompt:
Review Lesson 3 and its resources, as well as Chapter 9, Accounting and Cash Flow of your textbook Small Business Management in the 21st Century
Read the following situation then complete the three (3) financial statement items below.
9.2 Financial Accounting Statements – Exercises from Chapter 9, Accounting and Cash Flow of your textbook Small Business Management in the 21st Century
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.
Instructions & Deliverables:
- Develop an Excel spreadsheet with one tab for each of the three (3) statements within the same spreadsheet document.
- Prepare a beginning balance sheet for the first day of Edwina’s business (Statement #1).
- Prepare an income statement for the end of each trimester (Statement #2).
- Prepare a balance sheet for the end of each semester (Statement #3).
- NOTE: Please make sure you use the spreadsheet formulas for evidence of your calculations. See these two (2) Excel video tutorials that show you how to create a balance sheet and how to develop your formulas. Use this same process for developing your Income Statements and even a Cash Flow Statement if you wish.
https://youtu.be/XzXL2dx7G34
https://youtu.be/sWIcSMICFSk
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow