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
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.