Smithen Company, a wholesale distributor, has been operating for only a few months. The company sells three products-sinks. mirrors, and vanities. Budgeted sales by product and in total for the coming month are shown below based on planned unit sales as follows: Sinks Mirrors Vanities Total Percentage of total sales Sales Variable expenses Contribution margin Contribution margin per unit Fixed expenses Operating income Units 1,000 500 500 2,900 Break-even point in unit sales: Break-even point in sales dollars. Total Fixed expenses Weighted-average CM per unit Percentage 50% 25% 25% 100% Percentage of total sales Operating income (loss) Sinks *($198.00 x 0.50) + ($102.00 x 8.25) + ($288.00 Break-even point in sales dollars 48% $ Break-even point in unit sales $276,000 100.00% $115,000 100.00% $184,000 100.00% $575,000 100.00% 78,000 43.48% 198,458 34.51% $198,000 56.52% 376,550 65.49% $198.00 28.26% 64,000 71.74% $ 51,000 55.65% 80,000 44.35% $104,000 $ 208.00 $ 102.00 Sinks Product Mirrors 20% Fixed expenses Overall CM ratio $338,650 $176.50* 0.00 8.25) As shown by these data, operating income is budgeted at $37.900 for the month, break-even sales dollars at $517,125.88, and break- even unit sales at 1,918.70. % Assume that actual sales for the month total $579,600 (2,100 units), with the CM ratio and per unit amounts the same as budgeted. Actual fixed expenses are the same as budgeted, $338.650. Actual sales by product are as follows: sinks, $144,900 (525 units): mirrors, $241,500 (1,050 units); and vanities, $193,200 (525 units). Required: 1. Prepare a contribution format income statement for the month based on actual sales data. (Round your answers to 2 decimal places.) M Vanities 32% = 1,918.70 units % % 0.00 % $ $338,650 0.65 Mirrors SMITHEN COMPANY Contribution Margin Income Statement Product 0.00 % Total 100% 338,650 $ 37,900 % 96 0.00 % = $517,125.88 $ Vanities 0.00 %6 %6 2. Compute the break-even point in sales dollars for the month, based on the actual data. (Round your percentage answers to nearest whole percent. Round other intermediate values and final answer to the nearest whole dollar.) 0.00 % $ 3. Calculate the break-even point in unit sales for the month, based on the actual data. (Do not round your Intermediate calculations. Round your final answer to the nearest whole number.) Total 0.00 0.00 %6 *** 96 0.00 %
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Step by step
Solved in 2 steps with 4 images