Tyler Sheen is the owner of MTE Incorporated. He provided the selected opening balances as at June 1,
2019 and the budgeted information for June and July 2019.
Selected Opening Balances as of June 1, 2019 |
|
Cash Inventory Noncurrent Assets Accounts Payable Stockholder’s Equity |
$75,000 130,000 240,000 100,000 50,000 640,000 |
Budgeted Amounts |
|
For the month of June: Total Revenue Total Capital Expenditures For the month of July: Total Revenue Total Capital Expenditures |
$310,000 195,000 150,000 410,000 200,000 250,000 |
The company’s monthly depreciation represents 20% of general and
administration costs. Sixty percent
of the general and administration costs (excluding depreciation)
are paid in the month in which they are incurred, and the rest is
recorded in accounts payable to be paid in the next month. Of the
$150,000 capital expenditures for June, $125,000 will be paid in
July. The remaining amount will be paid in the month in which they
are incurred.
a) Calculate the total cash disbursement for the month of June.
b) Calculate the total cash disbursement for the month of July.
Tyler Sheen is the owner of MTE Incorporated. He provided the selected opening balances as at...
AP-10B LO 6 a Inc. provides you with the following budgeted information: May $510,000 June $450,000 280,000 July $550,000 Sales 150,000 250,000 Manufacturing Costs 120,000 400,000 Lal expenditures (machinery and buildings) 210,000 100,000 70,000 General and administration costs (excluding depreciation) 183 3096 will be cold month. The remainder month in which they Expectations Cash sales represent 10% of total sales. 70% of the credit sales is collected in the month of sale and the remaining 30% the following month The...
Candice Inc. provides you with the following budgeted information for two months in 2018: March April Sales 600,000 700,000 Manufacturing Costs 300,000 300,000 Capital Expenditures* 300,000 - General and Administration Costs (including amortization) 70,000 90,000 *Induces training programs, machines and building Expectations: Cash sales represent 20% of total sales All sales on account are collected in the following month 50% of March’s $300,000 worth of capital expenditures is to be paid at the end of March. The remainder is to be paid in the following month. Monthly amortization represents...
Melanie Inc. provides you with the following budgeted information for two months in year 2013: March April Sales $600,000 $630,000 Manufacturing Costs 230,000 400,000 Capital Expenditures* 275,000 25,000 General and Administration Costs (including amortization) 100,000 125,000 *includes training programs, machines and buildings Expectations: Cash sales represent 10% of total sales All sales on account are collected in the following month 65% of March’s $275,000 worth of capital expenditures is to be paid at the end of March. The remainder is...
Problem 21(7)-4B Excell Assignments
Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. 1 An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded. Enter a zero in cells you would otherwise leave blank. nim ARS August SS Mercury Shoes Inc. Cash Budget For the Three Months Ending August 31 June July Estimated cash receipts from: Cash sales Collections from...
Cash Budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: June July August Sales $160,000 $185,000 $200,000 Manufacturing costs 66,000 82,000 105,000 Selling and administrative expenses 40,000 46,000 51,000 Capital expenditures 120,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and...
The consulting firm of Martin and Associates uses the accounts listed below. Record the opening balances as of December 1, 2019 on the normal balance side of the following T-Accounts. List of accounts with their opening balances: Cash $ 5,300 Fees Income -0- Accounts Receivable 8,300 Rent Expense -0- Office Equipment 7,800 Utilities Expense -0- Accounts Payable 5,800 Salaries Expense -0- Joan Martin, Capital 15,600 Joan Martin, Drawing -0- The firm has the following transactions during the month of December...
task 2.1 prepare the general ledger by entering the opening
balances from trial balance
Micro Systems Trial Balance as at 30th June 2019. Debit Credit $ 2,160 7,000 3,000 100 130,695 31,600 8,400 4,500 DY Account Name epreciation Accumulated Depreciation - equipment 20 Accumulated depreciation - motor vehicle Advertising Allowance for doubtful debts Sales Capital - John Franklin Poral Cash at bank Accounts Payable Control Accounts Receivable Control Drawings - John Franklin Equipment at cost GST Collected A.GST Paid Residential...
The consulting firm of Martin and Associates uses the accounts listed below. Record the opening balances as of December 1, 2019 on the normal balance side of the following T-Accounts. List of accounts with their opening balances: -0- -O- Cash $ 5,900 Fees Income Accounts Receivable 8,900 Rent Expense Utilities Office Equipment 8,400 Expense Accounts Payable 7,000 Salaries Expense Joan Martin, Capital 16,200 Joan Martin, Drawing -0- The firm has the following transactions during the month of December 2019. Record...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $134,000 $159,000 $216,000 Manufacturing costs 56,000 68,000 78,000 Selling and administrative expenses 39,000 43,000 48,000 Capital expenditures _ _ 52,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $86,000 $90,000 $95,000 Manufacturing costs 34,000 39,000 44,000 Selling and administrative expenses 15,000 16,000 22,000 Capital expenditures _ _ 80,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...