80.2K

Verified Solution

Link Copied!

(2) Prepare a budgeted income statement for the quarter ending June 30, 2021, and a budgeted balance statement as of June 30, 2021. Olympia Company, Inc. Balance Sheet March 31,2021 Assets Cash $ 14,200.00 Accounts receivable 62,000 Raw materials inventory 8,064 Finished goods inventory 26,500 Total current assets 110.764 400,000 Land Property, plant, and equipment: Buildings and equipment Less: Accumulated depreciation Property, plant and equipment, net Total assets 1,713,460 (740,000) 973,460 1,484,224 19,000 Liabilities and stockholders' equity Current liabilities: Accounts payable Stockholders equity Common stock Retained earnings Total stockholders 300,000 1,165,224 1,465,224 Olympia Company, Inc. Balance Sheet March 31,2021 Assets Cash $ 14,200.00 Accounts receivable 62,000 Raw materials inventory 8,064 Finished goods inventory 26,500 Total current assets 110,764 400,000 Land Property, plant, and equipment: Buildings and equipment Less: Accumulated depreciation Property, plant and equipment, net Total assets 1,713,460 (740,000) 973,460 1,484,224 19,000 Liabilities and stockholders' equity Current liabilities: Accounts payable Stockholders' equity: Common stock Retained earnings Total stockholders Total liabilities and stockholder's equity 300,000 1,165,224 1,465,224 1,484,224 Key all inputs from the pdf project file into collumn B in this tab. Do not delete, add, or move rows or collumns. Collumn B: Inputs Budgeted Sales Units: April 27.400 May 36,100 June 35,200 July 30,900 August 25,000 Sales Price per Unit $ 11.10 Expected Cash Collections: Month of sale Month following sale Uncollectible 60% 35% 5% $ 62,000.00 March 31 Estimated A/R Balance Production: Percentage of next month's production in ending inventory Expected March 31 balance in units Raw Materials: 15% 4300 Required Quantity: Material (Pounds) 6 Cost: Material (Pounds) $ 0.42 Requirements for next month's budgeted raw materials inventory 10% Beginning Balance (Estimated): Material (Pounds) 19,200 Expected Cash Disbursements: Payments: Month of the purchase Month following the purchase 55% 45% Accounts Payable March 31 Ending Balance $ 19,000.00 0.05 15.50 Direct Labor Direct labor hours per unit Direct labor rate Manufacturing Overhend: Variable overhead per direct labor hour Fixed overhead per month Manufacturing overhead Depreciation (manufacturing) $ 26.00 $ 54,700.00 $ 25,000.00 SG&A Expenses: Variable SG&A Expenses per unit $ 0.60 Elxod SGSA Expenses per month SGSA fixed expenses Depreciation (8G&A) Cash Information: $ 65,000.00 $ 16,000.00 Minimum desired cash balance Line of credit Borrowing increments Interest rate on borrowings Cash balance, April $ 40,000.00 $ 100,000,00 $ 1,000.00 You can only borrow in multiples of $1000 For 10% Annually or per 12 Months $ 14,200.00 Equipment purchases in May Equipment purchases in June Cash dividend declared to be paid in April $ 137,000.00 $ 35,000.00 $ 18,000.00 Beginning Balance Sheet: Cash Accounts receivable Raw materials inventory Finished goods Inventory Land Buildings and equipment Accumulated depreciation $ 14,200.00 62.000.00 8,084.00 26,500.00 400,000.00 1,713,460.00 (740,000.00) Accounts Payable Common stock 19,000.00 ann man Notes Variable SG&A Expenses per unit 0.60 Fixed SG&A Expenses per month SG&A fixed expenses Depreciation (SG&A) $ 65,000.00 $ 16,000.00 Cash Information: Minimum desired cash balance Line of credit Borrowing increments Interest rate on borrowings Cash balance, April 1 $ 40,000.00 $ 100,000.00 $ 1,000.00 You can only borrow in multiples of $1000. For 10% Annually or per 12 Months $ 14,200.00 $ 137,000.00 $ 35,000.00 $ 18,000.00 Equipment purchases in May Equipment purchases in June Cash dividend declared, to be paid in April Beginning. Balance Sheet: Cash Accounts receivable Raw materials inventory Finished goods inventory Land Buildings and equipment Accumulated depreciation Accounts Payable Common stock Retained earnings $ 14,200.00 62,000.00 8,064.00 26,500.00 400,000.00 1,713,460.00 (740,000.00) 19,000.00 300,000.00 1,165,224.00

Answer & Explanation Solved by verified expert

See Answer