Answered step by step
Verified Expert Solution
Question
1 Approved Answer
My average monthly expenses seems wrong, the formula in the formula bar is what I used to calculate cell 30&31. It seems like it should
My average monthly expenses seems wrong, the formula in the formula bar is what I used to calculate cell 30&31. It seems like it should be much higher than that though...
A30 V -AVERAGE(D9626) Farm Budget June through September 2019 Prepared on 2/19/2019 June Aug Sep Total 4 Receipts 5 Sale of Products 6 Other Income $16,000.00 $16,960.00 $17,977.60 $19,056.26 $ 69,993.86 $ 2,000.002,000.00$ 2,000.00$ 2,000.00$ 8,000.00 8 Expenses 9 Car and Truck Expense 10 Chemicals 11 Depreciation 12 Feed Purchased 13 Fertilizers 14 Freight and Trucking 15 Gasoline and Fuels 16 Insurance 17 Labor 18 Rent or Lease of Vehicles 19 Rent or Lease Other 20 Repairs and Maintenance 21 Seeds and Plants 22 Storage and Warehousing 23 Supplies Purchased 24 Taxes 25 Utilities 26 Veterinary 27 Net Income 28 29 Average Monthly Expenses $500.00$500.00$ 500.00$ 500.00$ 2,000.00 $ 100.00$100.00$ 100.00$ 100.00$ 400.00 $ 1,000.001,000.00$ 1,000.00$ 1,000.00 $ 4,000.00 $ 1,000.00 $ 1,000.00$ 1,000.00$ 1,000.00$4,000.00 $ 400.00700.00$ 1,000.00$ 1,300.00$ 3,400.00 $600.00600.00$ 600.00$ 600.00$ 2,400.00 $ 700.00$ 700.00$ 700.00$ 700.00$ 2,800.00 $600.00 600.00$ 600.00600.00$2,400.00 $ 4,000.004,000.00$ 4,000.00$ 4,000.00 $16,000.00 S1,000.001,000.00$ 1,000.00$1,000.00$ 4,000.00 $ 1,000.001,000.00$ 1,000.00$ 1,000.00 $ 4,000.00 300.00300.00$ 300.00300.001,200.00 $ 1,800.00 $ 700.00700.00$ 700.00$ 700.00$ 2,800.00 $800.00$800.00$ 800.00$ 800.00$ 3,200.00 $ 900.00 900.00$ 900.00900.00 $3,600.00 $ 750.00$ 950.00$ 1,150.00$ 1,350.00$ 4,200.00 $ 700.00700.00$ 700.00$ 700.00$ 2,800.00 $ 2,550.00$ 2,810.00$ 3,127.60$ 4,506.26 $12,993.86 $ 400.00600.00$ 800.00 $ 31 32 33 34 902.78 Average Monthly Receipts 9,749.23 37 Average Monthly Net Income 3,248.46 40Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started