1. Several years ago, Westmont Corporation developed a comprehensive budgeting system for planning and control purposes. While departmental supervisors have been happy with the system, the factory manager has expressed considerable dissatisfaction with the information being generated by the system. A report for the company's Assembly Department for the month of March follows: Assembly Department Cost Report For the Month Ended March 21 Actual ResultsPlanning Budget Variances Machine-hours 15,000 20, 000 Variable costs: Supplies 10, 500 $ 11, 100 $ 600 F Scrap 37, 600 40, 500 2, 700 F Indirect materials 108,200 129,000 20, 800 F Fixed costs: Wages and salaries 82, 200 77, 000 5, 300 U Equipment depreciation 107,000 107, 000 Total cost 245, 800 $ 264, 600 $18, 800 F After receiving a copy of this cost report, the supervisor of the Assembly Department stated, "These reports are super. It makes me feel really good to see how well things are going in my department. I can't understand why those people upstairs complain so much about the reports." For the last several years, the company's marketing department has chronically failed to meet the sales goals expressed in the company's monthly budgets. Required: A. The company's president is uneasy about the cost reports, identify at least two reasons. Cost reports are ineffective since budgeted costs at one level of activity are compared to actual costs at another level of actirby Cost reports show whether food costs are controled and do not show whether variable costs are Cost reports are effective since compared to actual costs at another level of activity Coul reports show whether food costs and variable costs are conbelleB. What kind of reports should be used to give better insight into how well departmental supervisors are controlling costs? Flexible budget performance reports must be used Fixed budget performance reports must be used C. Complete the new performance report for the quarter, based on the Flexible Budget Performance approach. (Do not round your intermediate calculations. Indicate the effect of each variance by selecting "F' for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.} Westmont Corporation Assembly Department Flexible Budget Performance Report For the Month Ended March 31 Actual Flexible Planning Results Budget Budget Machine-hours (o) 15,000 201000 Supplies 10,500 11,100 Scrap 17.100 40.500 108 200 120 000 Wages and solanos 12,300 77 000 Equipment depreciation 107.800 107 000 Total 9 345,800 $ 204 600 D. Were costs well controlled in March? Costs were well controlled Costs were not well controlled2. The Little Theatre is a nonprofit organization devoted to staging plays for children. The theater has a very small full-time professional administrative staff. Through a special arrangement with the actors' union, actors and directors rehearse without pay and are paid only for actual performances. The Little Theatre had tentatively planned to put on six different productions with a total of 108 performances. For example, one of the productions was Peter Rabbit, which had a six- week run with three performances on each weekend. The costs from the current year's planning budget appear below. The Little Theatre Costs from the Planning Budget For the Year Ended December 21 Budgeted number of productions E Budgeted number of performances 108 Actors and directors wages $224, 640 Stagehands wage: 41, 040 Ticket booth personnel and ushers wages 24, 840 Scenery, costumes, and props 108, 480 Theater hall rent 62, 640 Printed programs 25, 640 Publicity 12, 480 Administrative expenses 51, 840 Total $561, 600 Some of the costs vary with the number of productions, some with the number of performances, and some are fixed and depend on neither the number of productions nor the number of performances. The costs of scenery, costumes, props, and publicity vary with the number of productions. It doesn't make any difference how many times Peter Rabbit is performed, the cost of the scenery is the same. Likewise, the cost of publicizing a play with posters and radio commercials is the same whether there are 10, 20, or 30 performances of the play. On the other hand, the wages of the actors, directors, stagehands, ticket booth personnel, and ushers vary with the number of performances. The greater the number of performances, the higher the wage costs will be. Similarly, the costs of renting the hall and printing the programs will vary with the number of performances. Administrative expenses are more difficult to analyze, but the best estimate is that approximately 75% of the budgeted costs are fixed, 15% depend on the number of productions staged, and the remaining 10% depend on the number of performances. After the beginning of the year, the board of directors of the theater authorized expanding the theater's program to seven productions and a total of 168 performances. Not surprisingly, actual costs were considerably higher than the costs from the planningbudget. (Grants from donors and ticket sales were also correspondingly higher, but are not shown here.) Data concerning the actual costs were as follows: The Little Theatre Actual Costs For the Year Ended December 31 Actual number of productions Actual number of performances 168 Actors and directors wages $363, 600 Stagehands wages 62, 900 Ticket booth personnel and ushers wages 29, 900 Scenery, costumes, and props 121, 000 Theater hall rent 90, 400 Printed programs 50, 700 Publicity 15, 900 Administrative expenses 59, 500 Total $813, 900 Required: A. Prepare a flexible budget performance report for the year that shows both spending variances and activity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) The Little Theatre Flexible Budget Performance Report For the Year Ended December 11 Actual Flexible Planning Budget Budget Number of productions Number of performance 109 $ 343,800 $ 224,840 Supahands wagin 12,000 41,040 Ticlove booth parconsol and ushand wayas 30.800 24,840 Somary costumes, and props 13.000 108.490 Theatre hall mint Printed programi 50,700 35,840 Publicin 15.900 12. 480 19.800 31.840 $ 901.8003. Tasman Products, Lid., of Australia has a Maintenance Department that services the equipment in the company's Forming Department and Assembly Department. The cost of this servicing is charged to the operating departments on the basis of machine-hours. Cost and other data relating to the Maintenance Department and to the other two departments for the most recent year are presented below. Data for the Maintenance Department follow: Budget Actual Variable costs for lubricants $321, 200- $424, 560 Fixed costs for salaries and other $192,000 $206, 200 *Budgeted at $23 per machine-hour. Data for the Forming and Assembly Departments follow: Percentage of Machine-Hours Peak-Period Capacity Required Budget Actual Forming Department 9, 500 11, 500 Assembly Department 4, 900 3, 900 Total 1008 14, 400 15, 400 The level of fixed costs in the Maintenance Department is determined by peak-period requirements. Required: A. How much Maintenance Department cost should be charged to the Forming Department and to the Assembly Department? Forming Assembly Department Department Total cost charged B. How much, if any, of the actual Maintenance Department costs for the year should be treated as a spending variance and not charged to the Forming and Assembly departments? Spending variance4. The contribution format income statement for Huerta Company for last year is given below: Total Unit Bales $1, 006, 000 $50.30 Variable expenses 603, 600 30.18 Contribution margin 402, 400 20.12 Fixed expenses 218 , 400 15 .92 Net operating income 24,000 4.20 Income taxes @ 409 33, 600 1. 68 Net income $ 50, 400 $ 2.52 The company had average operating assets of $506,000 during the year. Required: A. Compute the company's margin, turnover, and return on investment (ROI) for the period. Margin Tumover RO For each of the following questions, indicate whether the margin and turnover will increase, decrease, or remain unchanged as a result of the events described, and then compute the new ROI figure. Consider each question separately, starting in each case from the data used to compute the original ROI in (1) above. B. Using Lean Production, the company is able to reduce the average level of inventory by $100,000. Effect Margin Turnover ROI C. The company achieves a cost savings of $13,000 per year by using less costly materials. Effect Margin ROD. The company purchases machinery and equipment that increases average operating assets by $122,000. Sales remain unchanged. The new, more efficient equipment reduces production costs by $7,000 per year. Effect Margin Turnover RO E. As a result of a more intense effort by sales people, sales are increased by 15%; operating assets remain unchanged. Effect Margin Turnover RO F. At the beginning of the year, obsolete inventory carried on the books at a cost of $18,000 is scrapped and written off as a loss, thereby lowering net operating income. Margin RO G. At the beginning of the year, the company uses $176,000 of cash (received on accounts receivable) to repurchase some of its common stock. Effect Margin TUMTOYET RO