please answer both parts in excel with formula The Horizon Cable Manufacturing Company incurred the following costs whilemanufacturing its high voltage cables for SMUD and Washington Public Power.Materials used in productDepreciation on plantProperty taxes on store$ 114,00042,0003,750Labor costs assembly-line workers 96,365Factory supplies used17,250Advertising expenseProperty taxes on plantDelivery expenseSales commissions$36,00011,92011,00021,000Salaries paid to sales clerks 19,000Work-in-process inventory was $26,500 at January 1 and $15,500 at December 31.Finished goods inventory was $45,800 at January 1 and $51,300 at December 31.Instructions(a) Compute the cost of goods manufactured for Horizon Cable Company.(b) Compute the cost of goods sold for the company.

Lets understand the basics. Cost of goods manufactured is a cost for manufacturing goods. On other…

The Horizon Cable Manufacturing Company incurred the following costs while manufacturing its high voltage cables for SMUD and Washington Public Power. Materials used in product Depreciation on plant Property taxes on store $ 114,000 42,000 3,750 Labor costs assembly-line workers 96,365 Factory supplies used 17,250 Advertising expense Property taxes on plant $36,000 11,920 11,000 21,000 Salaries paid to sales clerks 19,000 Delivery expense Sales commissions Work-in-process inventory was $26,500 at January 1 and $15,500 at December 31. Finished goods inventory was $45,800 at January 1 and $51,300 at December 31.

The Horizon Cable Manufacturing Company incurred the following costs while manufacturing its high voltage cables for SMUD and Washington Public Power. Materials used in product Depreciation on plant Property taxes on store $ 114,000 42,000 3,750 Labor costs assembly-line workers 96,365 Factory supplies used 17,250 Advertising expense Property taxes on plant $36,000 11,920 11,000 21,000 Salaries paid to sales clerks 19,000 Delivery expense Sales commissions Work-in-process inventory was $26,500 at January 1 and $15,500 at December 31. Finished goods inventory was $45,800 at January 1 and $51,300 at December 31.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter10: Accounting Systems For Manufacturing Operations

Section: Chapter Questions

Problem 10.3E: Classifying costs as factory overhead Which of the following items are properly classified as part...

See similar textbooks

Similar questions

