Following are the budgeted income statements for the second
quarter of 2019 for SeaTech Inc.:
April | May | June | |||||||||
Sales | $ | 210,000 | $ | 255,000 | $ | 285,000 | |||||
Cost of goods sold* | 144,000 | 171,000 | 189,000 | ||||||||
Gross profit | $ | 66,000 | $ | 84,000 | $ | 96,000 | |||||
Operating expenses† | 33,000 | 37,500 | 40,500 | ||||||||
Operating income | $ | 33,000 | $ | 46,500 | $ | 55,500 | |||||
* Includes all product costs (i.e., direct
materials, direct labor, and manufacturing overhead).
† Includes all period costs (i.e., selling,
general, and administrative expenses).
The company expects about 30% of sales to be cash transactions. Of
sales on account, 60% are expected to be collected in the first
month after the sale is made, and 40% are expected to be collected
in the second month after sale. Depreciation, insurance, and
property taxes represent $18,000 of the estimated monthly cost of
goods sold and $12,000 of the estimated monthly operating expenses.
The annual insurance premium is paid in January, and the annual
property taxes are paid in August. Of the remainder of the cost of
goods sold and operating expenses, 80% are expected to be paid in
the month in which they are incurred, and the balance is expected
to be paid in the following month.
Current assets as of April 1, 2019, consist of cash of $21,000 and
accounts receivable of $224,700 ($157,290 from March credit sales
and $67,410 from February credit sales). Current liabilities as of
April 1 consist of $27,000 of accounts payable for product costs
incurred in March; $6,900 of accrued liabilities for operating
expenses incurred in March; and a $60,000, 14%, 120-day note
payable that is due on April 17, 2019.
An estimated income tax payment of $60,000 will be made in May. The
regular quarterly dividend of $24,000 is expected to be declared in
May and paid in June. Capital expenditures amounting to $25,800
will be made in April.
Required:
a. Complete the monthly cash budgets for the second
quarter of 2019 using the following format. Note that the ending
cash balance for June is provided as a check figure. (Use
360 days year for calculations.)
b. Assume that management of SeaTech Inc. desires
to maintain a minimum cash balance of $18,800 at the beginning of
each month and has arranged a $100,000 line of credit with a local
bank at an interest rate of 10% to ensure the availability of
funds. Borrowing transactions are to occur only at the end of
months in which the budgeted cash balance would otherwise fall
short of the $18,800 minimum balance. Repayments of principal and
interest are to occur at the end of the earliest month in which
sufficient funds are expected to be available for repayment.
(Do not round intermediate calculations.
Use 360 days year for calculations.)
Answer for A
Answer for B
Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April...
This is ALL the information for the question!! I don't
understand the comment no data available? The red X's are all
wrong.
Following are the budgeted Income statements for the second quarter of 2019 for SeaTech Inc: Sales Cost of goods sold Gross profit Operating expenses Operating income April $266, eee 182,400 $ 83,600 41,800 May $323,600 216,600 $196,400 47,500 $ 58,900 June $361,000 239,400 $121, 6ee 51,300 $ 70,3ee $ 41,800 Includes all product costs (.e., direct materials, direct...
i am missing a few parts in each chart and unsure how to find
them. thank you for your help!
How are the budgeted Income statements for the second quarter of 2016 for SeaTech, Inc. Cost of pood Gross profit Operating expenses Operating income $35.2005 49.500 59200 Includes all product costs (le, direct materials, direct labor, and manufacturing overhead Tincludes all period costs (le, seling, general, and administrative expenses). The company expects about 30% of sales to be cash transactions...
Compute the following for Iguana inc for the second quarter (April,
May, June)
We were unable to transcribe this imageIguana, Inc., had $11,100 cash on hand on April 1. Of its sales, 80 percent is in cash of the credit sales, 50 percent is collected during the month of the sale, and 50 percent is collected during the month following the sale. of direct materials purchases, 80 percent is paid for during the month purchased and 20 percent is paid...
a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 470,000 $1,000,000 $450,000 $ 350,000 329,000 700,000 315,000 245,000 141,000 300,000 135,000 105,000 Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense Total selling and administrative expenses Net operating income 91,000 42,500 133,500 7,500 $ 95,000 56,800 151,800 148,200 $ 56,000 35,000 9 1,000 44,000 $ 35,000 33,000 68,000 37,000 $ *Includes $17,000 of depreciation each month. b. Sales...
Complete Iguana’s budgeted income statement for quarter
2
Requirea information The following information applies to the questions displayed below.) Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame r es 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $11 per hour Iguana has the following inventory policies: • Ending finished goods inventory should be 40 percent of next month's sales. •...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May $ 550,000 $750,000 385,000 525,000 165,000 225,000 June $ 450,000 315,000 135,000 July $ 350,000 245,000...
just need help with: the cash budget(8) budgeted income
statement for the entire second quarter (9) and (10) budgeted
balanve sheet
Problem 07-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 550,000 $ 750,000 $ 450,000 $ 350,000 385,000 525,000 315,000 245,000...
PR 22-4A Cash budget OBJ. 5 The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash bud- get 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...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 450,000 $ 980,000 $ 430,000 $ 330,000 Cost of goods sold...