Question

Self-Study Problem 10-1 Master Budget
Hansell Company’s management wants to prepare budgets for one of its products, Duraflex, for July 2019. The firm sells the product for $91 per unit and has the following expected sales (in units) for these months in 2019:
April May June July August September
3,900 6,500 6,600 8,200 9,200 5,800
The production process requires 4 pounds of Dura-1000 and 2 pounds of Flexplas. The firm’s policy is to maintain an ending inventory each month equal to 10% of the following month’s budgeted sales, but in no case less than 500 units. All materials inventories are to be maintained at 5% of the production needs for the next month, but not to exceed 1,000 pounds. The firm expects all inventories at the end of June to be within the guidelines. The purchases department expects the materials to cost $1.25 per pound and $5.00 per pound for Dura-1000 and Flexplas, respectively.
The production process requires direct labor at two skill levels. The rate for labor at the K102 level is $50 per hour and $20 per hour for the K175 level. The K102 level can process one batch of duraflex per hour; each batch consists of 100 units. The manufacturing of Duraflex also requires one-tenth of an hour of K175 workers’ time for each unit manufactured.
Required:
On the basis of the preceding data and projections, prepare the following budgets:
a. Sales budget for July (in dollars).
b. Production budget for July (in units).
c. Production budget for August (in units).
d. Direct materials purchases budget for July (in pounds).
e. Direct materials purchases budget for July (in dollars).
f. Direct manufacturing labor budget for July (in dollars).

Answer 1

Answer:

a.-Sales Budget (in dollars).      

     

Budgeted sales in units     6,000

Budgeted selling price per unit            $40  

Budgeted sales              $240,000  

     

     

b.  Production Budget (in units)  

 

     

Desired ending inventory (July 31)      

(The higher of 100 and 7,000 x 0,1)     700

Budgeted sales for July 2002    + 6,000

Total units needed for July 2002     6700

Beginning inventory (July 1)    -  

(The higher of 100 and 6,000 x 0,1)     600

Units to manufacture in July     6100

C.-Production Budget (in units)  

for August 2002  

Desired ending inventory (8,000 x 0,1)     800

Budgeted sales    + 7,000

Total units needed     7800

Beginning inventory    - 700

Units to manufacture in August     7100

d.-Direct Materials Purchases Budget (in pounds)      

For July 2002      

      Direct Materials  

     Dura-tOOO  Flexplas

     (4Ib. each)  (2Ib. each)

       

d Materials required for budgeted        

production (6,100 units of duraflex)     24,400    12,200  

Add: Target inventories (lower of 1,000 or 5 percent of        

August production needs)   1,420   710   1000   710  

Total materials requirements      25,400    12,910  

Less: Expected beginning inventories (lower of 1,000 orr 5 percent)                                                                                     .                                                      1,220   610   1000   610  

Direct materials to be purchased    24,400    12,300  

e.Direct Materials Purchases Budget (in dollars)        For July 2002        

     Budgeted  Expected  

     Purchases  Purchase  

     (Pounds)  Price per Unit  Total

Dura-lOOO      24,400    $1.25    $30,500  

Flexplas       12,300    $5.00    $61,500  

Budgeted purchases         $92,000  

Explanation:

The firm's policy is to maintain a minimum of 100 units of duraflex on hand at alltimes with no fewer than 10 percent of units on hand at the end of a period to meet              

the expected sales for the following month. 100     10%  

             

All materials inventories are to be maintained at 5 ercent of the production needs for the next month, 5%  but not to exceed 1000 pounds 1000                      

The firm expects all inventories at the end of June to be within the Guidelines.

The purchase department expects the materials to cost $1.25 per pound          $1.25 and $5.00 per pound of dura-lOOO and flexplas, respectively.          $5.00      

             

The production process requires direct labor at two skill levels.          rate per unit  The rate for labor at the K102 level is $50 per hour and           $50.00   $0.50 for the K175 level is $20 per hour.   $20.00      

The K102 level can process one batch of duraflex per hour;          1  each batch consists of 100 units. 100  No. of units in one hour rate per unit              

The manufacturing of duraflex also requires one-tenth of an hour of K175 workers' time 0.10  10.0   $2.00  for each unit manufactured.                          

Manufactured overhead is allocated at the rate of $200 per batch and $30 per $200.00  per batch DIirect labor-hour. $30.00  per direct labor-hour.