Given the constant profit margin of 25%, determine the primary or net income for each SKU. Type your answers below.Note: 5th column is for RETURNS FROM CUSTOMERS due to product damages and defects.SKUSQUANTITYSELLINGRETURNSNETSOLDPRICEFROMINCOME1SPRITE 2L6795.004SPRITE 1.5LSPRITE 1LSPRITE 500MLSPRITE 355ML CANCBTL COFFEE MOCHA 3-in-1NESCAFE MOCHA LATTE 3-in-1SAN MIG SUGAR FREE COFFEE 3-in-1SWISS MISS DARK COCOA MIX 3-in-110 SWISS MISS MALLOWS COCOA MIX 3-in-1210170.00735950.0044525.007025.0034230.00275515.00389010.0059.3514.0015912.004

Net sales = Quantity sold - Returns from customers Net income = Net sales x Selling price x Profit…

Given the constant profit margin of 25%, determine the primary or net income for each SKU. Type your answers below. Note: 5th column is for RETURNS FROM CUSTOMERS due to product damages and defects. SKUS QUANTITY SELLING RETURNS NET SOLD PRICE FROM INCOME 4 SPRITE 2L SPRITE 1.5L SPRITE 1L SPRITE 500ML SPRITE 355ML CAN CBTL COFFEE MOCHA 3-in-1 NESCAFE MOCHA LATTE 3-in-1 1 67 95.00 2 101 70.00 7 59 50.00 4 45 25.00 1 70 25.00 3 6. 42 30.00 7 55 15.00 8 SAN MIG SUGAR FREE COFFEE 3-in-1 90 10.00 9. SWISS MISS DARK COCOA MIX 3-in-1 35 14.00 1 10 SWISS MISS MALLOWS COCOA MIX 3-in-1 59 12.00 4

Given the constant profit margin of 25%, determine the primary or net income for each SKU. Type your answers below. Note: 5th column is for RETURNS FROM CUSTOMERS due to product damages and defects. SKUS QUANTITY SELLING RETURNS NET SOLD PRICE FROM INCOME 4 SPRITE 2L SPRITE 1.5L SPRITE 1L SPRITE 500ML SPRITE 355ML CAN CBTL COFFEE MOCHA 3-in-1 NESCAFE MOCHA LATTE 3-in-1 1 67 95.00 2 101 70.00 7 59 50.00 4 45 25.00 1 70 25.00 3 6. 42 30.00 7 55 15.00 8 SAN MIG SUGAR FREE COFFEE 3-in-1 90 10.00 9. SWISS MISS DARK COCOA MIX 3-in-1 35 14.00 1 10 SWISS MISS MALLOWS COCOA MIX 3-in-1 59 12.00 4

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

