Ch. 17 P17-1B - Excel HW Assignment (2)

Info in images Required: 1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. 2. Compute the product margins for B300 and T500 under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.   1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)       B300 T500 Total Product margin     $0 2. Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)     B300 T500 Total Product margin     $0 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2…

Info in images Required: 1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. 2. Compute the product margins for B300 and T500 under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.   1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)       B300 T500 Total Product margin     $0 2. Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)     B300 T500 Total Product margin     $0 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2…

A manufacturer reports the following per unit cost information. The company uses absorption costing, and its target markup is 30%. Per unit cost $ 5.90 Variable overhead Fixed overhead Direct materials Direct labor $ 1.90 $ 49.00 $ 11.90 Complete this question by entering your answers in the tabs below. Required A Required B Calculate total product cost per unit. Note: Round your answers to 2 decimal places. Per unit Total product cost using absorption costing $ EA Required A 0.00 Required B >

Use a cost-volume graph to determine the type of cost behavior exhibited in Groups A, B, and C. In the graph, volume should range from 0 to 38, 400 units (in 4,000 unit increments), and cost should range from $0 to $49,000 (in $5,000 increments). Volume Group A Group B Group C (applicable to each group) Costs Costs Costs 3,200 $3,640 $1,400 $ 3,360 19,200 17,640 8,400 3,360 25,600 23,240 11,200 3, 360 32,000 28,840 14,000 3,3601. Identify the cost behavior (fixed, mixed, or variable) in the three groups. Group Cost behavior A B C 2. What is the expected total cost for Group B if volume is 0? $Answer 3. What is the expected total cost for Group C if volume is 0?

Hi-Tek Manufacturing, Incorporated, makes two types of industrial component parts-the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Incorporated Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses $ 1,651,600 1,245,644 405,956 630,000 Net operating loss $ (224,044) Hi-Tek produced and sold 60,400 units of B300 at a price of $19 per unit and 12,600 units of T500 at a price of $40 per unit. The company's traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company's two product lines is shown below: Direct materials Direct labor Manufacturing overhead Cost of goods sold B300 $ 400,800 $ 120,300 T500 $ 162,400 $ 42,100 Total $ 563,200 162,400 520,044 $ 1,245,644 The company has created an activity-based costing system to evaluate the profitability…

a. Prepare a contribution margin by product report. Calculate the contribution margin ratio for each. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries.

Ohno Company specializes in manufacturing a unique model of bicycle helmet. The model is well accepted by consumers, and the company has enough orders to keep the factory production at 10,000 helmets per month (80% of its full capacity). Ohno's monthly manufacturing cost and other expense data are as follows. Rent on factory equipment $1,600 Insurance on factory building 2,500 Raw materials (plastics, polystyrene, etc.) 79,700 Utility costs for factory 900 Supplies for general office 300 Wages for assembly line workers 63,700 Depreciation on office equipment 800 Miscellaneous materials (glue, thread, etc) 1,200 Factory manager's salary 6,400 Property taxes on factory building 500 Advertising for helmets 14,500 Sales commissions 10,600 Depreciation on factory building 1,600 (a)

Use a cost-volume graph to determine the type of cost behavior exhibited in Groups A, B, and C. In the graph, volume should range from 0 to 24,000 units (in 4,000 unit increments), and cost should range from $0 to $35,000 (in $5,000 increments). Volume Group A Group B Group C (applicable to each group) Costs Costs Costs 2,000 12,000 16,000 20,000 $2,600 $1,000 $2,400 12,600 6,000 2,400 16,600 8,000 2,400 20,600 10,000 2,400 1. Identify the cost behavior (fixed, mixed, or variable) in the three groups. Group Cost behavior A B C 2. What is the expected total cost for Group B if volume is 0? $ 3. What is the expected total cost for Group C if volume is 0? Check

