ACT 325 Portfolio Project Description Your portfolio project is due by the end of Week 8. Please complete the following seven problems based on the serial problem presented in the textbook beginning with Chapter 13. You are encouraged to use the working papers to create your answers. Please make sure to cite all sources that support your overall conclusions. You should paste any required Excel tables and type your answers into a Microsoft Word document clearly labeling label each problem. Problem 1 Santana Rey created Business Solutions on October 1 2011. The company has been successful and Santana plans to expand her business. She believes that an additional $86 000 is needed and is investigating these funding sources. Santana’s sister Cicely is willing to invest $86 000 in the business as a common shareholder. Since Santana currently had about $129 000 invested in the business Cicely’s investment will mean that Santana will maintain about 60% ownership and Cicely will have 40% ownership of Business Solutions. Santana’s Uncle Marcello is willing to invest $86 000 in the business as a preferred stockholder. Marcello would purchase 860 shares of $100 par value 7% preferred stock. Santana’s banker is willing to lend her $86 000 on a 7% 10-years not payable. She would make monthly payments of $1 000 per month for 10 years. Questions: 1. Prepare the journal entry to reflect the initial $86 000 investment under each of the options (a) (b) and (c). 2. Evaluate the three proposals for expansion providing the pros and cons of each option. 3. Which option did you recommend Santana adopt? Explain. Problem 2 While reviewing the March 31 2012 balance sheet of Business Solutions Santana Rey notes that the business has built a large cash balance of $68 057. Its most recent bank money market statement shows that the funds are earning an annualized return of 0.75% so Rey decided to make several investments with the desire to earn a higher return on the idle cash balance. Accordingly in April 2012 Business Solutions makes the following investments in trading solutions: April 16 – Purchase 400 shares of Johnson & Johnson at $50 per share plus $300 commission. April 30 – Purchase 200 shares of Starbucks Corporation at $22 per share plus $250 commission. Questions: Prepare journal entries to record the April purchases of trading securities by Business Solutions. On June 30 2012 the per share market price (fair value) of the Johnson & Johnson shares is $55 and the Starbucks shares is $19. Prepare the adjusting entry to record any necessary fair value adjustment to its portfolio of trading securities. Problem 3 Use the following selected data from Business Solutions’ income statement for the three months ended March 31 2012 and from its March 31 2012 balance sheet to complete the requirements before computer services revenue $25 307; net sales (of goods) $18 693; total sales and revenue $44 000; cost of goods sold $14 052; net income $18 833; quick assets $90 924; current assets $95 568; total assets $120 268; current liabilities $875; total liabilities $875 and total equity $119 393. Questions: Compute the gross margin ratio (both with and without services revenues) and net profit margin ratio. Compare the current ratio and acid-test ratio. Compute the debt ratio and equity ratio. What percent of its assets are current? What percent are long term? Problem 4 The computer workstation furniture manufacturing that Santana Rey started January is progressing well. As of the end of June Business Solutions’ job cost sheets show the following total costs accumulated on three furniture jobs. Job 6.02 Job 6.03 Job 6.04 Direct materials $1500 $3300 $2700 Direct labor 800 1420 2100 Overhead 400 710 1050 Job 6.02 was started in production in May and these costs were assigned to it in May: direct materials $600; direct labor $180; and overhead $90. Job 6.03 and 6.04 were started in June. Overhead costs is applied with a predetermined rate based on direct labor costs. Jobs 6.02 and 6.03 are finished in June and Job 6.04 is expected to be finished in July. No raw materials are used indirectly in June. (Assume this company’s predetermined overhead rate did not change over three months). Questions: What is the cost of the raw materials used in June for each of the three jobs and in total? How much total direct labor cost is incurred in June? What predetermined overhead rate is used in June? How much cost is transferred to finished goods inventory in June? Problem 5 After reading an article about activity-based costing in a trade journal for the furniture industry Santana Rey wondered if it was time to critically analyze overhead costs at Business Solutions. In a recent month Rey found that setup costs inspection costs and utility costs made up most of its overhead. Additional information about overhead follows: Activity Cost Driver Setting up machines $20 000 25 batches Inspecting components $7 500 5 000 parts Providing utilities $10 000 5 000 machine hours Overhead has been applied to output at a rate of 50% if direct labor costs. The following data pertain to Job 6.15. Direct materials $2500 Number of Parts 400 parts Direct labor $3500 Machine Hours 600 machine hours Batches 2 batches Questions: What is the total cost of Job 6.15 if Business Solutions applies overhead at 50% of direct labor cost? What is the total cost of job 6.15 is Business Solutions uses activity based costing? Which approach to assigning overhead gives a better representation of the costs incurred to produce Job 6.15? Explain. Problem 6 Santana Rey expects second quarter 2012 sales of her new line of computer furniture to be the same as the first quarter sales (reported below) without any changes in strategy. Monthly sales averaged 40 desk units (sales price of $1 250) and 20 chairs (sales price of $500). .0/msohtmlclip1/01/clip_image002.jpg”> Business Solutions .0/msohtmlclip1/01/clip_image004.jpg”> Segment Income Statement* .0/msohtmlclip1/01/clip_image004.jpg”> For Quarter Ended March 31 2012 .0/msohtmlclip1/01/clip_image005.gif”>.0/msohtmlclip1/01/clip_image006.gif”>.0/msohtmlclip1/01/clip_image007.gif”>.0/msohtmlclip1/01/clip_image008.gif”>.0/msohtmlclip1/01/clip_image009.gif”> Sales † $180 000 Cost of goods sold‡ 115 000 Gross Profit 65 000 Expenses Sales commissions (10%) 18 000 Advertising expenses 9 000 Other fixed expenses 18 000 Total expenses 45 000 Net income $20 000 .0/msohtmlclip1/01/clip_image010.gif”>.0/msohtmlclip1/01/clip_image010.gif”> *Reflect revenue and expense activity only related to the computer furniture segment. †Revenue: (120 desks X $1 250) (60 chairs X $500) = $150 000 $30 00 $180 000 ‡ Cost of goods sold: (120 chairs C $750) (60 chairs X $250) $10 000 = $115 000 Santana Rey believes that sales will increase each month for the next three months (April – 48 desks 32 chairs: May – 52 desks 35 chairs: June – 56 desks 38 chairs) if selling prices are reduced to $1 150 for desks and $450 for chairs and advertising expenses are increased by 10% and remain at that level for all three months. The products’ variable cost will remain at $750 for desks and $250 for chairs. The sales staff will continue to earn a 10% commission the fixed manufacturing costs per month will remain at $10 000 and other fixed expenses will remain at $6 000 per month. Questions: Prepare budgeted income statements for each of the months of April May and June that show the expected results from implementing the proposed changes. Use a three-column format with one column for each month. Use the budgeted income statements from part 1 to recommend whether Santana Rey should implement the proposed changes. Explain. Problem 7 Santana Rey is considering the purchase of equipment for Business Solutions that would allow the company to add a new product to its computer furniture line. The equipment is expected to cost $300 000 and to have a six-year life and no salvage value. It will be depreciated on a straight line basis. Business Solutions expects to sell 100 units of the equipment’s products each year. The expected annual incomes related to this equipment follows. Sales $375 000 Costs Materials labor and overhead (except for depreciation) 200 000 Depreciation of new equipment 50 000 Selling and administrative expenses 37 500 Total costs and 287 500 expenses Pretax income 87 500 Income taxes (30%) 26 250 Net income $61 250 Question: Compute the (1) payback period and (2) accounting rate of return for this equipment. (Record answers as percents rounded to one decimal.) Submit your portfolio project through the assignment link by Sunday midnight of Week 8.
