Homework Help is Here – Start Your Trial Now!
Business
Accounting
f) For the first quarter of 2022, prepare a selling and administrative budget. g) For the first quarter of 2022, prepare a schedule for expected cash collections from customers. h) For the first quarter of 2022, prepare a schedule for expected payments for materials purchases. i) For the first quarter of 2022, prepare a cash budget.

f) For the first quarter of 2022, prepare a selling and administrative budget. g) For the first quarter of 2022, prepare a schedule for expected cash collections from customers. h) For the first quarter of 2022, prepare a schedule for expected payments for materials purchases. i) For the first quarter of 2022, prepare a cash budget.

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
Kindly solve all parts
Blue Fish Corporation is preparing its budget for the coming year, 2022. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Blue Fish Corporation Blue Fish Corporation Income Statement Balance Sheet For the year ended December 31, 2021 December 31, 2021 Saks 16,662,000 Cash 93,000 Cost of Goods Sokld 5.980,904 Accounts Receiable, net 198,300 Raw Materials Inventory Finished Goods Inventory Machinery and oquipment, net Total Assets 10,681,096 7,386,000 Gross project 15,416 Selling and Administrative Expenses Income from Operations 91,838 920,000 1,318,554 3,295,096 Interest Expense 111,020 Income Before Taxes 3,184,076 Income Tax Experse 668,656 Accounts Payabke 106,885 Net Income 2,515,420 Income Taxes Payabke 668,656 Total Liabilities 775,541 Common Stock 250,000 Retained eamings Total liabilikies and Stockholder's equity 293,013 1,318,554 Sales Unit sales for November 2021 115,000 Expected unit sales for March 2022 117,100 Unit sales for December 2021 100,500 Expected unit sales for April 2022 126,800 Expected unit sales for January 2022 114,500 Expected unit sales for May 2022 135,300 Expected unit sales for February 2022 116,200 Unit selling price S13 Blue Fish likes to keep 15% of the next month's unit sales in ending inventory. All sales are on account. 80% of the Accounts Receivable are collected in the month of sale, and 20% of the Accounts Receivable are collected in the month after sale. Direct Materials Direct materials cost 82 cents per pound. 2.5 pounds of direct materials are required to produce each unit. Blue Fish likes to keep 10% of the materials needed for the next month in its ending inventory. Raw Materials on December 31, 2021, totaled 18,800 pounds. Payment for materials is made within 15 days. 60% is paid in the month of purchase, and 40% is paid in the month after purchase. There was no beginning or ending work-in- process inventory for the 1" quarter. Direct Labor Labor requires 9 minutes per unit for completion and is paid at S13 per hour. Manufacturing Overhead Indirect materials 35¢ per labor hour Depreciation $16,200 per month Indirect labor 60¢ per labor hour Property taxes $2,300 per month Utilities 55¢ per labor hour Insurance $1.450 per month Maintenance 35¢ per labor hour Maintenance $1,525 per month Salaries $49,000 per month Selling and Administrative Variable selling and administrative cost per unit is $1.82 Advertising $13,500 a month Insurance $1,375 a month Salaries $76,000 a month Depreciation $2,300 a month Other fixed costs $3,100 a month
Transcribed Image Text:Blue Fish Corporation is preparing its budget for the coming year, 2022. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Blue Fish Corporation Blue Fish Corporation Income Statement Balance Sheet For the year ended December 31, 2021 December 31, 2021 Saks 16,662,000 Cash 93,000 Cost of Goods Sokld 5.980,904 Accounts Receiable, net 198,300 Raw Materials Inventory Finished Goods Inventory Machinery and oquipment, net Total Assets 10,681,096 7,386,000 Gross project 15,416 Selling and Administrative Expenses Income from Operations 91,838 920,000 1,318,554 3,295,096 Interest Expense 111,020 Income Before Taxes 3,184,076 Income Tax Experse 668,656 Accounts Payabke 106,885 Net Income 2,515,420 Income Taxes Payabke 668,656 Total Liabilities 775,541 Common Stock 250,000 Retained eamings Total liabilikies and Stockholder's equity 293,013 1,318,554 Sales Unit sales for November 2021 115,000 Expected unit sales for March 2022 117,100 Unit sales for December 2021 100,500 Expected unit sales for April 2022 126,800 Expected unit sales for January 2022 114,500 Expected unit sales for May 2022 135,300 Expected unit sales for February 2022 116,200 Unit selling price S13 Blue Fish likes to keep 15% of the next month's unit sales in ending inventory. All sales are on account. 80% of the Accounts Receivable are collected in the month of sale, and 20% of the Accounts Receivable are collected in the month after sale. Direct Materials Direct materials cost 82 cents per pound. 2.5 pounds of direct materials are required to produce each unit. Blue Fish likes to keep 10% of the materials needed for the next month in its ending inventory. Raw Materials on December 31, 2021, totaled 18,800 pounds. Payment for materials is made within 15 days. 60% is paid in the month of purchase, and 40% is paid in the month after purchase. There was no beginning or ending work-in- process inventory for the 1" quarter. Direct Labor Labor requires 9 minutes per unit for completion and is paid at S13 per hour. Manufacturing Overhead Indirect materials 35¢ per labor hour Depreciation $16,200 per month Indirect labor 60¢ per labor hour Property taxes $2,300 per month Utilities 55¢ per labor hour Insurance $1.450 per month Maintenance 35¢ per labor hour Maintenance $1,525 per month Salaries $49,000 per month Selling and Administrative Variable selling and administrative cost per unit is $1.82 Advertising $13,500 a month Insurance $1,375 a month Salaries $76,000 a month Depreciation $2,300 a month Other fixed costs $3,100 a month
Other Information Management has decided it would like to maintain a cash balance of at least $850,000 beginning on January 31, 2022. Dividends are paid each month at the rate of $2.25 per share for 6,000 shares outstanding. The company has an open line of credit with Romney's Bank. The terms of the agreement require borrowing to be in $1,000 increments at 8% interest. If the company pays back any part of the loan, all interest owed will be paid first during that money. If a company borrows money, no interest payment will be made and that interest will accrued into the next month. Blue Fish borrows on the first day of the month and repays on the last day of the month. A $520,000 equipment purchase is planned for February. The taxes owed from December 31, 2021 will be paid March 15, 2022. The company has a 21% income tax rate. Notes: Be sure you use the costs for ending raw materials and ending finished goods inventory. (not units) Use the cost per unit calculated in part j to assist in calculating the finished goods inventory for the balance sheet. Remember to accrue the interest at quarter end if needed (this may also affect your interest expense). Although there was not a note due at the end of the year, there may be a note due at March 31, 2022. (refer to your Cash budget) To find variable manufacturing overhead cost per unit take the total variable overhead costs divided by the total units produced for the quarter Required f) For the first quarter of 2022, prepare a selling and administrative budget. g) For the first quarter of 2022, prepare a schedule for expected cash collections from customers. h) For the first quarter of 2022, prepare a schedule for expected payments for materials purchases. i) For the first quarter of 2022, prepare a cash budget. j) For the first quarter of 2022, calculate cost of goods sold k) For the first quarter of 2022, prepare a budgeted income statement 1) For the first quarter of 2022, prepare a budgeted balance sheet.
Transcribed Image Text:Other Information Management has decided it would like to maintain a cash balance of at least $850,000 beginning on January 31, 2022. Dividends are paid each month at the rate of $2.25 per share for 6,000 shares outstanding. The company has an open line of credit with Romney's Bank. The terms of the agreement require borrowing to be in $1,000 increments at 8% interest. If the company pays back any part of the loan, all interest owed will be paid first during that money. If a company borrows money, no interest payment will be made and that interest will accrued into the next month. Blue Fish borrows on the first day of the month and repays on the last day of the month. A $520,000 equipment purchase is planned for February. The taxes owed from December 31, 2021 will be paid March 15, 2022. The company has a 21% income tax rate. Notes: Be sure you use the costs for ending raw materials and ending finished goods inventory. (not units) Use the cost per unit calculated in part j to assist in calculating the finished goods inventory for the balance sheet. Remember to accrue the interest at quarter end if needed (this may also affect your interest expense). Although there was not a note due at the end of the year, there may be a note due at March 31, 2022. (refer to your Cash budget) To find variable manufacturing overhead cost per unit take the total variable overhead costs divided by the total units produced for the quarter Required f) For the first quarter of 2022, prepare a selling and administrative budget. g) For the first quarter of 2022, prepare a schedule for expected cash collections from customers. h) For the first quarter of 2022, prepare a schedule for expected payments for materials purchases. i) For the first quarter of 2022, prepare a cash budget. j) For the first quarter of 2022, calculate cost of goods sold k) For the first quarter of 2022, prepare a budgeted income statement 1) For the first quarter of 2022, prepare a budgeted balance sheet.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS