In column E, use the appropriate text function to return the position of the comma character located in the data in column D. Copy the formula down through cell E21. Hint: Do not use the optional argument

Bandar Industries manufactures sporting equipment. One of the company's products is a football helmet that requires special plastic. During the quarter ending June 30 , the company manufactured 3,200 helmets, using 2,368 kilograms of plastic. The plastic cost the company $20,365. According to the standard cost card, each helmet should require 0.69 kilogram of plastic, at a cost of $9.00 per kilogram. Required: 1. What is the standard quantity of kilograms of plastic (SQ) that is allowed to make 3,200 heimets? 2. What is the standard materials cost allowed (SC SP) to make 3,200 helmets? 3. What is the materials spending variance? 4. What are the materials price variance and the materials quantity variance? Note: For requirements 3 and 4 , Indicate the effect of each variance by selecting " F " for favorable, " U " for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values, Do not round intermediate calculations