Budgeting Assignment IBL company manufactures fumiture. Budgeted sales for 4 months are given below and the table also include selling price Months Quarter 2 Budgeted sales (units) April 1500 May 2800 June 3200 August 3500 Selling price $ 150 Each piece of furniture requires 10 square feet of wood which cost $4.00 per square feet. The targeted beginning inventory equals to 15% of next month's sale. Inventory at April 1st consisted of 120 pieces of furniture, The company decides ot keep an inventory of wood equal to 25% of next month requirements. Materials inventory on April 1st consisted of 3800 sq feet of wood. The company estimates an inventory of wood on hand at the end of June of approximately 2500 sq feet of wood. It takes about 4 hours of direct labour to make one furniture. The workers are paid $11.50 per hour Below is listed the variable and fixed manufacturing overhead $1.50 $3200 Variable manufacturing overhead Unit variable overhead cost Fixed manufacturing overhead Security Guard wages Depreciation of factory building Depreciation of factory equipment Factory rent expense Utilities expense (factory) S 1500 $850 $1450 $350 The following additional information is provided for making the pro-forma income statement S 7800 Beginning finished goods Ending finished goods Selling expenses $ 4000 $ 6200 Admin expenses $5100 Interest Rate 4% Tax Rate 15% Interest bearing debt $ 15,000 REQUIRED 1. Prepare a sales budget in S for each month and in total of Quarter 2 2. Prepare a production budget in units for each month and in total of Quarter 2. 3. Prepare a purchases budget in $ for direct materials for each month in total Quarter 2 4. Prepare a direct Labour budget for each month and in total for the Quarter 2 5. Prepare a manufacturing overhead budget for each month and in total for Quarter 2 6. Prepare the total cost of goods sold for the quarter 7. Make a pro-forma income statement for the quarter 8. Calculate the unit cost of the furniture and calculate the margin charged on the item