Mills Company uses standard costing for direct materials and direct labor. Management would like to use standard costing for variable and fixed overhead.The following monthly cost functions were developed for manufacturing overhead items:Overhead Item Cost FunctionIndirect materials $1.00 per DLHIndirect labor $1.25 per DLHUtilities $0.50 per DLHInsurance $10,000Depreciation $40,000The cost functions are considered reliable within a relevant range of 20,000 to 40,000 direct labor hours. The company expects to operate at 25,000 direct labor hours per month.Information for the month of June is as follows:Actual overhead costs incurred:Indirect materials $ 20,000Indirect labor 30,000Utilities 12,000Insurance 11,000Depreciation 40,000Total $113,000Actual direct labor hours worked: 24,000Standard direct labor hours allowed for production achieved: 27,000Required:a. Calculate the following standard manufacturing overhead rates based upon expected capacity:Variable manufacturing overheadFixed manufacturing overhead rateTotal manufacturing overhead rateb. Calculate the following variances:Variable overhead spending varianceVariable overhead efficiency varianceFixed overhead spending varianceFixed overhead volume variance2.. Marconi, Inc., a retailer of specialty paints, prepares a monthly master budget. Data for the September master budget are given below:a. The August 31st balance sheet:Cash $ 25,500 Accounts payable $ 53,760Accounts receivable 90,000 Capital stock 265,000Inventory 28,800 Retained earnings 25,540Building and equipment (net) 200,000b. Actual sales for August and budgeted sales for September, October, and November are given below:August $120,000September 360,000October 200,000November 180,000c. Sales are 25 percent for cash and 75 percent on credit. All credit sales are collected in the month following the sale. There are no bad debts.d. The gross margin percentage is 60 percent of sales. The desired ending inventory is equal to 20 percent of the following month’s sales. One fifth of the purchases are paid for in the month of purchase and the others are purchased on account and paid in full the following month.e. The monthly cash operating expenses are $80,000 including the monthly depreciation expense of $7,000.f. During September, Marconi Company will purchase new office equipment for $17,000 cash.g. Dividends of $13,500 were declared and paid in September.h. The company must maintain a minimum cash balance of $25,000. A line of credit is used to maintain this balance. Borrowing will be made in increments of $1,000. All borrowing is done at the beginning of the month and repayments are made at the end of the month. The annual interest rate is 12 percent, paid when the loan is repaid (ignore accrual of interest).3. Smithson Corporation has the following budgeted sales for the selected six-month period:Month Unit SalesJune 15,000July 20,000August 35,000September 25,000October 30,000November 20,000There were 7,500 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished product equal to 20 percent of the unit sales for the next month.Three pounds of materials are required for each unit produced. Each pound of material costs $20. Inventory levels for materials equal 30 percent of the needs for the next month. Materials inventory on June 1 was 5,000 pounds.Required:a. Prepare production budgets in units for July, August, and September.b. Prepare a purchases budget in pounds and dollars for July, August, and September.4. Horn Bank has two bank locations: Main and Rural. The central office provides check-processing services for the two banks. Information pertaining to the banks is as follows:Check Processing Main RuralBudgeted fixed costs $100,000 – -Budgeted variable rate per hour $20 – -Normal usage in hours – 600 400Actual fixed costs $107,500 – -Actual variable costs $ 17,500 – -Actual usage in hours – 550 250Required:a. Use the direct method to allocate the check-processing center costs to each bank to provide information for setting service charges.b. Use the direct method to allocate the computer center costs to each bank for performance evaluation purposes.c. Determine the costs of the check-processing center NOT allocated to the two banks. Why were these costs not allocated to the operating units?5 Earl, Inc., has two producing departments. Each producing department is held responsible for a share of the costs of a support department.Actual and budgeted data are as follows:2006Support department hours used:Department X 8,000Department Y 16,000Total hours 24,000Support department costs:Actual support department costs $72,000Budgeted fixed service center costs $24,000Budgeted variable rate per hour $3.00Normal support department usage is 12,000 hours each for Department X and Department Y.Required:a. Assuming the purpose is product costing, allocate the costs of the support department using the direct method.b. Assuming the purpose is to evaluate performance, allocate the costs of the support department.