please answer using my numbers and information provided. 
The overall purpose of this assignment is to enhance your skills with Excel relating to linking raw data into a schedule that will be useful to managers. It will help you integrate and understand the various components of an operating budget in master budget. Required: Dangate Industries Ltd. produces two (2) products; Dan_A1, and Gate_B2. Information for the products is given in the following table: Input prices Direct materials Base $7 per kg Active $5 per kg Direct manufacturing labour $20 per hour Input quantities per unit of output Dan_A1 Gate B2 Direct materials Base 8 kg 12 kg Active 2 kg 3 kg Direct manufacturing labour-hours 6 hours 9 hours Machine Hours 17 MH 28 MH Inventory information; Direct materials (FIFO) Base Active Beginning inventory 400 kg 100 kg Target ending inventory 600 kg 120 kg Cost of beginning inventory $2,400 $750 Sales and inventory information; Finished goods (FIFO) Dan A1 Gate B2 Expected Sales 850 units 608 units Selling price $350/unit $590/unit Target ending inventory 75 units 65 units Beginning Inventory 50 units 80 units Beginning inventory value $2,500 $9,000 XYZ uses activity-based costing classifying overhead into three pools: Setup $350 per setup hour Processing $4 per machine hour Quality Inspection $30 per inspection hour Cost driver information: A1 20 3 B2 15 3.5 1 2 Number of units per batch Setup time per batch Inspection time per batch Other information Non-production fixed costs (Oct) Salary increase for November Variable non-production cost $150,000; 12 is salaries 1.5% Sales commission 2% of revenue Part A (24 marks) Required: For the month of November, prepare the operating budgets. Your solution needs to #ave the following items labeled in the following order: a. Revenue Budget (2 marks) b. Production Budget (2 marks) c. Direct material usage budget (2 marks) d. Direct material purchase budget (2 marks) e. Direct manufacturing labour budget (2 marks) f. Manufacturing overhead budgets for each of the activities (4 marks) g. Computation of Unit Costs of Finished Goods (2 marks) h. Ending inventory budget (2 marks) i. Cost of Goods Sold budget (2 marks) j. Non-manufacturing costs budget (2 marks) k. Budgeted Income Statement (2 marks) Part A (10 marks) Required: For the month of November, prepare the Cash Budget using the information below in connection with information from your operation budget in Part A. The opening cash balance of Dangate Industry (DI) was $10,000. DI does not make any sales on credit. DI sells only to the public, and accepts cash and credit cards. Of its sales, 50% are to customers using credit cards, for which DI gets the cash right away, less a 2% transaction fee. Purchases of materials are on account. DI pays for half the purchases in the period of the purchase and the other half in the following period. At the end of October, DI owes suppliers $85,000. DI plans to replace a machine in November at a net cash cost of $20,0000. Labour, other production costs, and nonproduction costs are paid in cash in the month incurred except, of course, depreciation, which is not a cash flow. For November, $70,000 of the production cost and $10,000 of the nonproduction cost is depreciation. PT currently has a $40,000 loan at an annual interest rate of 6%. The interest is paid at the end of each month. If DI has more than $10,000 cash at the end of November, it will pay back the loan. PT owes $4,650 in income taxes that need to be remitted in November
