Instructions: Refer to detailed instractions on the previous tab. Complete the problems below. BOLD BLACK numbers come directly from the case and cannot be changed. Cells with thick t borders around them contain formulas which help to solve the problem. Please do not delete the formulas, 4You will find it useful to input your own formulas to solve the problems (instead of using a calculator and inputting only solutions), 5 Exhibit 1 Activity 7 Purchasing Material Handling 9 Blending 10 Freezing 11 Packaging 12 Quality Control Cost Driver Budget PDOH $80,000 Purchase Orders 909 $88.01 per order $95,000 Set Ups 1846 $51.46 per set up $122,000 Blender Hours 1000 $175,000 Freezer Hours 1936 $110,000 Packing Machine Hours 1100 $18,000 Batches 286 per blender hour per freezer hour per packaging hour per batch 13 14 Exhibit 2 15 Break Out Polynesian 16 General Information: 17 Direct Material $2.00 per gallon 18 Direct Labor 19 20 Budgeted Production $1.20 per gallon 2,000 gallons Vanilla $1.80 per gallon $1.20 per gallon 100,000 gallons PDOHTtion Coming $2.00 per DLS 21 Activity Based Costing Information: 22 23 24 Number of Batches 20 batches: Set Ups 3 per batch Number of Purchas Orders 40 purchase orders 25 26 Blender Time 0.006 hours per gallon $2.00 per DLS 40 batches 3 per batch. 100 purchase orders 0.003 hours per gallon. Freezer Time 0.010 hours per gallon 0.010 hours per gallon 27 Packaging Machine Time 0.003 hours per gallon 0.002 hours per gallon " Required Traditional Conting 12 Dun Matlas 34 Al Offe 15 Cat Reprised 7 Activity Based Costing Method ADC Contin Det Materials Dict Laber Poly 40000 Polynesian Neraber of Purche Orders 800 Nber of St Boder Hours th Free Hours Used Packing Machine Has sed Number of Bates V $13000000 118000000 Vanilla Nase of Parchese Order Parking Machine Hous SO POO- p P O Noop Applied C the number of purch sir $8 Parcher Parchan Cyfers-poll ABC Casting Duct Meals Dinet Labor of Call fotal CGallon Packing Machine Hoses Used DIVAR Moped