Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

19. Benicio has already calculated that the gross profit for the new product could be nearly $295,000 based on a unit price of $159.99 and

image text in transcribed

image text in transcribed

19. Benicio has already calculated that the gross profit for the new product could be nearly $295,000 based on a unit price of $159.99 and unit sales of 22,000. He wants to see how the gross profit changes if the price or unit sales are different. Create a two-variable data table as follows to calculate gross profit as the price and unit sales change: For the range D4:K9, create a two-variable data table using the price per unit (cell B6) as the Row input cell. Use the units sold (cell B5) as the Column input cell. thor =B16 B11 A B E F G H K Ew Product Virtual Assistant Virtual Assistant: Gross Profit Analysis $ 129.99 $ 139.99 $ 149.99 $ 159.99 $ 169.99 $ 179.99 $ 189.99 nit 22.000 $ 159.99 $3,519,780.00 $ 294,2130.00 18,000 20,000 22,000 24,000 26,000 es $ penses aufactured cost per unit able costs ses d cost 22,000 135.00 2.970,000.00 $ $ 255,000.00 $3,225,000.00 $ 146.59 enses pense per unit sold $ les penses profit $ $ 3,519,780.00 3,225,000.00 294,780.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

Students also viewed these Finance questions