The current profit situation of a business owner is as follows.
Current Sales 82
Cost per Unit 75
Profit per unit 12
Using the scenario manager, find the effect of in the new profit in case of the following
situations.
a. Sales = 70 and cost = 80
b. Sales = 90 and cost = 72
c. Sales = 85 and cost = 80
d. Sales = 65 and cost = 80
do it in electronic spreadsheet in pc or tell me the steps to do it.
Answers
Given : Current Sales 82
Cost per Unit 75
Profit per unit 12
To Find : new profit in case of the following
a. Sales = 70 and cost = 80
b. Sales = 90 and cost = 72
c. Sales = 85 and cost = 80
d. Sales = 65 and cost = 80
Explanation:
Current Sales 82
Cost per Unit 75
Profit per unit 12
Selling Price = 75 + 12 = 87
Profit = 82 * 12 = 984
a. Sales = 70 and cost = 80
Profit per unit = 87 - 80 = 7
Profit = 70 * 7 = 490
b. Sales =90 and cost = 72
Profit per unit = 87 - 72 = 15
Profit = 90 * 15 = 1350
c. Sales = 85 and cost = 80
Profit per unit = 87 - 80 = 7
Profit = 85 * 7 = 595
d Sales = 65 and cost = 80
Profit per unit = 87 - 80 = 7
Profit = 65 * 7 = 455
Learn More:
find cp when sp =630 and profit% =5 - Brainly.in
https://brainly.in/question/7596437