Ma Cost Cost Setups Parts Time Orders 3,600 min. 2,500 min. $630 $3,000 2,400 30 42 65 Laptops Desktops 575 12 24 20 Required a. Compute the cost per unit of laptop and desktop keyboards, assuming that Wu made 500 units of each type of keyboard. (Round your answers to 2 decimal places.) Cost per unit Laptop keyboards 10.03 Desktop keyboards $ 6.72 %24

Ma Cost Cost Setups Parts Time Orders 3,600 min. 2,500 min. $630 $3,000 2,400 30 42 65 Laptops Desktops 575 12 24 20 Required a. Compute the cost per unit of laptop and desktop keyboards, assuming that Wu made 500 units of each type of keyboard. (Round your answers to 2 decimal places.) Cost per unit Laptop keyboards 10.03 Desktop keyboards $ 6.72 %24

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter18: Cost-volume-profit Analysis (cvp)

Section: Chapter Questions

Problem 2R: Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where...

See similar textbooks

Similar questions

1.Calculate the missing information. Round dollars to the nearest cent and percents to the nearest tenth of a percent. Item Cost Amount ofMarkup Selling price Percent MarkupBased on Cost Hat $24.75 $30.00 $ % 2.A customer just paid $63.21 for a raincoat. If the percent markup based on cost is 47%, what was the cost (in $)?$ 3.Calculate the missing information. Round dollars to the nearest cent and percents to the nearest tenth of a percent. Item PercentMarkupBased onCost PercentMarkupBased onSelling Price Flashlight % 55% 4.Calculate the missing information. Round dollars to the nearest cent and percents to the nearest tenth of a percent. Item PercentMarkupBased onCost PercentMarkupBased onSelling Price Drill % 42%
Example 14: CVP Analysis Application: For example, sale price of one laptop is $500, sales revenue=500Q; Assume that expense is Y=a+bx=$80,000+300Q. We can draw two lines to assume Horizontal line (X) is the units sold Q and Vertical line (Y) is dollar sales $. We need to draw a graph using this information
A division sold 260000 calculators during 2020: Sales $2600000 Variable costs: Materials $494000 Order processing 195000 Billing labor 143000 Selling expenses 78000 Total variable costs 910000 Fixed costs 1000000 How much is the unit contribution margin? $1.00 $3.50 $7.35 $6.50
he company has these parties of goods on hand: 10x1.000 TL; 20x900 TL; 10x800 TL; 10x700 TL. If 37 items are sold with 20% profit margin (COGS +20% Profit), what is COGS and Sales Revenue in LIFO? a. COGS: 9.400 TL; Sales Revenue: 11.280 TL b. COGS: 33.600 TL; Sales Revenue: 40.320 TL c. COGS: 30.300 TL; Sales Revenue: 36.360 TL d. COGS: 12.700 TL; Sales Revenue: 15.240 TL
Hello! Please help me fill in the blanks in the last empty chart and answer question number 3 at the very end in bold. Thank you! :) UnitsProduced TotalLumberCost TotalUtilitiesCost Total MachineDepreciationCost 7,000 shelves $70,000 $9,550 $135,000 14,000 shelves 140,000 17,600 135,000 28,000 shelves 280,000 33,700 135,000 35,000 shelves 350,000 41,750 135,000 Cost Fixed Portionof Cost Variable Portionof Cost (per Unit) Lumber 0 10 Utilities 1,500 1.15 Depreciation 135,000 0 Question Content Area Units Produced Total Cost January 4,360 units $65,600 February 275 6,250 March 1,000 15,000 April 6,775 136,250 May 1,750 32,500 June 3,015 48,000 1. From the data previously provided, help Biblio Files Company estimate the fixed and variable portions of its total costs using the high-low method. Recall that Total Costs = (Variable Cost Per Unit x Number of Units Produced) + Fixed Cost.…
Use the table mentioned below and calculate the average monthly amount of each 3 drivers. Number of Machine Hours Purchase Orders Moves (Mhr) (PO) July 340 5400 250 Aug. 380 5200 300 Sept. 400 5800 450 Oct. 500 6200 380 Nov. 480 6000 340 Dec. 420 5600 200 Total 2520 34200 1920
Please help me fill in the last 6 cells and the last couple of questions if you can, all in bold! Thank you!! UnitsProduced TotalLumberCost TotalUtilitiesCost Total MachineDepreciationCost 7,000 shelves $70,000 $9,550 $135,000 14,000 shelves 140,000 17,600 135,000 28,000 shelves 280,000 33,700 135,000 35,000 shelves 350,000 41,750 135,000 2. For each cost, determine the fixed portion of the cost, and the per-unit variable cost. If there is no amount or an amount is zero, enter "0". Recall that, for N = Number of Units Produced, Total Costs = (Variable Cost Per Unit x N) + Fixed Cost. Complete the following table with your answers. Round variable portion of cost (per unit) answers to two decimal places. Cost Fixed Portionof Cost Variable Portionof Cost (per Unit) Lumber 0 10 Utilities 1500 1.15 Depreciation 135000 0 Question Content Area High-Low Biblio Files Company is the chief competitor of Cover-to-Cover Company in…
Based on the COA example in the marketing math spreadsheet, how can you purchase 1 paying customer when 1000 page views resulted in only .25 of a paying customer? a. This is an irrelevant concern. b. Because one customer purchases 2000 dollars c. The .25 person number found in the COA example result came from 1000 page views that cost 30 dollars. The cost of acquisition of a paying customer in the example was 120 dollars. This means it required 4000 page views or 4*30 dollars. Consequently, 4000 page views ($120) results in one paying customer 4*.25. d. All are true e. All are false
SEARCH ASK AN EXPERT CHAT MATH SOLVER Question The Variable Cost of Goods Sold in the Marin Company totals P325,000. Fixed selling and administrative expenses totaled P115,000 and variable selling and administrative expenses were P210,000. If Marin Company's contribution margin totaled P590,000, then sales is? Also, What is the effect of this in the company of Marin? a.P650,000 B.Ph 915,000 C.Ph 1,030,000 D.Ph 1,125,000 Topic: Cost Volume Profit Please explain each clearly and solve in good form.
Answer the following 2 questions based on the information in the spreadsheet you created below: Year 1 Year 2 Year 3 Year 4 $ % $ % $ % $ % Net Sales $ 500,000.00 100.00% $ 540,000.00 100.00% $ 577,800.00 100.00% $ 612,468.00 100.00% Cost of goods 265,000.00 53.00% $ 283,500.00 52.50% $ 300,456.00 52.00% $ 321,545.70 52.50% Gross Margin 235,000.00 47.00% $ 256,500.00 47.50% $ 277,344.00 48.00% $ 290,922.30 47.50% Operating expenses 210,000.00 42.00% $ 226,800.00 42.00% $ 245,565.00 42.50% $ 257,236.56 42.00% Operating proft 25,000.00 5.00% $ 29,700.00 5.50% $ 31,779.00 5.50% $ 33,685.74 5.50% 1. What can Mr. Ptolemy do to achieve the gross margin percentage goal set for the third and fourth years? Hint: What factors and elements of a P & L statement affect gross margin %?(List at least 2 things) 2. What efforts should Mr. Ptolemy make in the third and…
Pens cost $0.25 each. Pencils cost $0.10 each. Write an algebraic expression that represents the total cost of buying p pens and n pencils.
32.The following data were related to ABC Corp. COST RETAILInventory, beg 5,000 6,000Purchases 69,000 90,000Freight 6,000Purchase returns 4,000 4,800Net mark-up 8,000Sales 100,000Sales returns 12,000How much is the cost ratio under the FIFO method? (Round in 5 decimal places) 75.23% 76.10% 76.18% 77.85%