Question

In: Accounting

Variable Direct Costs Machine Hours Fixed Production Costs Fixed Overhead Costs Units Sold Unit Selling price...

Variable Direct Costs Machine Hours Fixed Production Costs Fixed Overhead Costs Units Sold Unit Selling price Machine Hours per Unit Total Sales Dollars Variable Cost per Unit Total Contribution Dollars Contribution Dollars per Unit Contribution Margin Percentage
Item #1 $65,000 10000 $25,000 $2,000 22500 $10
Item #2 $55,000 20000 $22,000 $2,500 23000 $8
Item #3 $42,000 7500 $15,000 $1,750 27500 $7
Item #4 $27,000 5000 $5,000 $500 11000 $6
Complete the grey cells in the above table
Which product would you recommend increasing market share? Support your answer in 1-2 paragraphs

Solutions

Expert Solution

Variable Direct Costs Machine Hours Fixed Production Costs Fixed Overhead Costs Units Sold Unit Selling price Machine Hours per Unit Total Sales Dollars Variable Cost per Unit Total Contribution Dollars Contribution Dollars per Unit Contribution Margin Percentage Net profit Market share
Item #1 $65,000 10000 $25,000 $2,000 22500 $10 0.44 $225,000 $2.89 $160,000 16000 71.1 $133,000 0.337079
Item #2 $55,000 20000 $22,000 $2,500 23000 $8 0.87 $184,000 $2.39 $129,000 16125 70.11 $104,500 0.275655
Item #3 $42,000 7500 $15,000 $1,750 27500 $7 0.27 $192,500 $1.53 $150,500 21500 78.2 $133,750 0.28839
Item #4 $27,000 5000 $5,000 $500 11000 $6 0.45 $66,000 $2.45 $39,000 6500 59.1 $33,500 0.098876
Total sales $667,500
1
Market share represents the percentage of an industry or market's total sales that is earned by a particular company over a specified time period. Market share is calculated by taking the company's sales over the period and dividing it by the total sales of the industry over the same period. This metric is used to give a general idea of the size of a company in relation to its market and its competitors.
From the above data we can conclude that the market share for ITEM #1 is higher when compared with remaining products, beacause of its higher sales.
We can also see that even thought net profit is lower for item 1 when compared to item 3 it is beacause of its higher fixed costs

Related Solutions

Variable Direct Costs Machine Hours Fixed Production Costs Fixed Overhead Costs Units Sold Unit Selling price...
Variable Direct Costs Machine Hours Fixed Production Costs Fixed Overhead Costs Units Sold Unit Selling price Machine Hours per Unit Total Sales Dollars Variable Cost per Unit Total Contribution Dollars Contribution Dollars per Unit Contribution Margin Percentage Item #1 $65,000 10000 $25,000 $2,000 22500 $10 Item #2 $55,000 20000 $22,000 $2,500 23000 $8 Item #3 $42,000 7500 $15,000 $1,750 27500 $7 Item #4 $27,000 5000 $5,000 $500 11000 $6 Complete the grey cells in the above table Which product would...
The Alphonse Company allocates fixed overhead costs by machine hours and variable overhead costs by direct...
The Alphonse Company allocates fixed overhead costs by machine hours and variable overhead costs by direct labor hours. At the beginning of the year the company expects fixed overhead costs to be $600,000 and variable costs to be $800,000. The expected machine hours are 6,000 and the expected direct labor hours are 80,000. The actual fixed overhead costs are $700,000 and the actual variable overhead costs are $750,000. The actual machine hours during the year are 5,500 and the actual...
if fixed costs are $728,400, the unit selling price is $42, and the unit variable costs...
if fixed costs are $728,400, the unit selling price is $42, and the unit variable costs are $27, what is the break-even sales (units) if target profits are increased by $330,930? A) 26,498 B) 22,062 C) 48,560 D) 70,622 if the contribution margin ratio for 4 Zsons Company is 30%, sales were $843,000 and fixed costs were $113,295, what was the income from operations? A) 252,900 B) 139,605 C) 158,200 D) 377,650 Period Costs: A) are expensed as costs are...
If fixed costs are $247,000, the unit selling price is $116, and the unit variable costs...
If fixed costs are $247,000, the unit selling price is $116, and the unit variable costs are $73, what are the break-even sales in units (rounded to a whole number)?
19) If fixed costs are $274,000, the unit selling price is $124, and the unit variable...
19) If fixed costs are $274,000, the unit selling price is $124, and the unit variable costs are $79, the break-even sales (units) is a.3,468 units b.1,350 units c.6,089 units d.2,210 units 18) Strait Co. manufactures office furniture. During the most productive month of the year, 3,400 desks were manufactured at a total cost of $83,000. In the month of lowest production, the company made 1,140 desks at a cost of $64,400. Using the high-low method of cost estimation, total...
Estimated Fixed Cost Estimated Variable Cost (per unit sold) 2 Production costs: 3 Direct materials —...
Estimated Fixed Cost Estimated Variable Cost (per unit sold) 2 Production costs: 3 Direct materials — $56.00 4 Direct labor — 34.00 5 Factory overhead $188,000.00 20.00 6 Selling expenses: 7 Sales salaries and commissions 102,000.00 6.00 8 Advertising 39,000.00 — 9 Travel 12,000.00 — 10 Miscellaneous selling expense 7,400.00 1.00 11 Administrative expenses: 12 Office and officers’ salaries 141,200.00 — 13 Supplies 8,000.00 2.00 14 Miscellaneous administrative expense 13,600.00 1.00 15 Total $511,200.00 $120.00 It is expected that 21,300...
Steven Company has fixed costs of $239,080. The unit selling price, variable cost per unit, and...
Steven Company has fixed costs of $239,080. The unit selling price, variable cost per unit, and contribution margin per unit for the company's two products are provided below. Product Selling Price per unit Variable Cost per unit Contribution Margin per unit X $1,248 $468 $780 Y 473 253 220 The sales mix for products X and Y is 60% and 40% respectively. Determine the break-even point in units of X and Y combined. Round answer to nearest whole number. units...
Steven Company has fixed costs of $239,080. The unit selling price, variable cost per unit, and...
Steven Company has fixed costs of $239,080. The unit selling price, variable cost per unit, and contribution margin per unit for the company's two products are provided below. Product Selling Price per unit Variable Cost per unit Contribution Margin per unit X $1,248 $468 $780 Y 473 253 220 The sales mix for products X and Y is 60% and 40% respectively. Determine the break-even point in units of X and Y combined. Round answer to nearest whole number. units
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs:...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs: $200,000 Required Each of these are separate situations: What is the break-even point in total sales in dollars? How many units need to be sold to make a profit of $20,000? How many units need to be sold to make a profit of $20,000 if fixed costs increase from $200,000 to $250,000? How many units would they need to sell if they wanted to...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs:...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs: $200,000 Required Each of these are separate situations: What is the break-even point in total sales in dollars? How many units need to be sold to make a profit of $20,000? How many units need to be sold to make a profit of $20,000 if fixed costs increase from $200,000 to $250,000? How many units would they need to sell if they wanted to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT