Answered step by step
Verified Expert Solution
Link Copied!

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...

image text in transcribed

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 40

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions