Tobin’s Frozen Pizza Inc. has determined from its productionbudget the following estimated production volumes for 12'' and 16''frozen pizzas for November:

	Units
	12" Pizza		16" Pizza
Budgeted production volume	76,000		56,000

There are three direct materials used in producing the two typesof pizza. The quantities of direct materials expected to be usedfor each pizza are as follows:

		12" Pizza		16" Pizza
Direct materials:
	Dough	0.55	lb. 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 informationabout each material:

	Dough		Tomato		Cheese
Estimated inventory, November 1	2,200	lbs.	1,000	lbs.	3,300	lbs.
Desired inventory, November 30	2,100	lbs.	1,000	lbs.	2,700	lbs.
Price per pound	$0.60		$0.70		$0.95

This information has been collected in the Microsoft ExcelOnline file. Open the spreadsheet, perform the required analysis,and input your answers in the question below.

Open spreadsheet

Prepare November's direct materials purchases budget for Tobin’sFrozen Pizza Inc. For those boxes in which you must entersubtracted or negative numbers use a minus sign. Round your finalanswers to the nearest dollar.

Tobin’s Frozen Pizza Inc.
Direct Materials PurchasesBudget
For the Month Ending November30
	Dough		Tomato		Cheese		Total
Units required for production:
12" pizza
16" pizza
Total units available
Total units to be purchased
Unit price	x	$	x	$	x	$
Total direct materials to be purchased		$		$		$		$