Budget Planning for the year 2012-13 1. Estimated Number of units sold = 20000 2. Whole sale price = Rs 7999 3. Base unit cost = Rs 4000 4. Gross sales (1*2) = Rs 159.9 million 5. Cost of goods sold (1*3) =Rs 80 million 6. Gross margin (4-5) = Rs 79.9 million
Expenses 1. Advertising = Rs 80 million 2. Sales promotion = Rs 20 million 3. R&D costs = Rs 100 million 4. Customer service = Rs 10 million 5. Sales force salary = Rs 20 million
Total expenses = Rs 230 million
Net Profit or Loss = Gross margin – Total Expenses = (Rs 150.1 million) [ Loss]
Budget Planning for the year 2013-14 7. Estimated Number of units sold = 28000 [CAGR = 40% ] 8. Whole sale price = Rs 7999 9. Base unit cost =4000 10. Gross sales (1*2) = Rs 223.7 million 11. Cost of goods sold (1*3) = Rs 112 million 12. Gross margin (4-5) = Rs 111.7 million
Expenses 6. Advertising = Rs 50 million 7. Sales promotion = Rs 20 million 8. R&D costs = Rs 80 million 9. Customer service = Rs 10 million 10.