Question

In: Accounting

The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially...

The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially completed Master Budget for January and February. Use the information to answer the 22 Multiple Choice Questions, each asking for a missing number from the Master Budget. Round all your computations to the nearest dollar.

  1. Sales are expected to be $80,900 in January, $100,900 in February, and $105,900 in March.
  2. All sales are on credit and it collects 20% of all sales in the month of the sale, the remaining 80% in the month after the sale.
  3. The cost of goods sold is equal to 40% of sales.
  4. The company likes to keep an ending inventory on hand equal to 15% of next month’s cost of goods sold.
  5. All purchases of inventory are on account, and the company pays for 60% of all purchases in the month of the purchase, 40% in the month after the purchase.
  6. The company pays its sales force a commission equal to 3% of sales.
  7. The company also believes that its miscellaneous expense is equal to $500 plus 2% of sales.
  8. Rent is $2,000 per month, Supplies are $600 per month, and Depreciation is $1,800 per month.
  9. On January 1st, the company purchased an insurance policy covering 24 months for $28,800.
  10. All selling and administrative expenses are paid in the month they are incurred except for commissions that are paid in the month after they are earned and the insurance which is paid two year in advance.
  11. The company purchased $4,000 of Land on February 18th. They paid cash for the land.
  12. Interest on long-term debt is equal to 1% of the beginning balance and is paid each month. The company must maintain a minimum balance in cash of $15,000 and will use any cash surplus to pay down long-term debt. The company borrows cash in $1,000 increments.
  13. The company is subject to a 30% income tax rate. The company pays income taxes in the month after they are accrued (expensed).
  14. The company’s Board of Directors declared a cash dividend of $950 on January 4th. The dividend will be paid on February 10th.
  15. The company had a beginning balance sheet (as of January 1) as follows:
Assets Liabilities & SE
Current Assets Current Liabilities
Cash $16,000 Accounts Payable $23,500
Accounts Receivable 48,000 Commissions Payable 3,400
Prepaid Insurance 0 Income Taxes Payable 9,275
Inventory 9,600 Dividends Payable 0
Total Current Assets 73,600 Total Current Liabilities 36,175
Long-term Debt 80,000
Property, Plant & Equipment
Equipment 95,000 Stockholders Equity
Land 8,800 Common Stock 26,225
Accumulated Depreciation (25,000) Return Earnings 10,000
Net PPE 78,800 Total SE 36,225
Total Assets $152,400 Total Liabilities & SE $152,400

Babcats Company's partically completed master budget is as follows:

Sales Budget

January February March
Credit Sales $80,900 $100,900 $105,900
Cash Receipts from Customers
From Current Month Credit Sales
From Prior Month Credit Sales      
Total Cash Receipts from Customers (1)

Inventory Purchases Budget

January February March
COGS $40,360 $42,360
Desired Ending Inventory
Total INventory Needed
Beginning Inventory
Inventory Purchases (2)
Cash Payments for Inventory Purchases
For Current Month Purchases
For Prior Month Purchases
Total Cash Payments for Inventory Purchases $40,788 (3)

Selling & Administrative Expenses Budget

January February
Variable Selling & Administrative Expenses
Commissions (4)
Miscellaneous
Total Variable S&A Expenses 4,045 5,045
Fixed Selling & Administrative Expenses
Miscellaneous
Rent 2,000 2,000
Supplies
Depreciation 1,800 1,800
Insurance (5)
Total Fixed S&A Expenses $6,100 $6,100
Cash Payments for S&A Expenses
Commissions
Utilities
Advertising
Salaries
Depreciation (6)
Insurance (7)
Total Cash Payments for S&A Expenses $36,918 $7,545

Cash Budget

January February
Beginning Cash Balance
Cash Receipts from Customers
Total Cash Available 80,180
Cash Payments
For Inventory Purchases 40,788
For S&A Expenses
For Interest (8)
For Income Taxes
For Land Purchase
For Dividends
Total Cash Payments 87,781
Surplus (Deficit) (9) 39,574
Borrowing (Repayment) (10)
Ending Cash Balance $ 15,000

