ill ) Food Recycling 2017 Cost Data.xlsx [Protected View] - Microsoft Excel XU9-07 File Home Insert 4:20 PM 10/15/2019 O X - Page Layout Formulas Data Review View x i Protected View Enable Editing B2 A This file originated from an Internet location and might be unsafe. Click for more details. fc =1300*8 B C K $ 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 Office Building Processing Expense Plant Expense $ 10,400 $ 6,125 S 10,400 $ 6,125 10,400 $ 6,125 10,400 $ 6,125 10,400 $ 6,125 10,400 $ 6,125 11,000 $ 6,500 11,000 $ 6,500 11,000 $ 6,500 11,000 $ 6,500 $ 11,000 $ 6,500 $ 11,000 $ 6,500 Electricity - Electricity - Office Processing $ 1,130 $ 895 $ 1,110 $ 910 $ 1,070 $ 930 $ 680 5 930 $ 600 $ 945 $ 530 $ 965 $ 550 $ 830 $ 560 $ 835 $ 705 $ 960 $ 940 $ 1,045 $ 1,010 $ 1,140 $ 1,060 $ 1,100 Water- Processing Insurance $ 445 $ 3,000 $ 450 $ 3,000 $ 470 $ 3,000 $ 470 $ 3,000 $ 475 $ 3,000 $ 490 $ 3,000 $ 430 $ 3,000 $ 420 $ 3,000 $ 475 $ 3,000 $ 510 $ 3,000 $ 560 $ 3,000 $ 550 $ 3,000 Salary- Manager $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 Salary - Office $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 5 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 Processing Labor Hours 4,470 4,555 4,660 4,650 4,725 4,815 4,225 4,195 4,753 5,160 5,640 5,450 Processing Feed Produced Transportation Total Miles Wage per Hour in Tons per mile Driven $18.00 8940 $1.38 17,880 $18.00 9110 $1.38 18,220 $18.00 9320 $1.38 18,640 $18.00 9300 $1.38 18,600 $18.00 9450 $1.38 18,900 $18.00 9630 $1.38 19,260 $18.00 8450 $1.38 16,900 $18.00 8390 $1.38 16,780 $18.00 9505 $1.38 19,010 $18.50 10320 $1.38 20,640 $18.50 11280 $1.38 22,560 $18.50 10900 $1.38 21,800 15 30 21 Sheet1 Ready BOU 84% 0. - 4:24 PM 10/15/2019 X W 9-0 File Home i Protected View = Food Recycling Case Study.docx (Protected View) - Microsoft Word Insert Page Layout References Mailings Review View This file originated from an Internet location and might be unsafe. Click for more details. Enable Editing 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. 4) Use Desmos to graph the monthly total cost function for 0