Managerial accounting (SUM) problem 3 (for 20 credits) A company manufactures and sells a product, which...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Managerial accounting (SUM) problem 3 (for 20 credits) A company manufactures and sells a product, which has seasonal variations in demand with a peak in the third quarter. The following is given: a) During the second year and two quarters of the third year they plan to sell 40, 60, 100, 50, 70, 80 thousands of items at unit price $8. b) 75% of sales are collected in the quarter the sales are made, and the remaining 25% in the following quarter. On January 1, year 2, the balance sheet shows $65,000 in accounts receivable. e) The ending inventory of finished goods should cover 30% of the budgeted sales for the next quarter. On December 31, yearl, company had 12,000 units on hand. d) Three pounds of raw materials are needed to produce a single unit. The ending inventory of raw materials should be at 10% of the budgeted production for the next quarter. On December 31, yearl, company had 13,800 pounds of materials on hand. e) The raw materials cost $0.80 per pound. Purchases of raw materials are paid for in the following way: 60% in the quarter the purchase is made, the remaining 40% in the following quarter. On January 1, year 2, the balance sheet showed $81,500 in accounts payable. f) It takes 12 minutes to produce a single item and cost of labor hour is $8. g) Predetermined overhead rate is $0.5 per labor hour, fixed manufacturing overhead is $40,000 per quarter and depreciation of machines $8000. h) Selling and administrative costs are planned to be $0.1 variable per unit, $20000 advertising, $24000 salaries and $6000 depreciation per quarter. i) The company has $50 000 in cash at the beginning of the year. It will invest $40 000, $50 000, $30 000, $30 000 in equipment in consecutive quarters. In each quarter $60 000 should be paid out as dividends. The company can borrow short-term at 10%. j) The land is worth $80 000, buildings and equipment $700 000 with accumulated depreciation $200 000. Equity is $300 000. Prepare: 1. The sales budget and the schedule of expected cash collections. 2. The production budget. 3. The direct materials purchases budget with a schedule of expected cash payments. 4. The direct labor budget. 5. The manufacturing overhead budget. 6. The calculation of the cost of finished goods per unit. Find the final worth of finished goods inventory. 7. The budget for selling and administrative expenses. 8. The cash budget. 9. The pro-forma income statement for year 2. 10. The balance sheet at the end of year 2, if the following is given: Balance sheet - beginning of year 2 Cash $ 50 000 A/P S 81 500 A/R $ 65 000 Equity $ 300 000 Inventory: RE $ 381 153 raw materials $ 11040 finished goods $ 56 613 Land $ 80 000 Building & equipment $ 700 000 Less: Accum. depreciation $ 200 000 Total $ 762 653 Total $ 762 653 Managerial accounting (SUM) problem 3 (for 20 credits) A company manufactures and sells a product, which has seasonal variations in demand with a peak in the third quarter. The following is given: a) During the second year and two quarters of the third year they plan to sell 40, 60, 100, 50, 70, 80 thousands of items at unit price $8. b) 75% of sales are collected in the quarter the sales are made, and the remaining 25% in the following quarter. On January 1, year 2, the balance sheet shows $65,000 in accounts receivable. e) The ending inventory of finished goods should cover 30% of the budgeted sales for the next quarter. On December 31, yearl, company had 12,000 units on hand. d) Three pounds of raw materials are needed to produce a single unit. The ending inventory of raw materials should be at 10% of the budgeted production for the next quarter. On December 31, yearl, company had 13,800 pounds of materials on hand. e) The raw materials cost $0.80 per pound. Purchases of raw materials are paid for in the following way: 60% in the quarter the purchase is made, the remaining 40% in the following quarter. On January 1, year 2, the balance sheet showed $81,500 in accounts payable. f) It takes 12 minutes to produce a single item and cost of labor hour is $8. g) Predetermined overhead rate is $0.5 per labor hour, fixed manufacturing overhead is $40,000 per quarter and depreciation of machines $8000. h) Selling and administrative costs are planned to be $0.1 variable per unit, $20000 advertising, $24000 salaries and $6000 depreciation per quarter. i) The company has $50 000 in cash at the beginning of the year. It will invest $40 000, $50 000, $30 000, $30 000 in equipment in consecutive quarters. In each quarter $60 000 should be paid out as dividends. The company can borrow short-term at 10%. j) The land is worth $80 000, buildings and equipment $700 000 with accumulated depreciation $200 000. Equity is $300 000. Prepare: 1. The sales budget and the schedule of expected cash collections. 2. The production budget. 3. The direct materials purchases budget with a schedule of expected cash payments. 4. The direct labor budget. 5. The manufacturing overhead budget. 6. The calculation of the cost of finished goods per unit. Find the final worth of finished goods inventory. 7. The budget for selling and administrative expenses. 8. The cash budget. 9. The pro-forma income statement for year 2. 10. The balance sheet at the end of year 2, if the following is given: Balance sheet - beginning of year 2 Cash $ 50 000 A/P S 81 500 A/R $ 65 000 Equity $ 300 000 Inventory: RE $ 381 153 raw materials $ 11040 finished goods $ 56 613 Land $ 80 000 Building & equipment $ 700 000 Less: Accum. depreciation $ 200 000 Total $ 762 653 Total $ 762 653
Expert Answer:
Related Book For
Financial Management Principles and Applications
ISBN: 978-0134417219
13th edition
Authors: Sheridan Titman, Arthur J. Keown, John H. Martin
Posted Date:
Students also viewed these accounting questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Prove that the function x2 x - 1 | f (x) = x 1)(x 2) is differentiable for all r E (-0, 1) U (1, 2) U (2, ). - |
-
Methoprene (marketed as Precor), an insect juvenile hormone mimic used in flea control products for pets, works by preventing the development of flea eggs and larvae. The effective form of...
-
Consider the list of individual 3NF relations below. These relations were developed from several separate normalization activities. PATIENT(Patient_ID,Room_Number,Admit_Date,Address)...
-
Journal entries for both buyer and seller periodic inventory system Non- GST version (a) Prepare general journal entries to record the following transactions (i) for Esther Ltd and (ii) for Barton...
-
On January 1, 2015, Universe of Fun issues $900,000, 8% bonds that mature in 10 years. The market interest rate for bonds of similar risk and maturity is 9%, and the bonds issue for $841,464....
-
Show work in terms of time lines or formulas ( No Excel) 4. A investment project generates the following incremental cash inflows over the next 5 years, C = $1.5 million, C = $1.3 million, C3 = $1...
-
Timothy is a 16-year-old whose mother brought him to the emergency room because of an asthma attack. He says he feels short of breath, but when you listen to his lungs, you hear no wheezing. 1. Does...
-
1. Let F : L(R) L(R) be the Fourier transform. That is: 1 (2) n/2 Prove that the spectrum o(F) = {-1, 1, i, -i}. F(f): = L Rn -i (x,x) f(x) dx .
-
Why are quest narratives told? _ What purpose do they serve in different societies? How can our own lives be viewed in terms of a quest narrative? How can an individual mature and change through...
-
katie received 1200 from her mother today she put that money in investment account that yields 12 percent per year semiannually compunding she plan to invest additional 800 and 600 in the next 3 and...
-
IHRMs have unique challenges when it comes to managing an international assignment portfolio.1 Types of International Assignees and thoroughly address each of the following three items: Describe the...
-
How can scholars study ethical leadership when the subject is a term with different definitions?
-
Read Mark Twains The War Prayer: Rhetorical Analysis and write a paper about it
-
SBS Company have received a contract to supply its product to a Health Care Service Hospital. The sales involve supplying 1,250 units every quarter, the sales price is RM 85 per unit. The Client...
-
One growing concern regarding the U.S. economy is the inequality in the distribution of income. The data in Table 1 represent the distribution of household income for various levels of income in...
-
One growing concern regarding the U.S. economy is the inequality in the distribution of income. An economist wants to know if the distribution of income is changing, so she randomly selects 1500...
-
Test whether \(\mu_{1}
Study smarter with the SolutionInn App