Cleveland Foods Data Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 12 (1 point) □ What is the unit contribution of BlueLiq, considering the given information? $0.70 $2.50 $ 1.00 $1.70 $ $ J 0 20% Retail Margin 2.50 Price to consumers (Retail Price) 15% Wholesale Margin 2.00 Price to retailers (Wholesale Price) $ 1.70 Price to Wholesalers Variable Costs $ 0.70 per unit Fixed Costs Variable Manufacturing Costs $300,000 annual $200,000 Corporate Overhead $250,000 Marketing and Advertising $750,000 Total Fixed Costs Cleveland Foods Data Fixed Manufacturing Costs Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 11 (1 point). Listen 4 What is the price at which Cleveland Foods sells BlueLiq to wholesalers? $1.70 $2.50 $1.00
Type the formulas to calculate the following: In cell B9, calculate the grand total amount owing for all customers. In ce E KBC DFGHJ1 Cost Retail 2 Mussels R12,40 R21, 70 3 Crabs R25, 60 R44,804 Markup % 75,0% 5 Discount % 8,5% EFT 6 VAT % 15 89 Total Sales 10 Cost of Sales 11 Profit or Loss No of 12 Customers No of Crab 13 Customers Sales of Mussel 14 Customers 15 Can
Download and fill out the Section 5 Comprehensive Problem Template attached below to complete the problems (ignore question 5-2 as this applies to the "combined accounting and finance" course). Problem 5-1 Redlands Inc. sells one product for $5. The variable cost per item is $3, and the fixed costs for the firm are $40. Required: a. Compute the breakeven point in units. b. Compute the number of units and sales revenue needed to achieve a $20 profit. (Ignore income taxes.) c. Assume that the income tax rate for Redlands is 40%. Compute the number of units and sales revenue needed to achieve an $18 net profit. d. Compute the number of units and sales revenue needed to achieve an 8% profit margin. (Ignore income taxes.) e. Compute the number of units and sales revenue needed to achieve a 12% net profit margin. (Assume a 40% income tax rate.) f. Assume that Redlands currently sells 40 units. Redlands estimates that if it increased sales price to $6 per unit demand would decrease by…
1. Use vertical analysis to compare profitability. 区日 Perform Vertical Analysis - Excel FILE НОМE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A % Paste BIU- Alignment Number Conditional Format as Cell Cells Formatting - Table Styles - Clipboard E Font Styles A1 fx Lake Athletics sells two distinct product lines: Apparel and Equipment. В C D E F 1 Lake Athletics sells two distinct product lines: Apparel and Equipment. 2 The income statement for each product line appears below. 3 4 LAKE ATHLETICS Income Statement For the Year Ended December 31, 20X1 7 Apparel Equipment 8 Amount Percent Amount Percent 9 Net sales $3,150,000 1,400,000 $5,550,000 2,720,000 2,830,000 10 Cost of goods sold 11 Gross profit 12 Operating expenses 13 Operating income 1,750,000 800,000 950,000 875,000 1,955,000 14 Other income 20,000 10,000 15 Income before tax 1,965,000 491,000 970,000 16 Income tax expense 241,250 $728,750 17 Net income $1,474,750 18 19 Required: 20 1. Use appropriate…
Jordan Cameras, Incorporated manufactures two models of cameras. Model ZM has a zoom lens; Model DS has a fixed lens. Jordan uses an activity-based costing system. The following are the relevant cost data for the previous month: Direct Cost per Unit Direct materials Direct labor Category Unit level Batch level Product level Facility level Total Estimated Cost $ 25,960 49,920 90,000 180,000 $ 345,880 Model ZM $ 20.70 29.40 Cost Driver Model DS $7.00 9.00 Number of units Number of setups Number of TV commercials Number of machine hours Amount of Cost Driver ZM: 2,500 units; DS: 9,300 units ZM: 26 setups; DS: 26 setups ZM: 14; DS: 11 ZM: 300 hours; DS: 600 hours Jordan's facility has the capacity to operate 2,700 machine hours per month. Required a. Compute the cost per unit for each product. b. The current market price for products comparable to Model ZM is $118 and for DS is $68. If Jordan sold all of its products at the market prices, what was its profit or loss for the previous month?…
Click Submit to complete this assessment. Question 4 When the gross profit percentage of costs is 32%, the gross profit percentage of sales is equal to: O 24.24% 30.07% O 26.78% O 28.65% A Click Submit to complete this assessment. O Type here to search a
Need detail explanation Test your template for 15,000 units sales volume to see if you get the same income as stated above ** attached image
e 1 of 16)- Google Chrome om/mod/quiz/attempt.php?attempt3D1893419&cmid%3891193 NG SYSTEM (ACADEMIC) erial Accounting - Spring21 %3 Time left 1:58:1 Company XYZ has three products A, B and C. The sales mix for products A, B and C are 7,5 and 4 units respectively. The contribution margin per unit for products A, B and C are $900, $600 and $400 respectively. Assuming that the fixed costs were $2,272,000. What is the breakeven point in units (in total)? (rounded to the nearest number) O a. None of the given answers O b. 1,641 O c. 6,745 O d. 3,335 O e. 800 The contribution margin ratio is 50%. If total fixed costs are $21.000, then what is the total cost ($) of producing and
igmeniMalh.do?invoker=&takeAssignmentSessionLocator=&inprogress%3Dfalse Show Me How Print Item eBook Contribution Margin and Contribution Margin Ratio For a recent year, McDonald's (MCD) company-owned restaurants had the following sales and expenses (in millions): Sales $15,295.0 Food and packaging $(4,896.9) Payroll (4,134.2) Occupancy (rent, depreciation, etc.) (3,667.7) General, selling, and administrative expenses (2,384.5) $(15,083.3) Operating income $211.7 Assume that the variable costs consist of food and packaging, payroll, and 40% of the general, selling, and administrative expenses. a. What is McDonald's contribution margin? Round to the nearest tenth of a million (one decimal place). million b. What is McDonald's contribution margin ratio? Round to one decimal place. % c. How much would operating income increase if same-store sales increased by $800 million for the coming year, with no change in the contribution margin ratio or fixed costs? Round your answer to the nearest…
chapter 3 3. Given the information below, what is the profit dollars? Round your answer to the dollar and add a dollar sign and comma separator (i.e. $15,467) Gross Sales $341,420 Customer Returns 29,870 Cost of Goods Sold 161,570 Expenses 138,140
e| MyUSF A My Home CengageNOWv2|Online teachir x engagenow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker-&takeAssignmentSessionLocator=&inpro. to Product J is one of the many products manufactured and sold by Oceanside Company. An income statement by product line for the past year indicated a net profit for Product J of $2,750. This net profit resulted from sales of $275,000, cost of goods sold of $186,500, and operating expenses of $85,750. It is estimated that 30% of the cost of goods sold represents fixed factory overhead costs and that 40% of the operating expense is fixed. If Product J is retained, the revenue, costs, and expenses are not expected to change significantly from those of the current year. Because of the large number of products manufactured, the total fixed costs and expenses are not expected to decline significantly if Product J is discontinued. Prepare a differential analysis report dated February 8 of the current year. If an amount is zero, enter "0". If…
Example-4 Open with Google Slides The Garware Paints Ltd presents to you the following income statement in a condensed form for the first quarter ending March 31: Particulars Sales Variable costs Contribution Fixed costs Net income P/V ratio Break-even sales Sales-mix (per cent) X Rs 1,00,000 80,000 20,000 0.20 0.50 Product Y Rs 60,000 42,000 hy 18,000 0.30 0.30 Z Rs 40,000 24,000 16,000 0.40 0.20 Total Rs 2,00,000 1,46,000 54,000 27,000 27,000 0.27 1,00,000 100 Determine the Break-even point for the firm. □ How many units of each product X, Y and Z need to be sold in order to achieve the Break-even, given the selling price of Rs. 10, 15 and 5 respectively? Assumption: Sales Mix remains Constant