Broadband Case Study LKV Company is a new firm which won a Pan India broadband spectrum in the recently concluded broadband spectrum auction. The Company decided that the market roll out will be done in a phased manner. The company decided to set up the I.T infrastructure and implement a software solution to facilitate the roll out. The Customer Service department will be interfacing with the customer. Each customer should be registered in the system with a unique id. The system should be able to make a record of personal details like name, age, sex, DOB, Address etc. The company has two delivery models- wireless and wired. Prepaid and postpaid options are available in both categories. The prepaid plans for wired and wireless are given below Prepaid Plan Wireless Usage Limit Price Validity 500 MB 500 rs 30 days 600 MB 550 rs 30 days 800 MB 900 rs 45 days 1 GB 1200 rs 45 days 2 GB 1500 rs 45 days 5GB 2200 rs 60 days Unlimited 2500 rs 30 days Post Paid Plan -Wireless Speed Rate 128 kbps rs 10 per MB 256 kbps rs 18 per MB 512 kbps rs 22 per MB 1024 kbps rs 28 per MB Prepaid Plan-Wired Speed Rate 128 kbps rs 10 per MB 256 kbps rs 18 per MB 512 kbps rs 22 per MB 1024 kbps rs 28 per MB Post Paid Plan-Wired Speed Rate 128 kbps rs 6 per MB 256 kbps rs 8 per MB 512 kbps rs 9 per MB 1024 kbps rs 10 per MB There is a state government levy of 12.37% on the total billing amount as VAT For all connections, there is an instrument cost of 2000rs (non refundable) which is levied at the time of customer registration. For wired connections, there is an additional charge of 1200 towards installation cost. For all postpaid connections the billing is done on 20th of very month. The payment has to be made within 10 days; else a fine of 10% of the bill amount is levied as late payment charges. Prepaid customers are free to recharge anytime. Once the payment is received, a receipt should be generated. The customer can switch between prepaid/postpaid and also change the plans. The customer can call anytime to en-quire about his details validity date, usage, validity expiry (in case of prepaid customer). The application should be able to provide these details to the customer fairly quickly. The Customer Service department should also be able to generate reports on 1) Number of customers - plan wise , delivery model wise ,age group wise 2) Revenue generated plan wise / delivery model wise on weekly/monthly/yearly basis 3) Number of customers who had switched between different plans The teams are encouraged to incorporate as much reporting options as possible and not just restrict to the options mentioned above.