Using the Profit data develop a two-way Data Table that calculates the profit using labor cost...

Transcribed Image Text:

Using the Profit data develop a two-way Data Table that calculates the profit using labor cost per item ranging from $5 to $7 with $0.2 increments and quantity from 1500 to 2500 units with 100-unit increments. Assumptions: Fixed cost: Material costs per item: Labor costs per item: Shipping costs per 100 items: Price per item: Quantity: Outputs: Total revenue: Total costs: Total profit: $ $ 69 69 69 69 5,000.00 2.25 6.50 200.00 12.99 Using the Profit data develop a two-way Data Table that calculates the profit using labor cost per item ranging from $5 to $7 with $0.2 increments and quantity from 1500 to 2500 units with 100-unit increments. Assumptions: Fixed cost: Material costs per item: Labor costs per item: Shipping costs per 100 items: Price per item: Quantity: Outputs: Total revenue: Total costs: Total profit: $ $ 69 69 69 69 5,000.00 2.25 6.50 200.00 12.99