Skulas, Inc., manufactures and sells snowboards. Skulas manufactures a single model, the Pipex. In late 2017, Skulas’s management accountant gathered the following data to prepare budgets for January 2018:

Materials and Labor Requirement

Direct Materials

Wood                                           9 Boards Feet (b.f.) per snowboard

Fiberglass                                    10 Yards per snowboard

Direct manufacturing labor          5 hours per snowboard

Skulas’s CEO expects to sell 2,900 snowboards during January 2018 at an estimated retail price of $650 per board. Further, the CEO expects 2018 beginning inventory of 500 snowboards and would like to end January 2018 with 200 snowboards in stock.

Direct Materials Inventories

Beginning Inventory 1/1/2018    Ending Inventory 1/31/2018

Wood                2,040 b.f.                                 1,540 b.f.

Fiberglass          1,040 yards                              2,040 yards

Alternative Text Variable manufacturing overhead is $7 per direct manufacturing labor-hour. There are also $81,000 in fixed manufacturing overhead costs budgeted for January 2018. Skulas combines both variable and fixed manufacturing overhead into a single rate based on direct manufacturing labor-hours. Variable marketing costs are allocated at the rate of $250 per sales visit. The marketing plan calls for 38 sales visits during January 2018. Finally, there are $35,000 in fixed nonmanufacturing costs budgeted for January 2018.

Other data include:

                                     2017 Unit Price                      2018 Unit Price

Wood                           $32.00 per b.f.                         $34.00 per b.f.

Fiberglass                    $8.00 per yard                        $9.00 per yar

Direct manu. labor        $28.00 per hour                   $29.00 per hour

Question:

Budgeted balances at January 31, 2018 are as follows:

Cash?

Accounts Receivable?

Inventory?

Property, plant and Equipment (net)                          $1,175,600

Accounts Payable                                                        ?

Long-term liabilities                                                  182,000

Stockholders equity?

Selected budget information for December 2017 follows:

Cash balance, December 31, 2017                               $124,000

Budgeted Sales                                                              $1,650,000

Budgeted materials purchases                                       $820,000 

Customer invoices are payable within 30 days. From past experience, Skulas’s accountant projects 40% of invoices will be collected in the month invoiced, and 60% will be collected in the following month. Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with 50% of direct materials purchases paid during the month of the purchase, and 50% paid in the month following purchase. Fixed manufacturing overhead costs include $64,000 of depreciation costs and fixed nonmanufacturing overhead costs include $10,000 of depreciation costs. Direct manufacturing labor and the remaining manufacturing and nonmanufacturing overhead costs are paid monthly. All property, plant, and equipment acquired during January 2018 were purchased on credit and did not entail any outflow of cash. There were no borrowings or repayments with respect to long-term liabilities in January 2018. On December 15, 2017, Skulas’s board of directors voted to pay a $160,000 dividend to stockholders on January 31, 2018.

Questions:

1. Prepare a cash budget for January 2018. Show supporting schedules for the calculation of collection of receivables and payments of accounts payable, and for disbursements for fixed manufacturing and nonmanufacturing overhead.

2. Skulas is interested in maintaining a minimum cash balance of $120,000 at the end of each month. Will Skulas be in a position to pay the $160,000 dividend on January 31?

3. Why do Skulas’s managers prepare a cash budget in addition to the revenue, expenses, and operating income budget?

4. Prepare a budgeted balance sheet for January 31, 2018 by calculating the January 31, 2018 balances in

   • (a) cash

   • (b) accounts receivable

   • (c) inventory 

   • (d) accounts payable and

   • (e) plugging in the balance for stockholders’ equity.