I need help with this please
Problem 4: Budgeting Suppose that you manage Whitewater Sporting Goods Store No. [3, which carries a complete line of outdoor recreation gear. You are to prepare the master budget for your store for April, May. June and July, the main selling season. The division manager and the assistance controller [head of the accounting department} of the company will arrive from headquarters next week to review the budget with you. The balance sheet of your store as at Sll'j" JuneI 2|] [9, the beginning of the budget period, is shown in the following Whitewater Sporting Goods Store No. 13 Balance Sheet as at 31} June1 21119 - Liabilities and {laser's - Iui .- Current assets: Current liabilities: Cash Accounts payable 5115, Bill) Accounts receivable Salary and commissions payable 4,251} Inventory Prepaid Insurance Plat assets: $21, 1151] Plant assets: Equipment and xtures Accumulated depreciation Owner's equity $101}, llllll Total assets Total liabilities and owner's equity :- Cash collections follow sales because the company sells on account. When extra cash is needed, the company borrows on six-month instalment notes payable. :- Sales in June 30' were $4ll. Dill]. Monthly sales are projected by sales personnel: July '5 5D. Dill] August ED. Dill] September 6D. Dctubet 5D, DUI] :- Sales are t} percent cash and 4D percent on credit. All credit sales are collected in the month following the sale. The $ lo, [Hill of accounts receivable at June 3|] arose from credit sales made in June [4|] percent of $411] }. Uncollectible accounts are insignificant. Whitewater maintains inventory equal to $20 000 plus 80 percent of the budgeted cost of goods sold for the following month. (All these percentages are drawn from the business's past experience). Cost of goods sold averages 70 percent of sales. Whitewater pays for inventory as follows: 50 percent during the month of purchase 50 percent during the next month. Accounts payable consists of inventory purchases only. Monthly payroll has two parts: a salary of $2, 500 plus commissions equal to 15 percent of sales. The company pays half of this amount during the month and half early in the following month. Therefore, at the end of each month Whitewater reports salary and commissions payable equal to half the month's payroll. . Other monthly expenses are: Rent expense $ 2 000, paid as incurred Depreciation expense, including truck 500 Insurance expense 200 expiration of prepaid amount Miscellaneous expense 5% of sales, paid as incurred. A used delivery truck will be purchased in July for $3, 000 cash. Whitewater requires each store to maintain a minimum cash balance of $10, 000 at the end of each month. The store can borrow money on notes payable of $10, 000 each at an annual rate of 12 percent. Management borrows no more than the amount needed to maintain the $10, 000 minimum balance. Notes payable require six equal monthly payments consisting of principal plus monthly interest on the entire unpaid principal. Borrowing and all principal and interest payment occur at the end of the month. Income taxes are the responsibility of corporate headquarters, so you can ignore tax for budgeting purposes. Required: You have studied the company guideline on how to prepare a budget. The directions instruct you to prepare the following detailed schedules: Schedule Sales budget Purchases, cost of goods sold, and inventory budget Operating expenses budget Budgeted cash collections from customers Budgeted cash disbursement for purchases Budgeted cash disbursement for operating expenses After preparing these schedules, you are asked to prepare a summary statement of budgeted cash receipts and disbursements (a cash budget)
