We need to prepare a report that will pull information from a
completed work
order. The information we need is the sales price and the actual
production
cost per unit by work order. We want to pull this information into
an exception
report, so we only have to look at the work orders whose gross
margins are
outside of a certain range. We also want to see what the standard
cost and
standard gross margins were supposed to be.
We want to be able to run the report daily or as often as we want.
The report
should be only one line per work order.
Actual Costs Standard Costs
Part number Work order Actual cost Sales price Gross margin
GM % Gross margin GM %
Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217
[Non-text portions of this message have been removed]
completed work
order. The information we need is the sales price and the actual
production
cost per unit by work order. We want to pull this information into
an exception
report, so we only have to look at the work orders whose gross
margins are
outside of a certain range. We also want to see what the standard
cost and
standard gross margins were supposed to be.
We want to be able to run the report daily or as often as we want.
The report
should be only one line per work order.
Actual Costs Standard Costs
Part number Work order Actual cost Sales price Gross margin
GM % Gross margin GM %
Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217
[Non-text portions of this message have been removed]