Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i. j. Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to
i. j. 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 Debits Credits $43,000 Accounts receivable 202,400 Inventory 58,200 Buildings and equipment (net) 353,000 Accounts payable $ 86,025 Common stock 500,000 Retained earnings 70,575 f. $ 656,600 $656,600 b. Actual sales for December and budgeted sales for the next four months are as follows: December(actual) January February March April $253,000 $ 388,000 $585,000 $ 299,000 $196,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, $18,000 per month: advertising, $58,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,580 for the quarter. Each month's ending inventory should equal 25% of the following month's cost of goods sold. g. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid in the following month. h. During February, the company will purchase a new copy machine for $1,300 cash. During March, other equipment will be purchased for cash at a cost of $71,500. During January, the company will declare and pay $45,000 in cash dividends. Management wants to maintain a minimum cash balance of $30,000. 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. The interest rate on these loans is 1% per month and for
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started