Q: The spreadsheet below models the costs and potential revenues of manufacturing speakers, assuming that the full order is sold. In the spreadsheet, four different sets of cells have been designated as A, B, C, and D.
Assume there is an expedited manufacturing option that results in a 50% reduction in time for customers to receive their goods. However, that expedited service increases the cost of the order by 25%.
Which designated set of cells is the logical place to insert that potential 25% cost increase as a variable?
or
Q: Assuming that the entire order is sold, the spreadsheet that follows simulates the expenses and possible profits of producing speakers. Four distinct cell sets have been labeled as A, B, C, and D in the spreadsheet.
Let’s say there is a production alternative that can be hastened, saving clients 50% on the time it takes to acquire their items. However, the order costs 25% more because of that faster service.
It makes sense to add that possible 25% cost increase as a variable in which specific group of cells?
- A
- B
- D
- C
- None of these
Explanation: If this set includes revenue calculations, inserting a cost variable here would be illogical.
