Define range names for all the entities in the Crebo Manufacturing Model spreadsheet and apply them to the formula in the model

 

Transcribed Image Text:

Crebo Manufacturing Model Product Gross margin/unit Minutes/unit Gross margin/minute Maximum production Profit Plugs (X1) $0.30 1 $0.30 Rails (X2) $1.30 2.5 $0.52 Rivets (X3) Clips (X4) $0.75 1.5 $0.50 280,000.00 112,000.00 186,666.67 $84,000 $145,600 $140,000 $1.20 2 $0.60 140,000.00 $168,000 Machine Capacity 280,000 Crebo Manufacturing Model Product Gross margin/unit Minutes/unit Gross margin/minute Maximum production Profit Plugs (X1) $0.30 1 $0.30 Rails (X2) $1.30 2.5 $0.52 Rivets (X3) Clips (X4) $0.75 1.5 $0.50 280,000.00 112,000.00 186,666.67 $84,000 $145,600 $140,000 $1.20 2 $0.60 140,000.00 $168,000 Machine Capacity 280,000

Answer rating: 100% (QA)

The Range names for tthe respective Table will be as under Starting with the First G... View the full answer