Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Direct materials purchases budget Tobin s Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 1 2 ' '
Direct materials purchases budget Tobins Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for and frozen pizzas for November: Line Item Description Units Pizza Units Pizza Budgeted production volume 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: Line Item Description Pizza Pizza Direct materials: Dough lb per unit lb per unit Tomato Cheese In addition, Tobin's has determined the following information about each material: Line Item Description Dough Tomato Cheese Estimated inventory, November lbs lbs lbs Desired inventory, November lbs lbs lbs Price per pound $ $ $ 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 materials purchases budget for Tobins Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Round your final answers to the nearest dollar. Tobins Frozen Pizza Inc. Direct Materials Purchases Budget For the Month Ending November Line Item Description Dough Tomato Cheese Total Units required for production: pizza fill in the blank fill in the blank fill in the blank pizza fill in the blank fill in the blank fill in the blank fill in the blank fill in the blank fill in the blank Total units available fill in the blank fill in the blank fill in the blank fill in the blank fill in the blank fill in the blank Total units to be purchased fill in the blank fill in the blank fill in the blank Unit price times $ fill in the blank times $ fill in the blank times $ fill in the blank Total direct materials to be purchased $ fill in the blank
Direct materials purchases budget
Tobins Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for and frozen pizzas for November:
Line Item Description Units Pizza Units Pizza
Budgeted production volume
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:
Line Item Description Pizza Pizza
Direct materials:
Dough lb per unit lb per unit
Tomato
Cheese
In addition, Tobin's has determined the following information about each material:
Line Item Description Dough Tomato Cheese
Estimated inventory, November lbs lbs lbs
Desired inventory, November lbs lbs lbs
Price per pound $ $ $
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 materials purchases budget for Tobins Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Round your final answers to the nearest dollar.
Tobins Frozen Pizza Inc.
Direct Materials Purchases Budget
For the Month Ending November Line Item Description Dough Tomato Cheese Total
Units required for production:
pizza
fill in the blank
fill in the blank
fill in the blank
pizza
fill in the blank
fill in the blank
fill in the blank
fill in the blank
fill in the blank
fill in the blank
Total units available
fill in the blank
fill in the blank
fill in the blank
fill in the blank
fill in the blank
fill in the blank
Total units to be purchased
fill in the blank
fill in the blank
fill in the blank
Unit price times $
fill in the blank
times $
fill in the blank
times $
fill in the blank
Total direct materials to be purchased $
fill in the blank
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started