Problems Prepare the problems below using Exc…
Problems Prepare the problems below using Excel. Upload the workbook using the link. 1. (18 points) Xavior Sales Corporation, a merchandising company, reported total sales of $2,413,000 for May. Variable selling expenses were $104,800, fixed selling expenses were $51,700, variable administrative expenses were $113,700, and fixed administrative expenses were $140,200. The cost of merchandise purchased during the month was $1,549,100. The beginning balance in the merchandise inventory account was $247,100, and the ending balance was $251,400. In addition to the above costs, sales salaries and commissions were $34,800 plus 8% of sales. Required: a. Prepare a contribution format income statement for May. b. Prepare a traditional format income statement for May. 2. (6 points) Electrical costs of one of Reifel Corporation’s factories are listed below: Machine- Electrical Hours Cost March 288 $5,892 April 290 $5,911 May 273 $5,753 June 254 $5,600 July 305 $6,049 August 284 $5,894 September 259 $5,659 October 309 $6,057 November 275 $5,799 Management believes that electrical cost is a mixed cost that depends on machine-hours. Required: a. Estimate the variable cost per machine-hour and the fixed cost per month using the high-low method. Show your work. Round the variable cost per unit to the nearest cent and the fixed cost to the nearest whole dollar. b. Express these costs as a formula in the format y = mx + b. c. Using the formula derived above, estimate the electrical cost when machine-hours in a month are 280. Round to the nearest dollar. Show your work.