Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income 546,000 April $ 580,000 406,000 May $ 780,000 June $ 400,000 280,000 July $ 380,000 266,000 174,000 234,000 120,000 114,000 78,000 98,000 59,000 38,000 44,000 59,200 36,800 36,000 122,000 157,200 95,800 74,000 $ 52,000 $ 76,800 $ 24,200 $ 40,000 *Includes $21,000 of depreciation each month. 5 b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with 10% collected in the month of sale; 70% collected in the first month following the month of sale; and the remaining 20% collected in the second month following the month of sale. February's sales totaled $195,000, and March's sales totaled $240,000. d. Inventory purchases are paid for within 15 days. Therefore, 50% of a month's inventory purchases are paid for in the month of purchase. The remaining 50% is paid in the following month. Accounts payable at March 31 for inventory purchases during March total $107,800. e. Each month's ending inventory must equal 20% of the cost of the merchandise to be sold in the following month. The merchandise inventory at March 31 is $81,200. f. Dividends of $28,000 will be declared and paid in April. g. Land costing $36,000 will be purchased for cash in May. h. The cash balance at March 31 is $50,000; the company must maintain a cash balance of at least $40,000 at the end of each month. i. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $200,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Required: 1. Prepare a schedule of expected cash collections for April, May, and June, and for the quarter in total. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for April, May, and June. b. A schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in total. 3. Prepare a cash budget for April, May, and June as well as in total for the quarter.

Need help

Assume the following information for a merchandising company: Number of units sold Selling price per unit. Variable selling expense per unit Variable administrative expense per unit Fixed administrative expenses Beginning merchandise inventory Ending merchandise inventory Merchandise purchases What is the amount of total variable expenses? 20,700 $ 30 $ 3 $2 $ 50,000 $ 24,000 $ 19,000 $ 341,000

III MT217_Unit... Period Ending Total Sales ABC Company Income Statement 31-Dec-15 Cost of Goods Sold $485,651,000 365,086,000 31-Dec-14 $476,294,000 358,069,000 31-Dec-13 $475,210,000 350,400,000 Gross Profit 120,565,000 118,225,000 124,810,000 Selling Generall and Adminstrative 93,418,000 91,353,000 90,343,000 Operating Profit 27,147,000 26,872,000 34,467,000 Total Other Income/Expenses Net 113,000 119,000 115,000 Earnings before Interest and Taxes 27,034,000 26,753,000 34,352,000 Interest Expense 2,461,000 2,335,000 2,200,000 Income Before Tax 24,573,000 24,418,000 32,152,000 Income Tax Expense 7,985,000 8,105,000 9,800,000 Net Income from Continuing Ops 16,588,000 16,313,000 22,352,000 Discontinued Operations 285,000 Net Income (Net Profit) $16.303,000 144,000 $16,169,000 182,000 $22,170,000 14,000,000 Shares outstanding Market Share price per share $10.00 $9.00 $8.50 Q ABC Company Balance Sheet Period Ending 2015 2014 2013 Assets Current Liabilities Current Assets Accounts Payable…

The following is the year ended data for Tiger​ Company:   Sales Revenue $58,000 Cost of Goods Manufactured 21,000 Beginning Finished Goods Inventory 1,100 Ending Finished Goods Inventory 2,200 Selling Expenses 15,000 Administrative Expenses 3,900   What is the gross​ profit?   A. $22,100   B. $38,100   C. $19,200   D.

s

The following is the year ended data for Tiger Company: Sales Revenue Cost of Goods Manufactured Beginning Finished Goods Inventory Ending Finished Goods Inventory Selling Expenses Administrative Expenses What is the cost of goods available for sale? O A. $5,700 OB. $29,300 OC. $26,700 O D. $24,300 $51,000 28,000 1,300 2,600 15,100 3,500

Warrior Industries Income Statement for year ending 12/31/20XX Sales revenue Less cost of goods sold Gross margin Less operating expenses Marketing Sales and administrative Depreciation ood to go Total operating expenses Operating income Less interest expense Income before taxes Income tax expense Net income E 40,000 20,000 10,000 5. 456,428 205,200 251,228 70,000 181,228 7,000 174,228 40,000 134,228 Assets Current Assets Cash Accounts receivable Inventory Fixed assets Total assets O Warrior Industries Balance Sheet for 12/31/20XX Total current assets Property, plant and equipment Accumulated depreciation Net fixed assets Liabilities and Owner's Equity Current liabilities Accounts payable Note payable to bank Deposits from customers N Total current liabilities Long term mortgage Owner's Equity Total liabilities Retained earnings Total Owners' Equity Total liability and equities $ 52,400.00 $ 11,000.00 $ 15,900.00 $ 79,300.00 $ 80,000.00 $ (20,000.00) $ 60,000.00 $139,300.00 $ 5,300.00…