Complete the following questions using Excel, No other submission format is allowed, Review the grading rubric to comm you are meet amounts in US Dollars unless otherwise indicated. Problem 1 Bligha Corporation is considering trading a truck with a book value of BAR 52 000 with an estimated five-year Wife for a new bruck that would cost SAR 80 000. The s'! fuck could be sold for SAR 65.080. The new truck has a five year like with no residual value. The new truck would reduce annual operating costs by SAR 4,300 per your Prepare a differential analysis on whether to continue with the old machine (Afemative 1] or purchase the now machine [Alemannew 2) Problem 2 A condensed income statement by product line for Yanbu Baking Inc. indicated the following for Almond Cookies for the past year Sales SAR 1 20.TOOD Cost of goods sold TOO OOO Groth profit 500.000 Operating expenses $70Loop Loss from operations (SAR TO DOO) It is estimated that 201% of the cost of goods sold represents food factory overhead costs, and that 25%% of the operating expenses are fixed. Because Almond Cookies is only one of the many products, the fixed costs will not be materially affected if the product is liscontinued Propane a differential analysis to determine whether Almond Cookies should be continued (Ahemative 1) or discontinued (Alteration 2). Should Almond Cookin be retained? Explain and indicate the dollar differences in favor or against. Problem ] Asbear Company manufactures various sized plastic bottles for its medicinal product. The manufacturing cost for small bottles is SAR 65 per unit (100 bottles), including food costs of BAR 14 per unit. A proposal is offered to purchase small bottles thom an outside source for SAR 42 pair unit, plus BAR 3 per unit for haight Propa a differential analysis to determine whether the company should make (Allemative ")or buy (Alternative 2) for bottles. awsuming fixed costs are not allected by the decision Problem 4 Product K12 is produced for SAR 14 per gallon. Product K12 can be sold without additional processing for SAR 22 per gallon or proonand further into Product MOT ot am additional com of SAR 7 per gallon. Product MIT can be sold for SAR 27 per gallon Prepare a diferential analysis on whether to well Product K12 (Ahemative 1) or process further into Product M27 (Alteration 21 You must show all your work. please solve it with detailed calculations