Labs performs a specialty lab test for local companies for $ 48 per test. For the upcoming quarter, Bentfield Labs is projecting the following sales: January 5,000 February 4,500 March 5,200 Number of lab tests . . . . . The budgeted cost of performing each test is $ 21. Operating expenses are projected to be $62,000 in January, $54,000 in February, and $64,000 in March. Bentfield Labs is subject to a corporate tax rate of 30%. Requirement Prepare a budgeted income statement for the first quarter, with a column for each month and for the quarter. Prepare the budgeted income statement by first calculating the operating income, then calculate the net income.
Answer-
BUDGETED INCOME STATEMENT | ||||
PARTICULARS | JANUARY | FEBRUARY | MARCH | QUARTER |
Sales | 5000 tests*$48 per test =$240000 | 4500 tests*$48 per test =$216000 | 5200 tests*$48 per test =$249600 | $705600 |
Less- Cost of performing of tests | 5000 tests*$21 per test =$105000 | 4500 tests*$21 per test =$94500 | 5200 tests*$21 per test =$109200 | $308700 |
Gross profit | 135000 | 121500 | 140400 | 396900 |
Less- Operating expenses | 62000 | 54000 | 64000 | 180000 |
Operating income | 73000 | 67500 | 76400 | 216900 |
Less- Corporate Tax @30% | 21900 | 20250 | 22920 | 65070 |
Net Income | 51100 | 47250 | 53480 | 151830 |
Labs performs a specialty lab test for local companies for $ 48 per test. For the...
LaChut Labs performs a specialty lab test for local companies for $54 per test. For the upcoming quarter, LaChut Labs is projecting the following sales: The budgeted cost of performing each test is $27. Operating expenses are projected to be $61,000 in January, $56,000 in February, and $60,000 in March. LaChut Labs is subject to a corporate tax rate of 30%. January February March Requirement Prepare a budgeted income statement for the first quarter, with a column for each month...
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 44,000 for January, 64,000 for February, and 54,000 for March. Cost of goods sold is $12 per unit. Other expense information for the first quarter follows. Commissions Rent Advertising Office salaries Depreciation Interest Tax rate 9% of sales dollars $ 22,000 per month 13% of sales dollars $ 74,000 per...
Walton Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Walton expects sales in January year 1 to total $340,000 and to increase 15 percent per month in February and March. All sales are on account. Walton expects to collect 65 percent of accounts receivable in the month of sale, 22 percent in the month following the sale, and 13 percent in the...
Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 45,000 for January, 55,000 for February, and 50,000 for March. Cost of goods sold is $14 per unit. Other expense information for the first quarter follows. Comissions Rent Advertising office salaries Depreciation Interest Tax rate 8t of sales dollars $ 14,000 per month 156 of sales dollars $75,000 per month...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Credits Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Capital shares Retained earnings Debits $ 49,000 224,000 57,000 356,000 $ 93,000 485,000 108,000 $686,000 $686,000...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Credits Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Capital shares Retained earnings Debits $ 48,000 232,000 61,500 375,000 $ 93,000 520,000 103,500 $716,500 $716,500...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Credits Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Capital shares Retained earnings Debits $ 50,000 224,000 61,500 366,000 $ 91,000 505,000 105,500 $701,500 $701,500...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debits Credits Cash $ 46,000 Accounts receivable 232,000 Inventory 57,000 Buildings and equipment (net) 375,000 Accounts payable $ 96,000 Capital shares 505,000 Retained earnings 109,000 $ 710,000...
Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: a. Estimated sales at $125 per unit: January 25,000 units February 30,000 units March 45,000 units April 50,000 units b. Estimated finished goods inventories: January 1 2,000 units January 31 10% of next month’s sales February 28 10% of next month’s sales March 31 10% of next month’s...