Reference no: EM131784611

Assignment: MASTER BUDGET PREPARATION

Dean's Devices Corporation has the following balance sheet at December 31, 2012:

                           Assets                                                                  Liabilities

Cash......................................     $10,200          Accounts payable ...............      $ 5,400

 

Accounts receivable ...................  17,200              

 

Inventories:

 

Direct materials (4,400 units)........ 8,800                           

 

Finished goods (1,400 units)          20,160            Stockholder's Equity

 

Equipment ............................... 50,000               Common stock ....................10,500

 

Less: Accumulated depreciation ...(30,000)            Retained earnings .............. 60,460

 

Total liabilities and Total assets .....$76,360           Stockholders' equity             $ 76,360

The company is preparing its budget for the first quarter of 2013 and has collected the data below:

a. The sales forecast is 2,000; 1,700; 1,600; and 1,500 units for January, February, March, and April, respectively. The unit sales price is $16. All sales are on credit and collections are 40% in the month of sale and 60% the following month. Accounts receivable is for credit sales only.

b. At the end of each month Dean's Devices wants a finished goods inventory equal to 70% of the next month's sales and a direct materials inventory of 120% of that month's production requirement.

c. A unit of finished product requires 3 pounds of direct material at $2 a pound, and 30 minutes of direct labor at $7 an hour. Direct materials purchases are paid 25% in the month of purchase and 75% in the following month. Accounts payable is for credit purchases only. All other costs are paid in the month incurred.

d. Manufacturing overhead consist of the following: indirect materials $0.50 per unit, indirect labor $0.60 per unit, other variable costs $0.40 per unit, salaries $3,000 per month, depreciation $1,500 per month, and other fixed costs $1,110 per month.

e. Selling costs are sales commissions ($0.30 per unit sold) and shipping ($0.14 per unit sold). Administrative costs each month are: salaries $800; rent $500; and depreciation $400.

f. Dean's Devices plans to buy equipment costing $10,000 in January.

Prepare the master budget for the first quarter of 2013 for each month and the quarter in total.