Raspberry Jam Strawberry Jam Raspberry Pints Strawberry Quarts Unit sales over the past year were downloaded...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Raspberry Jam Strawberry Jam Raspberry Pints Strawberry Quarts Unit sales over the past year were downloaded from Lina's database and are in the Excel sheet "Sales", as are the prices. Additionally, she has sold 50 strawberry jams to a local coffee shop, but they have not yet paid their invoice. The farm is rather simple. Lina owns the land (worth $9,859) as well as a building where she produces the jam (worth $3,200). She purchased a new canning machine for use this year for $5,000 and expects it to have a 10-year lifespan. Her irrigation equipment, which was purchased for $10,000, is 3 years old and has an annual depreciation rate of $1,000. She took out a loan several years ago from her local Farm Credit agency, which has a remaining principal of $16,960 after her $2,000 principal repayment and $800 Interest payment this year. For fruit production, plants cost $6,000, mulch is $3,000, labor is $5,000, water for irrigation is $2,200, pesticides are $1,500 and packaging is $155. For jam, her annual sugar expenses are $3,000, water costs $2,000 and labor is an additional $1,000. Her jam jars cost $2,200 and she must pay an annual $200 fee to sell at the farmers' market in town. Additional miscellaneous costs of $25,000 include rent, utilities, promotions, her business license and insurance costs. She additionally has $8,000 in savings from last year. Any profits remaining will be directly reinvested into the business (note: this is often referred to as "retained earnings", after paying off shareholders, but as Lina's farm is organized as a sole proprietorship it simply goes into her personal account). Prices $8 $8 $5 $7 1) Create a well-formatted bar chart (with two bars) for Strawberry and Raspberry fruit sales by month (in dollars), then for Strawberry and Raspberry Jam sales by month (in dollars). Copy this into Word and provide a brief description. Do you see any trends? 2) Complete Lina's Income Statement, Balance Statement and Cash Flow statement, putting the below values in the correct position on the statements. Create a well-formatted table with the following values and copy into Word. Provide a brief explanation/interpretation of each value in your own words. It should be clear from this explanation that you understand the definition of each term. a. Total Revenue b. Total Cost of Goods Sold Total Farm Expenses d. Total Earnings Before Interest, Taxes, Depreciation and Amortization (EBITDA) e. Net Earnings f. Total Assets g. Total Liabilities h. Equity/Net Worth L Net Cash from Operations I j. Total Cash and Cash equivalents 3) Explain the following values in the tables using your own words. a. What does the Savings value under Current Assets represent b. What does the New Canning Machine value of $4,500 under Fixed Assets represent C. What does the Accounts Receivable value of $300/-$300 represent? Raspberry Jam Strawberry Jam Raspberry Pints Strawberry Quarts Unit sales over the past year were downloaded from Lina's database and are in the Excel sheet "Sales", as are the prices. Additionally, she has sold 50 strawberry jams to a local coffee shop, but they have not yet paid their invoice. The farm is rather simple. Lina owns the land (worth $9,859) as well as a building where she produces the jam (worth $3,200). She purchased a new canning machine for use this year for $5,000 and expects it to have a 10-year lifespan. Her irrigation equipment, which was purchased for $10,000, is 3 years old and has an annual depreciation rate of $1,000. She took out a loan several years ago from her local Farm Credit agency, which has a remaining principal of $16,960 after her $2,000 principal repayment and $800 Interest payment this year. For fruit production, plants cost $6,000, mulch is $3,000, labor is $5,000, water for irrigation is $2,200, pesticides are $1,500 and packaging is $155. For jam, her annual sugar expenses are $3,000, water costs $2,000 and labor is an additional $1,000. Her jam jars cost $2,200 and she must pay an annual $200 fee to sell at the farmers' market in town. Additional miscellaneous costs of $25,000 include rent, utilities, promotions, her business license and insurance costs. She additionally has $8,000 in savings from last year. Any profits remaining will be directly reinvested into the business (note: this is often referred to as "retained earnings", after paying off shareholders, but as Lina's farm is organized as a sole proprietorship it simply goes into her personal account). Prices $8 $8 $5 $7 1) Create a well-formatted bar chart (with two bars) for Strawberry and Raspberry fruit sales by month (in dollars), then for Strawberry and Raspberry Jam sales by month (in dollars). Copy this into Word and provide a brief description. Do you see any trends? 2) Complete Lina's Income Statement, Balance Statement and Cash Flow statement, putting the below values in the correct position on the statements. Create a well-formatted table with the following values and copy into Word. Provide a brief explanation/interpretation of each value in your own words. It should be clear from this explanation that you understand the definition of each term. a. Total Revenue b. Total Cost of Goods Sold Total Farm Expenses d. Total Earnings Before Interest, Taxes, Depreciation and Amortization (EBITDA) e. Net Earnings f. Total Assets g. Total Liabilities h. Equity/Net Worth L Net Cash from Operations I j. Total Cash and Cash equivalents 3) Explain the following values in the tables using your own words. a. What does the Savings value under Current Assets represent b. What does the New Canning Machine value of $4,500 under Fixed Assets represent C. What does the Accounts Receivable value of $300/-$300 represent?
Expert Answer:
Answer rating: 100% (QA)
2 Income Statement Balance Statement and Cash Flow Statement a Total Revenue This represents the total amount of money earned from sales of goods or services It includes revenue from fruit sales jam s... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Write a literature review for your study. See below for an example of a literature review. Your literature review should provide both analysis and synthesis of previous studies as related to the...
-
Hyten Corporation On June 5, 1998, a meeting was held at Hyten Corporation, between Bill Knapp, Director of Marketing/Sales, and John Rich, director of engineering. The purpose of the meeting was to...
-
Line A: y = 3 0.6x Line B: y = 4 x a. Graph the linear equations and data points. b. Construct tables for x, y, Ëy, e, and e 2 similar to Table 4.4 on page 151. c. Determine which line fits the...
-
Identify and briefly explain the limitations of financial statement analysis.
-
Statistics students were asked to ll a one-cup measure with raisin bran, tap the cup lightly on the counter three times to settle the contents, if necessary add more raisin bran to bring the contents...
-
\({ }^{15} \mathrm{O}\) and \({ }^{131} \mathrm{I}\) are isotopes used in medical imaging. \({ }^{15} \mathrm{O}\) is a BIO beta-plus emitter, \({ }^{131}\) I a beta-minus emitter. What are the...
-
Classification of Income Statement Items As audit partner for Grupo and Rijo, you are in charge of reviewing the classification of unusual items that have occurred during the current year. The...
-
Provide an analysis of how the minimum wage is likely to affect the market for low-skilled workers. To make the analysis easier, assume that all markets are perfectly competitive and there is no...
-
What are the range of issues around controlling environmental pollution (land, air, water, biodiversity and waste) through private civil law (tort law) and criminal regulatory law? How can one answer...
-
On December 2, Amram Pizza had a cash-in-bank balance of $7,000. During the month of December, Amram Pizza wrote checks totaling $4,800. Two-thirds of this amount was used to purchase a computer for...
-
Decker Company assigns some of its patents to other enterprises under a variety of licensing agreements. In some instances advance royalties are received when the agreements are signed, and in...
-
Organizational Competencies: Use the SOAR analysis framework to identify opportunities and set result-oriented aspirations based on the strengths of Molson Coors Brewing Company. Analyze and Identify...
-
Jessica is having a bonfire at her house. She wants to have enough s'mores so that all five of her friends can each have two. If each s'more takes one piece of chocolate and each chocolate bar has 4...
-
choose an area relevant to your area of training in the Tourism, Hospitality and Events Industry. This may include Accommodation Services, Front Office, Cookery, Food and Beverage, Tourism or Events....
-
For each of the following, write down the limit that is used to represent the derivative. Then simplify the expression in order to evaluate the limit. a. Use limit definition of derivative to find...
-
In Exercises 1-2, rewrite each verbal statement as an equation. Then decide whether the statement is true or false. Justify your answer. 1. The logarithm of the difference of two numbers is equal to...
-
Carr Orthotics Company distributes a specialized ankle support that sells for $30. The company's variable costs are $18 per unit; fixed costs total $360,000 each year. Required a. If sales increase...
-
Voss Visuals produces tablets and books. Total overhead costs traditionally have been allocated on the basis of direct labor hours. After implementing activity-based costing, managers determined the...
-
Dakota Williams is one of Texas's premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Dakota has prepared the...
-
Summer and winter constellations are different because (a) of the spin of Earth about its polar axis. (b) the night sky faces in opposite directions in summer and winter. (c) of the tilt of Earths...
-
The longest-lived stars are those of (a) low mass. (b) high mass. (c) intermediate mass. (d) infinite mass.
-
What is the star nearest Earth? (a) Proxima Centauri (b) Polaris (c) Mercury (d) the Sun
Study smarter with the SolutionInn App