preparw new set of of budgets :icone statment , cash flow and balance sheet

con variable manufacturing cus und sales is based on what happened in 2010 aven though there is again pressure free the discount chains for to reduce our prices) Exhibit 2: Luxor Cosmetics Initial Budget for 2011 Incorporating Susan's Recommended Inventory Reduction (S Millions) (continued) Cash Flow Budget Exhibit 2: Luxor Cosmetics Initial Budget for 2011 Incorporating Susan's Recommended Inventory Reduction (S Millions) Cash Receipts From Customers $33.5 Budgeted Inventory Movement: Expressed in Wholesale Selling Prices (WSP) Cash disbursements Variable Manufacturing Fixed Manufacturing Marketing & Promotion General Administration Interest Total Disbursements 142 10 34 1.3 18 Nail Lipstick Polish Creams $15.0 $114 $ 1.2 80 60 23.0 16,9 7.2 18.0 110 6,5 $ 70 $ 59 $0.2 55 Inventory 12/31/2010 (Actual) Planned Production (Not Sales Goods Available for Sale Budgeted Sales Ending Inventory 12/31/2011(Budget 3212 $ 55 335 Beginning Cash Receipts Disbursements Loan Repayment Ending Cash (Budgeted! 21.7 100 $ 7.3 Budgeted Cost of Goods Manufactured and Sold Variable Manufacturing Cost Budget) SBB Fixed Manufacturing Cost (Budget) 018 Cast of Goods Manufactured 7.5 Inventory 12/31/2010 (Actual Costi 13.6 Goods Available for Sale 212 Inventory 12/31/2011 (Budget) 8.6 Budgeted Cost of Goods Sold $145 Pro-Forma Year End Balance Sheet 544 08 50 98 148 54 3.9.2 S 30 0.8 2.5 0.7 4.3 0.4 Assets Cash Miscellaneous Current Assets Inventory Property & Equipment Goodwill Total Asset $ 7.3 20 124 $ 39 112 93 SOZ Budgeted Income Statement Sales Cost of Goods Sold Gross Margin Marketing & Promotion General Administration Interest Pretax Income $35 27.7 5.8 3.4 12 La $10. $15.3 Equities Bank Loan Miscellaneous Current Lab Common Stock Retained Earn Total que 10 125 10.4 $43.2 IMA EDUCATIONAL CASE JOURNAL 5 VOL. 2. NDARJUNE con variable manufacturing cus und sales is based on what happened in 2010 aven though there is again pressure free the discount chains for to reduce our prices) Exhibit 2: Luxor Cosmetics Initial Budget for 2011 Incorporating Susan's Recommended Inventory Reduction (S Millions) (continued) Cash Flow Budget Exhibit 2: Luxor Cosmetics Initial Budget for 2011 Incorporating Susan's Recommended Inventory Reduction (S Millions) Cash Receipts From Customers $33.5 Budgeted Inventory Movement: Expressed in Wholesale Selling Prices (WSP) Cash disbursements Variable Manufacturing Fixed Manufacturing Marketing & Promotion General Administration Interest Total Disbursements 142 10 34 1.3 18 Nail Lipstick Polish Creams $15.0 $114 $ 1.2 80 60 23.0 16,9 7.2 18.0 110 6,5 $ 70 $ 59 $0.2 55 Inventory 12/31/2010 (Actual) Planned Production (Not Sales Goods Available for Sale Budgeted Sales Ending Inventory 12/31/2011(Budget 3212 $ 55 335 Beginning Cash Receipts Disbursements Loan Repayment Ending Cash (Budgeted! 21.7 100 $ 7.3 Budgeted Cost of Goods Manufactured and Sold Variable Manufacturing Cost Budget) SBB Fixed Manufacturing Cost (Budget) 018 Cast of Goods Manufactured 7.5 Inventory 12/31/2010 (Actual Costi 13.6 Goods Available for Sale 212 Inventory 12/31/2011 (Budget) 8.6 Budgeted Cost of Goods Sold $145 Pro-Forma Year End Balance Sheet 544 08 50 98 148 54 3.9.2 S 30 0.8 2.5 0.7 4.3 0.4 Assets Cash Miscellaneous Current Assets Inventory Property & Equipment Goodwill Total Asset $ 7.3 20 124 $ 39 112 93 SOZ Budgeted Income Statement Sales Cost of Goods Sold Gross Margin Marketing & Promotion General Administration Interest Pretax Income $35 27.7 5.8 3.4 12 La $10. $15.3 Equities Bank Loan Miscellaneous Current Lab Common Stock Retained Earn Total que 10 125 10.4 $43.2 IMA EDUCATIONAL CASE JOURNAL 5 VOL. 2. NDARJUNE