Need excel template with answers The Gilster Company, a machine tooling firm, has several plants. One plant, located in St. Falls, Minnesota, uses a job order costing system for its batch production processes. The St. Falls plant has two departments through which most jobs pass. Plantwide overhead, which includes the plant managers salary, accounting personnel, cafeteria, and human resources, is budgeted at $250,000. During the past year, actual plantwide overhead was $240,000. Each departments overhead consists primarily of depreciation and other machine-related expenses. Selected budgeted and actual data from the St. Falls plant for the past year are as follows: Department A Department B

Budgeted department overhead (excludes plantwide overhead) $ 150,000 $ 600,000 Actual department overhead 160,000 620,000 Expected activity: Direct labor hours 35,000 15,000 Machine-hours 10,000 40,000 Actual activity: Direct labor hours 51,000 9,000 Machine-hours 10,500 42,000

For the coming year, the accountants at St. Falls are in the process of helping the sales force create bids for several jobs. Projected data pertaining to job no. 110 are as follows:

Direct materials $ 25,000 Direct labor cost: Department A (2,200 hr) 45,000 Department B (800 hr) 10,000 Machine-hours projected: Department A 200 Department B 1,200 Units produced 10,000

a.1 Assume the St. Falls plant uses a single plantwide overhead rate to assign all overhead (plantwide and department) costs to jobs. Use the expected total direct labor hours to compute the overhead rate. What is the expected cost per unit produced for job no. 110?

b.1 recalculate the projected manufacturing costs for job no. 110. (using three separate rates: one rate for plantwide overhead and two separate department overhead rates, all based on machine-hours

c.1 The sales policy at St. Falls dictates that job bids be calculated by adding 40 percent to total manufacturing costs. What would be the bid for job no. 110 using the overhead rate from part a ? using the overhead rate from part b ? explain why the bids differ. Which of the overhead allocation methods would you recommend and why?

d. Using the allocation rates in part b, compute the under- or overapplied overhead for the St. Falls plant for the year. Explain the impact on net income of assigning the under or over applied overhead to cost of goods sold rather than prorating the amount between inventories and cost of goods sold. e. A St. Falls subcontractor has offered to produce the parts for job no. 110 for a price of $12 per unit. Assume the St. Falls sales force has already committed to the bid price based on the calculations in part b. Should St. Falls buy the $12 per unit part from the subcontractor or continue to make the parts for job no. 110 itself?

f. Would your response to part e change if the St. Falls plant could use the facilities necessary to produce parts for job no. 110 for another job that could earn an incremental profit of $20,000? g. if the subcontractor mentioned in part e is located in mexico what additional international environmental issues other than price will glister and st falls management need to evaluate? h. if glister company management decided to undertake a target costing approach to pricing its jobs, what types of changes will it need to make for such an approach to be successful?