Income Statement

January February
Sales $80,900 $100,900
Less: Variable Expenses
COGS
Variable S&A Expenses
Contrinbution Margin (11)
Less: Fixed Expenses
Fixed S&A Expenses
Interest Expense
Pre-tax Net Income
Income Taxes Expense 11,279 14,510
After-tax Net Income $26,317 $33,856

Balance Sheet

Assets Liabilities & SE
Current Assets Current Liabilities
Cash (12) Accounts Payable (18)
Accounts Receivable (13) Commissions Payable (19)
Prepaid Insurance (14) Income Taxes Payable
Inventory (15) Dividends Payable (20)
Total Current Assets Total Current Liabilities
Long-term Debt (21)
Property, Plant & Equipment
Equipment 95,000 95,000 Stockholders Equity
Land (16) Common Stock 26,225 26,225
Accumulated Depreciation (17) Return Earnings (22)
Net PPE Total SE
Total Assets $190,773 $207,674 Total Liabilities & SE $190,773 $207,674

(1) What are Total Cash Receipts from customers for January?

multiple choice 1

  • $48,000

  • $84,900

  • $64,180

  • $16,180

(2) What are Total Purchases of Inventory for January?

multiple choice 2

  • $40,660

  • $48,014

  • $37,895

  • $28,814

(3) ​​What are Total Cash Payments for Purchases of Inventory for February?

multiple choice 3

  • $40,660

  • $40,788

  • $35,922

  • $24,396

(4) What is Total Commission Expense for January?

multiple choice 4

  • $2,427

  • $5,454

  • $3,027

  • $4,045

(5) What is Total Insurance Expense for January?

multiple choice 5

  • $0

  • $2,400

  • $1,200

  • $28,800

(6) What is the Total Cash Payment for Depreciation Expense for January?

multiple choice 6

  • $3,600

  • $1,800

  • $0

  • $25,000

(7) What is Total Cash Payment for Insurance Expense for February?

multiple choice 7

  • $0

  • $2,400

  • $1,200

  • $28,800

(8) What is Total Interest Expense for January?

multiple choice 8

  • $1,030

  • $800

  • $8,000

  • $1,830

(9) What is Total Cash Surplus (Deficit) for January?

multiple choice 9

  • $39,574

  • $-7,601

  • $7,601

  • $-11,601

HUGE QUESTION..... ABSOLUTE BLESSING Tho if you could help!!!

Solutions

Expert Solution

Dear student, we cannot able to post solution more than four sub-parts of the question as per our policy.

Part 1

January February March
Credit Sales             80,900          100,900          105,900
Cash Receipts from Customers
From Current Month Credit Sales (Credit Sales*20%)             16,180             20,180             21,180

From Prior Month Credit Sales

