Repair Shop Co. provides electronic repairs and has the following budget for next year: Repair technicians' wages Repair service manager salary Parts manager salary Repair shop operating costs Parts ordering costs Parts handling costs Invoice cost of parts used Total billable hours for repair $420,000 45,000 40,000 180,000 10,000 30,000 260,000 12,000 hrs The company has a target profit of $6 per hour of repair time and 20% of the invoice cost of parts used.

Repair Shop Co. provides electronic repairs and has the following budget for next year: Repair technicians' wages Repair service manager salary Parts manager salary Repair shop operating costs Parts ordering costs Parts handling costs Invoice cost of parts used Total billable hours for repair $420,000 45,000 40,000 180,000 10,000 30,000 260,000 12,000 hrs The company has a target profit of $6 per hour of repair time and 20% of the invoice cost of parts used.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 9E: Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost...

See similar textbooks

Similar questions

Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of 12,000 per year per unit Six welding employees each paid a salary of 50,000 per year (A total of 9,000 welding hours are supplied by the six workers.) Welding supplies: 300 per job Welding hours: Three hours used per job During the year, the activity operated at 90 percent of capacity and incurred the actual activity and resource costs, shown on page 676. Lease cost: 48,000 Salaries: 315,000 Parts and supplies: 805,000 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. 2. Prepare a performance report for the welding activity. 3. What if welders were hired through outsourcing and paid 30 per hour (the welding equipment is provided by Foy)? Repeat Requirement 1 for the outsourcing case.
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Olin Company manufactures and distributes carpentry tools. Production of the tools is in the mature portion of the product life cycle. Olin has a sales force of 20. Salespeople are paid a commission of 7 percent of sales, plus expenses of 35 per day for days spent on the road away from home, plus 0.50 per mile. They deliver products in addition to making the sales, and each salesperson is required to own a truck suitable for making deliveries. For the coming quarter, Olin estimates the following: On average, a salesperson travels 6,000 miles per quarter and spends 38 days on the road. The fixed marketing and administrative expenses total 400,000 per quarter. Required: 1. Prepare an income statement for Olin Company for the next quarter. 2. Suppose that a large hardware chain, MegaHardware, Inc., wants Olin Company to produce its new SuperTool line. This would require Olin Company to sell 80 percent of total output to the chain. The tools will be imprinted with the SuperTool brand, requiring Olin to purchase new equipment, use somewhat different materials, and reconfigure the production line. Olins industrial engineers estimate that cost of goods sold for the SuperTool line would increase by 15 percent. No sales commission would be incurred, and MegaHardware would link Olin to its EDI system. This would require an annual cost of 100,000 on the part of Olin. MegaHardware would pay shipping. As a result, the sales force would shrink by 80 percent. Should Olin accept MegaHardwares offer? Support your answer with appropriate calculations.
Bonita Industries has the following budgeted costs for the next year: Time Charges Material Charges Shop employee' wages and benefits $130000 $ - Parts manager's salary and benefits - 45000 Office employee's salary and benefits 35000 25000 Other overhead 15000 55000 Invoice cost of parts and materials - 420000 Total budgeted costs $180000 $545000 The labor rate to be used next year assuming 7500 hours of repair time and a profit margin of $25 per labor hour is
An electrical repair service company has produced the following budget for the year ahead: Office repairs House repairs Total £ £ Received from customers Variable costs Fixed costs (apportioned) Profit (loss) 45,000 (24,000) (7,000) 14,000 24,000 (18,000) (8,000) (2,000) 69,000 (42,000) (15,000) 12,000 The fixed costs, which relate to rent and insurance, will be incurred irrespective of the type of activity carried out. Which of the following decisions is supported by the information in the table? A) If the company ceases to carry out house repairs, it will increase total profit from 12,000 to 14,000 B) If the company ceases to carry out house repairs, it will increase total profit from 12,000 to 18,000 C) If the company ceases to carry out house repairs, it will reduce total profit from 12,000 to 6,000 D) If the company ceases to carry out house repairs, it will reduce total profit from 12,000 to 4,000
Fazel Company makes and sells paper products. In the coming year, Fazel expects total sales of $18,000,000. There is a 6% commission on sales. In addition, fixed expenses of the sales and administrative offices include the following: Salaries $ 960,000 Utilities 365,000 Office space 230,000 Advertising 1,200,000 Required: Prepare a selling and administrative expenses budget for Fazel Company for the coming year. Fazel Company Selling and Administrative Expenses Budget For the Coming Year Variable selling expenses Fixed expenses: Salaries Utilities Office space Advertising Total fixed expenses Total selling and administrative expenses
Vaughn Manufacturing has the following budgeted costs for the next year: Shop employees' wages and benefits Parts manager's salary and benefits Office employee's salary and benefits Other overhead Invoice cost of parts and materials Total budgeted costs Time Charges O. $42. O $47. O $54. O $44. $125000 25000 15000 $165000 Material Charges $ 50000 20000 55000 450000 $575000 The labor rate to be used next year assuming 7500 hours of repair time and a profit margin of $25 per labor hour is >
XYZ Co. makes and sells product AB. The company provides the following data about its selling and administrative expenses budget: Monthly Fixed Cost Variable cost per unit sold Sales Commissions P0.75 Shipping P1.30 Advertising P30,000 P0.20 Executive salaries P25,000 Depreciation P15,000 Other expenses P7,000 All expenses except depreciation of office equipment are paid in cash in the month they are incurred. The company has budgeted to sell 18,000 units of product AB in August 2021. Questions: 1. How much is the total budgeted selling and administrative expenses for August 2021? 2. Assuming the cash disbursements for selling and administrative expenses total P116,000, then how many units of product AB does the company plan to sell?
Evergreen Corporation manufactures circuit boards and is in the process of preparing next year's budget. The pro forma income statement for the current year is presented below. Sales $ 3,500,000Cost of sales: Direct Material $ 500,000 Direct labor 250,000 Variable Overhead 275,000 Fixed Overhead 600,000 1,625,000Gross Profit $ 1,875,000Selling and General & Admin. Exp. Variable 750,000 Fixed 250,000 1,000,000Operating Income $ 875,000The break-even point (rounded to the nearest dollar) for Evergreen Corporation for the current year is:$2,155,172.$1,865,672.$1,724,138.$2,625,000.
Evergreen Corporation manufactures circuit boards and is in the process of preparing next year's budget. The pro forma income statement for the current year is presented below. Sales $ 3,500,000Cost of sales: Direct Material $ 500,000 Direct labor 250,000 Variable Overhead 275,000 Fixed Overhead 600,000 1,625,000Gross Profit $ 1,875,000Selling and General & Admin. Exp. Variable 750,000 Fixed 250,000 1,000,000Operating Income $ 875,000For the coming year, the management of Evergreen Corporation anticipates a 5 percent decrease in sales, a 10 percent increase in variable costs, and a $45,000 increase in fixed costs.The break-even point for next year would be: $2,668,750.$2,168,225.$3,022,500.$2,947,500.
Gardner Corporation manufactures skateboards and is in the process of preparing next year's budget. The pro forma income statement for the current year is presented below. Sales $ 1,500,000Cost of sales: Direct Material $ 250,000 Direct labor 150,000 Variable Overhead 75,000 Fixed Overhead 100,000 575,000Gross Profit $ 925,000Selling and General & Admin. Exp. Variable 200,000 Fixed 250,000 450,000Operating Income $ 475,000For the coming year, the management of Gardner Corporation anticipates a 10 percent increase in sales, a 12 percent increase in variable costs, and a $45,000 increase in fixed costs.The break-even point for next year (rounded to the nearest dollar) would be:$474,000.$729,027.$862,103.$214,018.
The Puyer Corporation makes and sells only one product called a Deb. The company is in the process of preparing its Selling and Administrative Expense Budget for next year. The following budget data are available: Sales commissions Shipping Advertising Executive salaries Depreciation on office equipment Other Monthly Fixed Cost $50,700 $ 60,700 $ 20,700 $ 40,700 Variable Cost Per Deb Sold $ 0.97 $ 1.47 $ 0.27 All of these expenses (except depreciation) are paid in cash in the month they are incurred. If the company has budgeted to sell 15,700 Debs in February, then the total budgeted fixed selling and administrative expenses for February is: