Question;PROBLEM #5;Hillyard Company prepares its master;budget on a quarterly basis. The following data have been assembled to assist;in preparation of the master budget for the first quarter of 2014;a. As of December 31, 2013, the company?s;balance sheet showed the following account balances;Cash $ 48,000 Accounts Payable $ 93,000;Accounts;Receivable 156,800 Capital Stock;400,000;Less: Allowance for bad debt (4,480) $152,320;Retained Earnings 137,320 Inventory 60,000;Plant;Equipment (net) 370,000;$630,320 $630,320;======= =======;b. Actual sales for December and budgeted sales;for the next four months are as follows;Dec.-$280,000 Jan.-$400,000 Feb.-$600,000 Mar.-$300,000 Apr.-$200,000;c. Sales are 20 percent for cash and 80 percent;on credit. The collection pattern for;credit sales, which is not expected to change over the next six months, is 30;percent in the month of sale, 68 percent one month after the month of sale, and;2 percent uncollectible.;d. The monthly;gross profit rate is 40 percent of sales.;e. Monthly expenses are budgeted as;follows: salaries and wages, $27,000 per;month, advertising, $50,000 per month plus 4 percent of previous month?s sales;and other expenses, 3% of sales. These expenses are paid for in the month in;which they are incurred. Depreciation;expense is $14,000 per month.;f. At the end of each month, inventory is to be;on hand equal to 25 percent of the following month?s sales needs stated at;cost.;g. One half of a;month?s inventory purchases are paid for in the month of purchase, the other;half is paid for in the following month.;h. During January, the company will purchase a;new copy machine for $1,700 cash. During February, other equipment will be;purchased for $80,000 (25% cash down payment with the remaining balance to be;paid in four equal installments beginning one month after the date of;purchase).;i. During January, the company will declare and;pay $45,000 in cash dividends.;A. Prepare a well labeled Schedule of;Expected Cash Collections (not an entire cash budget) for each month (January;February, and March) of the first quarter of 2014.;B. Prepare a well labeled Inventory;Purchases Budget (in $) for each month (January, February, and March) of the;first quarter of 2014.;C. Prepare a well labeled Schedule of;Cash Disbursements (not an entire cash budget) for each month (January;February, and March) of the first quarter of 2014.;D. Assume that at the end of January, 2014;Hillyard Company?s Cash Budget indicates a negative cash balance. Other than;borrowing money, list at least three distinctly different recommendations for;alleviating this expected negative cash balance.
Paper#50610 | Written in 18-Jul-2015Price : $29