Need solutions to the following problems. Please provide spreadsheet.

*Exercise 22-15 (part level submission) Deitz Inc. has three divisions which are operated as profit centers. Actual operating data for the divisions are listed below. *(a) Compute the missing amounts. Operating Data Contribution margin Women's Shoes Men's Shoes $268,500 Controllable fixed costs 107,400 Sales 644,400 $ Controllable margin Variable costs Children's Shoes (3) $193,320 (4) (1) (2) 96,660 483,300 343,680 (5) 102,030 268,500 (6) Attempts: 0 of 3 used *(b) The parts of this question must be completed in order. This part will be available when you complete the part above. Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Exercise 22-2 Crede Company budgeted selling expenses of $30,819 in January, $35,291 in February, and $39,642 in March. Actual selling expenses were $32,627 in January, $34,672 in February, and $46,931 in March. (a) Prepare a selling expense report that compares budgeted and actual amounts by month and for the year to date. Month January February March Budget Actual By Month CREDE COMPANY Selling Expense Report For the Quarter Ending March 31 Difference Budget Actual Year-to-Date $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Difference $ Question Attempts: 0 of 3 used Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Exercise 22-5 DeWitt Company uses flexible budgets to control its selling expenses. Monthly sales are expected to range from $166,400 to $204,500. Variable costs and their percentage relationship to sales are sales commissions 8%, advertising 4%, traveling 3%, and delivery 2%. Fixed selling expenses will consist of sales salaries $34,627, depreciation on delivery equipment $7,209, and insurance on delivery equipment $1,699. Prepare a monthly flexible budget for each $12,700 increment of sales within the relevant range for the year ending December 31, 2014. (List variable costs before fixed costs.) DEWITT COMPANY Monthly Selling Expense Flexible Budget For the Year 2014 $ $ $ $ $ $ $ $ $ $ $ $ Question Attempts: 0 of 3 used Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Exercise 22-9 (part level submission) Lowell Company's manufacturing overhead budget for the first quarter of 2014 contained the following data. Variable Costs Indirect materials Indirect labor Utilities Maintenance $11,885 10,130 7,827 5,520 Fixed Costs Supervisory salaries Depreciation Property taxes and insurance Maintenance $35,857 7,041 7,011 4,802 Actual variable costs were indirect materials $15,388, indirect labor $9,343, utilities $9,140, and maintenance $5,106. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $8,654. The actual activity level equaled the budgeted level. All costs are considered controllable by the production department manager except for depreciation, and property taxes and insurance. *(a) Prepare a manufacturing overhead flexible budget report for the first quarter. (List variable costs before fixed costs.) LOWELL COMPANY Manufacturing Overhead Flexible Budget Report For the Quarter Ended March 31, 2014 Budget Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual $ $ $ $ $ $ Attempts: 0 of 3 used *(b) The parts of this question must be completed in order. This part will be available when you complete the part above. Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Problem 22-3A (part level submission) Hill Company uses budgets in controlling costs. The August 2014 budget report for the company's Assembling Department is as follows. HILL COMPANY Budget Report Assembling Department For the Month Ended August 31, 2014 Manufacturing Costs Variable costs Direct materials Budget Actual Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) $48,600 $47,500 $1,100 F Indirect materials 28,200 28,460 260 U Utilities 19,800 Direct labor Indirect labor Maintenance Total variable Fixed costs Rent Supervision Depreciation Total fixed Total costs 57,600 19,800 7,200 54,960 2,640 F 19,330 470 F 19,600 200 F 7,540 340 U 181,200 177,390 3,810 F 10,350 10,350 -0- N 7,530 -0- N 17,140 7,530 35,020 $216,220 17,140 35,020 $212,410 -0- N -0- N $3,810 F The monthly budget amounts in the report were based on an expected production of 60,000 units per month or 720,000 units per year. The Assembling Department manager is pleased with the report and expects a raise, or at least praise for a job well done. The company president, however, is unhappy with the results for August because only 58,000 units were produced. *(a) State the total monthly budgeted cost formula. (Round cost per unit to 2 decimal places, e.g. 1.25.) The formula = $ *(b1) + variable costs of $ per unit. Attempts: 0 of 3 used The parts of this question must be completed in order. This part will be available when you complete the part above. *(c) The parts of this question must be completed in order. This part will be available when you complete the part above. Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Problem 22-5A (part level submission) Suppan Company manufactures a variety of tools and industrial equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Home Division for the year ended December 31, 2014, and relevant budget data are as follows. Actual Sales $1,400,470 Variable cost of goods sold Comparison with Budget $100,480 favorable 675,160 Variable selling and administrative expenses 54,500 unfavorable 125,920 Controllable fixed cost of goods sold 25,000 unfavorable 169,390 Controllable fixed selling and administrative expenses On target 80,500 On target Average operating assets for the year for the Home Division were $2,000,070 which was also the budgeted amount. *(a) Prepare a responsibility report for the Home Division. (List variable costs before fixed costs. Round ROI to 1 decimal place, e.g. 1.5%.) SUPPAN MANUFACTURING COMPANY Home Division Responsibility Report For the Year Ended December 31, 2014 $ Budget $ $ ROI Actual $ $ % Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) $ % % Attempts: 0 of 3 used *(c) The parts of this question must be completed in order. This part will be available when you complete the part above. Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. Exercise 22-2 A) Prepare a selling Expense Report Month January February March $ $ $ Budget 30,819.00 $ 35,291.00 $ 39,642.00 $ CREDE COMPANY Selling Expense Report For the Quarter Ending March 31 By Month Actual Difference 32,627.00 $ 1,808.00 U 34,672.00 $ 619.00 F 46,931.00 $ 7,289.00 U $ $ $ Budget 30,819.00 $ 66,110.00 $ 105,752.00 $ Year-to-Date Actual 32,627.00 $ 67,299.00 $ 114,230.00 $ Difference 1,808.00 U 1,189.00 U 8,478.00 U Exercise 22-5 A) Prepare a selling Expense Flexible Budget DEWITT COMPANY Monthly Selling Expense Flexible Budget For the year 2014 Activity Level Sales Variable Expenses Sales Commissions Advertising Travelling Delivery Total Variable Expenses Fixed Expenses Salaries Depreciation Insurance Total Fixed Expenses Total Expenses $ 166,400.00 $ 179,100.00 $ 191,800.00 $ 204,500.00 $ $ $ $ $ 13,312.00 6,656.00 4,992.00 3,328.00 28,288.00 $ $ $ $ $ 14,328.00 7,164.00 5,373.00 3,582.00 30,447.00 $ $ $ $ $ 15,344.00 7,672.00 5,754.00 3,836.00 32,606.00 $ $ $ $ $ 16,360.00 8,180.00 6,135.00 4,090.00 34,765.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 71,823.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 73,982.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 76,141.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 78,300.00 Exercise 22-9 A) Prepare a manufacturing overhead flexible Budget LOWELL COMPANY Manufacturing Overhead Flexible Budget Report For the Quarter Ending March 31, 2014 Budget Variable Costs Indirect Materials Indirect Labor Utilities Maintenance Total Variable Costs Fixed Costs Supervisory Salaries Depreciation Prop. Taxes & Insurance Maintenance Total Fixed Costs Total Costs Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual $ $ $ $ $ 11,885 10,130 7,827 5,520 35,362 $ $ $ $ $ 15,388 9,343 9,140 5,106 38,977 $ $ $ $ $ 3,503 787 1,313 414 3,615 U F U F U $ $ $ $ $ $ 35,857 7,041 7,011 4,802 54,711 90,073 $ $ $ $ $ $ 35,857 7,041 8,654 4,802 56,354 95,331 $ $ $ $ $ $ 1,643 1,643 5,258 N N U N U U Exercise 22-15 A) Computing the missing amount Operating Data Contribution Margin Controllable Fixed Costs Controllable Margin Sales Variable Costs $ $ $ $ $ Women's Shoes 268,500 107,400 161,100 644,400 375,900 $ $ $ $ $ Men's Shoes 139,620 42,960 96,660 483,300 343,680 $ $ $ $ $ Children's Shoes 193,320 91,290 102,030 461,820 268,500 Exercise 22-3A A) Total Monthly Budget Cost Formula The Formula = $ 35,020 + Variable Costs of $ $ 3.02 Per Unit Exercise 22-5A A) Prepare a responsibility Report for the Home Division SUPPAN MANUFACTURING COMPANY Home Division Responsibility Report For the Quarter Ending March 31, 2014 Budget Sales Less: Variable Cost Variable Cost of Goods sold Variable Selling and Administrative Expenses Total Variable Cost Contribution Margin Less: Fixed Cost Fixed Cost of Goods sold Fixed Selling and Administrative Expenses Total Fixed Cost Net Income ROI $ Actual 1,299,990 $ 1,400,470 $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) 100,480 F $ $ $ $ 620,660 100,920 721,580 578,410 $ $ $ $ 675,160 125,920 801,080 599,390 $ $ $ $ 54,500 25,000 79,500 20,980 U U U F $ $ $ $ 169,390 80,500 249,890 328,520 16.4% $ $ $ $ 169,390 80,500 249,890 349,500 17.5% $ $ $ $ 20,980 1.0% N N N F F Exercise 22-2 A) Prepare a selling Expense Report Month January February March $ $ $ Budget 30,819.00 $ 35,291.00 $ 39,642.00 $ CREDE COMPANY Selling Expense Report For the Quarter Ending March 31 By Month Actual Difference 32,627.00 $ 1,808.00 U 34,672.00 $ 619.00 F 46,931.00 $ 7,289.00 U $ $ $ Budget 30,819.00 $ 66,110.00 $ 105,752.00 $ Year-to-Date Actual 32,627.00 $ 67,299.00 $ 114,230.00 $ Difference 1,808.00 U 1,189.00 U 8,478.00 U Exercise 22-5 A) Prepare a selling Expense Flexible Budget DEWITT COMPANY Monthly Selling Expense Flexible Budget For the year 2014 Activity Level Sales Variable Expenses Sales Commissions Advertising Travelling Delivery Total Variable Expenses Fixed Expenses Salaries Depreciation Insurance Total Fixed Expenses Total Expenses $ 166,400.00 $ 179,100.00 $ 191,800.00 $ 204,500.00 $ $ $ $ $ 13,312.00 6,656.00 4,992.00 3,328.00 28,288.00 $ $ $ $ $ 14,328.00 7,164.00 5,373.00 3,582.00 30,447.00 $ $ $ $ $ 15,344.00 7,672.00 5,754.00 3,836.00 32,606.00 $ $ $ $ $ 16,360.00 8,180.00 6,135.00 4,090.00 34,765.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 71,823.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 73,982.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 76,141.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 78,300.00 Exercise 22-9 A) Prepare a manufacturing overhead flexible Budget LOWELL COMPANY Manufacturing Overhead Flexible Budget Report For the Quarter Ending March 31, 2014 Budget Variable Costs Indirect Materials Indirect Labor Utilities Maintenance Total Variable Costs Fixed Costs Supervisory Salaries Depreciation Prop. Taxes & Insurance Maintenance Total Fixed Costs Total Costs Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual $ $ $ $ $ 11,885 10,130 7,827 5,520 35,362 $ $ $ $ $ 15,388 9,343 9,140 5,106 38,977 $ $ $ $ $ 3,503 787 1,313 414 3,615 U F U F U $ $ $ $ $ $ 35,857 7,041 7,011 4,802 54,711 90,073 $ $ $ $ $ $ 35,857 7,041 8,654 4,802 56,354 95,331 $ $ $ $ $ $ 1,643 1,643 5,258 N N U N U U B) Responsibility report LOWELL COMPANY Manufacturing Overhead Responsibility Report For the Quarter Ending March 31, 2014 Controllable Costs Indirect Material Indirect Labor Utilities Maintenance Supervisor Salaries Budget $ $ $ $ $ $ Actual 11,885 10,130 7,827 5,520 35,857 71,219 $ $ $ $ $ $ 15,388 9,343 9,140 5,106 35,857 74,834 $ $ $ $ $ $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) 3,503 U 787 F 1,313 U 414 F - N 6,017 U Exercise 22-15 A) Computing the missing amount Operating Data Contribution Margin Controllable Fixed Costs Controllable Margin Sales Variable Costs $ $ $ $ $ Women's Shoes 268,500 107,400 161,100 644,400 375,900 $ $ $ $ $ Men's Shoes 139,620 42,960 96,660 483,300 343,680 $ $ $ $ $ Children's Shoes 193,320 91,290 102,030 461,820 268,500 B) Responsibility report DEITZ INC Women's Shoe Division Responsibility Report For the Quarter Ending March 31, 2014 Budget Contribution Margin Controllable Fixed Costs Controllable Margin Sales Variable Costs $ $ $ $ $ Actual 268,500 107,400 161,100 644,400 375,900 $ $ $ $ $ 268,500 107,400 161,100 644,400 386,640 $ $ $ $ $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) - N - N - N - N 10,740 U Exercise 22-3A A) Total Monthly Budget Cost Formula The Formula = $ 35,020 + Variable Costs of $ $ B) Flexible Budget Report HILL COMPANY Budget Report Assembling Department For the Month Ended August 31, 2014 Budget Units Variable Costs: Direct Materials Direct Labor Indirect Materials Indirect Labor Utilities Maintenance Total Variable Fixed Costs Rent Supervision Depreciation Total Fixed Total Costs Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual 58,000 58,000 $ $ $ $ $ $ $ 46,980 55,680 27,260 19,140.00 19,140.00 6,960.00 175,160.00 $ $ $ $ $ $ $ 47,500 54,960 28,460 19,330.00 19,600.00 7,540.00 177,390.00 $ $ $ $ $ $ $ 520 720 1,200 190 460 580.00 3,670.00 U F U U U U U $ $ $ $ $ 10,350.00 17,140.00 7,530.00 35,020.00 210,180.00 $ $ $ $ $ 10,350.00 17,140.00 7,530.00 35,020.00 212,410.00 $ $ $ $ $ 3,670.00 N N N N U 3.02 Per Unit Exercise 22-5A A) Prepare a responsibility Report for the Home Division SUPPAN MANUFACTURING COMPANY Home Division Responsibility Report For the Quarter Ending March 31, 2014 Budget Sales Less: Variable Cost Variable Cost of Goods sold Variable Selling and Administrative Expenses Total Variable Cost Contribution Margin Less: Fixed Cost Fixed Cost of Goods sold Fixed Selling and Administrative Expenses Total Fixed Cost Net Income ROI $ Actual 1,299,990 $ 1,400,470 $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) 100,480 F $ $ $ $ 620,660 100,920 721,580 578,410 $ $ $ $ 675,160 125,920 801,080 599,390 $ $ $ $ 54,500 25,000 79,500 20,980 U U U F $ $ $ $ 169,390 80,500 249,890 328,520 16.4% $ $ $ $ 169,390 80,500 249,890 349,500 17.5% $ $ $ $ 20,980 1.0% N N N F F C) Expected ROI Expected ROI Variable Cost of goods sold is decreased by 6% Average Operating Assets are decreased by 11% Sales are increased by $199,160 and this increase is expected to increase contribution margin by $84,200 19.9% 19.6% 21.7% Exercise 22-2 A) Prepare a selling Expense Report Month January February March $ $ $ Budget 30,819.00 $ 35,291.00 $ 39,642.00 $ CREDE COMPANY Selling Expense Report For the Quarter Ending March 31 By Month Actual Difference 32,627.00 $ 1,808.00 U 34,672.00 $ 619.00 F 46,931.00 $ 7,289.00 U $ $ $ Budget 30,819.00 $ 66,110.00 $ 105,752.00 $ Year-to-Date Actual 32,627.00 $ 67,299.00 $ 114,230.00 $ Difference 1,808.00 U 1,189.00 U 8,478.00 U Exercise 22-5 A) Prepare a selling Expense Flexible Budget DEWITT COMPANY Monthly Selling Expense Flexible Budget For the year 2014 Activity Level Sales Variable Expenses Sales Commissions Advertising Travelling Delivery Total Variable Expenses Fixed Expenses Salaries Depreciation Insurance Total Fixed Expenses Total Expenses $ 166,400.00 $ 179,100.00 $ 191,800.00 $ 204,500.00 $ $ $ $ $ 13,312.00 6,656.00 4,992.00 3,328.00 28,288.00 $ $ $ $ $ 14,328.00 7,164.00 5,373.00 3,582.00 30,447.00 $ $ $ $ $ 15,344.00 7,672.00 5,754.00 3,836.00 32,606.00 $ $ $ $ $ 16,360.00 8,180.00 6,135.00 4,090.00 34,765.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 71,823.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 73,982.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 76,141.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 78,300.00 Exercise 22-9 A) Prepare a manufacturing overhead flexible Budget LOWELL COMPANY Manufacturing Overhead Flexible Budget Report For the Quarter Ending March 31, 2014 Budget Variable Costs Indirect Materials Indirect Labor Utilities Maintenance Total Variable Costs Fixed Costs Supervisory Salaries Depreciation Prop. Taxes & Insurance Maintenance Total Fixed Costs Total Costs Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual $ $ $ $ $ 11,885 10,130 7,827 5,520 35,362 $ $ $ $ $ 15,388 9,343 9,140 5,106 38,977 $ $ $ $ $ 3,503 787 1,313 414 3,615 U F U F U $ $ $ $ $ $ 35,857 7,041 7,011 4,802 54,711 90,073 $ $ $ $ $ $ 35,857 7,041 8,654 4,802 56,354 95,331 $ $ $ $ $ $ 1,643 1,643 5,258 N N U N U U B) Responsibility report LOWELL COMPANY Manufacturing Overhead Responsibility Report For the Quarter Ending March 31, 2014 Controllable Costs Indirect Material Indirect Labor Utilities Maintenance Supervisor Salaries Budget $ $ $ $ $ $ Actual 11,885 10,130 7,827 5,520 35,857 71,219 $ $ $ $ $ $ 15,388 9,343 9,140 5,106 35,857 74,834 $ $ $ $ $ $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) 3,503 U 787 F 1,313 U 414 F - N 3,615 U I have changed the value of Cell D41, But so far as other parts are concerned I don't understand how is it possible that Cell D39 which is difference of Cell C 39 and B 39 is correct a Same is with Cell B 41 and C 41, I think it's the system error rect and Cell C39 and B 39 are incorrect. Exercise 22-15 A) Computing the missing amount Operating Data Contribution Margin Controllable Fixed Costs Controllable Margin Sales Variable Costs $ $ $ $ $ Women's Shoes 268,500 107,400 161,100 644,400 375,900 $ $ $ $ $ Men's Shoes 139,620 42,960 96,660 483,300 343,680 $ $ $ $ $ Children's Shoes 193,320 91,290 102,030 461,820 268,500 B) Responsibility report DEITZ INC Women's Shoe Division Responsibility Report For the Quarter Ending March 31, 2014 Budget Sales Less: Variable Cost Contribution Margin Less: Fixed Costs Controllable Margin $ $ $ $ $ Actual 644,400 375,900 268,500 107,400 161,100 $ $ $ $ $ 644,400 386,640 257,760 107,400 150,360 $ $ $ $ $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) - N 10,740 U 10,740 U - N 10,740 U Exercise 22-3A A) Total Monthly Budget Cost Formula The Formula = $ 35,020 + Variable Costs of $ $ B) Flexible Budget Report HILL COMPANY Budget Report Assembling Department For the Month Ended August 31, 2014 Budget Units Variable Costs: Direct Materials Direct Labor Indirect Materials Indirect Labor Utilities Maintenance Total Variable Fixed Costs Rent Supervision Depreciation Total Fixed Total Costs Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual 58,000 58,000 $ $ $ $ $ $ $ 46,980 55,680 27,260 19,140.00 19,140.00 6,960.00 175,160.00 $ $ $ $ $ $ $ 47,500 54,960 28,460 19,330.00 19,600.00 7,540.00 177,390.00 $ $ $ $ $ $ $ 520 720 1,200 190 460 580.00 2,230.00 U F U U U U U $ $ $ $ $ 10,350.00 17,140.00 7,530.00 35,020.00 210,180.00 $ $ $ $ $ 10,350.00 17,140.00 7,530.00 35,020.00 212,410.00 $ $ $ $ $ 2,230.00 N N N N U 3.02 Per Unit Exercise 22-5A A) Prepare a responsibility Report for the Home Division SUPPAN MANUFACTURING COMPANY Home Division Responsibility Report For the Quarter Ending March 31, 2014 Budget Sales Less: Variable Cost Variable Cost of Goods sold Variable Selling and Administrative Expenses Total Variable Cost Contribution Margin Less: Fixed Cost Fixed Cost of Goods sold Fixed Selling and Administrative Expenses Total Fixed Cost Net Income ROI $ Actual 1,299,990 $ 1,400,470 $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) 100,480 F $ $ $ $ 620,660 100,920 721,580 578,410 $ $ $ $ 675,160 125,920 801,080 599,390 $ $ $ $ 54,500 25,000 79,500 20,980 U U U F $ $ $ $ 169,390 80,500 249,890 328,520 16.4% $ $ $ $ 169,390 80,500 249,890 349,500 17.5% $ $ $ $ 20,980 1.0% N N N F F C) Expected ROI Expected ROI Variable Cost of goods sold is decreased by 6% Average Operating Assets are decreased by 11% Sales are increased by $199,160 and this increase is expected to increase contribution margin by $84,200 19.5% 19.6% 21.7% Exercise 22-2 A) Prepare a selling Expense Report Month January February March $ $ $ Budget 30,819.00 $ 35,291.00 $ 39,642.00 $ CREDE COMPANY Selling Expense Report For the Quarter Ending March 31 By Month Actual Difference 32,627.00 $ 1,808.00 U 34,672.00 $ 619.00 F 46,931.00 $ 7,289.00 U $ $ $ Budget 30,819.00 $ 66,110.00 $ 105,752.00 $ Year-to-Date Actual 32,627.00 $ 67,299.00 $ 114,230.00 $ Difference 1,808.00 U 1,189.00 U 8,478.00 U Exercise 22-5 A) Prepare a selling Expense Flexible Budget DEWITT COMPANY Monthly Selling Expense Flexible Budget For the year 2014 Activity Level Sales Variable Expenses Sales Commissions Advertising Travelling Delivery Total Variable Expenses Fixed Expenses Salaries Depreciation Insurance Total Fixed Expenses Total Expenses $ 166,400.00 $ 179,100.00 $ 191,800.00 $ 204,500.00 $ $ $ $ $ 13,312.00 6,656.00 4,992.00 3,328.00 28,288.00 $ $ $ $ $ 14,328.00 7,164.00 5,373.00 3,582.00 30,447.00 $ $ $ $ $ 15,344.00 7,672.00 5,754.00 3,836.00 32,606.00 $ $ $ $ $ 16,360.00 8,180.00 6,135.00 4,090.00 34,765.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 71,823.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 73,982.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 76,141.00 $ $ $ $ $ 34,627.00 7,209.00 1,699.00 43,535.00 78,300.00 Exercise 22-9 A) Prepare a manufacturing overhead flexible Budget LOWELL COMPANY Manufacturing Overhead Flexible Budget Report For the Quarter Ending March 31, 2014 Budget Variable Costs Indirect Materials Indirect Labor Utilities Maintenance Total Variable Costs Fixed Costs Supervisory Salaries Depreciation Prop. Taxes & Insurance Maintenance Total Fixed Costs Total Costs Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual $ $ $ $ $ 11,885 10,130 7,827 5,520 35,362 $ $ $ $ $ 15,388 9,343 9,140 5,106 38,977 $ $ $ $ $ 3,503 787 1,313 414 3,615 U F U F U $ $ $ $ $ $ 35,857 7,041 7,011 4,802 54,711 90,073 $ $ $ $ $ $ 35,857 7,041 8,654 4,802 56,354 95,331 $ $ $ $ $ $ 1,643 1,643 5,258 N N U N U U B) Responsibility report LOWELL COMPANY Manufacturing Overhead Responsibility Report For the Quarter Ending March 31, 2014 Controllable Costs Indirect Material Indirect Labor Utilities Maintenance Supervisor Salaries Budget $ $ $ $ $ $ Actual 11,885 10,130 7,827 5,520 35,857 71,219 $ $ $ $ $ $ 15,388 9,343 9,140 5,106 35,857 74,834 $ $ $ $ $ $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) 3,503 U 787 F 1,313 U 414 F - N 3,615 U I have changed the value of Cell D41, But so far as other parts are concerned I don't understand how is it possible that Cell D39 which is difference of Cell C 39 and B 39 is correct a Same is with Cell B 41 and C 41, I think it's the system error rect and Cell C39 and B 39 are incorrect. Exercise 22-15 A) Computing the missing amount Operating Data Contribution Margin Controllable Fixed Costs Controllable Margin Sales Variable Costs $ $ $ $ $ Women's Shoes 268,500 107,400 161,100 644,400 375,900 $ $ $ $ $ Men's Shoes 139,620 42,960 96,660 483,300 343,680 $ $ $ $ $ Children's Shoes 193,320 91,290 102,030 461,820 268,500 B) Responsibility report DEITZ INC Women's Shoe Division Responsibility Report For the Quarter Ending June 30, 2014 Budget Sales Less: Variable Cost Contribution Margin Controllable Fixed Costs Controllable Margin $ $ $ $ $ Actual 644,400 375,900 268,500 107,400 161,100 $ $ $ $ $ 644,400 386,640 257,760 107,400 150,360 $ $ $ $ $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) - N 10,740 U 10,740 U - N 10,740 U Hey Dacire, Here again there is some problem with the system. See the value for C24 is dependent on Value of B24 and as per the screenshot both are incorrect. But if you look more carefully the value of Cell B24 is taken from Cell B10 Which is correct. And because all the subsequent values like Controllable margin and contribution margin is dependent on these figure the system are showing them as incorrect. I think its system issue :( Exercise 22-3A A) Total Monthly Budget Cost Formula The Formula = $ 35,020 + Variable Costs of $ $ B) Flexible Budget Report HILL COMPANY Budget Report Assembling Department For the Month Ended August 31, 2014 Budget Units Variable Costs: Direct Materials Direct Labor Indirect Materials Indirect Labor Utilities Maintenance Total Variable Fixed Costs Rent Supervision Depreciation Total Fixed Total Costs Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual 58,000 58,000 $ $ $ $ $ $ $ 46,980 55,680 27,260 19,140.00 19,140.00 6,960.00 175,160.00 $ $ $ $ $ $ $ 47,500 54,960 28,460 19,330.00 19,600.00 7,540.00 177,390.00 $ $ $ $ $ $ $ 520 720 1,200 190 460 580.00 2,230.00 U F U U U U U $ $ $ $ $ 10,350.00 17,140.00 7,530.00 35,020.00 210,180.00 $ $ $ $ $ 10,350.00 17,140.00 7,530.00 35,020.00 212,410.00 $ $ $ $ $ 2,230.00 N N N N U C) Flexible Budget Report HILL COMPANY Budget Report Assembling Department For the Month Ended September 30, 2014 Budget Units Variable Costs: Direct Materials Direct Labor Indirect Materials Indirect Labor Utilities Maintenance Total Variable Fixed Costs Rent Supervision Depreciation Total Fixed Total Costs Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) Actual 64,000 64,000 $ $ $ $ $ $ $ 51,840 61,440 30,080 21,120.00 21,120.00 7,680.00 193,280.00 $ $ $ $ $ $ $ 52,250 60,456 31,306 21,263 21,560 8,294 195,129.00 $ $ $ $ $ $ $ 410 984 1,226 143 440 614.00 1,849.00 U F U U U U U $ $ $ $ $ 10,350.00 17,140.00 7,530.00 35,020.00 228,300.00 $ $ $ $ $ 10,350.00 17,140.00 7,530.00 35,020.00 230,149.00 $ $ $ $ $ 1,849.00 N N N N U 3.02 Per Unit Exercise 22-5A A) Prepare a responsibility Report for the Home Division SUPPAN MANUFACTURING COMPANY Home Division Responsibility Report For the Quarter Ending March 31, 2014 Budget Sales Less: Variable Cost Variable Cost of Goods sold Variable Selling and Administrative Expenses Total Variable Cost Contribution Margin Less: Fixed Cost Fixed Cost of Goods sold Fixed Selling and Administrative Expenses Total Fixed Cost Net Income ROI $ Actual 1,299,990 $ 1,400,470 $ Difference Favorable (F) Unfavorable (U) Neither Favorable nor Unfavorable (N) 100,480 F $ $ $ $ 620,660 100,920 721,580 578,410 $ $ $ $ 675,160 125,920 801,080 599,390 $ $ $ $ 54,500 25,000 79,500 20,980 U U U F $ $ $ $ 169,390 80,500 249,890 328,520 16.4% $ $ $ $ 169,390 80,500 249,890 349,500 17.5% $ $ $ $ 20,980 1.0% N N N F F C) Expected ROI Expected ROI Variable Cost of goods sold is decreased by 6% Average Operating Assets are decreased by 11% Sales are increased by $199,160 and this increase is expected to increase contribution margin by $84,200 19.5% 19.6% 21.7%