Hello,

I would appreciate it if someone could help me out a bit with this homework problem for managerial accounting.

Each unit sells for $800. Below is information on production/sales and costs for 2004.

Production and Sales in Units - Production Costs - Selling and Admin Costs

January 95 $78,500 $13,800
February 100 80,000 14,000
March 105 81,500 14,200
April 108 82,400 14,320
May 107 82,100 14,280
June 110 83,000 14,400
July 107 82,100 14,280
August 115 84,500 14,600
September 105 81,500 14,200
October 110 83,000 14,400
November 120 86,000 14,800
December 150 95,000 16,000
Total 1,332 999,600 173,280
Average cost per unit $750.45045 $130.09009


How can I sort this data in Excel to identify the fixed and variable cost components for both production costs and selling and administrative costs?

Also, how can I forecast income before taxes for the company based on estimates that production and sales in 2005 will be 1,400 units?

Thank you very much.



Chloe