Single vs. Multiple Overhead Application Rates Thanks!! Foster Appliance Repair
ID: 2420038 • Letter: S
Question
Single vs. Multiple Overhead Application Rates
Thanks!!
Foster Appliance Repair has developed a reputation over many years of providing high quality. reliable repair services at a fair price. The company has grown from a two-person operation (run by Victor Foster and his wife Sally Jones) to a much larger company employing Foster and Jones as well as four skilled repair personnel and two service technicians. Jones manages the front office and prepares all accounting-related records for the company. Recently. Jones has noticed a decline in profits generated by the repair business. Foster has also noticed some decline in the number of repairs completed over the past few months. He believes this reduction may be due to increased competition from a new repair shop in the area. Since pricing is based to a large degree on the cost of repairs, Foster asked Jones to spend some time analyzing how repair costs were charged to jobs, to better understand the problem. He was quick to remind Jones that he was committed to keeping all personnel on fixed salaries since he believes this allows him to keep good employees and encourages loyalty to the company. Jones collected the following information about the costing system: Direct materials used in repairs are charged directly to the job. The four repair personnel are paid a fixed salary of $50,000 per year, and the two technicians are paid a fixed salary of $38,000 per year. Jones estimates that each of the six repair personnel works 1,750 hours per year on customer jobs. Other budgeted indirect support costs for the year (e.g., rent, insurance, utilities, supplies, repair van maintenance, repair van depreciation) total $178,450, including Foster's and Jones's salaries. The price for each job is calculated on a cost-plus basis. Customers pay the total cost to complete the job plus a markup of 10%. The total cost for each job is calculated as follows: total direct material cost plus the "shop rate" Times number of repair hours to complete the job. The shop rate is applied to all types of repair jobs. The shop rate is calculated as the sum of the repair personnel salaries plus budgeted indirect support costs for the year divided by the estimated total hours to be worked on customer jobs for the year. Jones noted that about 65% of total indirect costs related to complex repairs over the last couple of years, while the other 35% of total indirect costs related to simpler repairs. Even so, about half of the total time worked on customer jobs by repair personnel and technicians was related to complex repairs, while the other half was related to simple repairs. While Jones believed this was important information, she realized it was not taken into account when calculating the overall shop rate for the year. Calculate the shop rate for the year based on the above information gathered by Jones. Use the information gathered by Jones about the proportion of complex and simple repairs each year to calculate different shop rates that could be applied to complex and simple repair work. Consider Job 1246 completed by Foster Appliance Repair last month. The job cost sheet indicates $115 cost of direct materials plus 6 hours of labour time Times the shop rate. Calculate the total price charged to the customer, assuming a 10% markup on cost. By doing a little more digging, Jones was able to determine that 2 of the 6 hours spent on Job 1246 were related to complex repairs, while 4 of the 6 hours spent on the job were related to simple repairs. Use this information and the two shop rates calculated in (2) above to estimate the price that would have been charged for Job 1246 under this new system. Using all of the information gathered to this point, explain why Foster Appliance Repair may be selling fewer repairs, resulting in lower profitability.Explanation / Answer
Foster Appliances Details No/Amt $ d Direct Labor hrs in a year 1,750 a Direct Labor salary 88,000 Assuming total salary not individual salary is given in the question. b Indirect costs 178,450 c Total a+b= 266,450 Shop rate =c/d 152 Segregation of costs Details Simple repair Complex repair e Direct Labor Hours 875 875 Direct labor salary 44,000 44,000 Indirect Costs 62,458 115,993 f Total Costs 106,458 159,993 Shop rate =f/e= 122 183 3a. Job 1246 Costing by Markup Details Amt Direct Materials 115 Shop rate for 6 DLH @$152 rate 912 Total Costs 1,027 Mark Up @10% 103 Total Price charged 1,130 b Job 1246 Costing by multiple shop rate Details Amt Direct Materials 115 Complex repairs 2 Hrs @$183 366 Simple Repair 4Hrs @122 488 Total Cost 969 Mark up@10% 97 Total Price charged 1,066 4 It is clear that so far Foster is using single shop rate which is charging more to the customer and lowering the demand in competition. The new multiple shop rate more accurately distributes the overhead and results in more competitive pricing.