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,414,000 for May. Variable selling expenses were $104,900, fixed selling expenses were $50,100, variable administrative expenses were $114,000, and fixed administrative expenses were $147,200. The cost of merchandise purchased during the month was $1,660,300. The beginning balance in the merchandise inventory account was $238,500, and the ending balance was $233,900. In addition to the above costs, sales salaries and commissions were $38,100 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 286 $5,894 April 251 $5,576 May 275 $5,770 June 296 $5,967 July 313 $6,052 August 259 $5,648 September 306 $6,027 October 245 $5,525 November 249 $5,543 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.

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,567,000 for May. Variable selling expenses were $112,700, fixed selling expenses were $51,200, variable administrative expenses were $117,500, and fixed administrative expenses were $134,600. The cost of merchandise purchased during the month was $1,532,300. The beginning balance in the merchandise inventory account was $216,600, and the ending balance was $275,800. In addition to the above costs, sales salaries and commissions were $32,800 plus 3% 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 306 $6,056 April 261 $5,639 May 301 $5,990 June 243 $5,511 July 274 $5,776 August 297 $5,990 September 280 $5,811 October 279 $5,795 November 262 $5,690 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.

141 Test #1 FA 21.docx 

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 29,200 units? (Assume that this sales volume is within the relevant range.)

A partial listing of costs incurred at Backes Corporation during November appears below: Direct labor  $  136,800 Factory maintenance  $    30,000 Advertising  $    73,200 Utilities, factory  $      7,200 Depreciation of production equipment  $    55,200 Administrative salaries  $  118,800 Depreciation of administrative equipment  $    36,000 Direct materials  $  188,400 Indirect materials  $    50,400 Sales commissions  $    64,800 The total of the manufacturing overhead costs listed above for November is:

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 21,400 units? (Assume that this sales volume is within the relevant range.)

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 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.)

Find the x- and y-intercepts.  Graph the equation on your paper.  Clearly label the intercepts on the graph.

Graph the equation on your paper.  Clearly label at least two points on the graph. The correct answer here is: See my work.