This assignment includes an Excel workbook named Food Recycling 2017 Cost Data. Use the information in the workbook to answer the questions shown below. You will likely need to add new columns for calculations and new rows for totals and averages. You may find some of the charting easier if you rearrange the columns of the worksheet so that columns for fixed costs and variable costs are grouped together. Your final modified workbook will be submitted as part of the case study.

1. What are the fixed costs of this business?
2. What are the variable costs?
3. Develop a monthly total cost function for this business of the form:

C(x) = Vx + F

Where C(x) represents the total cost for the month to produce x tons of feed, V represents the variable costs per ton of feed produced based on monthly averages, and F is the total of all average monthly fixed costs.

Here is what I got for questions 1 and 2 so far. I am not sure if I have the fixed and variable costs correct or not.

E Average $ 114,416.77 445 450 470 470 475 490 430 420 Feed Produced Electricity - Water - in Tons Processing Processing 8940 $ 895 $ 9110 $ 910 $ 9320 $ 930 $ 9300 $ 930 $ 9450 $ 945 $ 9630 $ 965 $ 8450 $ 830 $ 8390 $ 835 $ 9505 $ 960 $ 10320 $ 1,045 $ 11280 $ 1,140 $ 10900 $ 1,100 $ Processing Labor Processing Wage Hours per Hour 4,470 $18.00 4,555 $18.00 4,660 $18.00 4,650 $18.00 4,725 $18.00 4,815 $18.00 4,225 $18.00 4,195 $18.00 4,753 $18.00 5,160 $18.50 5,640 $18.50 5,450 $18.50 2 January 3 February 4 March 5 April 6 May 7 June 8 July 9 August 10 September 11 October 12 November 13 December 14 15 Total 16 17 18 Average Transportation per mile $1.38 $1.38 $1.38 $1.38 $1.38 $1.38 $1.38 $80,460.00 $81,990.00 $83,880.00 $83,700.00 $85,050.00 $86,670.00 $76,050.00 $75,510.00 $85,554.00 $95,460.00 $104,340.00 $100,825.00 Total Miles Driven 17,880 18,220 18,640 18,600 18,900 19,260 16,900 16,780 19,010 20,640 22,560 21,800 Total $24,674.40 $ 106,474.40 $25,143.60 $ 108,493.60 $25,723.20 $ 111,003.20 $25,668.00 $ 110,768.00 $26,082.00 $ 112,552.00 $26,578.80 $ 114,703.80 $23,322.00 $ 100,632.00 $23,156.40 $ 99,921.40 $26,233.80 $ 113,222.80 $28,483.20 $ 125,498.20 $31,132.80 $ 137,172.80 $30,084.00 $ 132,559.00 $1.38 475 510 560 550 $1.38 $1.38 $1.38 $1.38 114595 $ 11,485 $ 5,745 $1,039,489.00 $316,282.20 $ 1,373,001.20 $502,095 $ 1,875,096.20 9549.583333 variable cost fixed costs + Ready 0 0 -- + + 100% J K L M N O P Q R S T A B C D EE F Office Building Electricit Insuranc Salary - Salary - Expense y - Office e Manager Office 2 January $ 10,400 $ 1,130 $ 3,000 $ 7,500 $ 13,500 3 February $ 10,400 $ 1,110 $ 3,000 $ 7,500 $ 13,500 4 March $ 10,400 $ 1,070 $3,000 $ 7,500 $ 13,500 5 April $ 10,400 $ 680 $ 3,000 $ 7,500 $ 13,500 6 May $ 10,400 $ 600 $ 3,000 $ 7,500 $ 13,500 7 June $ 10,400 $ 530 $ 3,000 $ 7,500 $ 13,500 8 July $ 11,000 $ 550 $3,000 $ 7,500 $ 13,500 9 August $ 11,000 $ 560 $3,000 $ 7,500 $ 13,500 10 Septembe $ 11,000 $ 705 $3,000 $ 7,500 $ 13,500 11 October $ 11,000 $ 940 $3,000 $ 7,500 $ 13,500 12 Novembe $ 11,000 $ 1,010 $ 3,000 $ 7,500 $ 13,500 13 December $ 11,000 $ 1,060 $3,000 $ 7,500 $ 13,500 14 15 Total $ 128,400 $ 9,945 $ 36,000 $90,000 $162,000 16 G H I Processin g Plant Expense Total Average $ 6,125 $ 41,655 $ 41,841 $ 6,125 $ 41,635 $ 6,125 $ 41,595 $ 6,125 $ 41,205 $ 6,125 $ 41,125 $ 6,125 $ 41,055 $ 6,500 $ 42,050 $ 6,500 $ 42,060 $ 6,500 $ 42,205 $ 6,500 $ 42,440 $ 6,500 $ 42,510 $ 6,500 $ 42,560 $ 75,750 $502,095 17 18 Average $ 143,456 variable cost fixed costs Ready @ J -_ + 100%