--- just need these parts!

Klandon Company manufactures decorative rocks for aquariums. Kim Klandon is preparing the budget for the quarter ended June 30. She has gathered the following information. 1. Klandon's sales manager reported that the company sold 12,000 bags of rocks in March. He has developed the following sales forecast. The expected sales price is $10 per bag. April 20,000 bags May 50,000 bags June 30,000 bags July 25,000 bags August 15,000 bags 2. Sales personnel receive a 5 percent commission on every bag of rocks sold. The following monthly fixed selling and administrative expenses are planned for the quarter. However, these amounts do not include the denreciation increase reulting from the hudoeted enuinment nurchase in luna (se nart 7) Variable Cost/Unit Monthly Fixed Selling and Administrative Coule $10,000 25.000 1,000 10,000 500 Depreciation Salaries of sales personnel Advertising Management salaries Miscellaneous Bad debts Total costs $0.50 0.50 $1.00 $46,500 3. The standard labor allowed for one bag of rocks is 15 minutes. The current direct labor rate is $10 per hour. 4. After experiencing difficulty in supplying customers in a timely fashion due to inventory shortages, the company established a policy requiring the ending finished goods inventory to equal 20 percent of the following month's budgeted sales, in units. On March 31, 4,000 bags were on hand. 5. Five pounds of raw materials are required to fill each bag of finished rocks. The company wants to have raw materials on hand at the end of each month equal to 10 percent of the following month's production needs. On March 31, 13,000 pounds of materials were on hand. 6. The raw materials used in production cost $0.40 per pound. Half of the month's purchases is paid for in the month of purchase, the other half, in the following month. No discount is available. 7. On June 1, the company plans to spend $48,000 to upgrade its office equipment that is fully depreciated. The new equipment is expected to have a five-year life, with no residual value. 8. The budgeted monthly variable and total fixed overhead are as follows. Variable overhead is based on the number of units produced. The fixed overhead budget is based on an annual production of 4 400.000 hags Fixed Monthly Overhead Variable Cost/Unit Depreciation $8.000 Indirect materials 1.000 S0.05 Indirect labor 10.000 0.20 Utilities 20,000 0.10 Property taxes 5,000 Maintenance 6.000 0.15 Total costs $50.000 $0.50 9. All sales are made on account. Historically, the company has collected 70 percent of its sales in the month of sale and 25 percent in the month following the sale. The remaining 5 percent of sales is uncollectible 10. Klandon must maintain a minimum cash balance of $30,000. An open line of credit at a local bank allows the company to borrow up to $175,000 per quarter in $1,000 increments 11. All borrowing is done at the beginning of the month, and all repayments are made at the end of a month in $1,000 increments. Accrued interest is paid only when principal is repaid. The interest rate is 12 percent per year. 12. A quarterly dividend of $49,000 will be declared and paid in April. 13. Income taxes payable for the first quarter will be paid on April 15. Klandon's tax rate is 30 percent. 14. The March 31 balance sheet is as follows: March 31 Cash $40,000 Accounts receivable 30.000 Finished goods inventory 26.000 Raw materials inventory 5.200 Plant & equipment 200,000 Accumulated Depreciation (50.000) Total geote $251 200 Depreciation Indirect materials Indirect labor Utilities Property taxes Maintenance Total costs $8.000 1.000 10.000 20,000 5,000 6.000 $50.000 $0.05 0.20 0.10 0.15 $0.50 9. All sales are made on account. Historically, the company has collected 70 percent of its sales in the month of sale and 25 percent in the month following the sale. The remaining 5 percent of sales is uncollectible. 10. Klandon must maintain a minimum cash balance of $30,000. An open line of credit at a local bank allows the company to borrow up to $175,000 per quarter in $1,000 increments. 11. All borrowing is done at the beginning of the month, and all repayments are made at the end of a month in $1,000 increments. Accrued interest is paid only when principal is repaid. The interest rate is 12 percent per year. 12. A quarterly dividend of $49,000 will be declared and paid in April. 13. Income taxes payable for the first quarter will be paid on April 15. Klandon's tax rate is 30 percent. 14. The March 31 balance sheet is as follows: March 31 Cash $40,000 Accounts receivable 30.000 Finished aoods inventory 26.000 Raw materials inventory 5.200 Plant & equipment 200,000 Accumulated Depreciation (50.000) Total assets $251.200 Accounts payable Income taxes payable Common stock Retained 3amnings Total liabilities and equities $12,000 50,000 52,000 137.200 $251..209 b. Prepare a pro forma income statement for the second quarter. Solve: Sales Cost of goods sold Gross profit Selling & administrative expense Operating income Interest expense Income before taxes Income tax expense (30%) Net income c. Prepare a pro forma balance sheet as of June 30. Solve: Cash A/R Finished Goods Raw Materials Inventory Property, Plant & Equipment Less: Accumulated Depreciation Total Assets A/P Income Taxes Payable Note Payable Common Stock Retained Earnings Total Liabilities & Equities