Question

The Bank of the West has asked the president of Montoya Products, Inc., for a budgeted P4. income statement and budgeted balance sheet for the quarter ending June 30, 20x1 These documents will be used to support the company's request for a loan. A quarterly Budgeted Financial Statements LO 4 LO 6 master budget is routinely prepared by the company, so the president indicated that the requested documents would be forwarded to the bank. To date (April 2), the following operating budgets have been developed. Sales: April $220,400, May, $164,220, and June, $165,980; direct materlals purchases for the period, $96,840; direct materlals usage, $102,710; direct labor expenses, $71,460; manufacturing overhead, $79,940; selling and administrative expenses, $143,740; capital expenditures $125,000 (to be spent on June 29); cost of goods manufactured, $252,880; and cost of goods sold, $251,700. Balance sheet account balances at March 31, 20xl were: Cash, $28,770; Accounts Recelvable, $26,500; Direct Materials Inventory, $23,910; Work in Process Inventory, $31,620; Finished Goods Inventory, $36,220; Prepaid Expenses, $7,200; Plant, Furniture, and Flxtures, $498,600; Accumulated Depreciation, Plant, Furniture, and Flxtures, $141,162; Patents, $90,600; Accounts Payable, $39,600; Notes Payable, $105,500; Common Stock, $250,000; and Retained Earnings, $207,158. Monthly cash balances for the quarter are projected to be: April 30, $20,490; May 31, $35,610; and June 30, $45,400. During the quarter, accounts recelvable are supposed to Increase by 30 percent, patents will go up by $6,500, prepaid expenses wll remaln con- stant, accounts payable will go down by 10 percent, and the company will make a $5,000 payment on the note payable ($4,100 is princlpal reduction). The federal income tax rate is 34 percent and the second quarter's tax is pald in July. Depreciation for the quarter will be $6,420, which was already included in the manufacturing overhead budget. No div dends were pald. 1. Prepaie a budgeted income statement for the quarter ending June 30, 20x1. Round answers to the nearest dollar. REQURED 2. Prepare a budgeted balance sheet as of June 30, 20x1.

Answer 1

Answer with working notes is given below

Income Statement for the Quarter ended June 30 20x1 Sales $550,600 Cost of Goods Sold $251,700 Gross Profit $298,900 Less: Selling and administration expenses Selling and administration expenses $143,740 Interest on Notes payable $900 $144,640 Income before tax $154,260 Tax at 34% $52,448 Income after tax $101,812 2. Budgeted Balance Sheet as on June 30, 20x1 Current Assets Cash $45,400 Accounts Receivable $34,450 Direct Material Inventory $18,040 WIP $32,850 Finished Goods $37,400 Prepaid expenses $7,200 $175,340 Fixed Assets Plant Additions during the Quarter $498,600 $125,000 $623,600 $147,582 $476,018 $97,100 $748,458 Accumulated Deprecation Intangible Assets Patents Total Assets Current Liabilities Accounts payable Tax payable Long Term Liabilities Notes Payable Shareholders Equity Common Stock Retained earnings $35,640 $52,448 $88,088 $101,400 $250,000 $308,970 $558,970 $748,458 Total Liabilities and Shareholders Equity Working notes Closing Inventory- Direct Material Opening stock Purchases $23,910 $96,840 $120,750 $102,710 $18,040 Raw Material consumed Closing stock Closing stock - WIP Direct Material Consumed Direct Labour Prime cost $102,710 $71,460 $174,170 Manufacturing expense Factory cost of production Opening WIP $79,940 $254,110 $31,620 $285,730 $252,880 $32,850 Less: Cost of Good manufactured Closing WIP Closing stock-Finished Goods Cost of Good manufactured Opening stock of Finished Goods Cost of Goods available for sale $252,880 $36,220 $289,100 Cost of Goods sold Closing stock (Difference) $251,700 $37,400 Retained Earnings Closing balance Opening Balance Add: Net profit Closing balance $207,158 $101,812 $308,970