Sales Budget | |||
JB 50 | JB 60 | Total | |
Units sold | 403200 | 205000 | 608200 |
S.P | 22 | 27 | |
Sales | 8870400 | 5535000 | 14405400 |
Deleon INC. - Production Budget | |||
JB 50 | JB 60 | Total | |
Expected Unit Sales | 403200 | 205000 | |
Add:- Desired ending FG Units | 26,300 | 16,000 | |
Total Reqd. Units | 429500 | 221000 | |
Less:- Beginning FG Units | 31,200 | 13,300 | |
Reqd. prod. Units | 398300 | 207700 | 606000 |
Direct Materials Budget | |||
JB 50 | JB 60 | Total | |
Units to be produced | 398300 | 207700 | 606000 |
DM p.u | 2 | 2 | |
Total Pounds needed for production | 796600 | 415400 | 1212000 |
Add:- Desired ending DM | 33,300 | 17,900 | |
Total Reqd. Units | 829900 | 433300 | |
Less:- Beginning DM | 43,500 | 13,100 | |
DM purchases | 786400 | 420200 | |
Cost per pound | 2 | 3 | |
Total cost of DM purchases | 1572800 | 1260600 | 2833400 |
Direct Labour Budget | |||
JB 50 | JB 60 | Total | |
Units to be produced | 398300 | 207700 | 606000 |
Direct labour time p.u | 0.4 | 0.6 | |
Total hours needed for production | 159320 | 124620 | 283940 |
Labour rate per hour | 12 | 12 | |
Total cost of Direct labour | 1911840 | 1495440 | 3407280 |
Budgeted Income Statement | |||
JB 50 | JB 60 | Total | |
Sales | 8870400 | 5535000 | 14405400 |
Cost of Goods sold | 4838400 | 4510000 | 9348400 |
Gross Profit | 4032000 | 1025000 | 5057000 |
Operating expenses :- | |||
Selling Expenses | 6,62,000 | 3,62,000 | 1024000 |
Administrative expenses | 5,42,000 | 3,45,000 | 887000 |
Total Operating expenses | 12,04,000 | 7,07,000 | 19,11,000 |
Income before interest and Income Taxes | 28,28,000 | 3,18,000 | 31,46,000 |
Interest Expense | 1,50,000 | ||
Income before Income Taxes | 29,96,000 | ||
Income tax Expense (30%) | 8,98,800 | ||
NET INCOME | 20,97,200 | ||
COGS | 403200 * 12 | 205000 * 22 |
Prepare the direct labor budget for the year. (Round Direct labor time per unit answers to...
(d) Prepare the direct labor budget for the year. (Round Direct labor time per unit answers to 1 decimal place, e.g. 52.7.) DELEON INC. Direct Labor Budget For the Year Ending December 31, 2017 JB 50 JB 60 Total Units to be produced Click if you would like to Show Work for this question: Open Show Work Pless N Teprocess your dilswei. Problem 21-2A (Part Level Submission) Deleon Inc. is preparing its annual budgets for the year ending Dece Pro...
Problem 21-2A Deleon Inc. is preparing its annual budgets for the year ending December 31, 2017. Accounting assistants furnish the data shown below. Problem 21-2A Deleon Inc. is preparing its annual budgets for the year ending December 31, 2017. Accounting assistants furnish the data shown below. Product JB 60 Product JВ 50 Sales budget: Anticipated volume in units 403,200 205,000 Unit selling price $22 $27 Production budget: Desired ending finished goods units 26,300 16,000 Beginning finished goods units 31,200 13,300...
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,800 203,900 $23 $28 27,800 34,900 19,000 13,600 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...
Deleon Inc. is preparing its annual budgets for the year ending December 31, 2020. Accounting assistants furnish the data shown below. Product Product JB 50 JB 60 403,200 203,300 $23 $28 28,000 33,500 17,000 12,100 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...
Problem 22-02A Deleon Inc. is preparing its annual budgets for the year ending December 31, 2020. Accounting assistants furnish the data shown below. Product JB 50 Product JB 60 403,400 $22 201,800 $27 27,500 32,800 17,200 13,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:...
Deleon Inc. is preparing its annual budgets for the year ending December 31, 2020. Accounting assistants furnish the data shown below. Product JB 50 Product JB 60 Sales budget: Anticipated volume in units 403,200 203,400 Unit selling price $22. $21 Production budget: Desired ending finished goods units 26,700 19.700 Beginning finished goods units 32,500 11.4 Direct materials budget: 2 Direct materials per unit (pounds) Desired ending direct materials pounds Beginning direct materials pounds Cost per pound 34,300 44,300 Direct labor...
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 JB 50 Product JB 60 404,400 $23 202,600 $28 27,300 34,700 19,000 13,000 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...
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 JB 50 Product JB 60 Sales budget: Anticipated volume in units 403,400 201,800 Unit selling price $22 $27 Production budget: Desired ending finished goods units 27,500 17,200 Beginning finished goods units 32,800 13,800 Direct materials budget: Direct materials per unit (pounds) 2 3 Desired ending direct materials pounds 31,100 17,800 Beginning direct materials...
Problem 22-02A (Part Level Submission) Deleon Inc. is preparing its annual budgets for the year ending December 31, 2020. Accounting assistants furnish the ssignment page below. Product JB 50 Product JB 60 400,000 200,000 $25 $20 30,000 25,000 15,000 10,000 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...
Problem 21-2A Deleon Inc. is preparing its annual budgets for the year ending December 31, 2017. Accounting assistants furnish the data shown below. Product JB 50 Product JB 60 204,600 404,400 $21 $27 27,900 34,100 16,900 13,400 2 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...