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:
Debits Credits
Cash $ 48,000
Accounts receivable 224,000
Inventory 60,000
Buildings and equipment (net) 370,000
Accounts payable $ 93,000
Common stock 500,000
Retained earnings 109,000
$ 702,000 $ 702,000
b. Actual sales for December and budgeted sales for the next four months are as follows:
December(actual) $ 280,000
January $ 400,000
February $ 600,000
March $ 300,000
April $ 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.
f. 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,700 cash. During March, other equipment will be purchased for cash at a cost of $84,500.
i. During January, the company will declare and pay $45,000 in cash dividends.
j. 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 simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.
Required:
Using the data above, complete the following statements and schedules for the first quarter:
1. Schedule of expected cash collections:
2-a. Merchandise purchases budget:
2-b. Schedule of expected cash disbursements for merchandise purchases:
3. Cash budget:
4. Prepare an absorption costing income statement for the quarter ending March 31.
5. Prepare a balance sheet as of March 31.

Hillyard Company

1. Schedule of expected cash collections:

                                       January       February       March        April

December(actual)       $ 280,000

January $ 400,000         80,000     $320,000

February $ 600,000                           120,000    $480,000

March $ 300,000                                                      60,000   $240,000

April $ 200,000                                                                            40,000

Total                            $360,000    $440,000    $540,000

2-a. Merchandise purchases budget:

                                     January       February         March          

Cost of goods sold     240,000       360,000        180,000      

Ending Inventory          90,000         45,000          30,000

Goods available         330,000       405,000         210,000

Opening Inventory     (60,000)       (90,000)        (45,000)

Purchases                $270,000     $315,000      $165,000

2-b. Schedule of expected cash disbursements for merchandise purchases:

Budgeted Purchases Disbursement:

                                       January       February        March          April

December(actual)       $ 93,000

January $270,000       135,000       $ 135,000

February $315,000                              157,500      $ 157,500

March $165,000                                                          82,500    $ 82,500

Total                          $228,000       $292,500     $240,000

3. Cash budget:

                                       January       February       March     Total

Beginning balance        $48,000      $30,000       $30,800     $48,000

Cash collections           360,000       440,000      540,000   1,340,000

Total                            $408,000    $470,000     $570,800 $1,388,000

Disbursements:

Purchases                    228,000       292,500      240,000    (760,500)

Salaries & wages           27,000          27,000        27,000       (81,000)

Advertising                    70,000          70,000        70,000     (210,000)

Shipping (5% sales)      20,000          30,000        15,000       (65,000)

Other Expense 3%        12,000          18,000          9,000       (39,000)

Equipment                                             1,700        84,500       (86,200)

Dividend                       45,000                                                 (45,000)

Total disbursement $402,000    $439,200    $445,500   (1,286,700)

Loan + Interest             24,000                             24,720            ( 720)    

Ending balance              6,000         30,800      100,580        100,580

Required

Minimum cash bal.      30,000         30,000       30,000

Interest on loan = $720 ($24,000 x 1% x 3)

4. Prepare an absorption costing income statement for the quarter ending March 31:

Sales                                 $1,300,000

Cost of goods sold               780,000

Gross profit                        $520,000

Expenses:

Salaries & Wages   81,000

Advertising           210,000

Shipping expense 65,000

Other expenses    39,000

Depreciation         42,000

Interest expense       720   (437,720)

Net Income                            82,280

5. Prepare a balance sheet as of March 31:

Assets:

Cash                                   $100,580

Accounts Receivable          240,000

Inventory                               30,000

Buildings & Equipment       414,200

Total Assets                     $

Liabilities + Equity:

Accounts Payable            $82,500

Common Stock               500,000

Retained Earnings           146,280

Total                              $

Explanation:

a) Data:

General Ledger Balances:

                                                    Debits             Credits

Cash                                           $ 48,000

Accounts receivable                  224,000

Inventory                                      60,000

Buildings and equipment (net) 370,000

Accounts payable                                           $ 93,000

Common stock                                                500,000

Retained earnings                                            109,000

                                              $ 702,000     $ 702,000

b) Budgeted Cash Collections

                                       January       February       March        April

December(actual)       $ 280,000

January $ 400,000         80,000     $320,000

February $ 600,000                           120,000    $480,000

March $ 300,000                                                      60,000   $240,000

April $ 200,000                                                                             40,000

Total                           $360,000     $440,000    $540,000

Ending Accounts Receivable balance = $240,000

c) Cost of goods sold

                                     January       February       March        Total

Sales                          $400,000    $600,000     $300,000    $1,300,000

Shipping costs 5%        20,000         30,000          15,000           65,000

Other Expense 3%        12,000          18,000           9,000            39,000

Depreciation                                                                                    42,000

Cost of goods sold     240,000       360,000        180,000         780,000

Ending Inventory          90,000         45,000          30,000

Goods available         330,000       405,000         210,000

Opening Inventory     (60,000)       (90,000)        (45,000)

Purchases                  270,000        315,000        165,000

b) Budgeted Purchases Disbursement:

                                       January       February        March          April

December(actual)       $ 93,000

January $270,000       135,000       $ 135,000

February $315,000                              157,500      $ 157,500

March $165,000                                                          82,500    $ 82,500

Ending Accounts Payable balance = $82,500

c) Retained Earnings:

Beginning   $109,000

Net Income    82,280

Dividends    (45,000)

Ending      $146,280

d) Buildings & Equipment     370,000

New additions:                        86,200

Less Depreciation expense (42,000)

Balance, net                        $414,200

a manufacturer of printed circuit boards uses exponential smoothing with trend to forecast monthly demand of its product. at the end of december, the company wishes to forecast sales for january. the estimate of trend through november has been 200 additional boards sold per month. average sales have been around 1000 units per month. the demand for december was 1100 units. the company uses α = 0.20 and β = 0.10. make a forecast including trend for the month of january.

answer; buyer guide;