Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started