This is all the data given you have to solve for the rest.

For 6 fx A B C D E F G H J Data Results Unit Revenue Fixed Cost Marginal Cost Total Revenue Total Fixed Cost Total Variable Cost Profit (Loss) Production Quantity Break-Even Point #DIV/0! Graph Points Production Qty Revenue Cost O, View Zoom Share Screen Shot 2022-... Q Highlight Rotate Markup Search PROBLEM 1: The product manager for a new haircare product called "turbo" is evaluating breakeven points for her organization. She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in a worksheet labeled "Haircare Data". The equipment that is used to produce this product is leased for $25,000/year. Using the data, create a pivot table that extracts the marginal costs and revenue for the turbo product. 1. What is the break-even point where profit is finally seen? (Ensure answer is in cell C:9) 2. Create a chart showing the crossover of Revenue and Cost. Make sure to appropriately label axis. Start your production quantity with a minimum of 4800 units. G 1 Work Order Mode 2 A7S00101 turbo 3 A7S00102 cha 4 A7500103 Sonic S AZS00104 mach 6 A7500105 turbo 7 A7500106 Burbe 8 A7S00102 viral 9 AZS00108 Wine 10 A7500109 viral 11 A7500110 mach! 12 A7500111 machi 13 A7500112 senic 14 A7500113 viral 15 A2S00114 Durbo 16 A7500115 mach! 17 A7500116 Sonic 18 A7500117 vind 19 A7500118 turbo 20 A7500119 mach! 21 A7500120 Burbe 22 A7500121 23 A7500122 vind 24 A2500123sonic 25 A7500124 turbo 26 A7500125 Durbo 27 A7500126 turbo 28 A2500127 Mach 1 29 AZS00128 viral 30 A7500129 viral 31 A7500130 mach! 92 A7500131 viral 33 A7500132 Durbo 34 AZS00133 viral 35 A7500134 turbo 36 A2500135 turbo 37 A7500136 mach 38 A7500137 viral 39 A2500138 vind 40 A7500139 turbo 41 A7500140 turbo 42 A7500141 mach 43 A7500142 viral 44 A7500143 45 A7500144 mach 46 A7500145 machi 47 A7500146 urbe 48 A7500147 Sonic 49 A7500148 viral SO A2500149 turbo S1 A2500150 Sonic 52 A7500151 Durbo 53 A7S00152 Burbe S4 A7500153 turbo SS A7500154 sonic Material Cost Laber Cast Shipping Ces Sales Price 1.21 2.62 1.1 9.47 1.42 2.69 1.22 9.47 1.46 2.49 1.17 10.78 1.03 2 1.08 10.83 1.62 2.62 10.35 1.56 2.36 1.16 10.82 1.33 2.61 1.15 10.87 1.51 2.59 1.17 1.19 2.64 1.15 1.39 2.08 1.18 9.98 1.26 2.33 1.15 9.73 1.95 2.07 1.19 10.07 1.32 2.51 1.16 9.77 1.05 2.03 1.04 9.05 1.70 2.2 1.21 9.67 1.23 2.4 1.02 10 1.41 2.3 1.09 10.61 1.34 2.67 1.06 9.61 1.73 2.21 1.24 10.34 1.09 2.14 1.16 9.92 1.50 2.13 1.03 10.2 1.44 2.75 1.23 9.87 1.74 2.02 1.09 9.18 1.65 2.11 1.13 10.33 1.17 2.59 1.12 9.41 1.70 2.02 1.18 10.51 2.57 1.22 9.67 1.55 2.6 1.13 10.91 1.76 2.29 1.04 10.22 1.37 2.32 1.2 10.52 1.35 2.55 10.36 1.72 2.23 1.08 9.97 1.78 2.58 1.22 10.65 1.88 2.33 1.24 9.97 1.76 2.58 1.2 10.03 1.18 2.51 1.07 10.56 1.25 2.47 1.04 10.6 1.63 2.66 1.08 10.77 1.26 2.13 1.07 9.16 1.53 2.39 1.22 9.71 1.75 2.42 1.11 10.04 1.33 2.53 1.25 10.45 1.14 2.61 1.13 10.97 1.19 2.65 1.03 10.14 1.30 2.02 1.18 10.22 1.87 2.07 1.13 10.01 1.20 2.64 1.14 9.27 1.56 2.07 1.02 10.03 1.26 2.13 1.23 9.85 1.09 2.68 9.31 1.17 2.35 1.21 9.15 1.09 2.18 1.19 9.87 1.06 2.5 1.17 9.12 1.80 2.33 1.2 9.33 B. sonic 1.80 1.60 181 193 1.26 171 156 1.16 Sonic 1.29 1.13 192 182 1.49 190 1.75 193 Viral SS A7500154 56 A7500155 machi S7 A7500156 turbo 58 A7500157 challenger 59 A7500158 viral 60 A7500159 machi 61 A7500160 sonic 62 A7500161 challenger 63 A7S00162 64 A7500163 machi 6S ATS00164 viral 66 A7500165 sonic 67 A7500166 turbo 68 A7500167 sonic 69 A7500168 machi 70 A7500169 sonic 71 A7500170 72 A7500171 machi 73 A7500172 challenger 74 A7500173 machi 75 A7500174 turbo 76 A7500175 sonic 77 A7500176 machi 78 A7500177 turbo 79 A7500178 turbo 80 A7500179 Viral 81 A7500180 82 A7500181 sonic 83 A7500182 machi 84 A7500183 machi 85 A7S00184 viral 86 A7500185 Viral 87 A7500186 turbo 88 A7S00187 sonic 89 A7500188 viral 90 A7500189 turbo 91 A7500190 machi 92 A7500191 Viral 93 A7500192 machi 94 A7500193 sonic 95 A7500194 turbo 96 A7500195 | turbo) 97 A7500196 machi 98 A7S00197 turbo 99 A7500198 viral 100 A7500199 mach 101 A7500200 Viral 164 9.33 10.74 9.52 9.67 9.95 9.63 9.91 10.5 9.92 10.3 9.84 10.59 9.66 10.55 10.99 9.7 9.24 9.46 10.33 10.8 9.05 10.61 10.55 10.18 10.64 10.8 9.36 9.48 10.33 9.82 2 33 2.14 2.71 201 2.67 2.17 2.54 2.39 25 2.71 2.1 237 2.67 2.57 2.51 2 24 2.51 2.27 2.53 2.04 2 23 2.35 2.43 2.74 2.58 2.08 2.23 2.41 2.14 2.44 2 26 2.45 2.32 2 33 205 2.13 2.29 2.44 2.69 2.45 2.16 2.41 2.47 2.7 2.68 2.46 237 187 112 125 1.86 2.00 114 1 89 172 122 1.02 181 125 111 190 158 121 1 39 12 119 105 1 125 119 116 11 12 115 118 102 113 1 1.22 11 1.03 1 105 124 111 12 1.05 1 24 107 101 1 1.25 101 119 103 1.19 112 117 1.13 118 117 117 11 1 24 1 23 104 124 125 11 119 105 Viral 10.95 1.56 9.05 10.58 9.75 10.46 9.28 10.8 10.77 10.57 9.7 9.88 132 183 115 1.69 111 191 1 34 1.45 187 192 130 139 9.28 10.82 9.84 9.08 10.51 9.6 The Vice-President from the same corporation in Problem 1, loves your analytical ability. She wants you to evaluate the breakeven point of all the Haircare products they manufacture together EXCEPT viral. She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in the previous worksheet labeled "Haircare Data. The equipment that is used to produce all the product except "viral is leased for $115,000/year. Using the data, create a pivot table that extracts the marginal costs and revenue for the select products. 1. What is the break-even point? (Ensure answer is in cell C:9) 2. Create a chart showing the crossover of Revenue and Cost. Make sure to appropriately label axis. Your production quantity should be near/close to half the range of the X axis. 3. You are sharing this file with a co-worker. You need to leave at least 2 comments regarding work-flow on this worksheet. F29 * fx A B C D E F G H J K Data Results ou WN- Unit Revenue Fixed Cost Marginal Cost Sales Forecast Total Revenue Total Fixed Cost Total Variable Cost Profit (Loss) Production Quantity Break-Even Point #DIV/0! Graph Points Production Quantity Revenue Cost 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 For 6 fx A B C D E F G H J Data Results Unit Revenue Fixed Cost Marginal Cost Total Revenue Total Fixed Cost Total Variable Cost Profit (Loss) Production Quantity Break-Even Point #DIV/0! Graph Points Production Qty Revenue Cost O, View Zoom Share Screen Shot 2022-... Q Highlight Rotate Markup Search PROBLEM 1: The product manager for a new haircare product called "turbo" is evaluating breakeven points for her organization. She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in a worksheet labeled "Haircare Data". The equipment that is used to produce this product is leased for $25,000/year. Using the data, create a pivot table that extracts the marginal costs and revenue for the turbo product. 1. What is the break-even point where profit is finally seen? (Ensure answer is in cell C:9) 2. Create a chart showing the crossover of Revenue and Cost. Make sure to appropriately label axis. Start your production quantity with a minimum of 4800 units. G 1 Work Order Mode 2 A7S00101 turbo 3 A7S00102 cha 4 A7500103 Sonic S AZS00104 mach 6 A7500105 turbo 7 A7500106 Burbe 8 A7S00102 viral 9 AZS00108 Wine 10 A7500109 viral 11 A7500110 mach! 12 A7500111 machi 13 A7500112 senic 14 A7500113 viral 15 A2S00114 Durbo 16 A7500115 mach! 17 A7500116 Sonic 18 A7500117 vind 19 A7500118 turbo 20 A7500119 mach! 21 A7500120 Burbe 22 A7500121 23 A7500122 vind 24 A2500123sonic 25 A7500124 turbo 26 A7500125 Durbo 27 A7500126 turbo 28 A2500127 Mach 1 29 AZS00128 viral 30 A7500129 viral 31 A7500130 mach! 92 A7500131 viral 33 A7500132 Durbo 34 AZS00133 viral 35 A7500134 turbo 36 A2500135 turbo 37 A7500136 mach 38 A7500137 viral 39 A2500138 vind 40 A7500139 turbo 41 A7500140 turbo 42 A7500141 mach 43 A7500142 viral 44 A7500143 45 A7500144 mach 46 A7500145 machi 47 A7500146 urbe 48 A7500147 Sonic 49 A7500148 viral SO A2500149 turbo S1 A2500150 Sonic 52 A7500151 Durbo 53 A7S00152 Burbe S4 A7500153 turbo SS A7500154 sonic Material Cost Laber Cast Shipping Ces Sales Price 1.21 2.62 1.1 9.47 1.42 2.69 1.22 9.47 1.46 2.49 1.17 10.78 1.03 2 1.08 10.83 1.62 2.62 10.35 1.56 2.36 1.16 10.82 1.33 2.61 1.15 10.87 1.51 2.59 1.17 1.19 2.64 1.15 1.39 2.08 1.18 9.98 1.26 2.33 1.15 9.73 1.95 2.07 1.19 10.07 1.32 2.51 1.16 9.77 1.05 2.03 1.04 9.05 1.70 2.2 1.21 9.67 1.23 2.4 1.02 10 1.41 2.3 1.09 10.61 1.34 2.67 1.06 9.61 1.73 2.21 1.24 10.34 1.09 2.14 1.16 9.92 1.50 2.13 1.03 10.2 1.44 2.75 1.23 9.87 1.74 2.02 1.09 9.18 1.65 2.11 1.13 10.33 1.17 2.59 1.12 9.41 1.70 2.02 1.18 10.51 2.57 1.22 9.67 1.55 2.6 1.13 10.91 1.76 2.29 1.04 10.22 1.37 2.32 1.2 10.52 1.35 2.55 10.36 1.72 2.23 1.08 9.97 1.78 2.58 1.22 10.65 1.88 2.33 1.24 9.97 1.76 2.58 1.2 10.03 1.18 2.51 1.07 10.56 1.25 2.47 1.04 10.6 1.63 2.66 1.08 10.77 1.26 2.13 1.07 9.16 1.53 2.39 1.22 9.71 1.75 2.42 1.11 10.04 1.33 2.53 1.25 10.45 1.14 2.61 1.13 10.97 1.19 2.65 1.03 10.14 1.30 2.02 1.18 10.22 1.87 2.07 1.13 10.01 1.20 2.64 1.14 9.27 1.56 2.07 1.02 10.03 1.26 2.13 1.23 9.85 1.09 2.68 9.31 1.17 2.35 1.21 9.15 1.09 2.18 1.19 9.87 1.06 2.5 1.17 9.12 1.80 2.33 1.2 9.33 B. sonic 1.80 1.60 181 193 1.26 171 156 1.16 Sonic 1.29 1.13 192 182 1.49 190 1.75 193 Viral SS A7500154 56 A7500155 machi S7 A7500156 turbo 58 A7500157 challenger 59 A7500158 viral 60 A7500159 machi 61 A7500160 sonic 62 A7500161 challenger 63 A7S00162 64 A7500163 machi 6S ATS00164 viral 66 A7500165 sonic 67 A7500166 turbo 68 A7500167 sonic 69 A7500168 machi 70 A7500169 sonic 71 A7500170 72 A7500171 machi 73 A7500172 challenger 74 A7500173 machi 75 A7500174 turbo 76 A7500175 sonic 77 A7500176 machi 78 A7500177 turbo 79 A7500178 turbo 80 A7500179 Viral 81 A7500180 82 A7500181 sonic 83 A7500182 machi 84 A7500183 machi 85 A7S00184 viral 86 A7500185 Viral 87 A7500186 turbo 88 A7S00187 sonic 89 A7500188 viral 90 A7500189 turbo 91 A7500190 machi 92 A7500191 Viral 93 A7500192 machi 94 A7500193 sonic 95 A7500194 turbo 96 A7500195 | turbo) 97 A7500196 machi 98 A7S00197 turbo 99 A7500198 viral 100 A7500199 mach 101 A7500200 Viral 164 9.33 10.74 9.52 9.67 9.95 9.63 9.91 10.5 9.92 10.3 9.84 10.59 9.66 10.55 10.99 9.7 9.24 9.46 10.33 10.8 9.05 10.61 10.55 10.18 10.64 10.8 9.36 9.48 10.33 9.82 2 33 2.14 2.71 201 2.67 2.17 2.54 2.39 25 2.71 2.1 237 2.67 2.57 2.51 2 24 2.51 2.27 2.53 2.04 2 23 2.35 2.43 2.74 2.58 2.08 2.23 2.41 2.14 2.44 2 26 2.45 2.32 2 33 205 2.13 2.29 2.44 2.69 2.45 2.16 2.41 2.47 2.7 2.68 2.46 237 187 112 125 1.86 2.00 114 1 89 172 122 1.02 181 125 111 190 158 121 1 39 12 119 105 1 125 119 116 11 12 115 118 102 113 1 1.22 11 1.03 1 105 124 111 12 1.05 1 24 107 101 1 1.25 101 119 103 1.19 112 117 1.13 118 117 117 11 1 24 1 23 104 124 125 11 119 105 Viral 10.95 1.56 9.05 10.58 9.75 10.46 9.28 10.8 10.77 10.57 9.7 9.88 132 183 115 1.69 111 191 1 34 1.45 187 192 130 139 9.28 10.82 9.84 9.08 10.51 9.6 The Vice-President from the same corporation in Problem 1, loves your analytical ability. She wants you to evaluate the breakeven point of all the Haircare products they manufacture together EXCEPT viral. She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in the previous worksheet labeled "Haircare Data. The equipment that is used to produce all the product except "viral is leased for $115,000/year. Using the data, create a pivot table that extracts the marginal costs and revenue for the select products. 1. What is the break-even point? (Ensure answer is in cell C:9) 2. Create a chart showing the crossover of Revenue and Cost. Make sure to appropriately label axis. Your production quantity should be near/close to half the range of the X axis. 3. You are sharing this file with a co-worker. You need to leave at least 2 comments regarding work-flow on this worksheet. F29 * fx A B C D E F G H J K Data Results ou WN- Unit Revenue Fixed Cost Marginal Cost Sales Forecast Total Revenue Total Fixed Cost Total Variable Cost Profit (Loss) Production Quantity Break-Even Point #DIV/0! Graph Points Production Quantity Revenue Cost 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35