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

The relationship between vanuible manufacturing costs and sales is based on what happened in 2010 Keren though there is again pressure from the discount chins for us 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 (Millions) Cash Receipts From Customers $33.5 Budgeted Inventory Movement Expressed in Wholesale Selling Prices (WSP) 14.2 10 Cash disbursements Variable Manufacturing Fixed Manufacturing Marketing & Promotion General Adininistration Interest Total Disbursements 3.4 13 18 Nail Lipstick Polish Creams SI5.0 $114 $12 B.O 55 60 23.0 159 72 16.0 110 6.5 $ 7.0 S 59 $07 Inventory 12/31/2010 (Actual Planned Production (Not Sales Goods Available for Sale Budgeted Sales Ending Inventory 122.1.2011. (Budget) $21.7 $ 55 335 Beginning Cash Receipts Disbursements Loan Repayment Ending Cash (Budgeted 217 10.0 $ 7.3 Pro-Forma Year-End Balan Sheet Budgeted Cost of Goods Manufactured and Sold Variable Manufacturing Cost Budget) S6B Fixed Manufacturing Cost (Budget) 0.8 Cost of Goods Manufactured 7.6 Inventory 12/31/2010 Actual Cost) 13.6 Goods Available for Sale 21.2 Inventory 12/342011 (Budget 5.6 Budgeted Cost of Goods Sold 5148 544 $ 30 0.8 0.6 5.0 36 95 0.7 4.3 5.4 0.4 $ 92 939 145 $ 7.3 3.0 Assets Cash Miscellaneous Current Assets Inventory Property & Equipment Goodwill Total Asses 124 112 9.3 $43.2 $225 27.2 58 Budgeted Income Statement Sales Cost of Goods Sold Gross Margin Marketing & Promotion General Administration Interest Pretax income 24 1.3 Equities Bank Loan Miscellaneous Contato Common Stock Retained Earning Total Equities 510.3 4,0 12.5 1.8 S103) 10.4 502 The relationship between vanuible manufacturing costs and sales is based on what happened in 2010 Keren though there is again pressure from the discount chins for us 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 (Millions) Cash Receipts From Customers $33.5 Budgeted Inventory Movement Expressed in Wholesale Selling Prices (WSP) 14.2 10 Cash disbursements Variable Manufacturing Fixed Manufacturing Marketing & Promotion General Adininistration Interest Total Disbursements 3.4 13 18 Nail Lipstick Polish Creams SI5.0 $114 $12 B.O 55 60 23.0 159 72 16.0 110 6.5 $ 7.0 S 59 $07 Inventory 12/31/2010 (Actual Planned Production (Not Sales Goods Available for Sale Budgeted Sales Ending Inventory 122.1.2011. (Budget) $21.7 $ 55 335 Beginning Cash Receipts Disbursements Loan Repayment Ending Cash (Budgeted 217 10.0 $ 7.3 Pro-Forma Year-End Balan Sheet Budgeted Cost of Goods Manufactured and Sold Variable Manufacturing Cost Budget) S6B Fixed Manufacturing Cost (Budget) 0.8 Cost of Goods Manufactured 7.6 Inventory 12/31/2010 Actual Cost) 13.6 Goods Available for Sale 21.2 Inventory 12/342011 (Budget 5.6 Budgeted Cost of Goods Sold 5148 544 $ 30 0.8 0.6 5.0 36 95 0.7 4.3 5.4 0.4 $ 92 939 145 $ 7.3 3.0 Assets Cash Miscellaneous Current Assets Inventory Property & Equipment Goodwill Total Asses 124 112 9.3 $43.2 $225 27.2 58 Budgeted Income Statement Sales Cost of Goods Sold Gross Margin Marketing & Promotion General Administration Interest Pretax income 24 1.3 Equities Bank Loan Miscellaneous Contato Common Stock Retained Earning Total Equities 510.3 4,0 12.5 1.8 S103) 10.4 502