A B 1 2 Budget assumptions: 3 4 Volume 5 Sales Revenue 20,000 cases es $...

Transcribed Image Text:

A B 1 2 Budget assumptions: 3 4 Volume 5 Sales Revenue 20,000 cases es $ 50.00 per case 7 8 6 Percent sold on credit Variable Expenses: 75% percent of sales 9 CGS $ 32.00 per case 10 Sales Commission $ 1.50 per case 11 Shipping Expense $ 3.25 per case 12 Bad Debt Expense 2.00% percent of credit sales 13 14 Fixed Monthly Expenses: 15 Salaries 16 Lease on Distribution center 17 Depreciation on fleet & Equip 18 Advertising 19 Office rent, phone, internet 20 eseses es es $ 50,000 $ 21,000 $ 12,000 $ 8,000 $ 9,500 21 Management by exception: 22 10% OR $7,500 Investigation rule A B 1 2 Budget assumptions: 3 4 Volume 5 Sales Revenue 20,000 cases es $ 50.00 per case 7 8 6 Percent sold on credit Variable Expenses: 75% percent of sales 9 CGS $ 32.00 per case 10 Sales Commission $ 1.50 per case 11 Shipping Expense $ 3.25 per case 12 Bad Debt Expense 2.00% percent of credit sales 13 14 Fixed Monthly Expenses: 15 Salaries 16 Lease on Distribution center 17 Depreciation on fleet & Equip 18 Advertising 19 Office rent, phone, internet 20 eseses es es $ 50,000 $ 21,000 $ 12,000 $ 8,000 $ 9,500 21 Management by exception: 22 10% OR $7,500 Investigation rule