Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Northeast Regional Division of Union Corp. has been requested to prepare a quarterly budgeted income statement for 2022. The regional manager expects that sales

image text in transcribed
image text in transcribed
image text in transcribed
The Northeast Regional Division of Union Corp. has been requested to prepare a quarterly budgeted income statement for 2022. The regional manager expects that sales in the first quarter of 2022 will increase by 10% over the same quarter of the preceding year and will then increase by 5% for each succeeding quarter in 2022. The corporate head office has requested that the regional manager maintain an inventory in dollars equal to 25% of the next quarter's sales. Quarterly purchases average 55% of quarterly sales, Budgeted ending inventory on December 31, 2021 is $176,000. Quarterly salaries are $20,000 plus 5% of sales. All salaries are classified as sales salaries. Other quarterly expenses are estimated to be as follows: Rent expense $24,000 Depreciation on office equipment $12,000 Utilities expense $3,600 Miscellaneous expenses 2% of sales $720,000 396.000 324,000 The income statement for the first quarter of 2021 was as follows: Income Statement For the Quarter Ended March 31, 2021 Sales Cost of goods sold Gross profit Operating expenses Sales salaries Rent expense Depreciation Utilities Miscellaneous Total operating expenses Net income..... $52,000 24,000 12,000 3,600 12.800 104.400 $219.600 Instructions Prepare a budgeted quarterly income statement form for the first quarter of 2022. (Show computations.) HW 2022.1.2. Cruises, Inc. has budgeted sales revenues as follows: June July August Credit sales $135,000 $125,000 $ 90,000 Cash sales 90.000 255.000 195.000 Total sales $225.000 $380.000 $285.000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are: June $300,000 July 240,000 August 105,000 Other cash disbursements budgeted: (a) selling and administrative expenses of $48,000 each month, (b) dividends of $103,000 will be paid in July, and (c) purchase of equipment in August for $30,000 cash. The company wishes to maintain a minimum cash balance of $50,000 at the end of each month. The company borrows money from the bank at 6% interest if necessary to maintain the minimum cash balance. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on July 1 was $50,000. Assume that borrowed money in this case is for one month. Instructions Prepare a cash budget for the months of July and August. Prepare separate schedules for expected collections from customers and expected payments for purchases of inventory. HW 2022.1.3. The Sunstate Bank has asked Dell Printing Co. for a budgeted balance sheet for the year ended December 31, 2022. The following information is available: 1. The cash budget shows an expected cash balance of $75,000 at December 31, 2022. 2. The 2022 sales budget shows total annual sales of $800,000. All sales are made on account and accounts receivable at December 31, 2022 are expected to be 10% of annual sales. 3. The merchandise purchases budget shows budgeted cost of goods sold for 2022 of $600,000 and ending merchandise inventory of $95,000. 20% of the ending inventory is expected to have not yet been paid at December 31, 2022. 4. The December 31, 2021 balance sheet includes the following balances: Equipment $294,000Accumulated Depreciation $122,000, Common Stock $270,000, and Retained Earnings $48,000. 5. The budgeted income statement for 2022 includes the following: depreciation on equipment $15,000. federal income taxes $21,000, and net income $49,000. The income taxes will not be paid until 2022. 6. In 2016, management does not expect to purchase additional equipment or to declare any dividends. It does expect to pay all operating expenses, other than depreciation, in cash. Instructions Prepare an unclassified budgeted balance sheet at December 31, 2022

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

Managerial Accounting

Authors: John J. Wild, Ken W. Shaw

2010 Edition

9789813155497, 73379581, 9813155493, 978-0073379586

More Books

Students also viewed these Accounting questions