Change the data in your worksheet so that it matches the following:1 Chapter 4: Applying Excel23 Enter a formula into each of the cells marked with a ? below4 Review Problem: Activity-Based Costing56789101112131415161718456922192021DataAnnual sales in unitsDirect materials per unitDirect labor-hours per unitADirect labor rateActivities and Activity MeasuresLabor related (direct labor-hours)Machine setups (setups)Production orders (orders)General factory (machine-hours)$$$B$DeluxeEstimatedOverheadCost1,00049 $1с35,000120,00070,000150,000375,000Tourist21 per DLH9,000491Deluxe1,000403510,000DExpected ActivityTourist9,000601510,000ETotal10,0001005020,000 a. What is the traditional unit product cost for the deluxe model now? (roundyour intermediate calculations and final answer to 2 decimal places.) b. Whatis the traditional unit product cost for the tourist model? (Round yourintermediate calculations and final answer to 2 deimal places) c. What is theABC unit product cost for the deluxe model now? (Round your intermediatecalculations and final answer to 2 decimal places.) d. What is the ABC productcost for the tourist model? (Round your intermediate calculations and finalanswer to 2 decimal places.)

Name: Change the data in your worksheet so that it matches the following:1
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Change the data in your worksheet so that it matches the following:1 Chapter 4: Applying Excel23 Enter a formula into each of the cells marked with a ? below4 Review Problem: Activity-Based Costing56789101112131415161718456922192021DataAnnual sales

Lets understand the basics.Overhead can be allocated using,(1) Traditional basis (2) Activity based…

Answered: Annual sales in units Direct materials…

Business

Accounting

Annual sales in units Direct materials per unit Direct labor-hours per unit Direct labor rate $ $ Deluxe 1,000 49 $ 1 Tourist 21 per DLH 9,000 49 1

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: #5. The following information was developed for Beta Company for the year ended December 31, 2018.…

A: Contribution Margin: It is the revenue which remains after deducting variable costs of products.…

Q: a. Criticize the preceding presentation. On what basis does the $10,000 of company fixed expenses…

A: Calculation of ratio of allocating company fixed expenses: 3333 : 1667 : 5000 or .33 : .17 : .50 or…

Q: A В C Sales $ 3.00 $ 5.00 $ 15.00 Variable costs $ 1.20 $ 3.40 2$ 8.00 Fixed costs $ 0.50 $ 1.00 $…

A: The key factor is such a factor of production whose availability is limited in quantity. To maximize…

Q: Variable Expenses Cost of Goods Sold 28% of sales Supplies 17% of sales Sales Commissions 10% of…

A: Contribution margin percentage = Contribution / Sales * 100 Contribution = Sales - variable expenses

Q: Contribution margin $ 26, 100 $ 10, 600 $ 25, 400 Fixed costs allocated to each product line 10, 980…

A: Please see the explanation for the answer If you have any questions, just comment down. Thank…

Q: Data concerning Wislocki Corporation's single product appear below: Percent of Sales 100% 25% 75%…

A: Cost-Volume-Profit (CVP) analysis is a managerial accounting technique that helps businesses…

Q: dies. income statement follows. sales Cost of goods sold Gross profit MERLINE MANUFACTURING Income…

A: Budgeting:Budgeting is the process of predicting future values in terms of sales, purchases, and…

Q: Annual sales volume Unit selling price Variable expense per unit Contribution margin per unit Velcro…

A: "Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: The following information is available for Nguoi Corporation. 2025 2024 Current assets $54, 000 $…

A: The Earnings per share is calculated by dividing Earnings available to Common Shareholder by Average…

Q: Selling price per unit: $15 Variable cost per unit: $10 Fixed MOH for each year: $800…

A: Under the absorption costing, Fixed MOH is considered as a Product Cost and therefore, the cost of…

Q: Robinson Products Company has two service departments (S1 and S2) and two production departments (P1…

A: One of the two techniques employed in the creation of a cash flow statement is the direct method.…

Q: None

A: Spending variance for sales salaries and commission = Flexible budget amount of sales salaries and…

Q: Denton Company manufactures and sells a single product. Cost data for the product are given:…

A: The fixed costs are the cost that normally does not change if the level of activity changes but…

Q: 5:Bettina Company incurs the following costs to produce and sell a single product. Variable costs…

A: 1) The Company using Variable Costing. Fixed Manufacturing Overhead is excluded under variable…

Q: Units produced 2,000 units Sales price $ 25 Direct materials $1 $ 2 Variable overhead $3 per unit…

A: The Contribution Margin is the difference between the sales and the marginal cost of the sales and…

Q: The Safeer Company manufactures and sells a single product. Price and cost data on product and…

A: As per Bartleby guidlines ,we are supposed to give answer for the first three sub parts if it is a…

Q: 60% increase During the months of January through June, the following total utility costs were paid…

A: Step 1: Introduction to cost of a productThe cost of a product refers to the total amount of…

Q: Ch 6 During Heaton Company's first two years of operations, it reported absorption costing net…

A: ABSORPTION COSTING Absorption Costing is a Cost managerial Accounting method in which All Cost…

Q: Miller Company's contribution format income statement for the most recent month is shown below:…

A: The contribution margin is calculated as the difference between the revenue and expenses. The net…

Q: Number of units produced 2,900 Number of units sold 1,700 Unit sales price $ 790.00 Direct…

A: Absorption income statement is as follows: Results of the formulas used in the above table are as…

Q: income statement total per…

Q: Miller Company's contribution format income statement for the most recent month is shown below:…

A: The contribution margin is calculated as the difference between the sales and variable costs. The…

