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

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter16: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 32P: More-Power Company has projected sales of 75,000 regular sanders and 30,000 mini-sanders for next...

See similar textbooks

Similar questions

West Island distributes a single product. The companys sales and expenses for the month of June are shown. Using the information presented, answer these questions: A. What is the break-even point in units sold and dollar sales? B. What is the total contribution margin at the break-even point? C. If West Island wants to earn a profit of $21,000, how many units would they have to sell? D. Prepare a contribution margin income statement that reflects sales necessary to achieve the target profit.
Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
When prices are rising (inflation), which costing method would produce the highest value for gross margin? Choose between first-in, first-out (FIFO); last-in, first-out (LIFO); and weighted average (AVG). Evansville Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming A62 sold just one unit of these goods for $10,000. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
The following is select account information for Sunrise Motors. Sales: $256,400; Sales Returns and Allowances: $34,890; COGS: $120,470; Sales Discounts: $44,760. Given this information, what is the Gross Profit Margin Ratio for Sunrise Motors? (Round to the nearest whole percentage.)
Wallace Industries has total contribution margin of $58,560 and net income of $24,400 for the month of April. Wallace expects sales volume to increase by 5% in May. What are the degree of operating leverage and the expected percent change in income for Wallace Industries? 0.42 and 2.2% 0.42and5% 2.4andl2% 2.Sandl3%
Olivian Company wants to earn 420,000 in net (after-tax) income next year. Its product is priced at 275 per unit. Product costs include: Variable selling expense is 14 per unit; fixed selling and administrative expense totals 290,000. Olivian has a tax rate of 40 percent. Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of 420,000. 2. Calculate the number of units that will yield operating income calculated in Requirement 1 above. (Round to the nearest unit.) 3. Prepare an income statement for Olivian Company for the coming year based on the number of units computed in Requirement 2. 4. What if Olivian had a 35 percent tax rate? Would the units sold to reach a 420,000 target net income be higher or lower than the units calculated in Requirement 3? Calculate the number of units needed at the new tax rate. (Round dollar amounts to the nearest dollar and unit amounts to the nearest unit.)
Faldo Company produces a single product. The projected income statement for the coming year, based on sales of 200,000 units, is as follows: Required: 1. Compute the unit contribution margin and the units that must be sold to break even. Suppose that 30,000 units are sold above the break-even point. What is the profit? 2. Compute the contribution margin ratio and the break-even point in dollars. Suppose that revenues are 200,000 greater than expected. What would the total profit be? 3. Compute the margin of safety in sales revenue. 4. Compute the operating leverage. Compute the new profit level if sales are 20 percent higher than expected. 5. How many units must be sold to earn a profit equal to 10 percent of sales? 6. Assume the income tax rate is 40 percent. How many units must be sold to earn an after-tax profit of 180,000?
(Use information attached) Calculate the total Marginal Income and Net Profit/Loss if all the tables are sold. Use the marginal income ratio to calculate the break-even value. Calculate the new total Marginal Income and Net Profit/Loss, if an increase in advertising expense by R100 000 is expected to increase sales by 400 units. How many units must be sold if the company wishes to earn a net profit of R298 920. Based on the expected sales volume of 2 400 units, determine the sales price per unit (expressedin rands and cents) that will enable the company to break even.
Study the information given below and answer each of the following questions independently:Calculate the total Marginal Income and Net Profit/Loss if all the tables are sold. Use the marginal income ratio to calculate the break-even value.Calculate the new total Marginal Income and Net Profit/Loss, if an increase in advertising expenseby R100 000 is expected to increase sales by 400 units.How many units must be sold if the company wishes to earn a net profit of R298 920.Based on the expected sales volume of 2 400 units, determine the sales price per unit (expressedin rands and cents) that will enable the company to break even.
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?
Given the information in the image below, please help me find the answer to each of the following indepedently:1. Calculate the total Marginal Income and Net Profit/Loss if all the tables are sold.2. Use the marginal income ratio to calculate the break-even value.3.Calculate the new total Marginal Income and Net Profit/Loss, if an increase in advertising expenseby R100 000 is expected to increase sales by 400 units.4. How many units must be sold if the company wishes to earn a net profit of R298 920. 5.Based on the expected sales volume of 2 400 units, determine the sales price per unit (expressedin rands and cents) that will enable the company to break even.
The following is Cullumber Company’s income statement for the past year. Sales revenue $336,000 Cost of goods sold 134,400 Gross margin 201,600 Operating expenses 145,600 Operating income $56,000 If the company wants to sell a new product that costs $49 wholesale while keeping the same markup structure, what will be the price of the new product? (Use the gross margin percentage and round final answer to 2 decimal places, e.g. 25,124.25.) Price of the new product $enter the price of the new product in dollars rounded to 2 decimal places