Question

In: Accounting

I. Barrett Company has completed all operating budgets other the income statement for 2017.    Selected...

I. Barrett Company has completed all operating budgets other the income statement for 2017.

   Selected data from these budgets follows.

            Sales revenue: $300,000                                     

            Purchases of raw materials: $145,000               

            Ending inventory of raw materials: $15,000     

            Direct labor: $40,000                                             

            Interest expense: $1,000

            Principal payment on note: $2,000

            Dividends declared: $2,000

            Income tax rate: 30%

            Manufacturing overhead: $73,000, including $3,000 of depreciation expense

            Selling and administrative expenses: $36,000 including depreciation expenses of $1,000

            Other information:

            Assume that the number of units produced equals the number sold.

            Tear-end accounts receivable: 4% of 2017 sales.

            Year-end accounts payable: 50% of ending inventory of raw materials.

Interest, direct labor, manufacturing overhead, and selling and administrative expenses other

           than depreciation are paid as incurred. Dividends declared and income taxes for 2017 will not   

           be paid until 2018.

Solutions

Expert Solution

Since beginning balances of finished goods inventory and raw material inventory is not given, it is taken as zero.

Income Statement
Sales Revenue $          300,000
Cost of Goods Sold
Direct Material used $                 130,000
Direct Labor $                   40,000
Manufacturing Overhead $                   73,000
Total Cost of Goods Sold $          243,000
Gross Profit $             57,000
Selling and administrative expenses $             36,000
Operating income $             21,000
Interest Expense $               1,000
Income before income tax $             20,000
Income tax expense @ 30% $               6,000
Net Income $             14,000

Related Solutions

North Company has completed all of its operating budgets. The sales budget for the year shows...
North Company has completed all of its operating budgets. The sales budget for the year shows 50,640 units and total sales of $2,354,100. The total unit cost of making one unit of sales is $23. Selling and administrative expenses are expected to be $305,500. Interest is estimated to be $11,620. Income taxes are estimated to be $225,500. Prepare a budgeted multiple-step income statement for the year ending December 31, 2020.
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $ 426,960 $ 474,400 Direct materials purchases 142,320 148,250 Direct labor 106,740 118,600 Manufacturing overhead 83,020 88,950 Selling and administrative expenses 93,694 100,810 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $ 425,520 $ 472,800 Direct materials purchases 141,840 147,750 Direct labor 106,380 118,200 Manufacturing overhead 82,740 88,650 Selling and administrative expenses 93,378 100,470 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...
Ayayai Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Ayayai Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $363,600 $404,000 Direct materials purchases 121,200 126,250 Direct labor 90,900 101,000 Manufacturing overhead 70,700 75,750 Selling and administrative expenses 79,790 85,850 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $425,520 $472,800 Direct materials purchases 141,840 147,750 Direct labor 106,380 118,200 Manufacturing overhead 82,740 88,650 Selling and administrative expenses 93,378 100,470 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...
Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are: January February Sales...
Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are: January February Sales $350,000 $400,000 Direct materials purchases 120,000 110,000 Direct labor 85,000 112,000 Manufacturing overhead 60,000 75,000 Selling and administrative expenses 75,000 80,000 All sales are on account. Collections are expected to be 50% in the month of sale, 40% in the first month following the sale, and 10% in the second month following the sale. Thirty percent (30%) of direct materials purchases are paid in...
Question 2 Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are...
Question 2 Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows. January February Sales $360,000 $400,000 Direct materials purchases 120,000 125,000 Direct labour 90,000 100,000 Manufacturing overhead 70,000 75,000 Selling and administrative expenses 79,000 85,000 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...
A) Company A has the following income statement information for the years 2015-2017:                             &
A) Company A has the following income statement information for the years 2015-2017:                                                 2015 Income           2016 Income           2017 Income                                                 Statement as           Statement as              Statement                                                    Reported                  Reported                  Totals       Construction Rev               10,000,000                12,500,000                17,000,000 Construction Costs            6,200,000                7,250,000                10,260,000 Gross Profit                         3,800,000                5,250,000                6,740,000 Operating Expenses         2,100,000                2,835,000                3,219,000 Income from    Operations                       1,700,000                2,415,000                3,521,000 Non-Operating Items        (220,000)                   (171,000)                  (249,000) Income from    Continuing Operations          1,480,000                2,244,000                3,272,000 Income Tax...
Problem 23-4A Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are...
Problem 23-4A Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $375,840 $417,600 Direct materials purchases 125,280 130,500 Direct labor 93,960 104,400 Manufacturing overhead 73,080 78,300 Selling and administrative expenses 82,476 88,740 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...
This all the information that I have, there is not an specific method. Selected financial statement...
This all the information that I have, there is not an specific method. Selected financial statement information and additional data for Johnston Enterprises is presented below. Johnston Enterprises Balance Sheet: Johnston Enterprises Balance Sheet and Income Statement Data                                                                                           December 31,       December 31,                                                                                               2020                       2019___ Current Assets: Cash                                                                        $153,000               $119,000 Accounts Receivable 238,000                 306,000 Inventory       391,000                 340,000 Total Current Assets 782,000                 765,000 Property, Plant, and Equipment 1,241,000              1,122,000 Less: Accumulated Depreciation       (476,000)               (442,000) Total Assets   $1,547,000            $1,445,000 Current Liabilities:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT