60.1K

Verified Solution

Link Copied!

Need help with the formulas on each section.

Total Spent for First Total Budgeted Total Budget Actual % spent at Department % 3 Quarters Amount through Q3 end of Q3 Meat 25% $112,500 $125,000.00 $93,750.00 Dairy 15% $48,750 $75,000.00 $56,250.00 Produce 15% $75,000 $75,000.00 $56,250.00 Dry Goods 30% $131,250 $150,000.00 $112,500.00 Nutritional Supplements and Tube Feedings 5% $37,500 $25,000.00 $18,750.00 Paper/Disposables 5% $26,250 $25,000.00 $18,750.00 Chemicals 5% $30,000 $25,000.00 $18,750.00 Totals $461,250 $500,000.00 $375,000.00 Q3 Spending/ Q3 Budget Difference between % spent and % budget for whole year Total Remaining % Remaining Budget Budget $12,500.00 $26,250.00 $0.00 $18,750.00 $12,500.00 $1,250.00 $5,000.00 $38,750.00 Total Spent for First Total Budgeted Total Budget Actual % spent at Department % 3 Quarters Amount through Q3 end of Q3 Meat 25% $112,500 $125,000.00 $93,750.00 Dairy 15% $48,750 $75,000.00 $56,250.00 Produce 15% $75,000 $75,000.00 $56,250.00 Dry Goods 30% $131,250 $150,000.00 $112,500.00 Nutritional Supplements and Tube Feedings 5% $37,500 $25,000.00 $18,750.00 Paper/Disposables 5% $26,250 $25,000.00 $18,750.00 Chemicals 5% $30,000 $25,000.00 $18,750.00 Totals $461,250 $500,000.00 $375,000.00 Q3 Spending/ Q3 Budget Difference between % spent and % budget for whole year Total Remaining % Remaining Budget Budget $12,500.00 $26,250.00 $0.00 $18,750.00 $12,500.00 $1,250.00 $5,000.00 $38,750.00

Answer & Explanation Solved by verified expert

See Answer