Question: An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named Unit_Price based on the heading in cell A2). A
An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named Unit_Price based on the heading in cell A2).
| A | B | |
| 1 | ||
| 2 | Unit Price | 11 |
| 3 | Unit Cost | 5.55 |
| 4 | Unit Gross Profit | Unit_Price - Unit_Cost |
| 5 | ||
| 6 | Quantity Sold | 5,600 |
| 7 | ||
| 8 | Gross Revenue | = Quantity_Sold Unit_Price |
| 9 | Variable Costs | = Quantity_Sold Unit_Cost |
| 10 | Fixed Costs | 2,500 |
| 11 | Net Profit | = Gross_Revenue Variable_Costs Fixed_Costs |
| 12 | Profit per Unit | = Net_Profit/Quantity_Sold |
After entering the data shown below in cells B2, B3, B6, and B10, what values should appear in the following cells?
Note: Round your "Unit Gross Profit and Profit per Unit" answers to 2 decimal places.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
