+ 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 Active $7 per kg $5 per kg Direct manufacturing labour $20 per hour Input quantities per unit of output Dan_A1 Gate_B2 Direct materials 8 kg 12 kg Base Active 2 kg 3 kg Direct manufacturing labour-hours 6 hours 17 MH 9 hours 28 MH Machine Hours Inventory information; Direct materials (FIFO) Beginning inventory Target ending inventory Cost of beginning inventory Base Active 400 kg 100 kg 600 kg 120 kg $2,400 $750 Sales and inventory information; Finished goods (FIFO) Expected Sales Selling price Target ending inventory Beginning Inventory Beginning inventory value Dan Al 850 units $350/unit 75 units 50 units $2,500 Gate B2 608 units $590/unit 65 units 80 units $9,000 XYZ uses activity-based costing classifying overhead into three pools: Setup Processing Quality Inspection $350 per setup hour $4 per machine hour $30 per inspection hour