How can I prepare a product cost report (with it's supporting calculations) for department 1. Round average cost per equivalent unit to two decimal places. Use rounded answers for subsequent calculations. Round other answers to the nearest whole number.

Ida Company produces a handcrafted musical instrument called a gamelan that is similar to a xylophone. The gamelans are sold for $880. Selected data for the company's operations last year follow: Units in beginning inventory Units produced Units sold 280 240 Units in ending inventory Variable costs per unit: 40 Direct materials 115 2$ 2$ 2$ Direct labor 335 Variable manufacturing overhead Variable selling and administrative Fixed costs: 35 25 Fixed manufacturing overhead Fixed selling and administrative $ 63,000 $ 23,000 The absorption costing income statement prepared by the company's accountant for last year appears below: $ 211,200 170,400 40,800 29,000 Sales Cost of goods sold Gross margin Selling and administrative expense Net operating income $ 11,800 Required: 1. Under absorption costing, how much fixed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. Prepare an income statement for last year using variable costing.

Please help me with correct answer thanku

please fill out this chart

Answer this cost accounting question

The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability:     Labor-Hours Required(hours/unit)   Department Product 1 Product 2 Hours Available A 1.00 0.35 95     B 0.30 0.20 36     C 0.20 0.50 50     Profit contribution/unit $30.00 $15.00           (a) Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2.   If required, round your answer to two decimal places.     Product 1 Product 2 Production     (b) In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for…

Max Machining incurs the following utilities costs at different levels of production: 0 units: 500 units: 1,000 units: How would utility costs be properly classified? Select one: A. Stepped B. Fixed C. Mixed D. Curvilinear E. Variable $120 $2,620 $5,120

Which of the following types of cost is shown in this table of cost data? Cost per Unit $6,000 3,000 2,000 1,500 b. fixed cost Number of Units C. variable cost d. period cost 1 A WN 2 3 4

Please help with T500. Thank you :)

please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)       Exhibit 1: Assumptions (Both Products) Product #1: Launch-it Sales price per unit $ 10.00 Variable costs per unit: $ 4.00 Monthly volume 240     Product #2: Treat-time Sales price per unit $ 30.00 Variable costs per unit: $ 14.00 Monthly volume 160     Total fixed costs per month $ 1,500.00     Target profit per month $ 8,000.00       Margin of Safety (in $)       Margin of Safety %       Degree of Operating Leverage       Expected % change in operating income (%)

Which of the following types of cost is shown in the cost data below? Cost per Number of Unit Units $6,000 3,000 2,000 1,500 a. fixed cost b. mixed cost C. variable cost d. period cost 2. 3. 4.

akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false Up eBook Show Me How Print Item High-Low Method Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs 80,000 $25,100,000 92,000 27,206,000 120,000 32,120,000 a. Determine the variable cost per unit and the total fixed cost. Variable cost (Round to two decimal places.) %24 per unit Total fixed cost b. Based on part (a), estimate the total cost for 115,000 units of production. Total cost for 115,000 units Check My Work 4 more Check My Work uses remaining. Previous Next

Please solve this one with calculation and explanation

if someone can answer quickly i will give a thumbs up!

Identifying Cost Behavior. Mountainside Company is trying to identify the cost behavior of the three costs that follow. Cost information is provided for three months.                   Cost A Cost B Cost C Month Units Produced Total Costs Cost per Unit Total Costs Cost per Unit Total Costs Cost per Unit 1 1,500 $1,500 _____ $4,500 _____ $3,000 _____ 2 3,000 1,500 _____ 5,250 _____ 6,000 _____ 3 750 1,500 _____ 3,750 _____ 1,500 _____   Required: Calculate the cost per unit, and then identify how the cost behaves for each of the three costs (fixed, variable, or mixed). Explain the reasoning for your answers. How does identifying cost behavior patterns help managers?

sing the following data, apply the high-low method of cost analysis to the three cost data groups:   Volume Alpha Beta Gamma 2,000 $6,600 $2,400 $8,000 6,000 $9,800 $7,000 $8,000 13,000 $13,000 $12,000 $8,000 20,000 $21,000 $24,000 $8,000     What cost behavior patterns are apparent for Beta?     Select one: a. Fixed b. Variable c. Mixed d. Semi-fixed e.  None of the above

Build a spreadsheet: Construct and excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if raw material purchases amounted to $190,000 and indirect labor was $20,000.