Otsego Industries manufactured 300,000 units of product last year and identified the following costs associated with the manufacturing activity: Variable costs: Direct materials used Direct labor Indirect materials and supplies Power to run plant equipment Fixed costs: Supervisory salaries Plant utilities (other than for plant equipment) Depreciation on plant and equipment Property taxes on building Answer is not complete. $ 10,965.00 $ 8,160.00 $ 19,125.00 ($000) $ 6,120.0 4,060.0 1,420.0 1,300.0 Required: Unit variable costs and total fixed costs are expected to remain unchanged in the following year. However, management expects a slowdown in sales, because of the economy in the following year. Calculate the unit cost and the total cost if 255,000 units are produced next year. Note: Enter your total cost answers in thousands. Round your answers to 2 decimal places. Total variable costs Total fixed costs Total costs Unit costs $ 2,460.0 1,896.7 2,285.0 1,518.3
Classifying costs as factory overhead Which of the following items are properly classified as part of factory overhead for Caterpillar? a. Amortization of patents on new assembly process b.Consultant fees for a study of production line employee productivity C. Depreciation on Peoria. Illinois, headquarters building d.Factory supplies used in the Morganton. North Carolina, engine parts plant e.Interest expense on debt f. Plant manager's salary at Aurora, Illinois, manufacturing plant g.Properly taxes on the Danville, Kentucky, tractor tread plant h.Sales incentive fees to dealers i. Steel plate j. Vice president of finance's salary
Verde Company reported operating costs of 50,000,000 as of December 31, 20x5, with the following environmental costs: Required: 1. Prepare an environmental cost report, classifying costs by quality category and expressing each as a percentage of total operating costs. What is the message of this report? 2. Prepare a pie chart that shows the relative distribution of environmental costs by category. What does this report tell you? 3. What if Verde deliberately did not include the cost of damaging the ecosystem because of solid waste disposal in its environmental cost report? Offer possible reasons for this decision. If consciously avoided, is this decision unethical?
Hicks Contracting collects and analyzes cost data in order to track the cost of installing decks on new home construction jobs. The following are some of the costs that they incur. Classify these costs as fixed or variable costs and as product or period costs. Lumber used to construct decks ($12.00 per square foot) Carpenter labor used to construct decks ($10 per hour) Construction supervisor salary ($45,000 per year) Depreciation on tools and equipment ($6,000 per year) Selling and administrative expenses ($35,000 per year) Rent on corporate office space ($34,000 per year) Nails, glue, and other materials required to construct deck (varies per job)
Complete this question by entering your answers in the tabs below. Required A Required B Which alternative should the company choose? The total cost of the "make" alternative is by Therefore, the company should the part.
Abagail Corp. uses activity-based costing system with three activity cost pools. The following information is provided: Costs: Wages and salaries $204,000 Depreciation 114,000 Utilities 116,000 Activity Cost Pools Assembly Setting Up Other Wages and Salaries 0.58 30% 10% Depreciation 0.39 45% 20% Utilities 0.24 40% 30% How much total cost would be allocated to the Assembly activity cost pool?
(Management Accounting) Davidson Company produces a part that is used in the manufacture of one of its products. The costs associated with the production of 5,000 units of this part are as follows: Direct materials $108,000 Direct labor 156,000 Variable factory overhead 70,000 Fixed factory overhead 168,000 Total costs $502,000 Of the fixed factory overhead costs, $72,000 are avoidable. Assuming there is no other use for the facilities. What is the highest price Davidson Company should be willing to pay for 5,000 units of the part? A) $264,000 B) $334,000 C) $406,000 D) $502,000
Part U67 is used in one of Broce Corporation's products. The company's Accounting Department reports the following costs of producing the 16,400 units of the part that are needed every year. Per Unit Direct materials $ 3.60 Direct labor $ 4.30 Variable overhead $ 7.30 Supervisor's salary $ 8.00 Depreciation of special equipment $ 8.60 Allocated general overhead $ 5.60 An outside supplier has offered to make the part and sell it to the company for $32.00 each. If this offer is accepted, the supervisor's salary and all of the variable costs, including direct labor, can be avoided. The special equipment used to make the part was purchased many years ago and has no salvage value or other use. The allocated general overhead represents fixed costs of the entire company. If the outside supplier's offer were accepted, only $22,400 of these allocated general overhead costs would be avoided. Required: a. Prepare a report that shows the financial impact of buying part…
Kell Corporation manufactures computers. Assume that Kell: • allocates manufacturing overhead based on machine hours • estimated 12,000 machine hours and $92,000 of manufacturing overhead costs • actually used 15,000 machine hours and incurred the following actual costs: Indirect labor $10,000 Depreciation on plant 47,000 Machinery repair 17,000 Direct labor 71,000 Plant supplies 5,000 Plant utilities 6,000 Advertising 33,000 Sales commissions 23,000 What is Kell's actual manufacturing overhead cost?
Product A is produced with the following costs: 1) Paper material P20 per unit 2) Plastic P15 per unit 3) Rubber P27000 per 12000 units. 4) Labor P4 per unit 5) Indirect material costs P2.5 per unit The company pays P60,000 for rent per month for factory. It depreciates a P300,000 vehicle used for delivery and a P210,000-machine used for manufacturing, both have a life of 5 years. a. How much should be the total overhead costs if in a month, 1000 units were produced? b. How much should be the direct material costs if in a month, 1,500 units were produced? c. How much is the total conversion cost if 3,000 units are produced? d.How much is the total product cost per unit if in a month of production 4,750 units were produced? e. How many units should be sold in a month to break even?
Piels Corporation produces a part that is used in the manufacture of one of its products. The costs associated with the production of 10,000 units of this part are as follows: Direct materials $87,000 Direct labor: $126,000 Variable factory overhead: $58,000 Fixed factory overhead: $136,000 Total costs: $407,000 Of the fixed factory overhead costs, $55,000 is avoidable Assuming no other use of their facilities, the highest price that Piels should be willing to pay for 10,000 units of the part is ?
Harith Company's industrial photo-finishing division, Rho, incurred the following cost and expenses in 2021: Direct Materials Direct Labor Factory Overhead General, selling and administrative Totals VARIABLE P200,000 150,000 70,000 30,000 P450,000 FIXED P42,000 48,000 P90,000 During 2021, Rho produced 300,000 units of industrial photo-prints, which were sold for P2.00 each. Oslo's investment in Rho was P500,000 and P700,000 at January 1 and December 31, 2021 respectively. Harith normally imputes interest on investment at 15% of average invested capital. Assume that net operating profit was P60,000 and that average invested capital was P600,000. For the year ended, Rho's residual income(loss) was -45,000 150,000 60,000 -30,000