Please help me to solve this problem Flexible Budget Report (2 Requirements below)As sales manager, lohn was grven the following static budget report in the dlothing dopartment ofDunham Company for the month of October2.ofDUNHAM COMPANYClothing DepartmentStatic Budget ReportMonth Ended October 31, 2020ActualBudgetVariance7,900U, For N/A3,100 FavourableSales in UnitsVariable Costs11 Sales commissions12 Advertising expenseTravel expense14 Free samples given outTotal variable costs11,00010$2,9707703,8501,2108,800$1,8961,1063,3181,1857,5051,074 Unfavourable336 Favourable532 Unfavourable25 Unfavourable1,295 Unfavourable131516 Fixed costs17 Rent18 Sales salaries19 Office salaries20 Depreciation - vehicles1 Total fixed costs1,2001,0001,2001.000N/AN/AN/AN/AN/A7007004004003,3003,300 10Variable CostSales cormmissionsAdvertising eNporiseTravel expenseFree samples given outTotal variable costsFixed costsRent$2,9701,074 Urifavourable336 Fuvourable532 Unfavourablo25 Unfavourable1,295 Unfavourable127701,1063,3181,1857,506133,8501,2108,800141516171,2001,000N/A1,2001,00070018 Sales salariesOffice salaries20 Depreciation - vehicles21 Total fixend costsTotal costsAs a result of this report, John was called into the president's office and congratulated on his fine sales24 performance. He was reprimanded, however, for allowing his costs to get out of control. John was notsure what to do and has come to you for advice.26 Complete the 2 Requirements below:27- IN/AN/AN/AN/A1,295 Unfavourable197004004003,300$12,1003,300$10,8052223251. Prepare a budget report based on flexible budget data to help John.Flexible Budget Report

The flexible budget is prepared on the basis of actual results and standard rates. The variance is…

As sales manager, lohn was grven the following static budget report in the cothing dopartment of Ounham Company for the month of October DUNHAM COMPANY Clothing Department Static Budget Report Month Ended October 31, 2020 7. Actual Budget Variance U, For N/A 3,100 Favourable Sales in Units 10 Variable Costs 11 Sales commissions 12 Advertising expense 33 Travel expense 4 Free samples given out 5 Total variable costs Fixed costs Rent Sales salaries Office salaries Depreciation - vehicles Total fixed costs 11,000 7,900 $2.970 $1,896 1,106 3318 1,185 7,505 1,074 Unfavourable 336 Favourable 532 Unfavourable 25 Unfavourable 1,295 Unfavourable 770 3,850 1,210 8,800 1,200 1,000 1,200 1,000 N/A -IN/A N/A N/A N/A 700 700 400 400 3,300 3,300

As sales manager, lohn was grven the following static budget report in the cothing dopartment of Ounham Company for the month of October DUNHAM COMPANY Clothing Department Static Budget Report Month Ended October 31, 2020 7. Actual Budget Variance U, For N/A 3,100 Favourable Sales in Units 10 Variable Costs 11 Sales commissions 12 Advertising expense 33 Travel expense 4 Free samples given out 5 Total variable costs Fixed costs Rent Sales salaries Office salaries Depreciation - vehicles Total fixed costs 11,000 7,900 $2.970 $1,896 1,106 3318 1,185 7,505 1,074 Unfavourable 336 Favourable 532 Unfavourable 25 Unfavourable 1,295 Unfavourable 770 3,850 1,210 8,800 1,200 1,000 1,200 1,000 N/A -IN/A N/A N/A N/A 700 700 400 400 3,300 3,300

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter14: Decentralized Operations

Section: Chapter Questions

Problem 14.1E: Budget performance reports for cost centers Partially completed budget performance reports for...

See similar textbooks

Similar questions

Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Mesa Publishing Co.: Factory output and sales for 20Y9 are expected to total 3,800 units of product, which are to be sold at 120 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Balances of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 35,000 on 20Y9 taxable income will be paid during 20Y9. Regular quarterly cash dividends of 0.20 per share are expected to be declared and paid in March, June, September, and December on 20,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 22,000 cash in May. Instructions Prepare a budgeted income statement for 20Y9. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.
Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for May: Prepare a cost of goods sold budget for May. Work in process at the beginning of May is estimated to be $4200. and work in process at the end of May is desired to be $3800.
A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
Budget performance reports for cost centers Partially completed budget performance reports for Runquist Company, a manufacturer of air conditioners, are provided below. a.Complete the budget performance reports by determining the correct amounts for the lettered spaces. b.Compose a memo to Jeff Kitchens, president of Meridian Company, explaining the performance of the Production Division for June.
Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: Estimated sales at 125 per unit: Estimated finished goods inventories: Work in process inventories are estimated to be insignificant (zero). Estimated direct materials inventories: Manufacturing costs: Selling expenses: Instructions Prepare the following budgets using one column for each month and a total column for the first quarter, as shown for the sales budget: Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement with budgeted operating income for March.
Preparing a performance report Use the flexible budget prepared in P7-6 for the 29,000-unit level of activity and the actual operating results listed below for the 29,000- unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 29,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level and the actual operating results listed below for the 31,000-unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 31,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: Estimated sales for March: Estimated inventories at March 1: Desired inventories at March 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for March: Estimated operating expenses for March: Estimated other revenue and expense for March: Estimated tax rate: 30% Instructions Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement for March.
Preparing a flexible budget Use the information in Figure 7-12 of the chapter. Required: Prepare flexible budgets for the production and sale of 29,000 units and 31,000 units, respectively.
Budgeted income statement and supporting budgets The budget director of Birding Homes Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January: Estimated inventories at January 1: Desired inventories at January 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for January: Estimated operating expenses for January: Estimated other revenue and expense for January: Estimated tax rate: 25% Instructions Prepare a sales budget for January. Prepare a production budget for January. Prepare a direct materials purchases budget for January. Prepare a direct labor cost budget for January. Prepare a factory overhead cost budget for January. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 9,000, and work in process at the end of January is estimated to be 10,500. Prepare a selling and administrative expenses budget for January. Prepare a budgeted income statement for January.
Professional labor cost budget for a service company Based on the data in Exercise 7 and assuming that the average compensation per hour for staff is 40 and for partners is 175, prepare a professional labor cost budget for each department forLundquist Fretwell, CPAs, for the year ending May 31, 20Y8. Use the following column headings: