“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Add a total row to this table and display the average for the Cost column instead of the sum of all the values.

Solved by E. Y. in 30 mins

I need to find the average excel for price

Solved by A. W. in 26 mins

Follow up: i need to find the average price for each year

Solved by K. F. in 23 mins

Trying to figure out how to do a dynamic year to date average

Solved by B. E. in 27 mins

hey I am having a problem with a single cell array formula, not sure why it isn't calculating the average and getting an error message, where the same formula, but looking at different cells is working?

Solved by E. F. in 18 mins

A. Product Labor Costs
You are making a new product. The cost of materials is $22.59. One person can assemble four per hour. You pay that person $10.25 per hour. What is the labor cost for the product? Did you say that the answer is $10.25/4 or $2.5625?
Consider what that $10.25 per hour person really costs you. You pay 6.2% social security and 1.45% Medicare on the employee’s pay. You have a 401K that you match 4% of the employee’s pay (assume everyone participates in the 401K). Your workers’ compensation insurance is $2.55 per $100 of payroll. The average paid vacation for your employees is three weeks. Everyone gets eleven paid holidays and ten paid personal days. All of your workers get two 20 minute paid breaks per day. Your facility works 5 days per week and 8 hours per day. You have done a study and have found that out of the remaining 7 hours 20-minute work day, your employees’ efficiency is 74%. You do your best to operate with no overtime, but your overtime runs 5% (i.e., 5% of the hours worked in a year are on overtime and paid with a 50% premium).
Your task is to create a spreadsheet to accurately cost the labor. Make the spreadsheet to allow easy costing of labor for other products.
B.
Product Costing
The cost of materials is $22.59. One person can assemble four per hour. You pay that person $10.25 per hour. The cost of packaging is $1.50 and it takes 5 minutes to package the product. You pay the person that does the packaging $10.25 per hour. All other costs are included in manufacturing overhead that is charged at 50% of the product material and labor. Sales, general, and administrative cost is charged at 40% of the total manufactured cost. What is the total manufactured cost of the product? All products are required to sell at a minimum profit of 20%. What is the minimum selling price?
You believe that you can sell the product for $99.98. What is the profit in dollars and percentage?
The union at the manufacturing facility just negotiated a new contract. The new labor rate is $10.97 per hour. They also got an additional personal day. What is the profit in dollars and percentage now?

Solved by K. E. in 16 mins

I am not sure this formulas can even be written but here goes....
I need a formula that searches for a specific text in a column on another sheet. When it finds those that text in cells I need it to take the numerical value of another cell in the row(s) where that text was found and average all the occurrences together of those cells with the numerical values.

Solved by S. C. in 25 mins

could you please help me find the 5-hour period with highest demand in order to calculate the level of earnings to offer a driver during those 5 hours. Finished Rides have average value of €10 (commission is 20%).

Solved by E. Y. in 30 mins

You will use the Billionaires list shown below. Your goal is to create a column chart by pivoting that shows the average networth of billionaires for each country in the list.

Solved by K. Y. in 30 mins

finding out the average math to calculate the price of when a certain amount is purchased

Solved by G. H. in 29 mins