Answered step by step
Verified Expert Solution
Question
1 Approved Answer
kindly solve part M and N please don't copy paste . Copy paste is wrong . Blue Fish Curpuration is preparing its budget for the
kindly solve part M and N please don't copy paste . Copy paste is wrong .
Blue Fish Curpuration 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 Coronition Income Statement Balance Sheet For the year ended December 31, 2021 December 31, 2021 Sales Cost of Goods Sakal Cimas project Selling and Adeustrative Expres Income from Operations Interest Expense Icone Before Taxes Incotes Tax Espreme Net Income 16,662,000 5,980.904 10.681.096 7.380.000 7.295,096 111020 3.184,076 668,656 2.515,420 Cash Accounts Receivable, net Raw Materials Imentary Frashed Goods Inventory Machinery and equipment, net Total Assets 93,000 198,300 15,416 91.83 920,000 1.318.55 Accounts Pavab Income Taxes Payable Total Linbilities Common Stock Retand can Totallibilities and Stockholder's equiry 106.885 668,656 775,541 250,000 293,013 1.318.554 Sales Unit sales for November 2021 115,000 Unit sales for December 2021 100,500 Expected unit sales for January 2022 114,500 Expected unit sales for February 2022 116,200 Expected unit sales for March 2022 Expected unit sales for April 2022 Expected unit sales for May 2022 Unit selling price 117.100 126,800 135,300 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 $13 per hour, Manufacturing Overhead Indirect materials Indirect labor Utilities Maintenance Salaries 35 per labor hour 60 per labor hour 55 per labor hour 35 per labor hour $49,000 per month Depreciation Property taxes Insurance Maintenance S16,200 per month $2,300 per month $1,450 per month $1,525 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 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 partj 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 m) Calculate the Break Even point in dollars & units for the first quarter of 2022. n) If the company wanted an income of $1,850,000 for the first quarter, what would their breakeven point in dollars and units be? Blue Fish Curpuration 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 Coronition Income Statement Balance Sheet For the year ended December 31, 2021 December 31, 2021 Sales Cost of Goods Sakal Cimas project Selling and Adeustrative Expres Income from Operations Interest Expense Icone Before Taxes Incotes Tax Espreme Net Income 16,662,000 5,980.904 10.681.096 7.380.000 7.295,096 111020 3.184,076 668,656 2.515,420 Cash Accounts Receivable, net Raw Materials Imentary Frashed Goods Inventory Machinery and equipment, net Total Assets 93,000 198,300 15,416 91.83 920,000 1.318.55 Accounts Pavab Income Taxes Payable Total Linbilities Common Stock Retand can Totallibilities and Stockholder's equiry 106.885 668,656 775,541 250,000 293,013 1.318.554 Sales Unit sales for November 2021 115,000 Unit sales for December 2021 100,500 Expected unit sales for January 2022 114,500 Expected unit sales for February 2022 116,200 Expected unit sales for March 2022 Expected unit sales for April 2022 Expected unit sales for May 2022 Unit selling price 117.100 126,800 135,300 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 $13 per hour, Manufacturing Overhead Indirect materials Indirect labor Utilities Maintenance Salaries 35 per labor hour 60 per labor hour 55 per labor hour 35 per labor hour $49,000 per month Depreciation Property taxes Insurance Maintenance S16,200 per month $2,300 per month $1,450 per month $1,525 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 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 partj 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 m) Calculate the Break Even point in dollars & units for the first quarter of 2022. n) If the company wanted an income of $1,850,000 for the first quarter, what would their breakeven point in dollars and units beStep 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