Eugene Brewing Company is budgeting for the next year. The following is the company's beginning balance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Eugene Brewing Company is budgeting for the next year. The following is the company's beginning balance sheet: Assets Cash Accounts receivable Inventory Total current assets Fixed assets Accumulated depreciation. Total Fixed Assets Net Total Assets Hops Yeast Sugar Bottles Hops Yeast Sugar Bottles EUGENE BREWING COMPANY BALANCE SHEET 12/31/2018 Material S 120,000 130,000 160,000 $ 410,000 The company expects to collect the beginning balance of accounts receivable in January. In general, 45% of the company's sales are on a cash basis. Of the credit sales, 40% are paid in the following month, and 60% are paid in the second month after the sale. Material 900,000 (300,000) 600,000 $1.010,000 The accounts payable at the beginning of the year must be paid in January. All materials are purchased on credit and paid for in the following month. The long-term debt has an annual interest rate of 12%. Interest payments of 1% of the principal are made each month. The long-term debt is not due for another five years. Eugene Brewing Company makes two different types of beer, an ale and a porter. The ale is a lighter beer that requires fewer ingredients than does the darker and heavier porter. The input requirements for a case of beer for each type of beer is as follow: Liabilities and Equities Accounts payable Long-term debt Total liabilities Common stock at par Additional paid-in Retained earnings Total Equity Total liabilities and equities For Making Ale Quantity per case 5 lb. 1 oz. 0.5 lb. 24 For Making Porter Quantity per case 10 lb. 1 oz. 0.8 lb. 24 $ 230,000 370,000 Cost $0.50/lb. 0.20/oz. 0.40/1b.. 0.20/bottle $ 600,000 $ 150,000 150,000 110,000 410,000 $1.010,000 Cost $0.50/lb. 0.20/oz. 0.40/lb. 0.20/bottle The labor to make a case of beer is the same for each type of beer, 0.20 hours at $20/hour. Labor is paid in the month earned. Monthly overhead expenses are paid in the month incurred and expected to be as follows: WALL 6/2004 Ale sells for $25 per case, and porter sells for $30 per case. Estimated sales (in cases) for Eugene Brewing to be as follows: a. Month b. Electricity Administrative Indirect labor Rent Depreciation January February March April C. Cases Ale $ 75,000 115,000 17,000 19,000 25,000 24,000 65,000 70,000 80,000 The beginning inventory includes 13,000 cases of ale and 12,000 cases of porter. The company prefers to have inventory at the end of each month equal to the expected sales in the next month. Eugene Brewing uses a first-in, first-out (FIFO) method of costing inventory. The company must buy a new bottling machine for $480,000 at the end of January. Estimate cash flows in each of the months. Does the company need to borrow money in any of the months? Make a balance sheet as of the end of March and an income statement for the first three months. Assume that the company borrows cash at an interest rate of 1% per month to make up any shortage of cash. Cases Porter 20,000 26,000 28,000 30,000 Eugene Brewing Company is budgeting for the next year. The following is the company's beginning balance sheet: Assets Cash Accounts receivable Inventory Total current assets Fixed assets Accumulated depreciation. Total Fixed Assets Net Total Assets Hops Yeast Sugar Bottles Hops Yeast Sugar Bottles EUGENE BREWING COMPANY BALANCE SHEET 12/31/2018 Material S 120,000 130,000 160,000 $ 410,000 The company expects to collect the beginning balance of accounts receivable in January. In general, 45% of the company's sales are on a cash basis. Of the credit sales, 40% are paid in the following month, and 60% are paid in the second month after the sale. Material 900,000 (300,000) 600,000 $1.010,000 The accounts payable at the beginning of the year must be paid in January. All materials are purchased on credit and paid for in the following month. The long-term debt has an annual interest rate of 12%. Interest payments of 1% of the principal are made each month. The long-term debt is not due for another five years. Eugene Brewing Company makes two different types of beer, an ale and a porter. The ale is a lighter beer that requires fewer ingredients than does the darker and heavier porter. The input requirements for a case of beer for each type of beer is as follow: Liabilities and Equities Accounts payable Long-term debt Total liabilities Common stock at par Additional paid-in Retained earnings Total Equity Total liabilities and equities For Making Ale Quantity per case 5 lb. 1 oz. 0.5 lb. 24 For Making Porter Quantity per case 10 lb. 1 oz. 0.8 lb. 24 $ 230,000 370,000 Cost $0.50/lb. 0.20/oz. 0.40/1b.. 0.20/bottle $ 600,000 $ 150,000 150,000 110,000 410,000 $1.010,000 Cost $0.50/lb. 0.20/oz. 0.40/lb. 0.20/bottle The labor to make a case of beer is the same for each type of beer, 0.20 hours at $20/hour. Labor is paid in the month earned. Monthly overhead expenses are paid in the month incurred and expected to be as follows: WALL 6/2004 Ale sells for $25 per case, and porter sells for $30 per case. Estimated sales (in cases) for Eugene Brewing to be as follows: a. Month b. Electricity Administrative Indirect labor Rent Depreciation January February March April C. Cases Ale $ 75,000 115,000 17,000 19,000 25,000 24,000 65,000 70,000 80,000 The beginning inventory includes 13,000 cases of ale and 12,000 cases of porter. The company prefers to have inventory at the end of each month equal to the expected sales in the next month. Eugene Brewing uses a first-in, first-out (FIFO) method of costing inventory. The company must buy a new bottling machine for $480,000 at the end of January. Estimate cash flows in each of the months. Does the company need to borrow money in any of the months? Make a balance sheet as of the end of March and an income statement for the first three months. Assume that the company borrows cash at an interest rate of 1% per month to make up any shortage of cash. Cases Porter 20,000 26,000 28,000 30,000
Expert Answer:
Answer rating: 100% (QA)
Calculation of production cost per case of beer for each type of beer Particulars Hops Yeast Sugar B... View the full answer
Related Book For
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these general management questions
-
A 30-year mortgage has an annual interest rate of 7.18 percent and a loan amount of $180,000. What are the monthly mortgage payments?
-
A 30-year mortgage has an annual interest rate of 6.84 percent and a loan amount of $250,000. What are the interest and principal for the 120th payment?
-
A 30-year mortgage has an annual interest rate of 7.42 percent and a loan amount of $200,000. What is the remaining balance at the 180th payment?
-
On average, which group of borrowers would have to pay a higher effective rate for its short-term loans, those who are required to put up collateral or those who are not? Explain.
-
List the three parts of a control system, and explain how such a system works.
-
A 0.4-m (15.7-in.) rod of a metal elongates 0.48 mm (0.019 in.) on heating from 20C to 100C (68F to 212F). Determine the value of the linear coefficient of thermal expansion for this material.
-
Eco-efficiency provides necessary but not sufficient indicators of environmental performance. What is environmental performance? Provide an example of another type of information that is important...
-
Comparative financial statement data of Rourke Optical Mart follow: Other information: 1. Market price of Rourke common stock: $78.12 at December 31, 2010, and $59.10 at December 31, 2009. 2. Common...
-
You are considering purchasing a house. You estimate that you can afford an $800,000 home, of which you will pay 20% in cash as the down payment and finance the remaining 80% with a 30-year loan with...
-
2. A double-spool turbofan engine is used to power an aircraft flying at speed of 250 m/s at an altitude of 11,000 m, where ambient temperature is -50C and pressure is 22.7 kPa. As shown below, the...
-
Products Liability has become a big issue in the news and courts. Is it fair to hold companies responsible when it is a small fraction of the products produced that cause consumers harm? Is there an...
-
The European Central Bank (ECB) is the central bank for the countries that participate in the European Monetary Unionthe euro area. a. The Euro system is composed of three distinct parts: i. The...
-
The quantity theory of money explains the link between inflation and money growth. a. The equation of exchange tells us that: i. The quantity of money times the velocity of money equals nominal GDP....
-
Read the Ideas in Action section in this chapter. Based on Mark Zuckerbergs comments and your own experiences, respond to the following questions: A. What are the reasons Zuckberg provides for...
-
Equilibrium output and inflation are determined by the intersection of the dynamic aggregate demand curve and either the short-run or long-run aggregate supply curve. a. The short-run equilibrium...
-
The aggregate supply curve tells us the amount of output producers are willing to supply at given levels of inflation. a. The short-run aggregate supply curve slopes up because, in the short run,...
-
Interpret the CFA of Ethics and Standards of Professional Conduct. In your opinion, does C. H. Robinson comply with this legislation? How do you know this to be true.
-
A new car sold for $31,000. If the vehicle loses 15% of its value each year, how much will it be worth after 10 years?
-
Carissa Communications reported the following figures from its adjusted trial balance for its first year of business, which ended on July 31, 2016: Cash............... $4,100 Selling...
-
Use the following information for a manufacturer to compute cost of goods manufactured and cost of goods sold: Ending s 26,000 34,000 22,000 Inventories: Raw Materials Work-in-Process Finished Goods...
-
The manager of Quick Car Inspection reviewed the monthly operating costs for the past year. The costs ranged from $4,400 for 1,400 inspections to $4,200 for 1,000 inspections. Requirements 1....
-
The kilogram force is commonly used in Europe as a unit of force. (As in the U.S. customary system, where \(1 \mathrm{lbf}\) is the force exerted by a mass of \(1 \mathrm{lbm}\) in standard gravity,...
-
The maximum theoretical flow rate (slug/s) through a supersonic nozzle is \[\dot{m}_{\max }=2.38 \frac{A_{t} p_{0}}{\sqrt{T_{0}}}\] where \(A_{t}\left(\mathrm{ft}^{2} ight)\) is the nozzle throat...
-
From thermodynamics, we know that the coefficient of performance of an ideal air conditioner \(\left(C O P_{\text {ideal }} ight)\) is given by \[C O P_{\text {ideal }}=\frac{T_{L}}{T_{H}-T_{L}}\]...
Study smarter with the SolutionInn App