Application of financial and break-even analysis to a scenario Essay

Fiscal Plan and Break-Even AnalysisNameCourse Name and NumberProfessorDate of SubmissionBreak-Even Analysis

Break Down Computation for 6 Calendar months Ended June 2013
In Dollars Unit of measurements Per Unit In Percentage
Gross saless ( invoiced ) $ 562,500.00 8500 $ 66.18* 100 %
Variable Cost $ 84,170.00 8500 $ 9.90 14.96 %
Contribution Margin $ 478,330.00 8500 $ 56.

28

85.04 %
Fixed Cost $ 35,363.00
Net Income $ 442,967.00

In calculation of the Break-Even Point, there are two results that require analysis. These are the Break-Even Gross saless in Unit of measurements or Volume and Break-Even Gross saless in Dollars.

In Figure 1, the sums listed are derived from Net income and Loss Forecast subdivision of the excel file. All sums are prognosiss from January to June of 2013 including estimated set-up costs.Figure 1. Interrupt Down Computation for 6 Calendar months Ended June*Sales Price per Unit= Original Price x ( 100 % + Mark-Up Percentage )= $ 57.55 x 1.15=$ 66.18

Fixed Costss
Wages and rewards $ 18,000.00 Repairs and care $ 240.

00

Ad $ 1,200.00 Marketing study $ 300.00
Rent $ 1,800.00 Design and testing $ 400.00
Equipment hire/lease $ 5,000.00 Patents $ 150.00
Depreciation $ 100.00 Copyright enrollment $ 120.

00

Electricity and gas $ 1,000.00 Recruitment and choice $ 200.00
Insurance $ 1,200.00 Water measures $ 200.00
Legal fees $ 300.00 Construction $ 3,000.00
Transport/courier costs $ 540.

00

Office set up $ 1,000.00
Postage, telephone and facsimile $ 190.00 Distribution $ 264.00
Stationery $ 159.

00

Entire Fixed Cost $ 35,363.00

Figure 2. Composition of Entire Fixed CostssThe company incurred entire fixed costs of $ 35,363.00 for its iScent Alarm Clocks from January to June of 2013. Variable cost is $ 9.

9 per unit which is 14.96 % of the gross revenues monetary value per unit. The iScent Alarm Clock has an original monetary value of $ 57.55. Given the proposed mark-up monetary value of 15 % , the new monetary value of iScent Alarm Clock is $ 66.18 per unit. Hence, the company will sell an iScent Alarm Clock for $ 57.

55 for retail merchants and jobbers while $ 66.18 for every individual purchase of clients. Furthermore, the mark-up per centum of 15 % can cover unforeseen or unanticipated product-related costs that may originate in future. Using informations provided in Figure 1, below is the calculation of break-even point in units and in dollars.

Break-Even Point in Units = Entire Fixed Cost
Gross saless Price per Unit – Variable Cost Per Unit
Break-Even Point in Units = $ 35,363.00
$ 66.

18 – $ 9.9

Break-Even Point in Units = 628.34 units
Break-Even Point in Dollars = $ 41,583.57
( $ 628.34 units x $ 66.18 )

Figure 3. Break-Even Point CalculationIn Figure 3, the break-even points are 628.34 units and $ 41,583.

57. It means that the company must sell 628.34 units of iScent Alarm Clock within six months to retrieve the cost of bring forthing those alarm redstem storksbills or to merely break-even. To farther explain ; if the company produced and sold 628.34 pieces of iScent Alarm Clock, each of these units will cover the fringy or variable costs of $ 84,170.00 every bit good as all associated fixed costs of $ 35,363.00. If the company sells 628.

34 iScent Alarm Clocks, so it will non see a loss. Upon selling more than 628.34 units, all fixed costs have been settled, and each unit contributes to net incomes by the part border. Hence, if the company sells more than 628.34 units, it will be considered as income for the company.

The Break-Even Point in Dollars of $ 41,583.57 is merely the monetary value of 628.34 units when sold.

Unit of measurements Gross saless Gross Variable Cost Contribution Margin Fixed Cost Entire Cost Net Income
100 6618 990 5628 35,363.00 36,353.00 -29,735.

00

200 13236 1980 11256 35,363.00 37,343.00 -24,107.00
300 19854 2970 16884 35,363.00 38,333.

00

-18,479.00
400 26472 3960 22512 35,363.00 39,323.00 -12,851.

00

500 33090 4950 28140 35,363.00 40,313.00 -7,223.00
600 39708 5940 33768 35,363.00 41,303.00 -1,595.00
628.

34

41583.541 6220.566 35363 35,363.00 41,583.

57

0.0
700 46326 6930 39396 35,363.00 42,293.00 4,033.00
800 52944 7920 45024 35,363.

00

43,283.00 9,661.00
900 59562 8910 50652 35,363.00 44,273.00 15,289.00
1000 66180 9900 56280 35,363.

00

45,263.00 20,917.00

Figure 4. Tabulation of Gross saless Revenue, Variable Cost, Contribution Margin, Fixed Cost, Total Cost and Net Income""Current Assetss Current Liabilitiess Cash in bank $ 307,751.00 Histories collectible $ 33,120 Histories receivable $ 61,430.00 Interest payable 6,700 Inventory $ 42,100.00 Taxs collectible 3,200 Prepaid disbursals $ 400.00 Notes, short-run ( due within 12 months ) 20,000 Other current assets 1,350 Current portion, long-run debt 12,000 Entire Current Assets $ 413,031 Other current liabilities 1,4