(Previous month's credit sales * 80%) [For Jan = Accounts Receivable]

            48,000             64,720             80,720
Total Cash Receipts from Customers (1)             64,180             84,900          101,900
Total Cash Receipts from customers for January (Answer 1)             64,180

Part 2 and 3

January February March
COGS (Sales * 40%)             32,360             40,360             42,360
Add: Desired Ending Inventory (Next month’s COGS * 15%)               6,054               6,354
Total Inventory Needed             38,414             46,714
Less: Beginning Inventory [Jan = From balance sheet]               9,600               6,054
Inventory Purchases             28,814             40,660
Cash Payments for Inventory Purchases
For Current Month Purchases (Inventory Purchases * 60%)             17,288             24,396

For Prior Month Purchases

(Next month's inventory purchases * 40%) (Jan = Balancesheet)

            23,500             11,526
Total Cash Payments for Inventory Purchases             40,788             35,922
Total Purchases of Inventory for January (Answer 2)             28,814
Total Cash Payments for Purchases of Inventory for February (Answer 3)             35,922

Part 4

January February March
Credit Sales             80,900          100,900          105,900
Multiply: Commission (%) 3% 3% 3%
Commission Expenses               2,427               3,027               3,177
Total Commission Expense for January (Answer 4)               2,427

Related Solutions

The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially completed Master Budget for January and February. Use the information to answer the 22 Multiple Choice Questions, each asking for a missing number from the Master Budget. Round all your computations to the nearest dollar. Sales are expected to be $80,900 in January, $100,900 in February, and $105,900 in March. All sales are on credit and it collects 20% of all sales in the...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially completed Master Budget for January and February. Use the information to answer the 22 Multiple Choice Questions, each asking for a missing number from the Master Budget. Round all your computations to the nearest dollar. Sales are expected to be $80,900 in January, $100,900 in February, and $105,900 in March. All sales are on credit and it collects 20% of all sales in the...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially completed Master Budget for January and February. Use the information to answer the 22 Multiple Choice Questions, each asking for a missing number from the Master Budget. Round all your computations to the nearest dollar. Sales are expected to be $80,900 in January, $100,900 in February, and $105,900 in March. All sales are on credit and it collects 20% of all sales in the...
The partially complete 2012 balance sheet and income statement for Challenge Industries are given below, followed...
The partially complete 2012 balance sheet and income statement for Challenge Industries are given below, followed by selected ratio values for the firm based on its completed 2012 financial statements. Use the ratios along with the partial statements to complete the financial statements. Hint: Use the ratios in the order listed to calculate the missing statement values that need to be installed in the partial statements. Challenge Industries, Inc. Balance Sheet At December 31, 2012 (in $ thousands) Assets Liabilities...
Beginning balances of FRS Company’s accounts as of January 1, 2018 as given below: Beg Balance...
Beginning balances of FRS Company’s accounts as of January 1, 2018 as given below: Beg Balance Account Title Debit Credit Cash 365,800 Accounts Receivable 42,500 Supplies 13,000 Prepaid Insurance 0 Inventory 18,000 Equipment 46,000 Accumulated Depreciation-Equipment 20,000 Accounts Payable 82,500 Salary Payable 16,000 Unearned Sales Revenue 25,000 Capital 341,800 Withdrawals 0 Sales Revenue Sales Returns& Allowances Sales Discounts Cost of Goods Sold Insurance Expense Depreciation Expense-Equipment Supplies Expense Salary Expense Total 485,300 485,300 During January 2018, FRS Company completed the...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
A condensed balance sheet for Simultech Corporation and a partially completed vertical analysis are presented below....
A condensed balance sheet for Simultech Corporation and a partially completed vertical analysis are presented below. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of total assets. 2-a. What percentage of Simultech’s total assets relate to inventory? 2-b. What percentage of Simultech’s total assets relate to property and equipment? 2-c. Which of these two asset groups is more significant to Simultech’s business? 3. What percentage of Simultech’s assets is financed by total stockholders'...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 31,000 $ 28,000 Accounts receivable 18,000 20,000 Inventory 58,000 56,000 Prepaid expenses 12,000 10,000 Total current assets 119,000 114,000 Property, plant, and equipment 374,000 354,000 Less accumulated depreciation 190,000 165,000 Net property, plant, and equipment 184,000 189,000 Total assets $ 303,000 $ 303,000 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 13,000 $ 9,000 Accrued liabilities 52,000...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 32,000 $ 25,800 Accounts receivable 18,500 21,000 Inventory 60,000 57,500 Prepaid expenses 12,200 10,100 Total current assets 122,700 114,400 Property, plant, and equipment 386,000 366,000 Less accumulated depreciation 193,000 164,700 Net property, plant, and equipment 193,000 201,300 Total assets $ 315,700 $ 315,700 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 14,700 $ 10,000 Accrued liabilities 53,000...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 33,000 $ 26,300 Accounts receivable 19,000 22,000 Inventory 62,000 59,000 Prepaid expenses 12,400 10,200 Total current assets 126,400 117,500 Property, plant, and equipment 398,000 378,000 Less accumulated depreciation 199,000 170,100 Net property, plant, and equipment 199,000 207,900 Total assets $ 325,400 $ 325,400 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 16,200 $ 11,000 Accrued liabilities 54,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT