Can you do the first question in excel?

Katharine Johnson is the owner of Best Bakes, a company that produces high-quality cross-country bicycles. Best Bikes participates in a supply chain that consists of suppliers, manufacturens, distributors, and elite bicyde shops. For several years Best Bikes has purchased titanium from suppliers in the supply chain. Best Bikes uses titanium for the bicycle frames because it is stronger and lighter than other metals and therefore increases the quality of the bicydle. Earler this year, Best Bikes hired Michael Bentfield, a recent graduate from State University, as purchasing manager. Michael beieved that he could reduce costs if he purchased titanium from an online marketplace at a lower price Best Bikes established the following standards based upon the company's experience with previous suppliers. The standards are as follows $18 per pound Cost of titanium Titanium used per bicycle 8 lbs. Actual results for the first month using the online supplier of tita are as follows Bicycles produced Titanium purchased Titanium used in production 4,700 lb. s nium 400 5,200 lb. for $88,400 Required 1. Compute the direct materials price and efficiency variances. 2. What factors can esplain the variances identified in requirement 17 Could any other variances be affected? & Was switching suppliers a good ides for Best Bikes? Explain