The Art of Mathematics in Business. Dr Jae K Shim

The Art of Mathematics in Business - Dr Jae K Shim


Скачать книгу
financial budget consists of:

      

Cash budget

      

Pro forma balance sheet

      The major steps in preparing the budget are:

      1. Prepare a sales forecast.

      2. Determine expected production volume.

      3. Estimate manufacturing costs and operating expenses.

      4. Determine cash flow and other financial effects.

      5. Formulate projected financial statements.

      Figure 9.1 shows a simplified diagram of the various parts of the comprehensive (master) budget, the master plan of the company.

      Illustration

      To illustrate how all these budgets are put together, we will focus on a manufacturing company called the Putnam Company, which produces and markets a single product. We will make the following assumptions:

      

The company uses a single material and one type of labor in the manufacture of the product.

      

It prepares a master budget on a quarterly basis.

      

Work in process inventories at the beginning and end of the year are negligible and are ignored.

      

The company uses a single cost driver—direct labor hours (DLH)---as the allocation base for assigning all factory overhead costs to the product.

      The Sales Budget

      The sales budget is the starting point in preparing the master budget, since estimated sales volume influences nearly all other items appearing throughout the master budget. The sales budget should show total sales in quantity and value. The expected total sales can be break-even or target income sales or projected sales. It may be analyzed further by product, by territory, by customer and, of course, by seasonal pattern of expected sales.

      Generally, the sales budget includes a computation of expected cash collections from credit sales, which will be used later for cash budgeting.

Image

      The Putnam Company – Sales Budget

Image Image
+All of the $100,000 accounts receivable balance is assumed to be collectible in the first quarter.
++40 percent of a quarter’s sales are collected in the quarter of sale.
+++60 percent of a quarter’s sales are collected in the quarter following.

      Frequently, there are time lags between monthly sales made on account and their related monthly cash collections. For example, in any month, credit sales are collected as follows: 15% in month of sale, 60% in the following month, 24% in the month after, and the remaining 1 percent are uncollectible.

Image

      The budgeted cash receipts for June and July are computed as follows:

      For June:

From April sales $320 × .24 $ 76.80
From May sales 200 × .60 120.00
From June sales 300 × .15 45.00
Total budgeted collections in June $241.80

      For July:

From May sales $200 × .24 $ 48
From June sales 300 × .60 180
From July sales 280 × .15 42
Total budgeted collections in July $270

      The Production Budget

      After sales are budgeted, the production budget can be determined. The production budget is a statement of the output by product and is generally expressed in units. It should take into account the sales budget, plant capacity, whether stocks are to be increased or decreased and outside purchases. The number of units expected to be manufactured to meet budgeted sales and inventory requirements is set forth in the production budget.

Image

      The production budget is illustrated as follows:

      The Putnam Company – Production Budget

Image
* 10 percent of the next quarter’s sales. (For example, 180 = 10% × 1,800).
** Given.
*** The same as the previous quarter’s ending inventory.

      Putnam Company is a manufacturing firm, so it prepares a production budget, as shown in Schedule 2. If it were a merchandising (retailing or wholesaling) firm, then instead of a production budget, it would develop a merchandise purchase budget showing the amount of goods to be purchased from its suppliers during the period. The merchandise purchases budget is in the same basic format as the production budget, except that it shows goods to be purchased rather than goods to be produced, as shown below:

Budgeted cost of goods sold (in units or dollars) $560,000
Add: Desired ending merchandise inventory 120,000
Total needs $680,000
Less: Beginning merchandise inventory (80,000)
Required purchases (in units or in dollars) $600,000

      Note:

      1.Cost of goods sold = beginning inventory + purchases − ending inventory.

      Hence, purchases = cost of goods sold + ending inventory − beginning inventory

      2.Gross profit (margin) = sales


Скачать книгу