prepare the operating budget for the XYZ Company

B6 A C F XYZ Company 1 Sales Budget 2 For October, November, December 2013 4 October November December Total 5 6 Cash Sales (35%) 7 Credit Sales (65%) 8 Total Sales 10 Assumptions 11 September Sales=$68,000 12 October Sales increase by 2 % 13 November Sales increase by 1% from October 14 December Sales increase by 2.5% from November Operating Expense Bud... Cost of Goods Sold Budget Sales Budget Pro Forma Income Statement Enter Et e Fle ome Currency Wap let A A 12 Calibri OCopy - A - Merge & Centes Paste Farmat Painler Mumbri Font Aignment Clipboard x XYZ Company 1 Pro Forma Income Statement 2 Quarter Ending December 31, 2013 Vertical Analysis 3 4 5 Sales 6 Cost of Goods Sold 7 Gross Profit 8 Operating Expenses: 9 Salaries Expense 10 Depreciation Expense 11 Other Operating Expenses 12 Total Expenses 13 Net Income Operating Exper Cost of Goods Sold Budget Sales Budget Pro Forma Income Statement Ready O Type here to search ste Format Painter Clipboard Alignment Font Number 16 A XYZ Company Cost of Goods Sold Budget For October, November, December 2013 October November December Total Cost of Goods Sold Desired Ending Inventory Total Inventory Required Less Beginning Inventory Purchases Required BAssumptions 4 Cost of Goods Sold=60% of Sales 5September Ending Inventory=$42,000 Desired Ending Inventory=$15,000+70% of Cost of Goods Sold for Current Month Operating Expense E Cost of Goods Sold Budget Sales Budget Pro Forma Income Statement ady Type here to search E15 D B XYZ Company Operating Expense Budget For October, November, December 2013 2 3 November Total October December 5 6 Salaries Expense 7 Depreciation Expense 8 Other Operating Expenses 9 Total Operating Expenses 10 11 12 Assumptions 13 Salaries Expense=15% of Sales 14 Depreciation Expense-$2,000 per month 15 Other Operating Expenses=10% of Sales 16 17 Operating Expense Budget Cost of Goods Sold Budget Sales Budget Deadu