Question

In: Accounting

Your answer is partially correct. Try again. Bramble, Inc. prepared the following cash budget for the...

Your answer is partially correct. Try again.

Bramble, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Bramble desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)

October November December Quarter
Beginning cash balance $ $15,530 $ $16,290
Collections from sales 56,290 241,390
Total cash available 72,580 97,630 125,320
Less disbursements
   Materials purchases 9,370 13,960 35,370
   Direct labor 5,020 5,740 7,830 18,590
   Manufacturing overhead 20,100 21,660 21,970
   Selling & administrative expenses 28,890 29,450
   Equipment purchase 15,440
   Dividends 4,940 4,940
Total disbursements 66,050
Excess (deficiency) of cash 31,410
Minimum cash balance 15,000 15,000 15,000
Cash available (needed) -8,470 14,730
Financing:
   Borrowings 9,000
   Repayments -9,000
   Interest -90 -90
Total financing -9,090 -90
Ending cash balance $15,530 $22,320 $ $

Solutions

Expert Solution

October November December Quarter
Beginning cash balance          16,290            15,530            22,320 $16,290
Collections from sales          56,290            82,100          103,000 241,390
A Total cash available          72,580            97,630          125,320
Less disbursements:
   Materials purchases          12,040               9,370            13,960      35,370
   Direct labor            5,020               5,740              7,830      18,590
   Manufacturing overhead          20,100            21,660            21,970      63,730
   Selling & administrative expenses          28,890            29,450            31,450      89,790
   Equipment purchase in Dec                   -                        -              15,440      15,440
   Dividends                   -                        -                4,940        4,940
B Total disbursements          66,050            66,220            95,590 227,860
Excess (deficiency) of cash (A-B)            6,530            31,410            29,730
Minimum cash balance          15,000            15,000            15,000
Cash available (needed) -         8,470            14,730
Financing:
   Borrowings-Balance          24,000        9,000
   Repayments -            9,000 -     9,000
   Interest -                  90 -           90
Total financing          24,000 -            9,090 -           90
Ending cash balance          15,530            22,320            29,730 $
October November
Total cash available          72,580            97,630
Less: Collection of Sales/beg Bala          56,290            15,530
Beginning cash balance          16,290            82,100
   Materials purchases-Qtr          35,370
Less: Nov & Dec          23,330
Oct Purchases          12,040
Total disbursements          66,050
Less: All Other Expense          66,050
Dividend                   -  

Related Solutions

