prepare operational budget

Q1: Prepare a purchases budget for Graham Murray for the periods January-June, July- MR FER December and for the calendar year. Use the following data: Budgeted sales income (in $000s) is: Jan - Jun 2,200 Jul - Dec 3,600 Jan - Jun (following year) 2,800 Selling price per unit is 200% of cost price. The value of opening inventory for each period should be 25% of the budgeted cost of sales for that period. Purchases Budgets for This Year (First Half, Second Half and Total) Current Year Next Year Current Year 2200 3600 2800 Jan-June July-Dec Jan-June TOTAL Expected Sales 4400 7200 5600 11600 425 COGS dos Closing Inventory Goods available Opening Inventory 257, Purchases