Question

Deleon Inc. is preparing its annual budgets for the year ending December 31, 2017. Accounting assistants furnish the data shown below. Product Product JB 50 JB 60 402.300 201.600 523 528 27.300 31.300 19.500 11.800 Sales budget Anticipated volume in units Unit selling price Production budget Desired ending finished goods units Beginning finished goods units Direct materials budget Direct materials per unit (pounds) Desired ending direct materials pounds Beginning direct materials pounds Cost per pound Direct labor budget: Direct labor time per unit Direct labor rate per hour Budgeted income statement: Total unit cost 32.700 41.500 19.500 12.400 53 53 0.4 $11 0.6 $11 $14 $21 An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $662,000 for product JB 50 and $364,000 for product JB 60, and administrative expenses of $544,000 for product JB 50 and $342,000 for product JB 60. Interest expense is $150,000 (not allocated to products). Income taxes are expected to be 30%. Your answer is correct. Prepare the sales budget for the year. DELEON INC. Sales Budget For the Year Ending December 31, 2017 Expected unit sules Unit selling prices Total sales e Textbook and Media

Answer 1

Solution:

Sales Budget - Deleon Inc.
Particulars	JB50	JB60	Total
Expected unit sales	402300	201600
Selling price per unit	$23.00	$28.00
Projected Sales Revenue	$9,252,900.00	$5,644,800.00	$14,897,700.00

Budgeted Income Statement - Deleon Inc. For the year ended Dec 31, 2017
Particulars	JB50	JB60	Total
Sales Revenue	$9,252,900.00	$5,644,800.00	$14,897,700.00
Cost of goods sold JB 50 - 402300*$14 JB 60 - 201600*$21	$5,632,200.00	$4,233,600.00	$9,865,800.00
Gross Profit	$3,620,700.00	$1,411,200.00	$5,031,900.00
Operating Expenses:
Selling Expenses	$662,000.00	$364,000.00	$1,026,000.00
Administrative expenses	$544,000.00	$342,000.00	$886,000.00
Total Operating expenses	$1,206,000.00	$706,000.00	$1,912,000.00
Operating Income	$2,414,700.00	$705,200.00	$3,119,900.00
Interest expense			$150,000.00
Income before taxes			$2,969,900.00
Income tax expense (30%)			$890,970.00
Net Income			$2,078,930.00