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

Similar questions

please I need help and provide correct and well explained answer with steps and all workings
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.
Q. 8 Which following costs need to be considered for both make or buy options? O. Fixed overhead O. Variable overhead O. Rental revenue Q. 9 What is the per unit cost to purchase from the vendor? Round to the nearest penny. Q. 10 Based on your analysis, the CreativeStationary Co. should make the product in-house or buy them from the vender? O. Make O. Buy Do (Q8,9,10 plz)
J a) You are given the cost and volume information below:+ VolumeCost+ 1 unit 10 units 100 units $ 15+ 150+ 1500 What type of a cost is given?+ a. fixed cost+ b. variable cost+ c. step cost+ d. mixed cost+ e. rent cost.
Accounting Question
I need help with part b please, i have part a done
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