Question: How can I get the margin realized? The following table reflects the results of a computer company for the year 2010. The company's target is
The following table reflects the results of a computer company for the year 2010. The company's target is to achieve a gross profit per product of more than $ 5000, and a realized margin of more than 15%. Only if both targets are realized, the operating result can be characterised as good, in all other cases as bad. Create this model in a worksheet. Formulas should be used for the determination of the gross profit, the margin and the result. If the gross profit and margin targets will be changed then result should be adjusted
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
