I need a Master Budget: Sales, Cash Collections, Production(Purchase), Production DirectMaterials, Direct Labor, Manufacturing OH, Ending Finished Goods, Selling and Administrative, Cash, Income Statement and Balance Sheet

sales in unit

q1 - 10,000 = 100,000

q2 - 11,000 = 110,000

q3 - 12,000 = 120,000

q4 - 13,000 = 130,000 = total 460,000

year is 46,000 in sales in units

Beginning Accounts Receivable - 100,000 ended with 100,000 for year

Quarter 1 Sales - 160,000 ended with 100,000 for year (60,000+40,000)

Quarter 2 Sales - 106,000 - ended with 110,000 for year (66,000+44,000)

Quarter 3 Sales - 116,000- ended with 120,00 for year 72,000 + 48,000

Quarter 4 Sales - 126,000- ended with 78,000 for year

Total cash collection 508,000