Grade 41/50
grade 41/50excel -6discussion -3Requirements: In an Excel Spreadsheet:Develop a Profit/Loss model:The End Inventory of a month can and has fell below 500 units because of the constant Production of 6000 units and the constant increase in the amount of units that is sold each month which will cause the End Inventory to fall below the 500 units mark. (Graph in Excel Spreadsheet named ”Profit_Loss Model 1.A”).When the profit drops below $25,000 it is due to the fact that the costs are weightier than the other months. Another reason why the Profit may have been under $25k is due to the constant revenue of $60.5k which allowed the Costs to allow the profit to drop below $25k. (Graph in Excel Spreadsheet named ”Profit_Loss Model 1.B”)COUNTIF Cell of Original Spread sheet the formula is “=(COUNTIF(B43:M43,"<25000"))+(COUNTIF(B26:M26,"<500")).”I suggest not to increase the price of the the products per unit, this is because as seen from the What-IF tab, profits will drop in the negatives. Due to the amount of sales that has dropped due to the increase in the sale price. problem due to inventory build up!!!grade =-2The main factor that should consider is the fact that they are purchasing a company that is supported by one product and any change in the sale price could have detrimental effects that may change the sales figures completely.Their IT structure, Their SCM, CRM systems, are they compatible with ours?Their sales and web presenceTransportation costs since spices will have to be transported from IndiaQuality controlInternational lawsAny antitrust problemsPolitical situation among countriesgrade=-1 ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.