@ 88% .. STAY HOME 10:16 PM Reader View Available Part II AlQuds sales company is interested I developing a financial planning model.it intends to begin with a very simple overall model and then progress to a more detailed and complex Version Upon analyzing the basic financial trends and relationships they discovered the following: Sales have increased by about 10% cach year for the past several years - The contribution margin percentage has remained rather constant at - Fixed expenses (selling. Administrative, and financial) o 20% of sales for the first 6 months of current year Administrative expenses remained constant Financial expenses averaged 15% of outstanding debt Taxes have averaged 18% of net profit before tax Required: A) Construct a financial planning model that generates the expected sales.contribution margin, total expenses, et profit after tax for a standard planning period (the coming year) B) If current year information is as follows Actual sales for the first six months $1,000,000 Estimated sales second months 900.000 Administrative expenses 217.000 Average outstanding debt 800,000 Uses your model to calculate the expected sales, contribution margin, total expenses, and net profit after tax