If a plumber knows the rate he charges per hour, the cost of his tools and travel, the cost of purchasing items, and other subsidiaries, he can figure out how much he will make in a week via a formula.  If he were to choose to target a specific number and then work backwards to figure out how much he should charge for each hour, which Excel tool would he use to get the most direct and quickest result?conditional formattingtables with subtotalsgoal seekdatabase formulas

A data analyst is trying to establish the cheapest way for a company to deliver inventory from a number of depots to a range of retail stores, based on quantities held at each depot, the distances between the depots and the capacity to hold required inventories in each store.If he were using an Excel spreadsheet to do this task, which function would be most appropriate to use to reach his desired objective? SolverScenario managerGoal seekMultiple regression

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

A production manager oversees a budget for a project and needs to determine the maximum cost per unit to stay within budget. The total budget and the number of units required are estimated in advance. Which Excel function can help you find the maximum cost per unit the organization can allow?Options :=SUMIFS=AVERAGEIFSGoal SeekData Table

Multiple Choice QuestionThe formula to compute the budgeted direct labor cost for a service firm is:Multiple choice question.budgeted total labor cost divided by total direct labor cost per hourbudgeted direct labor cost times direct labor cost per hourbudgeted direct labor hours times direct labor cost per hourbudgeted labor hours times labor cost per hour

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 do in excel