Problem 8-31 (Static) Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Cash. Accounts receivable Inventory Buildings and equipment (net) Accounts payable Common stock Retained earnings 48,000 224,000 60,000 370,000 $ 93,000 500,000 109,000 $ 702,000 $ 702,000 b. Actual sales for December and budgeted sales for the next four months are as follows: December (actual) January February March April $280,000 $ 400,000 $ 600,000 $ 300,000 $ 200,000 c. Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales. d. The company's gross margin is 40% of sales. (In other words, cost of goods sold is 60% of sales.) e. Monthly expenses are budgeted as follows: salaries and wages, $27,000 per month: advertising, $70,000 per month; shipping, 5% of sales; other expenses, 3% of sales. Depreciation, including depreciation on new assets acquired during the quarter, will be $42,000 for the quarter.