solved Complete the following three questions using Microsoft Excel. No other

Complete the following three questions using Microsoft Excel. No other submission format is allowed. Review the grading rubric to confirm you are meeting the assignment requirements.Problem 1Milwaukee Dairy Company produces cream, whole milk, and 2% milk. The joint cost of producing the three products is SAR 30,000. The split-off quantities and selling prices of each product are as follows:Split-off Quantity (Gallons)Price at Split off (SAR)Cream55019.00Whole milk4,00013.002% milk1,2006.50Required: Calculate how much of the joint costs should be allocated to each product using the market value at split off method.Problem 2The following information pertains to Delicious Bakery Company:GIVEN:Janitorial Dept.Cafeteria Dept.Mixing Dept.Baking Dept.Square feet42082028002500Number of employees122565120Department cost (SAR)620,0001,200,0003,200,0004,200,000Required: Allocate Janitorial and Cafeteria department costs to mixing and baking departments using the Direct method. Use square feet for allocating janitorial costs and number of employees for allocating cafeteria department costs.Problem 3Maintenance HoursMaintenance Cost (SAR)January2,40033,000February1,70028,000March2,70031,000April1,30017,000May1,50023,000June2,15026,000Required:Calculate variable cost per unit using the high-low method.Calculate fixed costs.Calculate estimated costs at 2,700 maintenance hours.Problem 4Given the following:Total (SAR)Sales (40,000 units)4,600,000Variable expenses2,700,000Contribution margin1,900,000Fixed expenses1,250,000Net operating income650,000Required:Calculate variable expense ratioCalculate contribution margin ratioCalculate break even sales in UnitsCalculate break even sales in SARHow many units must be sold to make a profit of 300,000 SAR?Management is considering increasing the quality of its units by spending SAR 5 more per unit in variable costs and increasing advertising by SAR 80,000. Management believes these changes will increase unit sales by 20% at the same price.i.Calculate the new operating profit or loss.Explain whether management should make the change and why or why not.