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…

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 >

Please help me with correct answer thanku

please fill out this chart

Harrington Corporation produces three products, A, B, and C. Pertinent information on these products is as follows:   Product Selling Price per Unit Variable Cost per Unit Fixed Costper Unit DL Hoursper Unit A $ 4.00   $ 1.00   $ 2.00   2   B $ 3.50   $ 0.50   $ 2.00   2   C $ 6.00   $ 2.00   $ 3.00   3       The objective function for a linear program to maximize contribution margin from the set of three products is:   Multiple Choice   Z = $3A + $2.50B + $5C.   Z = A + B + C.   Z = A + $0.50B + $2C.   Z = $3A + $3B + $4C.   Z = $4A + $3.50B + $6C.

Evaluating Selected Cost Driver Assume that a manufacturer of specialized machine parts developed the following total cost estimating equation for manufacturing costs. Y = $14,400 + $1,250 (actual units) a. What is total estimated manufacturing costs if 180 units are produced? $Answer 0

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…

i need this question answer General accounting

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

Quick answer of this accounting questions

Need help with this general accounting question

Please solve this one with calculation and explanation

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?

Data table Units of D4H produced and sold 1. 2. Selling price 3. Direct materials (kilograms) 4. Direct material cost per kilogram 5. Manufacturing capacity (units of D4H) 6. Total conversion costs 7. 8. Selling and customer-service capacity 9. Total selling and customer-service costs 10. Selling and customer-service capacity cost per customer 11. Design staff 12. Total design costs 13. Design cost per employee Conversion cost per unit of capacity Alt+Q Print Done $ $ 210 41,000 $ 310,000 7.25 $ 250 2,125,000 $ 8,500 $ $ $ 2,150,000 8,600 95 customers 90 customers 900,000 10,000 12 1,045,000 $ 11,000 $ 12 1,212,000 $ 101,000 $ $ $ ZUZT $ $ ZUZZ 235 43,000 325,000 7.75 250 1,218,000 101,500 (similar to) Data table HW Score: 3.03%, 0.12 of 4 points Daint 0 10 of 1 Revenue effect of growth Cost effect of growth The company has chosen a product differentiation strategy. The growth, price- recovery, and productivity components of the change in operating income from 2021 to 2022 are as…

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.

25: Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows: Activity Budgeted Activity Cost Activity Base Casting $570,000 Machine hours Assembly 80,000 Direct labor hours Inspecting Setup Materials handling 42,000 Number of inspections Number of setups 38,000 23,750 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantities and units produced follow: Activity Base Entry Dining Total Machine hours 6,000 13,000 19,000 Direct labor hours 3,000 2,000 5,000 Number of inspections 600 400 1,000 Number of setups 300 200 500 Number of loads 450 500 950 Units produced 6,000 3,000 9,000

s

Can you please help me fill out the two tables, also please let me know what formulas and rules were used

Ayala Inc. has conducted the following analysis related to its product lines, using a traditional costing system (volume-based) and an activity-based costing system. Both the traditional and the activity-based costing systems include direct materials and direct labor costs. Products Product 540X Product 137Y Product 2495 Sales Revenue $208,000 155,000 92.000 Total Costs Traditional $54,000 48,000 23.000 ABC $49,000 30,000 46,000

For many years, Sinclair Graphic Design has provided design and digital-printing services for indoor banners. The nylon banners, which come in a standard size, are used for a variety of purposes, including trade shows, sporting events, and other promotional activities. Three years ago, the company introduced a second printing and production service for outdoor banners that has become increasingly popular. The outdoor banners are a more complex product than the indoor banners, requiring weatherproof vinyl materials and a different printing process to improve the visibility of the text and graphics content. Moreover, outdoor banners are printed in smaller production runs because of less frequent orders; the setup of the printing equipment takes longer; and, since higher durability is needed to withstand the elements, more quality inspections are needed. Under the traditional costing approach, overhead costs are assigned to the products on the basis of direct labour-hours. Despite the…

Please show the solution on how to get the answer.

uired intor Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below.] Felix & Company reports the following information. Units Produced Total Costs $ 2,515 3,235 3,955 4,675 5,395 6,115 6,835 7,555 8,275 8,995 Period 1 2 400 800 1,200 1,600 2,000 2,400 2,800 3,200 3,600 4 6. 7 10 Exercise 18-5 (Algo) Measuring costs using high-low method LO P1 (1) Use the high-low method to estimate the fixed and variable components of total costs. (2) Estimate total costs if 3,000 units are produced. High-Low method - Calculation of variable cost per unit High-Low method - Calculation of fixed costs Total cost at the high point Variable costs at the high point Volume at the high point Variable cost per unit Total variable costs at the high point Total fixed costs Total cost at the low point Variable costs at the low point Volume at the low point Variable cost per unit Total variable costs at the low point Total fixed costs (2)…

Required information Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below.] Felix & Company reports the following information. Period Units Produced Total Costs 1 0 $ 2,900 2 460 3,774 3 860 4,534 4 1,260 5,294 5 1,660 6,054 6 2,060 6,814 7 2,460 7,574 8 2,860 8,334 9 3,260 9,094 10 3,660 9,854 Exercise 21-6A (Algo) Appendix: Measuring costs using regression LO P1 Use spreadsheet software to use ordinary least-squares regression to estimate the cost equation, including fixed and variable cost amounts. Cost equation = + per unit

please asnzwer as soon as possible

USING ACTIVITY BASED CSOTING, WHAT IS THE APPROXIMATE COST PER UNIT OF COATS

Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to the company's three activity cost pools-- Processing, Supervising, and Other. The costs in those activity cost pools appear below: Processing $ 3,800 $ 23,800 $ 10,400 Supervising other Processing costs are assigned to products using machine-hours (MHs) and Supervising costs are assigned to products using the number of batches. The costs in the Other activity cost pool are not assigned to products. Activity data appear below: Batches MHs (Processing) (Supervising) Product MO 9,700 500 Product M5 300 500 Total 10,000 1,000 Finally, sales and direct cost data are combined with Processing and Supervising costs to determine product margins. Product MO Product M5 $ 74,100 $ 28,500 $ 27,800 $ 89,900 $ 31,400 $ 41,700 Sales (total) Direct materials (total) Direct labor (total) What is the product margin for Product M5 under activity-based costing? Multiple Choice C4786