60.1K

Verified Solution

Link Copied!

applied leadninf has decided to revise its budget to show fourth quarter sales of 950 tablets due to the expectation of increased holiday sales. First quarter sales for the followinf yead are expected to be 950. The companh desires to have an ending Finished Goods Inventory each quarter to equal 40% of the next quarters sales.

Requirement 1a. Revise the sales budget

Requirement 1b. Revise rhe production budget

Requirement 2. Describe how the followinf budgets will be affected without revising the budgets

ed Learning prepared the following tuge okton to view the budget) Sied Learning has decided to revisits toget to show fourth quarter of the expectation of word holiday Fire quarters for wing you need to be the most hea aling Finished wory uchun qul to 40% of the next one's sales and the main Quarter To quirement fa. Revise the sales budget Aled Ling Sales Budget For the Yew Ended December 3, 2029 Second Third Fourth Quarter Quarter Quarter udgets to be price per unit Surat Requirement th. Revise the production budget Apple Learning Production Bogel For the Year 31, 2017 Second Thi Quarter Quarter Fourth Quarter Total Choose from any ator enter any number in the inputs and then co to the next question dutehon py Applied Lawning prepared the following budget Click the loon to view the budget) Applied Laming has decided to visits budget to show fourth quarters of 950 tablets due to the operation of increased holders for the following repeded to be The company to hewan ending Finished Goods Inventoryacht equal to 40% of the rest quarter's sale Read the Applied Learning Production Budget For the Year Ended December 31, 2027 Second Third Quarter Quarter Quarter Fourth Quarter Total Plus Total tabledanded Bedste tab to be died Requirement 2. Describe how the following budgets be affected without in the budget 2. Direct material budget Since production the amount of directed Sharefore purchases of materials will be required Die labor budget. The change in production will the amount of bored, the direct laborc Feed the change e. Maracturing overed budget. The change in production the amount of variatie manufacturing over therefore, variable manufacturing ovec.com In production takes olid Laing outstage Choose from any list or enter any number in the input fields and then continue to the next question Requirement 2. Describe how the following budgets will be affected without revising the budget a. Din materials budgetice production wil the amount of director will there puth of ma wiewed b. Direct labor budget. The change in production will the amount of labor read therefore, director e Manufacturing overhead get the change in production wil the amount of ander overhead, www com in production takes Applied Leaming out of its relevan d. Cost of goods sold budget: The change in production will the production compte tests with red among unterwondered location The change in production will have a afect on production costs because food manufacturing whead.com portion de production cool Theologos units sold Seling and administrative expense Budget: deling and administrative costs will We now les takes oled Looming out of its meant trone verte bryder with the change in sales Choose from any list or enter any number in the input fields and then continue to the next question Applied Learning Sales Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Fourth Quarter Total 500 800 900 Budgeted tablets to be sold Sales price per unit 450 300 $ 2,650 300 $ 300 $ 300||$ 300||$ $ 135,000 $ 150,000 $ 240,000 $ 270,000 $ 795,000 Total sales Applied Learning Production Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Fourth Quarter Total Budgeted tablets to be sold 450 500 320 800 360 900 380 2,650 380 200 Plus: Desired tablets in ending inventory Total tablets needed Less: Tablets in beginning inventory 650 820 1.160 320 1,280 360 3,030 400 400 200 LU 400 Tablets in beginning inventory Budgeted tablets to be produced 200 320 360 400 250 620 840 920 2,630 Applied Learning Direct Materials Budget For the Year Ended December 31, 2027 First Second Quarter Quarter Third ng bu Fourth Quarter Quarter Total on will 250 840 620 4 920 2,630 4 4 luct 2.480 1,000 1.240 Budgeted tablets to be produced Direct materials (pounds) per tablet Direct materials needed for production Plus: Desired direct materials in ending inventory (pounds) Total direct materials needed Less: Direct materials in beginning inventory (pounds) Budgeted purchases of direct materials Direct materials cost per pound 3,360 1,840 mang fits 3.680 1,852 1,680 10,520 1,852 2,240 1,600 4,160 1.240 5.200 1,680 5,532 1,840 12,372 1,600 in po OVE 640 70 S 2,920 70 S 3.520 70 S 3,692 70S 10.772 70 old $ 5 Budgeted cost of direct materials purchases 44,800 $ 204,400 S 246,400 $ get: 258,440||$ 754,040 ane geted cost of direct materials purchases 44,8005 204,4005 246,400||$ 258,4405 754,04 Fourth Applied Learning Direct Labor Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Budgeted tablets to be produced 250 620 840 Direct labor hours per unit 5 5 5 Direct labor hours needed for production 1,250 3.100 4,200 Direct labor cost per hour 16 $ 16||$ 16 $ 1 20,000 49,600 $ 67,200 $ Budgeted direct labor cost Quarter Total 920 2,630 5 5 $ 4,600 16 S 13,150 16 $ s 73,600 $ 210,400 Applied Learning Manufacturing Overhead Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Fourth Quarter Total Budgeted tablets to be produced 250 620 840 920 2,630 budget More Info bud arter 1 250 40 $ 620 40 $ 840 40 $ 920 40 $ 2,630 40 $ 10,000 $ 24,800 $ 33,600 $ 36,800 $ 105,200 Budgeted tablets to be produced VOH cost per tablet Budgeted VOH Budgeted FOH Depreciation Utilities, insurance, property taxes Total budgeted FOH Budgeted manufacturing overhead costs 3,500 49.100 3,500 49,100 3,500 3,500 49.100 14,000 198,400 49,100 52,600 52,600 52,600 52,600 gby 210,400 62,600 $ 77 400 $ 86,200 $ 89,400$ 315,600 n wi uctid 1.250 3.100 4,200 4,600 13,150 Direct labor hours Budgeted manufacturing overhead costs Predetermined overhead allocation rate 315,600 $ $ 24 ang its npi Applied Learning Cost of Goods Sold Budget For the Year Ended December 31, 2027 First Second Third Fourth pt: Quarter Quarter Quarter Quarter Total e ann nal Print Done -in First Second Third Fourth Quarter Quarter Quarter Quarter Total $ Begir inventory Tablets produced and sold in 2027 Total budgeted cost of goods sold 92,000 24,000 $ 240,000 $ $ 384,000 $ 432,000 92,000 1,080,000 $ 116,000 $ 240,000 $ 384,000 $ 432,000||$ 1,172,000 Fourth Quarter Total 25,000 $ GO Applied Learning Selling and Administrative Expense Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Salaries Expense $ 25,000||$ 25,000 $ 25,000 S Rent Expense 29,000 29,000 29,000 Insurance Expense 2,200 2.200 2,200 Depreciation Expense 1,700 1,700 1.700 2.700 3,000 4,800 Supplies Expense 60.600 $ 60,900 $ 62,700 $ Total budgeted selling and administrative expense Supplies expense is 2% of sales revenue. 29,000 2 200 100,000 116,000 8.800 6,800 15.900 1,700 5,400 63 300 s 247,500 en Print Done ed Learning prepared the following tuge okton to view the budget) Sied Learning has decided to revisits toget to show fourth quarter of the expectation of word holiday Fire quarters for wing you need to be the most hea aling Finished wory uchun qul to 40% of the next one's sales and the main Quarter To quirement fa. Revise the sales budget Aled Ling Sales Budget For the Yew Ended December 3, 2029 Second Third Fourth Quarter Quarter Quarter udgets to be price per unit Surat Requirement th. Revise the production budget Apple Learning Production Bogel For the Year 31, 2017 Second Thi Quarter Quarter Fourth Quarter Total Choose from any ator enter any number in the inputs and then co to the next question dutehon py Applied Lawning prepared the following budget Click the loon to view the budget) Applied Laming has decided to visits budget to show fourth quarters of 950 tablets due to the operation of increased holders for the following repeded to be The company to hewan ending Finished Goods Inventoryacht equal to 40% of the rest quarter's sale Read the Applied Learning Production Budget For the Year Ended December 31, 2027 Second Third Quarter Quarter Quarter Fourth Quarter Total Plus Total tabledanded Bedste tab to be died Requirement 2. Describe how the following budgets be affected without in the budget 2. Direct material budget Since production the amount of directed Sharefore purchases of materials will be required Die labor budget. The change in production will the amount of bored, the direct laborc Feed the change e. Maracturing overed budget. The change in production the amount of variatie manufacturing over therefore, variable manufacturing ovec.com In production takes olid Laing outstage Choose from any list or enter any number in the input fields and then continue to the next question Requirement 2. Describe how the following budgets will be affected without revising the budget a. Din materials budgetice production wil the amount of director will there puth of ma wiewed b. Direct labor budget. The change in production will the amount of labor read therefore, director e Manufacturing overhead get the change in production wil the amount of ander overhead, www com in production takes Applied Leaming out of its relevan d. Cost of goods sold budget: The change in production will the production compte tests with red among unterwondered location The change in production will have a afect on production costs because food manufacturing whead.com portion de production cool Theologos units sold Seling and administrative expense Budget: deling and administrative costs will We now les takes oled Looming out of its meant trone verte bryder with the change in sales Choose from any list or enter any number in the input fields and then continue to the next question Applied Learning Sales Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Fourth Quarter Total 500 800 900 Budgeted tablets to be sold Sales price per unit 450 300 $ 2,650 300 $ 300 $ 300||$ 300||$ $ 135,000 $ 150,000 $ 240,000 $ 270,000 $ 795,000 Total sales Applied Learning Production Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Fourth Quarter Total Budgeted tablets to be sold 450 500 320 800 360 900 380 2,650 380 200 Plus: Desired tablets in ending inventory Total tablets needed Less: Tablets in beginning inventory 650 820 1.160 320 1,280 360 3,030 400 400 200 LU 400 Tablets in beginning inventory Budgeted tablets to be produced 200 320 360 400 250 620 840 920 2,630 Applied Learning Direct Materials Budget For the Year Ended December 31, 2027 First Second Quarter Quarter Third ng bu Fourth Quarter Quarter Total on will 250 840 620 4 920 2,630 4 4 luct 2.480 1,000 1.240 Budgeted tablets to be produced Direct materials (pounds) per tablet Direct materials needed for production Plus: Desired direct materials in ending inventory (pounds) Total direct materials needed Less: Direct materials in beginning inventory (pounds) Budgeted purchases of direct materials Direct materials cost per pound 3,360 1,840 mang fits 3.680 1,852 1,680 10,520 1,852 2,240 1,600 4,160 1.240 5.200 1,680 5,532 1,840 12,372 1,600 in po OVE 640 70 S 2,920 70 S 3.520 70 S 3,692 70S 10.772 70 old $ 5 Budgeted cost of direct materials purchases 44,800 $ 204,400 S 246,400 $ get: 258,440||$ 754,040 ane geted cost of direct materials purchases 44,8005 204,4005 246,400||$ 258,4405 754,04 Fourth Applied Learning Direct Labor Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Budgeted tablets to be produced 250 620 840 Direct labor hours per unit 5 5 5 Direct labor hours needed for production 1,250 3.100 4,200 Direct labor cost per hour 16 $ 16||$ 16 $ 1 20,000 49,600 $ 67,200 $ Budgeted direct labor cost Quarter Total 920 2,630 5 5 $ 4,600 16 S 13,150 16 $ s 73,600 $ 210,400 Applied Learning Manufacturing Overhead Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Fourth Quarter Total Budgeted tablets to be produced 250 620 840 920 2,630 budget More Info bud arter 1 250 40 $ 620 40 $ 840 40 $ 920 40 $ 2,630 40 $ 10,000 $ 24,800 $ 33,600 $ 36,800 $ 105,200 Budgeted tablets to be produced VOH cost per tablet Budgeted VOH Budgeted FOH Depreciation Utilities, insurance, property taxes Total budgeted FOH Budgeted manufacturing overhead costs 3,500 49.100 3,500 49,100 3,500 3,500 49.100 14,000 198,400 49,100 52,600 52,600 52,600 52,600 gby 210,400 62,600 $ 77 400 $ 86,200 $ 89,400$ 315,600 n wi uctid 1.250 3.100 4,200 4,600 13,150 Direct labor hours Budgeted manufacturing overhead costs Predetermined overhead allocation rate 315,600 $ $ 24 ang its npi Applied Learning Cost of Goods Sold Budget For the Year Ended December 31, 2027 First Second Third Fourth pt: Quarter Quarter Quarter Quarter Total e ann nal Print Done -in First Second Third Fourth Quarter Quarter Quarter Quarter Total $ Begir inventory Tablets produced and sold in 2027 Total budgeted cost of goods sold 92,000 24,000 $ 240,000 $ $ 384,000 $ 432,000 92,000 1,080,000 $ 116,000 $ 240,000 $ 384,000 $ 432,000||$ 1,172,000 Fourth Quarter Total 25,000 $ GO Applied Learning Selling and Administrative Expense Budget For the Year Ended December 31, 2027 First Second Third Quarter Quarter Quarter Salaries Expense $ 25,000||$ 25,000 $ 25,000 S Rent Expense 29,000 29,000 29,000 Insurance Expense 2,200 2.200 2,200 Depreciation Expense 1,700 1,700 1.700 2.700 3,000 4,800 Supplies Expense 60.600 $ 60,900 $ 62,700 $ Total budgeted selling and administrative expense Supplies expense is 2% of sales revenue. 29,000 2 200 100,000 116,000 8.800 6,800 15.900 1,700 5,400 63 300 s 247,500 en Print Done

Answer & Explanation Solved by verified expert

See Answer