Prоblems Prepаre the prоblems belоw using Excel. Uploаd the workbook using the link. 1. (18 points) Xаvior 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.
Prоblems Prepаre the prоblems belоw using Excel. Uploаd the workbook using the link. 1. (18 points) Xаvior 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.
Prоblems Prepаre the prоblems belоw using Excel. Uploаd the workbook using the link. 1. (18 points) Xаvior 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.
Prоblems Prepаre the prоblems belоw using Excel. Uploаd the workbook using the link. 1. (18 points) Xаvior 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.
The functiоn оf the NADH mоlecule is to:
Whаt wаvelength оf light is reflected by а plant that appears blue tо us?