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,615,000 for May. Variable selling expenses were $99,400, fixed selling expenses were $53,600, variable administrative expenses were $124,500, and fixed administrative expenses were $138,400. The cost of merchandise purchased during the month was $1,687,500. The beginning balance in the merchandise inventory account was $238,300, and the ending balance was $244,000. In addition to the above costs, sales salaries and commissions were $37,900 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 271 $5,786 April 290 $5,889 May 310 $6,054 June 269 $5,746 July 243 $5,497 August 267 $5,698 September 284 $5,811 October 249 $5,538 November 264 $5,662 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.

A soft drink bottler incurred the following plant utility costs: 2,070 units bottled with utility costs of $5,000 and 1,725 units bottled with utility costs of $4,522. What is the fixed portion of the utility costs? Use the high-low method. Round to the nearest dollar.

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.

A partial listing of costs incurred at Backes Corporation during November appears below: Direct labor  $    91,200 Direct materials  $  125,600 Depreciation of administrative equipment  $    24,000 Sales commissions  $    43,200 Utilities, factory  $      4,800 Advertising  $    48,800 Administrative salaries  $    79,200 Depreciation of production equipment  $    36,800 Factory maintenance  $    20,000 Indirect materials  $    33,600 The total of the manufacturing overhead costs listed above for November is:

A soft drink bottler incurred the following plant utility costs: 2,250 units bottled with utility costs of $4,600, and 1,875 units bottled with utility costs of $4,160. What is the variable cost per unit bottled? Use the high-low method. Round to the nearest cent.

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: