Required information1Requirement 3:Change the data in your worksheet so that it matches the following:2higher proportion of the production orders are now attributable to the Deluxe model.The ABC unit product cost of the Deluxe model has decreased and the ABC unit product cost of the Tourist model has increased because alower proportion of the production orders are now attributable to the Deluxe model.The ABC unit product cost of the Deluxe model has decreased and the ABC unit product cost of the Tourist model has increased because ahigher proportion of the production orders are now attributable to the Deluxe model.67Chapter 4: Applying Excel3Enter a formula into each of the cells marked with a ? below4 Review Problem: Activity-Based Costing5AData8 Annual sales in units9 Direct materials per unit10 Direct labor-hours per unit1112 Direct labor rate13141516 Activities and Activity Measures17 Labor related (direct labor-hours)18 Machine setups (setups)19 Production orders (orders)20 General factory (machine-hours)21$$$B$DeluxeEstimatedOverheadCost1,00049 $135,000120,00070,000с21 per DLH150,000375,000Tourist9,000491Deluxe1,000403510,000DExpected ActivityTourist9,000601510,000ETotal10,0001005020,000 (a). What is the traditional unit product cost for the Deluxe model now? (Round your intermediate calculations and final answer to 2decimal places.)Traditional unit product cost for the Deluxe model(b). What is the traditional unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2decimal places.)Traditional unit product cost for the Tourist model(c). What is the ABC unit product cost for the Deluxe model? (Round your intermediate calculations and final answer to 2 decimalplaces.)ABC unit product cost for the Deluxe model(d). What is the ABC unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimalplaces.)ABC unit product cost for the Tourist model

“Since you have posted a question with multiple sub parts, we will provide the solution only to the…

Answered: Required information nigner proportion…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter16: Manufacturing Accounting (mfg)

Section: Chapter Questions

Problem 4R: Open MFG2 and click the Chart sheet tab. The management of Twisp is convinced that the quality of...

See similar textbooks

Similar questions

Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Foxed expenses Operating income (loss) Contribution margin per unit $ Case #1 15,000 180,000 $ 100,000 120,000 50,000 $ $ Case #2 Case #1 Case #3 10,000 Case #2 70,000 $ 32,000 8,000 $ 12,000 $ 10 $ 13 Case #4 b. Assume that more than one product is being sold in each of the following four case situations: (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) Case #3 6,000 300,000 100,000 (10,000) Case #4
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Fixed expenses Operating income (loss) Contribution margin per unit Sales Variable expenses Fixed expenses $ Operating income (loss) Average contribution margin (percentage) Case #1 20,100 241,200 $ 160,800 67,000 $ Case #2 S $ $ Case #1 134,000 42,880 10,720 S 10 S 8,700 20% b. Assume that more than one product is being sold in each of the following four case situations. (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) 534,000 $ Case #3 Case #2 13,400 434,000 282,100 108,500 93,800 Case #4 8,040 S 402,000…
Fill in the missing amounts in each of the eight case situations below. Each case Is Independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format Income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Fixed expenses Operating income (loss) Contribution margin per unit Sales Variable expenses Fixed expenses $ Operating income (loss) Average contribution margin (percentage) Case #1 20,400 244,800 163,200 68,000 $ $ 136,000 $ 10 Case #2 $ Case #1 536,000 43,520 10.880 $ 8,800 20% 10 $ 69 Case #3 Case #2 13,600 b. Assume that more than one product is being sold in each of the following four case situations: (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) 436.000 283.400 109.000 95,200 16,320 13 $ S CA Case #4…
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Fixed expenses Operating income (loss) Contribution margin per unit Sales Variable expenses Fixed expenses $ Operating income (loss) Average contribution margin (percentage) Case #1 15,600 187,200 124,800 52,000 $ $ $ 104,000 $ $ Case #2 Case #1 33,280 8,320 $ 10 $ 7,200 20% Case #3 Case #2 504,000 $ 404,000 262,600 101,000 b. Assume that more than one product is being sold in each of the following four case situations: (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) 10,400 72,800 $ $ Case #4 104,000 12,480 $…
Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the break-even point, sales and costs are exactly equal. However, the goal of most companies is to make a profit. When a company decides that it wants to earn more than the break-even point of income, it must define the amount it thinks it will realistically make. By modifying the break-even equation, the sales required to earn a target or desired amount of profit may be computed. Complete the following: If a company makes $5 off of each unit it sells and has a target operating income of $5,000, then it must sell units. Similarly, if a company has a target operating income of $75,000 and knows that total expenses for the period will be $75,000, how much revenue must it earn to reach its target operating income? Units sold or revenue earned above and bevond the break-even point contributes to the margin of safety for a company, Margin of safety is a crude measure of risk, in that it serves as the…
A. engageNOWv2 | Online teachir X + com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssigni tSessionLocator=&inprogress... A The Atlantic Company sells a product with a break-even point of 6,167 sales units. The variable cost is $110 per unit, and fixed costs are $234,346. Determine the following: $ a. Unit sales price units b. Break-even point in sales units if the company desires a target profit of $82,080 ▬
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. ( Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.)a. Assume that only one product is being sold in each of the four following case situations:Contribution Net OperatingUnits Variable Margin Fixed IncomeCase Sold Sales Expenses per Unit Expenses (Loss)1 .......... 15,000 $180,000 $120,000 ? $50,000 ?2 .......... ? $100,000 ? $10 $32,000 $8,0003 .......... 10,000 ? $70,000 $13 ? $12,0004 .......... 6,000 $300,000 ? ? $100,000 $(10,000)
Refer to the pictur ebelow: Find: 1. Total Cost of Product A under ABC System2. Total Cost of Product B under ABC System3. Selling Price per unit of Product B assuming profit margin of 20% above cost
Activity 2: Complete me! Directions: Fill in the needed data to complete the table below. Unit B.E.P in B.E.P in Selling Price per Unit Variable Cost per Unit Total Fixed Cost Contributio Units Pesos n Margin P19,500.00 P15.00 P13.00 P960.00 P18.00 P15.00 P24.00 P3.00 69 P34.00 P3.00 150 P27.00 P5.00 100 2. 3. 4.
1) what is the breakeven selling price per unit for Product A? 2) For product C, assume the selling price cannot change., what variable cost per unit will result in breakeven at 150 units sold? 3) what is the breakeven unit sales for Product F. Do not give answer in image
* CengageNOWv2 | Online teachin x now.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress3false Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows: Estimated Estimated Variable Cost Fixed Cost (per unit sold) Production costs: Direct materials $19 Direct labor 13 Factory overhead $182,500 10 Selling expenses: Sales salaries and commissions 37,900 4 Advertising 12,800 Travel 2,900 Miscellaneous selling expense 3,100 4 Administrative expenses: Office and officers' salaries 37,100 Supplies 4,600 2…
In the spreadsheet below, there is data on the price, cost, demand, and quantity produced for an item. There are also different "what if" values that can help a manager to calculate costs and revenue with variability in demand. A B C 1 Profit Model 2 What- 3 Data IfDemand Values 4 20,000 5 Unit Price ($) 50 40,000 9 Unit Cost ($) 25 55,000 7 Fixed Cost ($) 550,000 60,000 8 Demand 60,000 65,000 9 Quantity Produced 55,000 10 From the "what if" values, calculate the total cost when demand is 40,000. A. $2,000,000 B. $75,000 C. $1,100,000 D. $1,925,000

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS