Cash Budget
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:
| September | October | November | ||||
| Sales | $116,000 | $146,000 | $183,000 | |||
| Manufacturing costs | 49,000 | 63,000 | 66,000 | |||
| Selling and administrative expenses | 41,000 | 44,000 | 70,000 | |||
| Capital expenditures | _ | _ | 44,000 | |||
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $8,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.
Current assets as of September 1 include cash of $44,000, marketable securities of $63,000, and accounts receivable of $129,900 ($102,000 from July sales and $27,900 from August sales). Sales on account for July and August were $93,000 and $102,000, respectively. Current liabilities as of September 1 include $8,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $18,000 will be made in October. Bridgeport’s regular quarterly dividend of $8,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $43,000.
Required:
1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.
| Bridgeport Housewares Inc. | |||
| Cash Budget | |||
| For the Three Months Ending November 30 | |||
| September | October | November | |
| Estimated cash receipts from: | |||
| Cash sales | $ | $ | $ |
| Collection of accounts receivable | |||
| Total cash receipts | $ | $ | $ |
| Less estimated cash payments for: | |||
| Manufacturing costs | $ | $ | $ |
| Selling and administrative expenses | |||
| Capital expenditures | |||
| Other purposes: | |||
| Income tax | |||
| Dividends | |||
| Total cash payments | $ | $ | $ |
| Cash increase or (decrease) | $ | $ | $ |
| Plus cash balance at beginning of month | |||
| Cash balance at end of month | $ | $ | $ |
| Less minimum cash balance | |||
| Excess or (deficiency) | |||
In: Accounting
| Script Company uses a job costing accounting system for its production costs. A predetermined overhead rate based on direct labor-hours is used to apply overhead to individual jobs. An estimate of overhead costs at different volumes was prepared for the current year as follows: | |||||
| Direct labor-hours | 18,000 | 24,000 | 30,000 | ||
| Variable overhead costs | 864,000 | 1,152,000 | 1,440,000 | ||
| Fixed overhead costs | 1,200,000 | 1,200,000 | 1,200,000 | ||
| Total overhead | 2,064,000 | 2,352,000 | 2,640,000 | ||
| The expected volume is 24,000 direct labor-hours for the entire year. The following information is for October, when jobs 1011 and 1015 were completed: | |||||
| Inventories, October 1 | |||||
| Raw materials and supplies | 100800 | ||||
| Work in process (Job 1011) | 219120 | ||||
| Finished goods | 546960 | ||||
| Purchases of raw materials and supplies | |||||
| Raw materials | 1509600 | ||||
| Supplies | 190320 | ||||
| Materials and supplies requisitioned for production | |||||
| Job 1011 | 674400 | ||||
| Job 1015 | 562800 | ||||
| Job 1017 | 113280 | ||||
| Supplies | 184080 | ||||
| 1534560 | |||||
| Machine-hours (MH) | |||||
| Job 1011 | 7,440 MH | ||||
| Job 1015 | 7,320 MH | ||||
| Job 1017 | 4,440 MH | ||||
| Direct labor-hours (DLH) | |||||
| Job 1011 | 8,400 DLH | ||||
| Job 1015 | 3,660 DLH | ||||
| Job 1017 | 2,220 DLH | ||||
| Labor costs | |||||
| Direct labor wages (all hours @ $48) | 685440 | ||||
| Indirect labor wages (12,000 hours) | 151200 | ||||
| Supervisory salaries | 307200 | ||||
| Building occupancy costs (heat, light, depreciation, etc.) | |||||
| Factory facilities | 88560 | ||||
| Sales and administrative offices | 34080 | ||||
| Factory equipment costs | |||||
| Power | 52320 | ||||
| Repairs and maintenance | 19680 | ||||
| Other | 23760 | ||||
| 95760 | |||||
| (Note: Regardless of your answer to requirement [a], assume that the predetermined overhead rate is $100 per direct labor-hour. Use this amount in answering requirements [b] through [e].) | |||||
| Required: | |||||
| a. Compute the predetermined overhead rate (combined fixed and variable) to be used to apply overhead to individual jobs during the year. | |||||
| b. Compute the total cost of Job 1011 when it is finished. | |||||
| c. How much of factory overhead cost was applied to Job 1017 during October? | |||||
| d. What total amount of overhead was applied to jobs during October? | |||||
| e. Compute actual factory overhead incurred during October. | |||||
| f. At the end of the year, Script Company had the following account balances: | |||||
In: Accounting
The collectibility of the lease payments is reasonably predictable,
and there are no important uncertainties surrounding the costs yet
to be incurred by the lessor. The lessee assumes responsibility for
all executory costs, which amount to $5,500 per year and are to be
paid each October 1, beginning October 1, 2014. (This $5,500 is not
included in the rental payment of $62,700.) The asset will revert
to the lessor at the end of the lease term. The straight-line
depreciation method is used for all equipment.
The following amortization schedule has been prepared correctly for
use by both the lessor and the lessee in accounting for this lease.
The lease is to be accounted for properly as a capital lease by the
lessee and as a direct-financing lease by the lessor.
Date
10/01/14 10/01/14 10/01/15 10/01/16 10/01/17 10/01/18
10/01/19
Annual Lease Payment/ Receipt
Interest (10%) on Unpaid Liability/Receivable
$23,768 19,875 15,593 10,882
5,699*
$75,817
Reduction of Lease Liability/Receivable
Balance of Lease Liability/Receivable
$300,383 237,683 198,751 155,926 108,819
57,001 –0–
*Rounding error is $1.
Instructions
$
62,700 62,700 62,700 62,700 62,700 62,700
$
62,700 38,932 42,825 47,107 51,818 57,001
$376,200
$300,383
(Balance Sheet and Income Statement Disclosure—Lessee) The
following facts pertain to a noncancelable lease agreement between
Alschuler Leasing Company and McKee Electronics, a lessee, for a
computer system.
Inception date Lease term Economic life of leased equipment Fair
value of asset at October 1, 2014 Residual value at end of lease
term Lessor’s implicit rate Lessee’s incremental borrowing rate
Annual lease payment due at the beginning of
October 1, 2014 6 years 6 years $300,383 –0– 10% 10%
each year, beginning with October 1, 2014
$62,700
(b) Assuming the lessee’s accounting period ends on December 31,
answer the following questions with respect to this lease
agreement. (1) What items and amounts will appear on the lessee’s
income statement for the year ending
December 31, 2014? (2) What items and amounts will appear on the
lessee’s balance sheet at December 31, 2014? (3) What items and
amounts will appear on the lessee’s income statement for the year
ending
December 31, 2015? (4) What items and amounts will appear on the
lessee’s balance sheet at December 31, 2015?
In: Accounting
Cash Budget
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:
| September | October | November | ||||
| Sales | $109,000 | $134,000 | $184,000 | |||
| Manufacturing costs | 46,000 | 58,000 | 66,000 | |||
| Selling and administrative expenses | 38,000 | 40,000 | 70,000 | |||
| Capital expenditures | _ | _ | 44,000 | |||
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.
Current assets as of September 1 include cash of $41,000, marketable securities of $59,000, and accounts receivable of $121,100 ($95,000 from July sales and $26,100 from August sales). Sales on account for July and August were $87,000 and $95,000, respectively. Current liabilities as of September 1 include $7,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $16,000 will be made in October. Bridgeport’s regular quarterly dividend of $7,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $40,000.
Required:
1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.
| Bridgeport Housewares Inc. | |||
| Cash Budget | |||
| For the Three Months Ending November 30 | |||
| September | October | November | |
| Estimated cash receipts from: | |||
| Cash sales | $ | $ | $ |
| Collection of accounts receivable | |||
| Total cash receipts | $ | $ | $ |
| Less estimated cash payments for: | |||
| Manufacturing costs | $ | $ | $ |
| Selling and administrative expenses | |||
| Capital expenditures | |||
| Other purposes: | |||
| Income tax | |||
| Dividends | |||
| Total cash payments | $ | $ | $ |
| Cash increase or (decrease) | $ | $ | $ |
| Plus cash balance at beginning of month | |||
| Cash balance at end of month | $ | $ | $ |
| Less minimum cash balance | |||
| Excess or (deficiency) | $ | $ | $ |
Feedback
In: Accounting
Cash Budget
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budgetinformation:
| September | October | November | ||||
| Sales | $146,000 | $181,000 | $232,000 | |||
| Manufacturing costs | 61,000 | 78,000 | 84,000 | |||
| Selling and administrative expenses | 51,000 | 54,000 | 88,000 | |||
| Capital expenditures | _ | _ | 56,000 | |||
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.
Current assets as of September 1 include cash of $55,000, marketable securities of $79,000, and accounts receivable of $163,100 ($128,000 from July sales and $35,100 from August sales). Sales on account for July and August were $117,000 and $128,000, respectively. Current liabilities as of September 1 include $7,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $22,000 will be made in October. Bridgeport’s regular quarterly dividend of $7,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $54,000.
Required:
1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.
| Bridgeport Housewares Inc. | |||
| Cash Budget | |||
| For the Three Months Ending November 30 | |||
| September | October | November | |
| Estimated cash receipts from: | |||
| Cash sales | $ | $ | $ |
| Collection of accounts receivable | |||
| Total cash receipts | $ | $ | $ |
| Less estimated cash payments for: | |||
| Manufacturing costs | $ | $ | $ |
| Selling and administrative expenses | |||
| Capital expenditures | |||
| Other purposes: | |||
| Income tax | |||
| Dividends | |||
| Total cash payments | $ | $ | $ |
| Cash increase or (decrease) | $ | $ | $ |
| Plus cash balance at beginning of month | |||
| Cash balance at end of month | $ | $ | $ |
| Less minimum cash balance | |||
| Excess or (deficiency) | |||
In: Accounting
Cash Budget
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:
| September | October | November | ||||
| Sales | $97,000 | $122,000 | $162,000 | |||
| Manufacturing costs | 41,000 | 52,000 | 58,000 | |||
| Selling and administrative expenses | 34,000 | 37,000 | 62,000 | |||
| Capital expenditures | _ | _ | 39,000 | |||
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $6,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.
Current assets as of September 1 include cash of $37,000, marketable securities of $52,000, and accounts receivable of $108,400 ($85,000 from July sales and $23,400 from August sales). Sales on account for July and August were $78,000 and $85,000, respectively. Current liabilities as of September 1 include $6,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $15,000 will be made in October. Bridgeport’s regular quarterly dividend of $6,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $36,000.
Required:
1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.
| Bridgeport Housewares Inc. | |||
| Cash Budget | |||
| For the Three Months Ending November 30 | |||
| September | October | November | |
| Estimated cash receipts from: | |||
| Cash sales | $ | $ | $ |
| Collection of accounts receivable | |||
| Total cash receipts | $ | $ | $ |
| Less estimated cash payments for: | |||
| Manufacturing costs | $ | $ | $ |
| Selling and administrative expenses | |||
| Capital expenditures | |||
| Other purposes: | |||
| Income tax | |||
| Dividends | |||
| Total cash payments | $ | $ | $ |
| Cash increase or (decrease) | $ | $ | $ |
| Plus cash balance at beginning of month | |||
| Cash balance at end of month | $ | $ | $ |
| Less minimum cash balance | |||
| Excess or (deficiency) | $ | $ | $ |
In: Accounting
Knight Co. owned 80% of the common stock of Stoop Co. Stoop had 50,000 shares of $5 par value common stock and 2,000 shares of preferred stock outstanding. Each preferred share received an annual per share dividend of $2 and is convertible into four shares of common stock. Knight did not own any of Stoop's preferred stock. Stoop also had 600 bonds outstanding, each of which is convertible into ten shares of common stock. Stoop's annual after-tax interest expense for the bonds was $2,000. Knight did not own any of Stoop's bonds. There are no excess amortizations or intra-entity transactions associated with this consolidation. Stoop reported net income of $300,000 for 2018. Knight has 100,000 shares of common stock outstanding and reported net income of $400,000 for 2018.
What would Knight Co. report as consolidated basic earnings per share (rounded)?
Multiple Choice
$6.37
$6.40
$7.00
$5.68
In: Accounting
MM Co. predicts sales of $40,000 for May. MM Co. pays a sales
manager a monthly salary of $3,300 plus a commission of 7% of sales
dollars. MM’s production manager recently found a way to reduce the
amount of packaging MM uses. As a result, MM’s product will receive
better placement on store shelves and thus May sales are predicted
to increase by 9%. In addition, MM’s shipping costs are predicted
to decrease from 5% of sales to 4% of sales.
Compute (1) budgeted sales and (2) budgeted selling expenses for
May assuming MM switches to this more sustainable
packaging.
(1) Budget sales -
(2) Budget selling expense -
In: Accounting
This is a partial adjusted trial balance of Wildhorse
Co..
| WILDHORSE
CO. Adjusted Trial Balance January 31, 2017 |
||||
|---|---|---|---|---|
| Debit | Credit | |||
|
Supplies |
$780 | |||
|
Prepaid Insurance |
1,620 | |||
|
Salaries and Wages Payable |
$1,040 | |||
|
Unearned Service Revenue |
710 | |||
|
Supplies Expense |
910 | |||
|
Insurance Expense |
540 | |||
|
Salaries and Wages Expense |
1,770 | |||
|
Service Revenue |
4,350 | |||
Prepare the closing entries at January 31, 2017. (If no
entry is required, select "No Entry" for the account titles and
enter 0 for the amounts. Credit account titles are automatically
indented when the amount is entered. Do not indent
manually.)
|
Date |
Account Titles and Explanation |
Debit |
Credit |
|---|---|---|---|
|
Jan. 31 |
enter an account title to close revenue account |
enter a debit amount |
enter a credit amount |
|
enter an account title to close revenue account |
enter a debit amount |
enter a credit amount |
|
|
(To close revenue account) |
|||
|
Jan. 31 |
enter an account title to close expense accounts |
enter a debit amount |
enter a credit amount |
|
enter an account title to close expense accounts |
enter a debit amount |
enter a credit amount |
|
|
enter an account title to close expense accounts |
enter a debit amount |
enter a credit amount |
|
|
enter an account title to close expense accounts |
enter a debit amount |
enter a credit amount |
|
|
(To close expense accounts) |
|||
|
Jan. 31 |
enter an account title to close net income / (loss) |
enter a debit amount |
enter a credit amount |
|
enter an account title to close net income / (loss) |
enter a debit amount |
enter a credit amount |
|
|
(To close net income / (loss)) |
In: Accounting
Thomson Co. produces and distributes semiconductors for use by computer manufacturers. Thomson Co. issued $900,000 of 10-year, 7% bonds on May 1 of the current year at face value, with interest payable on May 1 and November 1. The fiscal year of the company is the calendar year.
Journalize the entries to record the following selected transactions for the current year. Refer to the Chart of Accounts for exact wording of account titles.
| May | 1 | Issued the bonds for cash at their face amount. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Nov. | 1 | Paid the interest on the bonds. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Dec. | 31 |
Recorded accrued interest for two months.
none X Journal Journalize the transactions. Refer to the Chart of Accounts for exact wording of account titles. PAGE 10 JOURNAL ACCOUNTING EQUATION
Solution
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting