Question

A business owner wants to decide if he should try to increase the sales a product or

price of an existing product in order to increase the profit by 10%.

Current Sales 82

Cost per Unit 75

Profit per unit 12

The owner believes that he can either increase sales by 5 units without incurring additional

costs while the price can be increased by Rs 8 without affecting the sales.

do it in electronic spreadsheet advance

Answer 1

Answer:

Increase of 10% of 12 is 1.2 . So, he wants profit per unit to be 13.2

Explanation:

Steps :-

1) Click on Tool>Solver in menu bar

2)Solver window will open and select the cell containing profit per unit (B3).

3)In OPTIMIZE RESULT TO category select Value of and type 13.2 there.

4)In By Changing Cell box select the cells containing value of Current Sales and Cost Per Unit ( B1 and B2 by dragging).

5)In Limiting Conditions section, there are three list Cell reference, Operator and Value.

6)In first row, select B1 for cell reference, <= as operator and type value as 87

7)In second row, select B2 for cell reference, <= as operator and type value as 83.

8) Click on Solve

Answer 2

Explanation:

$20 + 162 \times \frac{?}{?}$