Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I NEED HELP WITH REQ 8 PLEASE. EVERYTHING ELSE IS CORRECT Tune Printing Supply of Baltimore has applied for a loan. Its bank has requested

I NEED HELP WITH REQ 8 PLEASE. EVERYTHING ELSE IS CORRECT

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Tune Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted As Tune Printing Supply's controller, you have assembled the following additional information: balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: i (Click the icon to view the information.) (Click the icon to view the balance sheet.) i Data Table - X Requirement 1. Prepare the sales budget for April. Tune Printing Supply Assets Sales Budget Current Assets For the Month Ended April 30, 2024 Cash $ 50,800 Total budgeted sales 87,000 Accounts Receivable 12,800 More Info Requirement 2. Prepare the inventory, purchases, and cost of goods sold budget for April. Merchandise Inventory 11,800 Tune Printing Supply Total Current Assets $ 75,400 a. April dividends of $3,000 were declared and paid. Inventory, Purchases, and Cost of Goods Sold Budget Property, Plant, and Equipment: b . April capital expenditures of $16,500 budgeted for cash purchase of equipment. For the Month Ended April 30, 2024 Equipment and Fixtures 80,400 C. April depreciation expense, $600. d. Cost of goods sold, 50% of sales. Cost of goods sold 43,500 Less: Accumulated Depreciation (12,000) 68,400 e . Desired ending inventory for April is $27, 100. Plus: Desired ending merchandise inventory 27, 100 Total Assets $ 143,800 April selling and administrative expenses include salaries of $32,000, 40% of which will be paid in cash and the remainder paid next month. Total merchandise inventory required 70,600 Liabilities g. Additional April selling and administrative expenses also include miscellaneous expenses of 11.800 10% of sales, all paid in April. Less: Beginning merchandise inventory Current Liabilities: h. April budgeted sales, $87,000, 80% collected in April and 20% in May. 58,800 Budgeted Purchases Accounts Payable $ 8, 100 i. April cash payments of March 31 liabilities incurred for March purchases of inventory, $8, 100. April purchases of inventory, $20,900 for cash and $37,900 on account. Half the credit Stockholders' Equity Requirement 3. Prepare the selling and administrative expense budget for April. purchases will be paid in April and half in May. Common Stock, no par 55,000 Tune Printing Supply Retained Earnings 80,700 Print Done Sellina and Administrative Expense Budget Total Stockholders' Equity 135,700 Enter any number in the edit fields and then click Check Answer. Total Liabilities and Stockholders' Equity $ 143,800 All parts showing Check Answer Print DoneRequirement 3. Prepare the selling and administrative expense budget for April. Tune Printing Supply Selling and Administrative Expense Budget For the Month Ended April 30, 2024 Variable expenses: Miscellaneous expense S 8,700 Fixed expenses: Salaries expense 32,000 Depreciation expense 600 Total fixed expenses 32,600 $ 41,300 Total selling and administrative expensesRequirement 4. Prepare the budgeted cash receipts from customers for April. Tune Printing Supply Budgeted Cash Receipts from Customers For the Month Ended April 30, 2024 Current month sales, 80% $ 69,600 Prior month sales, 20% 12,800 $ 82,400 Total cash receipts Requirement 5. Prepare the budgeted cash payments for selling and administrative expenses for April. Tune Printing Supply Budgeted Cash Payments for Selling and Administrative Expenses For the Month Ended April 30, 2024 Variable expenses: Miscellaneous expenses $ 8,700 Fixed expenses: 40% of current month's salaries expense 12,800 $ 21,500 Total payments for selling and administrative expensesRequirement 6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance. Review the budgeted cash receipts from customers you prepared above. Review the budgeted cash payments for selling and administrative expenses you prepared above. Tune Printing Supply Cash Budget For the Month Ended April 30, 2024 Beginning cash balance $ 50,800 Cash receipts from customers 82,400 Cash available 133,200 Cash payments: Purchases of merchandise inventory 47,950 Selling and administrative expenses 21,500 Capital expenditures 16,500 Payments for dividend 3,000 Total cash payments 88,950 Ending cash balance 44,250Requirement 7. Prepare the budgeted income statement for April. (Check your spelling carefully and do not abbreviate.) Review the sales budget you prepared above. Review the selling and administrative expense budget you prepared above. Review the inventory,_purchases, and cost of goods sold budget you prepared above. Tune Printing Supply Budgeted Income Statement For the Month Ended April 30, 2024 Sales Revenue $ 87,000 Cost of Goods Sold 43,500 Gross Profit 43,500 Selling and Administrative Expenses: Miscellaneous expense $ 8,700 Salaries expense 32,000 Depreciation expense 600 Total Selling and Administrative Expenses 41,300 Net income (loss) $ 2,200Cost of Goods Sold 43,500 Gross Profit 43,500 Selling and Administrative Expenses: Miscellaneous expense 8,700 Salaries expense 32,000 Depreciation expense 600 Total Selling and Administrative Expenses 41,300 2,200 Net income (loss) Requirement 8. Prepare the budgeted balance sheet at April 30, 2024. (Check your spelling carefully and do not abbreviate. When applicable, use only the account names in the balance sheet provided.) Review the cash budget you prepared above. Tune Printing Supply Budgeted Balance Sheet April 30, 2024 Assets Current Assets: Cash S 44.250 Accounts Receivable 17.400 Merchandise Inventory 27.100 Total Current Assets 88,750 Property. Plant, and Equipment: Equipment and Fixtures 96,900 Less: Accumulated Depreciation (12,600) 84.300 Total Assets 173,050 Liabilities Current Liabilities: Accounts Payable Salaries Payable 19200 Total Liabilities Stockholders' Equity Common Stock 65000 Retained Earnings 80700 Total Stockholders' Equity Total Liabilities and Stockholders Equity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Regulation In Japan Evolution And Development From 2001 To 2015

Authors: Masatsugu Sanada, Yoshihiro Tokuga

1st Edition

0367221071, 9780367221072

More Books

Students also viewed these Accounting questions

Question

Explain the concept of employment at will.

Answered: 1 week ago

Question

Discuss compensation for sales representatives.

Answered: 1 week ago

Question

Explain termination of employment.

Answered: 1 week ago