Brief Exercise 11-8 Partially correct answer. Your answer is partially correct. Try again. Bramble Corp. has...
Brief Exercise 11-8 Partially correct answer. Your answer is partially correct. Try again. Bramble Corp. has these accounts at December 31: Common Stock, $12 par, 6,900 shares issued, $82,800; Paid-in Capital in Excess of Par Value $20,400; Retained Earnings $45,400; and Treasury Stock, 640 shares, $14,080. Prepare the stockholders’ equity section of the balance sheet. Bramble Corp. Balance Sheet (Partial) December 31 Entry field with incorrect answer Entry field with incorrect answer Entry field with incorrect answer Entry field with...
Partially correct answer. Your answer is partially correct. Try again. The actual selling expenses incurred in...
Partially correct answer. Your answer is partially correct. Try again. The actual selling expenses incurred in March 2017 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $14,228 Sales salaries $35,000 Advertising 10,086 Depreciation 7,200 Travel 8,355 Insurance 1,900 Delivery 3,422 (a) Prepare a flexible budget performance report for March, assuming that March sales were $167,100. Variable costs and their percentage relationship to sales are sales commissions 8%, advertising 6%, traveling 5%, and delivery 2%. Fixed selling...
Exercise 16-7 Partially correct answer. Your answer is partially correct. Try again. Illiad Inc. has decided...
Exercise 16-7 Partially correct answer. Your answer is partially correct. Try again. Illiad Inc. has decided to raise additional capital by issuing $170,000 face value of bonds with a coupon rate of 10%. In discussions with investment bankers, it was determined that to help the sale of the bonds, detachable stock warrants should be issued at the rate of one warrant for each $100 bond sold. The value of the bonds without the warrants is considered to be $136,000, and...
Problem 13-3A [Partially correct answer.] Your answer is partially correct. Try again. The income statement of...
Problem 13-3A [Partially correct answer.] Your answer is partially correct. Try again. The income statement of Whitlock Company is presented here. WHITLOCK COMPANY Income Statement For the Year Ended November 30, 2017 Sales revenue $7,524,400 Cost of goods sold     Beginning inventory $1,816,200     Purchases 4,438,600     Goods available for sale 6,254,800     Ending inventory 1,364,600 Total cost of goods sold 4,890,200 Gross profit 2,634,200 Operating expenses 1,191,900 Net income $1,442,300 Additional information: 1. Accounts receivable increased $204,700 during the year, and inventory decreased...
Problem 18-6A Partially correct answer. Your answer is partially correct. Try again. The comparative statements of...
Problem 18-6A Partially correct answer. Your answer is partially correct. Try again. The comparative statements of Corbin Company are presented below. CORBIN COMPANY Income Statement For the Years Ended December 31 2017 2016 Net sales (all on account) $600,500 $520,800 Expenses Cost of goods sold 414,600 353,300 Selling and administrative 119,900 113,000 Interest expense 7,800 6,300 Income tax expense 17,900 14,200 Total expenses 560,200 486,800 Net income $ 40,300 $ 34,000 CORBIN COMPANY Balance Sheets December 31 Assets 2017 2016...
Your answer is partially correct. Try again. At the end of 2016, Metlock, Inc. has accounts...
Your answer is partially correct. Try again. At the end of 2016, Metlock, Inc. has accounts receivable of $666,300 and an allowance for doubtful accounts of $24,740. On January 24, 2017, it is learned that the company’s receivable from Madonna Inc. is not collectible and therefore management authorizes a write-off of $4,398. (a) Prepare the journal entry to record the write-off. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Account Titles and Explanation Debit...
Exercise 21-4 Partially correct answer. Your answer is partially correct. Try again. Turney Company produces and...
Exercise 21-4 Partially correct answer. Your answer is partially correct. Try again. Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows. Quarter HD-240 1 5,100 2 7,490 3 8,330 4 10,350 The January 1, 2017, inventory of HD-240 is 2,040 units. Management desires an ending inventory each quarter equal to 40% of the next quarter’s sales. Sales in the first quarter of 2018 are expected to be 25% higher than sales in...
Exercise 14-12 Partially correct answer. Your answer is partially correct. Try again. On January 2, 2012,...
Exercise 14-12 Partially correct answer. Your answer is partially correct. Try again. On January 2, 2012, Cheyenne Corporation issued $2,100,000 of 10% bonds at 97 due December 31, 2021. Interest on the bonds is payable annually each December 31. The discount on the bonds is also being amortized on a straight-line basis over the 10 years. (Straight-line is not materially different in effect from the preferable “interest method”.) The bonds are callable at 102 (i.e., at 102% of face amount),...
Exercise 21-4 Partially correct answer. Your answer is partially correct. Try again. Klean Fiber Company is...
Exercise 21-4 Partially correct answer. Your answer is partially correct. Try again. Klean Fiber Company is the creator of Y-Go, a technology that weaves silver into its fabrics to kill bacteria and odor on clothing while managing heat. Y-Go has become very popular in undergarments for sports activities. Operating at capacity, the company can produce 1,048,000 Y-Go undergarments a year. The per unit and the total costs for an individual garment when the company operates at full capacity are as...
Exercise 10-4 [Partially correct answer.] Your answer is partially correct. Try again. Myers Company uses a...
Exercise 10-4 [Partially correct answer.] Your answer is partially correct. Try again. Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.00 Indirect materials 0.70 Utilities 0.40 Fixed overhead costs per month are Supervision $4,200, Depreciation $1,800, and Property Taxes $600. The company believes it will normally operate in a range of 7,000–13,000 direct labor hours per month. Assume that in July...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT