I have answered the question below
Please up vote for the same and thanks!!!
Do reach out in the comments for any queries
Answer:
Assignment Exercise 18–3: Target Operating Income Acme Medical Supply Company desires a target operating income amount...
Please open this spreadsheet and compute: (1) The number of
units needed to be sold in order to attain $100,000 in net income.
(2) The number of units needed to be sold in order to break even.
Please submit your response as a spreadsheet. If possible, please
leave any formulas intact so that I can review them.
Show work on excel spreadsheet.
F G H I 2 Acme Medical Supply desires a target operating income amount of $100,000 with the...
Cedar Mills Incorporated desires an operating income of $72,000. Its variable expenses are $20,000 and its total fixed expenses have increased from $32,000 to $60,000. Its unit contribution margin is $10. Its sales in units to achieve the target profit is A. 15,200. B. 11,200 .C. 1,200. D. 13,200.
Exercise 18-12 Computing sales to achieve target income LO C2 Blanchard Company manufactures a single product that sells for $100 per unit and whose total variable costs are 576 per unit. The company's annual fixed costs are $338.400. Management targets an annual pretax income of $600,000. Assume that foxed costs remain at $338,400. (1) Compute the unit sales to earn the target Income Choose Numerator: Choose Denominator: - = Units to Achieve Target Units to achieve target (2) Compute the...
Check my work Exercise 18-12 Computing sales to achieve target income LO C2 Blanchard Company manufactures a single product that sells for $220 per unit and whose total variable costs are $176 per unit The company's annual fixed costs are $664,400. Management targets an annual pretax income of $1,100,000. Assume that fixe costs remain at $664,400. (1) Compute the unit sales to earn the target income. Choose Numerator: Choose Denominator: = Units to Achieve Target Units to achieve target (2)...
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...
APPLY THE CONCEPTS: Target income (number of units sold) Suppose a business has pricing and cost information as follows:: Price and Cost Information Amount Selling Price per Unit $10.00 Variable Cost per Unit $5.00 Total Fixed Cost $100 For the upcoming period, the company wishes to generate operating income of $400. Given the cost and pricing structure for the company’s product, how many units must the company sell to attain its target income? Remember that the basic equation for calculating...
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...
9. Xavier Medical Supply is a retailer of home medical equipment. Last year, Xavier's sales revenues totaled $6,000,000. Total expenses were $2,100,000. Of this amount, approximately $1,500,000 were variable, while the remainder were fixed. Since Xavier's offers thousands of different products, its managers prefer to calculate the breakeven point in terms of sales dollars rather than units. Read the requirements Requirement 1. What is Xavier's current operating income? Begin by identifying the formula to compute the operating income. (1) -...
Units Sold to Break Even, Unit Variable Cost, Unit Manufacturing Cost, Units to Earn Target Income Werner Company produces and sells disposable foil baking pans to retailers for $2.75 per pan. The variable cost per pan is as follows: Direct materials Direct labor $0.37 0.63 Variable factory overhead Variable selling expense 0.53 0.12 Fixed manufacturing cost totals $111,425 per year. Administrative cost (all foxed) totals $48,350. Unless otherwise instructed, round all total doilar figures (eg. sales, total contribution-margin) to the...
The East Company is operating at full capacity and sold 100,000 units at a price of $80 per unit during 2020. Its gross margin (profit) income statement for 2020 is as follows: Sales $8,000,000 Cost of goods sold 4,000,000 Gross profit 4,000,000 Operating expenses: Selling expenses $2,500,000 Administrative expenses 500,000 Total operating expenses 3,000,000 Operating income $1,000,000 The proportion of the above costs between fixed and variable is as follows: Fixed Variable Cost of goods sold $4,000,000 35% 65% Selling...