Prepare an budgeted income statement for 2007

17:03 . 4G A .. . A B C D E F Katrina's Kids N 3 Sales (bracelets) 570,000 $12.00 4 Selling Price Fixed Selling & Admin Expenses $986,000.00 5 (includes depreciation of $36,000) Commissions (as % of Sales $$$) 5.00% 7 Shipping (as % of Sales $$$) 3.00% 8 Variable Manufacturing Costs (per bracelet): Direct Materials $4.00 Direct Labor $1.00 10 $2.00 11 Variable Overhead Fixed Manufacturing Costs (total, includes $180,000.00 12 depreciation of $60,000) 13 Total Production (bracelets) 600,000 14 51,000 December's Production (bracelets) 15 Inventory Summary:(bracelets) 16 Finished Goods Inventory, Jan 1 21,000 17 Finished Goods Inventory, Dec 31 51,000 18 19 Budgeted cash balance, Dec 31 $50,000 20 Katrina's Kids 21 Statement of Cost of Goods Manufactured & 22 Sold Year Ended December 31, 2006 23 Cost of Goods Manufactured: 24 Direct Materials $2,400,000.00 25 Direct Labor 600,000.00 26 Variable Overhead 1,200,000.00 27 Fixed Manufacturing Cost 180.000.00 $4,380,000.00 28 Add: 29 Finished Goods Inventory Jan 1 198.000.00 30 Total Available for Sale $4,578,000.00 31 Less: Finished Goods Inventory Dec 31 (372.300.00) 32 Cost of Goods Sold $4 205.700.00 33 34 35 Income Statement: Year Ended December 31, 2006 $6,840,000.00 36 Sales less: Cost of Goods Sold (4,205. 700.00) 37 Gross Margin $2,634,300.00 38 Fixed Selling & Admin Expense (986,000 .00) 39 Variable Selling & Admin Expense (547.200.00) 40 Surplus $1.101,100,00 41 42 43 44 45 46 47 48 49 50 51 52 53 54 E 2006 Statements Q1) Produ +17:04 .1 4GO Case #3 - Katrina Kids-1.docx KATRINA'S KIDS Katrina's Kids is a non-profit formed in the aftermath of the fury that hit the New Orleans area in August 2005. The mission of this organization is to make library grants to schools in any of the areas hit by Hurricane Katrina. Funds are being raised through the manufacture and sale of popular beaded bracelets to retailers throughout the U.S. Katrina 's Kids hopes to spread word of the disastrous impact on education for these children by advertising their mission via store displays. In the current year, 2006, Katrina's Kids (KK) anticipates a surplus of $1, 100,000 based upon sales of $6,840,000. Given a very successful first year with little effort, key members of the management team feel that they can expand the market significantly if they could use a publicity campaign that would make written materials more available throughout the nation. This would increase selling and administrative expenses by $125,000, however it is believed that this will result in a 17% increase in bracelet sales in 2007. This bump in sales could be realized at a critical time as KK. plans to begin disseminating funds sometime during the next year. Other proposed changes for 2007 include changes in the stringing process that would result in variable manufacturing overhead of $1.95/bracelet. This major change would cost approximately $500,000 for machinery, which is expected to have a useful life of 10 years. Management believes that this machinery would serve to increase factory capacity from 750,000 units to 1,100,000 units. KK would purchase this machinery in the first quarter (January) of 2007 and pay for it in March. All bracelets are sold to retail outlets on credit. Collections for bracelets are typically made as follows: 50% in the month of sale and 50% in the month following the month of sale. Depreciation is computed using the straight-line method and, a full year of depreciation will be taken in the first year. Cash disbursements for raw materials are made in the month after the purchase. Other expenses are paid for as incurred. KK keeps a supply of bracelets on hand at the end of every month equivalent to one month's sales. Raw materials are purchased on an as needed basis, so at the end of the month there is no balance in raw materials inventory. Katrina's Kids Sales (bracelets) Selling Price Fixed Selling & Admin Expenses (includes depreciation of $36,000) Commissions (as % of Sales $$$) Shipping (as % of Sales $$$) Variable Manufacturing Costs (per bracelet): Direct Materials Direct Labor Variable Overhead Fixed Manufacturing Costs (total, includes depreciation of $60,000) Total Production (bracelets) December's Production (bracelets) Inventory Summary:(bracelets) Finished Goods Inventory, Jan 1 Finished Goods Inventory, Dec 31 Budgeted cash balance, Dec 31 570,000 $12.00 $986,000.00 5.00% 3.00% $4.00 $1.00 $2.0 $180,000 .00 600,000 51,000 21,000 $1 ,000 $50.000 Katrina's Kids Statement of Cost of Goods Manufactured & Sold Year Ended December 31, 2006 Cost of Goods Manufactured $2,400,000. Direct Labor Variable Overhead Fixed Manufacturing Cost Finished Goods Inventory Jan 1 Total Available for Sale $4,578,000.0 Less: Finished Goods Inventory Dec 31 (372,300.00) Cost of Goods Sold $4 205.700.00 Sales Income Statement: Year Ended December 31, 2006 $6,840,000.00 less: Cost of Goods Sold Gross Margin Fixed Selling & Admin Expense Variable Selling & Admin Expense Surplus (4,205, 700.00) $2,634,300.00 (986,000 .00) (547,200.00) $1.101,100,00 838 25 n Dashboard Calendar To Do Notifications Inbox