Raspberry Jam Strawberry Jam Raspberry Pints Strawberry Quarts Unit sales over the past year were downloaded...

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?

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