Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. Create a two-variable data table in D15:123 to calculate the net income for units sold from 25,000 to 150,000 units in increments of 25,000

image text in transcribed
4. Create a two-variable data table in D15:123 to calculate the net income for units sold from 25,000 to 150,000 units in increments of 25,000 with sales prices of $180 up to $200 in increments of $5. See results below. Net Income Analysis Price per Unit Units Sold $180 $185 S $190 $195 $200 25,000 $1,178,052,50) ($1,053,052.50) ($928,052.50) (5803,052,50) ($678,052.50) 50,000 $496,105.00)_($246,105.00) $3,895.00 $253,895.00 $503,895.00 75,000 $185,842.50 $560,842.50 $935,842.50 $1,310,842.50 $1,685,842.50 100,000 $867,790.00 $1,367,790.00 $1,867, 790.00 $2,367,790.00 $2,867,790.00 125,000 $1,549,737.50 $2,174,737.50 $2,799,737.50 $3,424,737.50 $4,049,737.50 150,000 $2,231,685.00 $2,981,685,00 $3,731,685.00 $4,481,685.00 $5,231,685.00 4. Create a two-variable data table in D15:123 to calculate the net income for units sold from 25,000 to 150,000 units in increments of 25,000 with sales prices of $180 up to $200 in increments of $5. See results below. Net Income Analysis Price per Unit Units Sold $180 $185 S $190 $195 $200 25,000 $1,178,052,50) ($1,053,052.50) ($928,052.50) (5803,052,50) ($678,052.50) 50,000 $496,105.00)_($246,105.00) $3,895.00 $253,895.00 $503,895.00 75,000 $185,842.50 $560,842.50 $935,842.50 $1,310,842.50 $1,685,842.50 100,000 $867,790.00 $1,367,790.00 $1,867, 790.00 $2,367,790.00 $2,867,790.00 125,000 $1,549,737.50 $2,174,737.50 $2,799,737.50 $3,424,737.50 $4,049,737.50 150,000 $2,231,685.00 $2,981,685,00 $3,731,685.00 $4,481,685.00 $5,231,685.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Grade Energy Audit Making Smart Energy Choices

Authors: Shirley J. Hansen, James W. Brown

1st Edition

0824709284, 978-0824709280

More Books

Students also viewed these Accounting questions