Attached are questions I need assistance with. Can you place them in a excel sheet with formaulas?

Question 1 Maxx Inc. has provided the following data from its activity-based costing system: Activity Cost Pools Total Cost Total Activity Designing products $387,300 6,510 product design hours Setting up batches $52,678 7366 batch set-ups Assembling products $25,122 4,018 assembly hours The activity rate for the \"designing products\" activity cost pool is: Answer: 59.49 View Feedback Hide Feedback SOLUTION: (Total cost of designing products / Total activity of designing products) {DC}/{DA} Question 2 Sasha Company allocates the estimated $184,600 of its accounting department costs to its production and sales departments since the accounting department supports the other two departments particularly with regard to payroll and accounts payable functions. The costs will be allocated based on the number of employees using the direct method. Information regarding costs and employees follows: Department Accounting Production Sales Employees 4 32 17 How much of the accounting department costs will be allocated to the production? Answer: 120,555.1 View Feedback SOLUTION: (costs to be allocated / Employees in Production and Sales)* Employees in production Question 3 Medusa Company allocates costs from the payroll department (S1) and the maintenance department (S2) to the molding (P1), finishing (P2), and packaging (P3) departments. Payroll department costs are allocated based on the number of employees in the department and maintenance department costs are allocated based on the number of square feet which the production department occupies within the factory. Information about the departments is presented below: Department Payroll (S1) Maintenance (S2) Molding (P1) Finishing (P2) Packaging (P3) Costs $142,000 $220,000 Number of Employees 2 8 66 48 23 Number of Square Feet Occupied 2,000 64,000 100,000 60,000 40,000 Medusa uses the direct method to allocate costs. Round all answers to the nearest dollar. What amount of the payroll department costs will be allocated to the molding department? Answer: 68,408.76 View Feedback {(Payroll costs/(employees in molding, finishing, and production)}*Employees in Molding Question 4 The Manassas Company has 55 obsolete keyboards that are carried in inventory at a cost of $9,600. If these keyboards are upgraded at a cost of $6,700, they could be sold for $18,000. Alternatively, the keyboards could be sold \"as is\" for $8,500. What is the net advantage or disadvantage of re-working the keyboards? Answer: 2,800 View Feedback SOLUTION: 1) Complete processing revenue {S} - Current state of completion revenue {AI} = Incremental revenue 2) Subtract additional processing costs {AC} Question 5 Ritz Company sells fine collectible statues and has implemented activity-based costing. Costs in the shipping department have been divided into three cost pools. The first cost pool contains costs that are related to packaging and shipping and Rand has determined that the number of boxes shipped is an appropriate cost driver for these costs. The second cost pool is made up of costs related to the final inspection of each item before it is shipped and the cost driver for this pool is the number of individual items that are inspected and shipped. The final cost pool is used for general operations and supervision of the department and the cost driver is the number of shipments. Information about the department is summarized below: Cost Pool Total Costs Packaging and shipping Final inspection General operations and supervision Cost Driver $165,500 Number of boxes shipped Number of individual items $198,000 shipped $83,900 Number of orders Annual Activity 21,200 boxes 98,800 items 9,300 orders During the period, the Far East sales office generated 669 orders for a total of 6,000 items. These orders were shipped in 1,372 boxes. What amount of shipping department costs should be allocated to these sales? Answer: 28,770.34 View Feedback SOLUTION: 1) Calculate packaging and shipping costs as: total cost / annual activity * # of boxes used. 2) Calculate Final inspection costs as: total cost / annual activity * # items in shipment. 3) Calculate general operations cost as: total cost / annual activity * # of orders. 4) Add Question 6 Baller Financial is a banking services company that offers many different types of checking accounts. The bank has recently adopted an activity-based costing system to assign costs to their various types of checking accounts. The following data relate to the money market checking accounts, one of the popular checking accounts, and the ABC cost pools: Annual number of accounts = 56,000 accounts Checking account cost pools: Cost Pool Returned check costs Checking account reconciliation costs New account setup Cost $2,820,000 56,000 650,000 Cost Drivers Number of returned checks Number of account reconciliation requests Number of new accounts Copies of cancelled checks 389,000 Number of cancelled check copy requests Online banking web site maintenance 181,000 Per product group (type of account) Annual activity information related to cost drivers: Cost Pool Returned check Check reconciliation costs New accounts Cancelled check copy requests Web site costs All Products 190,000 returned checks 389,000 checking account 59,000 new accounts 90,000 cancelled check 2 types of accounts Money Market Checking 18,000 420 15,000 60,000 1 Calculate the overhead cost per account for the Money Market Checking. Answer: 13.97 View Feedback SOLUTION: ((returned check cost / number of all products returned checks * money market returned checks) + (checking acct reconciliation cost / number of all checking acct reconciliations * money market checking account reconciliation) + (new account cost / number of all products new accounts * money market new accounts) + (copies of checks cost / number of all products copies of checks * money market copy of checks) + (online banking cost / number of all products online banking * money market online banking)) / annual number of accounts Question 7 Sosa Company has $39 per unit in variable costs and $1,900,000 per year in fixed costs. Demand is estimated to be 138,000 units annually. What is the price if a markup of 35% on total cost is used to determine the price? Answer: 71.24 View Feedback SOLUTION: TC/Unit = {VC}+({FC}/{demand}))*1.35 Question 8 Bob's Company sells one product with a variable cost of $5 per unit. The company is unsure what price to charge in order to maximize profits. The price charged will also affect the demand. If fixed costs are $100,000 and the following chart represents the demand at various prices, what price should be charged in order to maximize profits? Units Sold Price 30,000 $10 40,000 $9 50,000 $8 60,000 $7 $10 $9 $8 $7 View Feedback SOLUTION: 1) Calculate profit for each as: (price * qty)-VC-FC 2) At $9, profit is $60,000, which maximizes profits. Question 10 Carlton Products Company has analyzed the indirect costs associated with servicing its various customers in order to assess customer profitability. Results appear below: Cost Pool Annual Cost Cost Driver Annual Driver Quantity Processing electronic orders Processing non-electronic orders Picking orders Packaging orders Returns $1,000,000 Number of orders $2,000,000 Number of orders $3,000,000 Number of different products ordered $1,500,000 Number of items ordered $2,000,000 Number of returns 500,000 400,000 800,000 50,000,000 50,000 If all costs were assigned to customers based on the number of items ordered, what would be the cost per item ordered? Answer: 0.19 View Feedback Divide the annual cost for each cost pool by the annual driver quantity where the cost driver is "number of items ordered" and add. Question 11 Costa Company has a capacity of 40,000 units per year and is currently selling 35,000 for $400 each. Barton Company has approached Costa about buying 2,000 units for only $300 each. The units would be packaged in bulk, saving Costa $20 per unit when compared to the normal packaging cost. Normally, Costa has a variable cost of $280 per unit. The annual fixed cost of $2,000,000 would be unaffected by the special order. What would be the impact on profits if Costa were to accept this special order? Profits would increase $40,000. Profits would increase $60,000. Profits would decrease $200,000. Profits would increase $80,000 Question 12 A company has $6.80 per unit in variable costs and $4.80 per unit in fixed costs at a volume of 50,000 units. If the company marks up total cost by 0.42, what price should be charged if 66,000 units are expected to be sold? Answer: 14.82 View Feedback Hide Feedback SOLUTION: 1) Calculate fixed cost per unit for the expected unit sales total: (FC*50,000)/expected unit sales total 2) Add variable cost per unit 3) Multiply by 1+markup percentage Question 14 The Estrada Company uses cost-plus pricing with a 0.48 mark-up. The company is currently selling 100,000 units. Each unit has a variable cost of $4.80. In addition, the company incurs $199,300 in fixed costs annually. If demand falls to 87,600 units and the company wants to continue to earn a 0.48 return, what price should the company charge? Answer: 10.47 View Feedback SOLUTION: 1) Calculate Fixed cost per unit as Total FC/Demand 2) Add variable cost per unit 3) Multiply by 1+markup percentage Question 15 A new product is being designed by an engineering team at Golem Security. Several managers and employees from the cost accounting department and the marketing department are also on the team to evaluate the product and determine the cost using a target costing methodology. An analysis of similar products on the market suggests a price of $133.00 per unit. The company requires a profit of 0.15 of selling price. How much is the target cost per unit? Answer: 113.05 View Feedback SOLUTION: {P} -({I}*{P}) Where P=selling price, I=required profit Question 16 A company using activity based pricing marks up the direct cost of goods by 0.27 plus charges customers for indirect costs based on the activities utilized by the customer. Indirect costs are charged as follows: $7.60 per order placed; $2.40 per separate item ordered; $29.30 per return. A customer places 7 orders with a total direct cost of $2,700, orders 292 separate items, and makes 7 returns. What will the customer be charged? Answer: 4,388.1 View Feedback SOLUTION: ({X}*1+{M})+({O}*{P})+({S}*{I})+({R}*{Y}) where X is orders, M=markup rate, O=cost of orders placed, S=cost of separate item, R=cost of return, P=number of orders placed, I=number of separate items, Y=number of returns Question 17 A law firm uses activity-based pricing. The company's activity pools are as follows: Cost Pool Annual Estimated Cost Cost Driver Annual Driver Quantity Consultation 190,000 Number of consultations 100 consultations Administrative Costs 146,000 Admin labor hours 9,900 labor hours Client Service 84,000 Number of clients 120 clients The firm had two consultations with this client and required 130 administrative labor hours. What additional costs will be charged to this customer? Answer: 6,417.17 View Feedback SOLUTION: (annual estimated cost consultation / annual driver consultation qty * 2 consultations) + (annual estimated cost admin / annual driver admin qty * 130 labor hours) + (annual estimated cost client service / annual driver qty)