Question
Alliance Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2018 and budgeted balance sheet
Alliance Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2018 and budgeted balance sheet at April 30, 2018. The March 31, 2018, balance sheet follows (Click the icon to view the balance sheet) Data Table As Alliance Printing Supply's controller, you have assembled the following additional information (Click the icon to view the information) Read the trements More Info Alliance Printing Supply Balance Sheet March 31, 2010 Assets Current Assets Cash Accounts Receivable Merchandise Inventory Total Cument Assets Property, Plant, and Equipment Equipment and Fidures S 50,700 15.500 12.000 S 78.200 80.500 a. April dividends of $7.000 were declared and paid. b. April capital expenditures of $16,300 budgeted for cash purchase of equipment c. April depreciation expense, $1,000 d. Cost of goods sold. 40% of sales e. Desired ending inventory for Aprillis $22,400 f. April selling and administrative expenses include salaries of $37.000, 30% of which will be paid in cash and the remainder paid next month g. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April h. April budgeted sales, $89,000, 80% collected in April and 20% in May April cash payments of March 31 liabilities incurred for March purchases of inventory. $8,600 April purchases of inventory, $8,600 for cash and $37,400 on account Half the credit purchases will be paid in April and half in May Print Done 4 Data Table Property, Plant, and Equipment: Equipment and Fixtures Less: Accumulated Depreciation Total Assets Current Liabilities: Accounts Payable Liabilities 80,500 (12,900) 67,600 $ 145,800 $ 8,600 - X Stockholders' Equity Common Stock, no par $ 38,000 99,200 Retained Earnings 137,200 Total Stockholders' Equity q 145,800 Total Liabilities and Stockholders' Equity Alliance Printing Supply Sales Budget For the Month Ended April 30, 2018 Total budgeted sales 89000 Requirement 2. Prepare the inventory, purchases, and cost of goods sold budget for April. Alliance Printing Supply Inventory, Purchases, and Cost of Goods Sold Budget Cost of goods sold Plus: For the Month Ended April 30, 2018 Desired ending merchandise inventory Total merchandise inventory required 22400 into the no his Question: 11 pts Alliance Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted in statement for April 2018 and budgeted balance sheet at April 30, 2018. The March 31, 2018, bala follows: EEB Click the icon to view the balance sheet.) Inventory, Purchases, and Cost of Goods Sold Budget For the Month Ended April 30, 2018 Cost of goods sold Desired ending merchandise inventory Beginning merchandise inventory Plus: Total merchandise inventory required Less: Budgeted Purchases 22400 Requirement 3. Prepare the selling and administrative expense budget for April. Alliance Printing Supply Selling and Administrative Expense Budget For the Month Ended April 30, 2018 Choose from any list or enter any number in the input fields and then continue to the next que Alliance Printing Supply Selling and Administrative Expense Budget For the Month Ended April 30, 2018 Variable expenses: Miscellaneous expense Fixed expenses: Salaries expense Depreciation expense Total fixed expenses Total selling and administrative expenses Requirement 4. Prepare the budgeted cash receipts from customers for April. Requirement 4. Prepare the budgeted cash receipts from customers for Ap Alliance Printing Supply Budgeted Cash Receipts from Customers For the Month Ended April 30, 2018 Current month sales, 80% Prior month sales, 20% Total cash receipts and admin Requirement 3. Prepare the budg Alliance Printing Supply Budgeted Cash Payments for Selling and Administrative Expenses For the Month Ended April 30, 2018 Variable expenses: Miscellaneous expenses Fixed expenses: 30% of current month's salaries expense Total payments for selling and administrative expenses door not use shor Cash Budget For the Month Ended April 30, 2018 Beginning cash balance Cash receipts from customers Cash available Cash payments: Purchases of merchandise inventory Selling and administrative expenses Capital expenditures Payments for dividend Total cash payments Ending cash balance Choose from any list or enter any number in the input fields and then contin Sales Revenue Budgeted Income Statement For the Month Ended April 30, 2018 Cost of Goods Sold Gross Profit Selling and Administrative Expenses: Miscellaneous Expense Salaries Expense Depreciation Expense Total Selling and Administrative Expenses Net income (loss) Current Assets: Cash Assets Accounts Receivable Merchandise Inventory Total Current Assets Property, Plant, and Equipment: Equipment and Fixtures Less: Accumulated Depreciation Total Assets Liabilities Total Assets Current Liabilities: Accounts Payable Salaries Payable Total Liabilities Liabilities Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity number in the input fields and then continue
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started