You are the new manager of the local Greatbuy Electronics store. Top management of Greatbuy Electronics is convinced that management training should include the active participation of store managers
You are the new manager of the local Greatbuy Electronics store. Top management of Greatbuy Electronics is convinced that management training should include the active participation of store managers in the budgeting process. You have been asked to prepare complete master budget for your store June, July, and August. All accounting is done centrally so you have no expert help on the premises. In addition, tomorrow the branch manager and the assistant controller will be here to examine your work; at that time, they will assist you in formulating the final budget document. The idea is to have you prepare the initial budget on your own so that you gain more confidence about accounting matters. You want to make a favorable impression on your supervisors, so you gather the financial statement and sales data of may 31, 2008.
Credit sales are 70% of the total sales. Seventy percent of each credit account is collected in the following the sale and the remaining 30% are collected in the subsequent month. Assume the bad debts are negligible and can be ignored. The accounts receivable on May 31 are the result of bad credit sales for April and May:
(.30 * .70 * $130,000) + (1.0 * .70 * $130,000) = $118, 300.
The policy is to acquire enough inventories each month to equal to the following month’s projected cost of goods sold. All purchases are paid for in the month following purchase.
The average gross profit on sales is 37%. Salaries, wages, and commissions average 24% of sales; all other items are $9,000 monthly. Assume that these variable and fixed expenses require cash disbursements each month. Depreciation is $ 1,000 monthly.
In June, $5,000 is going to be disbursed for fixtures acquired and recorded in furniture and fixtures in may. The May 31 balance accounts payable includes this amount.
Assume that a minimum cash balance of $ 4,000 is to be maintained. Also assume that all borrowings are effective the beginning of the month and all repayments are made at the end of the month of repayment. Interest is compounded and added to the outstanding balance each month, but interest is paid only at the ends of months when principal is repaid. The interest is 9% per year; round interest computations and interest payments to the nearest dollar. Interest payment may be any dollar amount but all borrowing and repayments of principal are made in multiples of $ 1,000.
1. Prepare a budget income statement for the coming June- august quarter, a cash budget for each of the 3months, and a budgeted balance sheet for August 31, 2008. All Operations are evaluated on before-income- taxes may be ignored here.
2. Explain why there is need for a bank loan and what operating sources supply cash for repaying the bank loan.
Cash $ 6,600 Recent and Projected Sales
Inventory 151,200 April $130,000
Account receivable 118,300 May 130,000
Net furniture and fixtures 52,000 June 240,000
Total Assets $328,100 July 170,000
Accounts payable $ 156, 200 August 170,000
Owner’s equity 171,900 September 120,000
Total liabilities & O&E $328,100