Fey Companys organization chart includes the president; the vice president of production; three assembly plantsDallas, Atlanta, and Tucson; and two departments within each plantMachining and Finishing. Budget and actual manufacturing cost data for July 2020 are as follows.

$50,000 on the vertical axis. E10.13 (LO 3), AP Fey Company's organization chart includes the president; the vice president of production; three assembly plants - Dallas, Atlanta, and Tucson; and two departments within each plant-Machining and Finishing. Budget and actual manufacturing cost data for July 2020 are as follows. Prepare reports in a responsibility reporting system. Finishing Department-Dallas: direct materials $42,500 actual, $44,000 budget; direct labor $83,400 actual, $82,000 budget; manufacturing overhead $51,000 actual, $49,200 budget. Machining Department-Dallas: total manufacturing costs $220,000 actual, $219,000 budget. Atlanta Plant: total manufacturing costs $424,000 actual, $420,000 budget. Tucson Plant: total manufacturing costs $494,200 actual, $496,500 budget. The Dallas plant manager's office costs were $95,000 actual and $92,000 budget. The vice president of production's office costs were $132,000 actual and $130,000 budget. Office costs are not allocated to departments and plants. Instructions Using the format shown in Illustration 10.19, prepare the reports in a responsibility system for: a. The Finishing Department-Dallas. b. The plant manager - Dallas. c. The vice president of production. Report A Data Home Insert Page Layout Formas P18 A B C 1 2 3 Report A Report A President sees summary data of vice presidents. Budget $ 150,000 Actual $ 151,500 Month: January Fav/Unfav $ 1,500 V To President 4 Controllable Costs: 5 President 6 Vice Presidents: 7 Sales 8 Production 9 Finance 10 Total 11 185,000 1,179,000 100,000 $1,614,000 187,000 1,186,300 101,000 $1,625,800 2,000 U 7,300 U 1,000 U $11,800 U Report B Beview Formas Data Page Layout A P18 A B C D E 1 Report B Report B Vice president sees sum- mary of controllable costs in his/her functional area. Budget $ 125,000 Actual $ 126,000 Month: January Fav/Unfav $ 1,000 U 3 To Vice President Production 4 Controllable Costs: 5 VP Production 6 Assembly Plants: 7 Detroit 8 Chicago 9 St. Louis 10 Total 420,000 304,000 330,000 $1,179,000 418,000 309,300 333,000 $1,186,300 2,000 F 5,300 U 3,000 U $ 7,300 U 11 . Report C Data Review View Home Insert Formula Page Layout fx P18 B E Report Report Plant manager sees sum- mary of controllable costs for each department in the plant. Budget Month: January Fav/Unfav $3,000 U Actual $113,000 $110,000 3 To Plant Manager-Chicago 4 Controllable Costs: 5 Chicago Plant 6 Departments: 7 Fabricating 8 Enameling Assembly 10 Total 84,000 62,000 48,000 $304,000 85,300 64,000 47,000 $309,300 1,300 U 2,000 U 1,000 F $5,300 U 9 11 Report D Vice president sees sum- mary of controllable costs in his/her functional area. Budget $ 125,000 Actual $ 126,000 Month: January Fav/Unfav $ 1,000 U 10 Vice President Production 4 Controllable Costs: 5 VP Production 6 Assembly Plants: 7 Detroit 8 Chicago 9 St. Louis 10 Total 11 420,000 304,000 330,000 51,179,000 418,000 309,300 333,000 $1,186,300 2,000 F 5,300 U 3,000 V $ 7,300 U . Report Data Review Home Insert View Page Layout Format ft P18 B C D E 1 Report 3 Report Plant manager sees sum- mary of controllable costs for each department in the plant. Budget $110,000 Actual $113,000 Month: January Fav/Unfav $3,000 To Plant Manager-Chicago 4 Controllable Costs: 5 Chicago Plant 6 Departments: Fabricating 8 Enameling 9 Assembly 10 Total 11 7 84,000 62,000 48,000 S304,000 85,300 64,000 47,000 $309,300 1,300 U 2,000 U 1,000 F $5,300 U Report D Date Page Layout Formulas View P18 B C D E Report D Report D Department manager sees controllable costs of his/her department. 2 3 To Fabricating Dept. Manager 4 Controllable Costs: 5 Direct Materials 6 Direct Labor 7 Overhead 8 Total 9 Budget $20,000 40,000 24,000 584,000 Actual $20,500 41,000 23,800 585,300 Month: January Fav/Unfav $ 500 U 1,000 U 200 F $1,300 U