A manufacturing process can be designed for varying degrees of automation. The following is relevant cost information: Annual Power and Maintenance Expense First Degree Cost A B C D $10,000 14,000 20,000 30,000 Annual Labor Expense $9,000 7,500 5,000 3,000 $500 800 1,000 1,500 Determine which is best by after-tax analysis using an income tax rate of 40%, an after-tax MARR of 15%, and SL depreciation. Assume that each has a life of five years and no BV or MV.

A manufacturing process can be designed for varying degrees of automation. The following is relevant cost information: Annual Power and Maintenance Expense First Degree Cost A B C D $10,000 14,000 20,000 30,000 Annual Labor Expense $9,000 7,500 5,000 3,000 $500 800 1,000 1,500 Determine which is best by after-tax analysis using an income tax rate of 40%, an after-tax MARR of 15%, and SL depreciation. Assume that each has a life of five years and no BV or MV.

Name: A manufacturing process can be designed for varying degrees of automa
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: A manufacturing process can be designed for varying degrees of automation. The following is relevant cost information:Annual Powerand MaintenanceExpenseDegreeABCDFirstCost$10,00014,00020,00030,000AnnualLaborExpense$9,0007,5005,0003,000$5008001,0001,

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter19: Variable Costing (varcost)

Section: Chapter Questions

Problem 4R: To determine the effect of different levels of production on the company’s income, move to cell B7...

See similar textbooks

Similar questions

A manufacturing process can be designed for varying degrees of automation. The following is relevant cost information: Determine which is best by after-tax analysis using an income tax rate of 40%, an after-tax MARR of 15%, andSL depreciation. Assume that each has a life of five years and no BV or MV.
The cost data for Evencoat Paint for the year 2019 is as follows: Using the high-low method, express the companys maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Predict the maintenance costs i190,000 gallons of paint are produced. Predict the maintenance costs if 81,000 gallons of paint are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between gallons of paint produced and equipment maintenance expenses.
To determine the effect of different levels of production on the company’s income, move to cell B7 (Actual production). Change the number in B7 to the different production levels given in the table below. The first level, 100,000, is the current level. What happens to the operating income on both statements as production levels change? Enter the operating incomes in the following table. Does the level of production affect income under either costing method? Explain your findings.
Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.
(ii) Suppose that 80% of the R&D and selling expenses are traceable to Zderm. Prepare life-cycle income statements for each product. What does this indicate about the importance of accurate life-cycle costing?
Given the following cost and activity observations for Leno Enterprises'utilities, use the high-low method to calculate Leno's variable utilities cost permachine hour. Cost Machine HoursSeptember £4,100 22,000October £3,700 18,000November £3,900 19,000December £4,500 28,000a) £0.08b) £4.86c) £0.25d) £12.50
The following activity and cost data that were provided by Hoist Corporation would help in estimating its future maintenance costs: Units Maintenance cost P1,350 7. P1,590 11 P1,920 15 P2.100 Using the least squares regression method to estimates the cost formula, the expected total cost for an activity level of 10 units would be closest to (nearest peso) e.g. 1405.688888, Type 1406 3.
As a new accountant of the company, you are provided with the following information related to KOKO: Product Annual production and sales unit Direct material cost per unit Direct labour cost per unit Machine hours per unit Selling price per unit Koko 5,500 RM50 RM35 3 hours RM150 The company is considering of changing the traditional method to the Activity Based Costing (ABC) method. In order to adopt ABC method the following information is required: Activity Cost Cost Driver Pool Expected overhead Expected use of drivers per product Other products 3,500 costs Коко (RM) No of purchase orders Machine hours Maintenance Maintenance hours Number of inspections Total Purchasing 4,000 37,500 Machining 16,500 8,000 1,500 147,000 43,000 3,500 Quality control 1900 1600 17,500 245,000 Required: a. If the company decided to use the Activity Based Costing (ABC) method, determine the cost per unit of KOKO. Based on your answer in (a), advise whether the company should change to ABC method. Support…
Jerome Company has manufactured a product and has provided you the following relevant range of 30,000 to 50,000 units produced and sold annually: Units produced and sold 30000 40000 50000 Particulars Units Units Units Total Costs: Variable Costs $ 180,000 S 300,000 $ 480,000 ? ? Fixed Costs ? ? Total Costs ? ? Costs per Unit: Variable cost ? ? ? Fixed cost ? ? ? Total cost per unit: You are required to calculate net operating income if the company produces and sells 45,000 units during the year at a selling price of $16 per unit. a. Net income for the year is $250,000 b. Net income for the year is $150,000 c. Net income for the year is $175,000 d. Net income for the year is $215,000
A.Prepare Statement of Income and Expenses with a marginal contribution approach. Empresas La Torre presents the following information for the year ended December 31, 2020: Product Costs: Direct materials (Variables) $ 50.00 per unit Direct Labor (Variable) $ 20.00 per hour Variable Indirect Costs $ 10.00 per hour Total Fixed Indirect Costs $ 250,000 Period Expenses Seller Commissions $ 20.00 per unit Variable Administrative Expenses $ 30.00 per unit Total Fixed Administrative Expenses $ 150,000 The company sells solar batteries at $ 200.00 per unit. Making each battery takes 2 hours of direct labor. The company taxes its income at 40%. If the Company sells 10,000 units, prepare a statement of income and expenses using the marginal contribution approach.
Write a linear cost function equation for each of the following conditions. Use y for estimated costsand X for activity of the cost driver. Machine operating costs include $1,000 of maintenance per month, and $15.00 of coolant usagecosts for each day the machinery is in operation.