Sales=40,000 variable cost=20% Fixed cost=30000 using Goal Seek analysis find the profit when sales is Rs.80000 Options : 34000 30000 22000 32000 excel solution
Question
Sales=40,000 variable cost=20% Fixed cost=30000 using Goal Seek analysis find the profit when sales is Rs.80000 Options : 34000 30000 22000 32000 excel solution
Solution
To solve this problem, we first need to understand the formula for profit. Profit is calculated as:
Profit = Total Sales - Total Cost
Where Total Cost is the sum of Variable Cost and Fixed Cost.
Given: Sales = 40,000 Variable Cost = 20% of Sales = 0.20 * 40,000 = 8,000 Fixed Cost = 30,000
So, the Total Cost = Variable Cost + Fixed Cost = 8,000 + 30,000 = 38,000
Therefore, the Profit at Rs. 40,000 sales is = Sales - Total Cost = 40,000 - 38,000 = 2,000
Now, we need to find the profit when sales is Rs. 80,000.
The Variable Cost at Rs. 80,000 sales = 20% of 80,000 = 0.20 * 80,000 = 16,000
So, the Total Cost at Rs. 80,000 sales = Variable Cost + Fixed Cost = 16,000 + 30,000 = 46,000
Therefore, the Profit at Rs. 80,000 sales = Sales - Total Cost = 80,000 - 46,000 = 34,000
So, using Goal Seek analysis, the profit when sales is Rs. 80,000 is Rs. 34,000. Hence, the correct option is 34000.
Similar Questions
The financial information of the company is as follows:Sales units: 490Price per unit: $30Fixed cost: $400Variable cost per unit: $20You have generated a scenario summary report for your Excel model, which includes the following two scenarios:Best case scenario: variable cost = $10, unit price = $40Worst case scenario: variable cost = $30, unit price = $20What is the profit obtained in best case scenario?Options :$9800$15200$12500$14300
The financial information of the company is as follows:Sales units: 200Price per unit: $30Fixed cost: $400Variable cost per unit: $20What would be the profit if 400 and 500 units are sold? Create a data table for the same.Options :$2,000 and $3,500$3,600 and $4,600$2,500 and $3,200$4000 and $6,500
Sales Rs. 50,000; Variable cost Rs. 30,000; Net profit Rs. 6,000; fixed cost is .a.b. Rs. l4,000 .b.Rs. 10,000.c.Rs. 12,000.d.Rs. 8,000.
Fixed cost Rs. 80,000; Variable cost Rs. 2 per unit; Selling price_Rs. 10 per unit; turnover required for a profit target of Rs. 60,000.a.Rs. 1,75,000.b.Rs. 1,86,667.c.Rs. 1.57,000.d.Rs. 1,17,400.
Enter a formula in the selected cell to calculate the profit projection for 2022: total sales (cell F4) minus the cost of goods sold (cell F5).
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.