Create a excel worksheet that displays a differential analysis addressing a "sell or process further" problem. The following iformation is provided: Data set: Inputs: Total cost(s) to selling point $4 per unit Sales price without further processing $7 per unit Total cost(s) if processed further $7 per unit Sales price if processed further $11 per unit Check figure: Differential Income if processed further $1 per unit All data, both input and output, will be in per unit amounts. The input data will consist of: Sales price per unit before processing further Cost per unit before further processing Cost per unit of additional processing Sales price per unit after additional processing The output data (the data computed and displayed by your template) will consist of (at minimum): The differential revenue of processing further The differential cost of processing further The differential income of processing further
Create a excel worksheet that displays a differential analysis addressing a "sell or process further" problem. The following iformation is provided:
Data set:
Inputs:
Total cost(s) to selling point $4 per unit
Sales price without further processing $7 per unit
Total cost(s) if processed further $7 per unit
Sales price if processed further $11 per unit
Check figure:
Differential Income if processed further $1 per unit
All data, both input and output, will be in per unit amounts. The input data will consist of:
- Sales price per unit before processing further
- Cost per unit before further processing
- Cost per unit of additional processing
- Sales price per unit after additional processing
The output data (the data computed and displayed by your template) will consist of (at minimum):
- The differential revenue of processing further
- The differential cost of processing further
- The differential income of processing further
Step by step
Solved in 3 steps with 2 images