Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 14 5 points Save Answer For Set 3 data, what was the total dollars sales generated by Tony (total qty produced x price)? QUESTION
QUESTION 14 5 points Save Answer For Set 3 data, what was the total dollars sales generated by Tony (total qty produced x price)? QUESTION 15 5 points Save Answer For Set 3 data, what was the company's total labor cost during this period? QUESTION 16 5 points Save Answer For Set 3 data, what was the company's total profit during this period? QUESTION 17 5 points Save Answer For Set 3 data, what was the total sales dollar volume generated by Ziva (total qty produced x price)?The hours column is locked. You can't use it. So, now what? Give up? Never. Instructions: The hours worked, quantity produced and the employee hourly rates are provided here. Calculate Hours in Units / Hour column and verify if the calculations are correct. Product details per unit Also provided are the selling price and the cost of the material and energy. Then modify the formula a bit to get Units / Hour. Material Energy Selling price From this information, compute $5_85 $2.33 $13.25 1. Units produced per hour Employee Clock-in Clock-out Units / Emp # hours Qty Paid Labor cost Total cost / hour / unit unit 2. Amount paid (hours more than 8 are paid at 1.2 times hourly rate) Tony 3 7:10 AM 5:53 PM 10.72 95 8.86 $349.06 | $ 3.67 $ 11.85 Employee Rate 3. Labor cost per unit produced McGee 8:38 AM 4:08 PM 7.50 78 10.40 $210.00 2.69 $ 10.87 Gibbs 26.00 4. Total unit cost (labor cost + material cost + energy cost) McGee 8:53 AM 3:33 PM 63 McGee 28.00 Gibbs 7:58 AM 3:03 PM 44 Tom $ 31.00 Use proper Excel functions to be more efficient as on the test, eonard 8:26 AM 3:21 PM 73 Ziva $ 27.00 You'll have very limited time to answer these questions. Sheldon 7:59 AM 4:22 PM 59 Ra 25.00 You'll not be able to sort or Filter or copy data to another Excel sheet. McGee 8:32 AM 3:17 PM 64 Leonard 26.00 Raj 7:21 AM 3:20 PM 80 Penny 29.00 Ziva 4 7:12 AM 4:24 PM 122 Sheldon $ 33.00 Gibbs 8:23 AM 3:19 PM 48 Sheldon 8:53 AM 5:14 PM 58 eonard 8:23 AM 3:41 PM 58 Penny 7:24 AM 4:37 PM 62 enm 7:49 AM 4:25 PM 80 Gibbs 8:32 AM 4:36 PM 56 Sheldon 7:39 AM 3:20 PM 44 heldon 7:39 AM 3:31 PM 60 Sheldon 7:34 AM 3:40 PM 46 Gibbs 7:47 AM 4:13 PM 78 7:48 AM 3:49 PM 60 Sheldon 8:51 AM 4:33 PM 44 Raj 5 7:39 AM 5:26 PM 82 8:58 AM 4:31 PM 57 7:47 AM 4:35 PM 73 McGee 7:09 AM 4:37 PM 98 Ziva 8:27 AM 4:41 PM 73 Gibbs 8:58 AM 4:18 PM 57 7:53 AM 3:55 PM 98 Gibbs 8:18 AM 5:05 PM 82 Penny 8:39 AM 4:08 PM 57 Ziva 8:20 AM 5:14 PM 79 Leonard 7:26 AM 5:43 PM 73 8:10 AM 5:08 PM 82 McGee 2 8:40 AM 5:03 PM 654 7:44 AM 4:51 PM 91 Penny 7:46 AM 1:29 PM 81 Sheldon 7:18 AM 4:05 PM 56 Jive 4 7:32 AM 3:44 PM 91 Tony 3 8:17 AM 4:11 PM 93 Sheldon 8:20 AM 4:57 PM 60 diva 4 8:53 AM 3:32 PM 66 Gibbs 1 7:01 AM 3:01 PM 74 Tony 3 7:41 AM 4:01 PM 74 Penny 8:58 AM 3:08 PM 52 Gibbs 1 8:07 AM 6:35 PM 81 Ra 8:33 AM 5:31 PM 67 4 7:40 AM 4:35 PM 79 McGee 8:59 AM 1:33 PM 52 Leonard 6 8:26 AM 3:38 PM 57 McGee 8:57 AM 3:28 PM 45 Ziva 4 7:12 AM 5:57 PM 107 Penny 8:40 AM 5:21 PM 88 McGee 2 7:42 AM 1:40 PM 62 Leonard 6 8:32 AM 3:31 PM 49 Sheldon 8:44 AM 3:15 PM 50 Sheldon 7:43 AM 4:26 PM 55 Leonard 6 8:40 AM 3:31 PM 67 Leonard 6 8:26 AM 4:14 PM 62 Ra in 7:08 AM 4:31 PM 63 Raj 5 8:22 AM 3:24 PM 47 Sheldon 7:07 AM 5:05 PM 70 Sheldon 7:02 AM 1:08 PM 58 Gibbs 7:35 AM 4:16 PM 67 Penny 7:17 AM 3:05 PM 79 Tony 3 8:15 AM 4:29 PM 65 Gibbs 8:47 AM 3:56 PM 55 McGee 8:17 AM 1:26 PM 56 McGee 7:51 AM 5:26 PM 100 Ra 7:22 AM 4:22 PM 90 Sheldon 8:53 AM 5:06 PM 42 Tony 7:29 AM 5:01 PM 94 Leonard 6 7:30 AM 8:52 PM 59 Leonard 7:01 AM 3:06 PM 57 Gibbs 1 8:34 AM 3:47 PM 50 Penny 8:33 AM 5:06 PM 87 McGee 2 8:17 AM 5:56 PM 67 Gibbs 7:11 AM 4:07 PM 62Ziva 4 7:24 AM 5:12 PM 97 Raj 5 8:52 AM 4:54 PM 67 Leonard 6 7:36 AM 3:39 PM 57 Gibbs 1 8:21 AM 4:12 PM 55 Gibbs 7:14 AM 4:35 PM 58 McGee 2 7:11 AM 5:58 PM 75 McGee 2 7:38 AM 5:36 PM 78 Tony 8:01 AM 5:10 PM 72 Ziva 4 7:45 AM 5:49 PM 122 Leonard 6 8:47 AM 5:07 PM 59 McGee 2 8:27 AM 5:35 PM 95 Gibbs 1 7:50 AM 5:19 PM 81 Tony 3 7:21 AM 3:33 PM 81 Tony 3 8:41 AM 5:58 PM 91 Ra 5 7:41 AM 5:53 PM 85 Penny 8:51 AM 3:55 PM 72 Tony 3 7:07 AM 3:41 PM 93 Tony 8:36 AM 3:44 PM 84 Tony 8:43 AM 4:13 PM 89 Ziva 4 7:21 AM 4:39 PM 92 Gibbs 1 8:36 AM 3:59 PM 51 Ziva 4 7:11 AM 5:40 PM 128
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started