eBook Show Me How Omice 365 Calculator Direct materials purchases budget Tobin's Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 12" and 16" frozen pizzas for November: Units 12" Pla 16" Plaza Budgeted production volume 61,000 41,000 There are three direct materials used in producing the two types of pizza. The quantities of direct materials expected to be used for each pizza are as follows: 12" Plaza 16" Plum Direct materials: Dough 0.55 . per unit 0.80 lbs. per unit Tomato 0.25 0.40 Cheese 0.70 1.20 In addition, Tobin's has determined the following information about each material: Dough Tomato Cheese Estimated inventory, November 1 2.200 lbs. 1,200 lbs. 2,700 lbs. Desired Inventory, November 30 1,900 1.100 lbs 2,700 lbs Price per pound $0.40 $0.50 $0.75 This information has been collected in the Microsoft Excel Online file Open the spreadsheet, perform the required analysis, and input your answers in the question below Open spreadsheet Prepare November's direct material purchases budget for Tobin's Frozen Inc. For those boxes in which you must enter subtracted or negative numbers use a min sign. Round your final answers to the nearest dolar Previous Next AWO Email Save and Ex Submit Assignment for Grading MacBook Air 80 GOO 14 41 19 FO 12 A # 3 % 5 4 6 * CO 7 9 E R T Y Y U O D F G H