Category: Uncategorized

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,461,000 for May. Variable selling expenses were $100,600, fixed selling expenses were $46,800, variable administrative expenses were $126,700, and fixed administrative expenses were $127,600. The cost of merchandise purchased during the month was $1,393,100. The beginning balance in the merchandise inventory account was $257,300, and the ending balance was $250,800. In addition to the above costs, sales salaries and commissions were $36,200 plus 4% 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 287 $5,900 April 267 $5,736 May 312 $6,055 June 274 $5,760 July 283 $5,825 August 245 $5,543 September 273 $5,774 October 291 $5,894 November 284 $5,889 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.

At a sales volume of 28,000 units, Thoma Corporation’s sales…

At a sales volume of 28,000 units, Thoma Corporation’s sales commissions (a cost that is variable with respect to sales volume) total $358,400. To the nearest whole dollar, what should be the total sales commissions at a sales volume of 30,200 units? (Assume that this sales volume is within the relevant range.)