In: Accounting
Problem 21-2A (Part Level Submission)
Deleon Inc. is preparing its annual budgets for the year ending December 31, 2017. Accounting assistants furnish the data shown below.
Product |
Product |
|||
Sales budget: | ||||
Anticipated volume in units | 402,300 | 203,700 | ||
Unit selling price | $23 | $27 | ||
Production budget: | ||||
Desired ending finished goods units | 28,100 | 18,100 | ||
Beginning finished goods units | 34,100 | 12,500 | ||
Direct materials budget: | ||||
Direct materials per unit (pounds) | 1 | 3 | ||
Desired ending direct materials pounds | 34,000 | 18,500 | ||
Beginning direct materials pounds | 44,600 | 13,400 | ||
Cost per pound | $3 | $3 | ||
Direct labor budget: | ||||
Direct labor time per unit | 0.4 | 0.6 | ||
Direct labor rate per hour | $12 | $12 | ||
Budgeted income statement: | ||||
Total unit cost | $14 | $22 |
An accounting assistant has prepared the detailed manufacturing
overhead budget and the selling and administrative expense budget.
The latter shows selling expenses of $661,000 for product JB 50 and
$361,000 for product JB 60, and administrative expenses of $545,000
for product JB 50 and $344,000 for product JB 60. Interest expense
is $150,000 (not allocated to products). Income taxes are expected
to be 30%.
Prepare the production budget for the year.
DELEON INC.
Production Budget
JB 50
JB 60
402,300
203,700
:
18,500
18,100
:
Production Budget | |||
For the Year Ended Dec 31, 2017 | |||
JB 50 | JB 60 | Total | |
Sales In Units | 402,300 | 203,700 | |
Add: Closing Inventory in Units | 28,100 | 18,100 | |
Total Needs | 430,400 | 221,800 | |
Less: opening Inventory in Units | (34,100) | (12,500) | |
Required Production in Units | 396,300 | 209,300 | 605,600 |