Answer full question. 2. Suppose that sales are 3% higher as shown below:В1Chapter 1: Applying ExcelData4.Sales2$39,140Variable costs:Cost of goods sold2$25,750Variable selling2$2,5757Variable administrative$43698Fixed costs:9.Fixed selling2$2,50010Fixed administrative$1,50011 Enter this new data into your worksheet. Make sure you enter all of the new data - not just the sales.(a) What is the gross margin now?i Gross marginces(b) What is the net operating income now?Net operating income(c) What is the contribution margin now?Contribution margin

Name: Answer full question. 2. Suppose that sales are 3% higher as shown bel
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: Answer full question. 2. Suppose that sales are 3% higher as shown below:В1Chapter 1: Applying ExcelData4.Sales2$39,140Variable costs:Cost of goods sold2$25,750Variable selling2$2,5757Variable administrative$43698Fixed costs:9.Fixed selling2$2,50010F

Solution Concept mathematically Gross margin = sales – cost of goods sold Net operating income…

Answered: a) What is the gross margin now? Gross…

Business

Accounting

a) What is the gross margin now? Gross margin b) What is the net operating income now? Net operating income c) What is the contribution margin now? Contribution margin

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 87PSB

See similar textbooks

Similar questions

vi) If cost of goods sold increases 20%, fixed selling expense decreases RM10,000 and selling price decreases 10%, calculate the profit/loss for DSRSB. (CLO3, C4) vii) Calculate the additional sales volume required to meet RM 10,500 additional administrative expenses to maintain the original profit. (CLO3, C4)
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
Given the following information:SalesFixed ExpensesVariable Expensess5,0002,0001,750What would expected operating profit be if the company experienced a 10% increase in fixedcosts and a 100/0 increase m sales volume? a) $1,375. b) $1,550. c) $1,250. d) $1,750.
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…
Consider the following information for a given business. Sale revenue =GHS40,000 VC per unit =GHS20 Activity level =1,000 to break even Required: 1. Determine the TFC 2. Express the contribution as a percentage of sale. 3. The company plans to sale 1,500 unit in the next period. What will be the percentage margin of safety (MoS) 4. What margin should the business employ for planning purposes? 5. What total profit should the business expect in order to achieve it's planned sales?
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%
As a costing team member, calculate the gross profit if: Sales P6,000; Cost of Sales P5,000; Beginning Inventory P1,000; Purchases P4,000; Wages P2,000; and Office Rent P1,000?a. Loss = P2,500b. Loss = P1,500c. Profit = P2,500d. Profit = P1,000
A business determines selling price by adding a mark-up of 30% to cost. The profit earned on a product with a selling price of £390 will be: a) £300 b) £117 c) £210 d) £90
Please answer quicklyX product; total sales quantity is 25, unit sales price is 1600 TL, unit variable expense is 1000 TL. (Total fixed expenses 120.000TL)What is the 'break-even point' of X according to uniform production? 2310143019
A company produces and sells the following quantites of a product: Date Number of tons Total CostsJuly 1 Opening Inventory 10 P200 4 Production 8 176 6 Sale 9 15 Production 6 144 18 Sale 11 23 Production 4 104 Question:Which statement is true? A. Cost of goods sold using FIFO is higher than cost of goods sold using weighted average. B. Profit using FIFO is higher than profit using weighted average. C. Total assets at July 31 is higher using weighted average than total assets using FIFO. D. Profit is not affected by the costing method used to measure inventory.
P8.6 (LO 3) (Compute FIFO, LIFO, Average-Cost—Periodic and Perpetual) Ehlo Company is a multi product firm. Presented below is information concerning one of its products, the Hawkeye.Date Transaction Quantity Price/Cost1/1 Beginning inventory 1,000 $122/4 Purchase 2,000 182/20 Sale 2,500 304/2 Purchase 3,000 2311/4 Sale 2,200 33Instructions Compute ending inventory AND cost of goods sold, assuming Ehlo uses: a. Periodic system, FIFO cost flow. b. Perpetual system, FIFO cost flow. c. Periodic system, LIFO cost flow. d. Perpetual system, LIFO cost flow. e. Periodic system, weighted-average cost flow. f. Perpetual system,…
7. I do not understand how to find the dollar amounts for these questions with the numbers given: Compute the $ based on these percentages Net Sales $46,710Gross Profit: $21,479Net Income: $6,046Total Selling and Administrative Expense: $14, 804 a)Cost of Goods 54.0% = $ Amountb)Gross Margin Percentage 46.0% = $ Amountc)SG&A Expense Percentage 31.7% = $ Amountd)Operating Profit Margin Percentage 14.2% = $ Amounte) Net Profit Margin (After Taxes) 12.9% = $ Amount If you could provide the formulas used it would be a big help, again the percents are already there I need to find the dollar amount the percents reflect.