Q: Peeler's Smoothie Company has provided the following information: Sales price per unit Variable cost…

A: Solution:- Calculation of Contribution margin ratio as follows:-

Q: 6 Data Section: Fixed Variable 7 -- 8 Production costs: 9 Direct materials $2.30 10 Direct labor…

A: Dollar sales at break even point can be calculated by following two formulas; Dollar sales at…

Q: Units Sold Sales Variable Expenses Fixed Expenses Net Income (LOSS) Contribution Margin Per Unit…

A: Cost volume profit analysis is the technique used by management for decision making. The methods…

Q: Selling price Units in beginning inventory Units produced Units sold Units in ending inventory $ 126…

A: ABSORPTION COSTINGAbsorption Costing is a Cost managerial Accounting method in which All Cost…

Concept explainers

Variance Analysis

In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.

Standard Costing

The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.

Topic Video

Question

Change the data in your worksheet so that it matches the following:
1 Chapter 4: Applying Excel
2
3 Enter a formula into each of the cells marked with a ? below
4 Review Problem: Activity-Based Costing
56
7
8
9
10
11
12
13
14
15
16
17
18
456
922
19
20
21
Data
Annual sales in units
Direct materials per unit
Direct labor-hours per unit
A
Direct labor rate
Activities and Activity Measures
Labor related (direct labor-hours)
Machine setups (setups)
Production orders (orders)
General factory (machine-hours)
$
$
$
B
$
Deluxe
Estimated
Overhead
Cost
1,000
49 $
1
с
35,000
120,000
70,000
150,000
375,000
Tourist
21 per DLH
9,000
49
1
Deluxe
1,000
40
35
10,000
D
Expected Activity
Tourist
9,000
60
15
10,000
E
Total
10,000
100
50
20,000

a. What is the traditional unit product cost for the deluxe model now? (round
your intermediate calculations and final answer to 2 decimal places.) b. What
is the traditional unit product cost for the tourist model? (Round your
intermediate calculations and final answer to 2 deimal places) c. What is the
ABC unit product cost for the deluxe model now? (Round your intermediate
calculations and final answer to 2 decimal places.) d. What is the ABC product
cost for the tourist model? (Round your intermediate calculations and final
answer to 2 decimal places.)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Understanding of traditional and activity based costing

VIEW

Step 2: Product cost under traditional basis

VIEW

Step 3: Product cost under activity based costing

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Direction: Read carefully and answer the questions below. Encircle the letter of the correct answer. 1. Which of the following is an example of a variable cost? а. interest b. ingredients с. insurance d. lease 2. What type of cost varies depending on the quantity of products being produced? а. fixed b. net sales с. total d. variable 3. Which among the following concepts is usually seen on the top item in an income statement from which all costs and expenses is subtracted to arrive at net income? a. fixed cost b. net sales с. total cost d. variable cost 4. When do we obtain the break-even point? When the fixed cost is equal to the total cost When the total cost is equal to the variable cost When the variable cost is equal to the fixed cost d. When the number of units of goods sold covers the all the costs а. b. с. 5. Which of the following is NOT true? а. The fixed cost does not vary over time. b. The total cost is the sum of the fixed cost and the variable cost. с. The total cost is…
Question B options: Yes or No
Need help solving this, please.
Accounting Question
Atlanta Systems produces two different products, Product A, which sells for $450 per unit, and Product B, which sells for $800 per unit, using three different activities: Design, which uses Engineering Hours as an activity driver; Machining, which uses machine hours as an activity driver; and Inspection, which uses number of batches as an activity driver. The cost of each activity and usage of the activity drivers are as follows: Usage by Product A Usage by Cost Product B Design (Engineering Hours) Machining (Machine Hours) Inspection (Batches) $ 190,000 $1,800,000 $ 160,000 108 142 2,160 2,840 42 38 Atlanta manufactures 12,500 units of Product A and 10,200 units of Product B per month. Each unit of Product A uses $100 of direct materials and $45 of direct labor, while each unit of Product B uses $140 of direct materials and $75 of direct labor.
Solve this problem
1. Fill in the missing numbers in the table. Use the following questions to help fill in the missing numbers in the table: a. What is the total contribution margin? b. What is the total variable expense? c. How many units were sold? d. What is the per-unit variable expense? e. What is the per-unit contribution margin? 2. Answer the following questions about breakeven analysis: a. What is the breakeven point in units? b. What is the breakeven point in sales dollars? 3. Answer the following questions about target profit analysis and safety margin: a. How many units must the company sell in order to earn a profit of $48,000? b. What is the current margin of safety in units? c. What is the margin of safety in sales dollars? d. What is the margin of safety in percentage?
Use the following information to answer the next two questions. Rounding instructions for these two questions: round your variable cost per unit to the nearest cent for purposes of answering the first question, BUT for purposes of performing additional calculations round the variable cost per unit at the FOURTH DECIMAL PLACE. For example, if you come up with a variable cost per unit of 55.28448 your answer for the first question would be 55.28, but you would use 55.2845 for any additional calculations where the variable cost per unit is utilized. If your answer for the second question is within $10 of one of the answer choices then assume your answer corresponds to that answer choice. A company provides the following information about the total amount of a mixed cost for each month along with the number of units produced in each month. Month Cost Units produced January $200,000 7,575 February $199,000 7,600 March $215,000 8,000 April $240,000 9,250 $241,000 9,225 May Using the high-low…
Do not give solution in image format thanku
select best options with short details
Please solve accurately. Thank you
Given the mixed cost function y = $6.50x + $3,000. What does the $6.50 represent? a.Total cost per unit of the cost driver b.The fixed cost per unit c.The slope of the cost function d.Total fixed costs