In: Accounting
#2
Direct Materials Purchases Budget
Romano’s Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 12'' and 16'' frozen pizzas for September:
| Units | ||||
| 12" Pizza | 16" Pizza | |||
| Budgeted production volume | 15,300 | 21,700 | ||
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" Pizza | 16" Pizza | ||||
| Direct materials: | |||||
| Dough | 0.90 | lb. per unit | 1.50 | lbs. per unit | |
| Tomato | 0.60 | 1.00 | |||
| Cheese | 0.80 | 1.30 | |||
In addition, Romano's has determined the following information about each material:
| Dough | Tomato | Cheese | ||||
| Estimated inventory, September 1 | 590 | lbs. | 220 | lbs. | 300 | lbs. | 
| Desired inventory, September 30 | 620 | lbs. | 210 | lbs. | 330 | lbs. | 
| Price per pound | $1.10 | $2.30 | $3.10 | |||
Prepare September's direct materials purchases budget for Romano’s Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
| Romano’s Frozen Pizza Inc. | ||||
| Direct Materials Purchases Budget | ||||
| For the Month Ending September 30 | ||||
| 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 | $ | $ | $ | $ | 
| 
 Romano’s Frozen Pizza Inc.  | 
||||
| 
 Direct Materials Purchases Budget  | 
||||
| 
 For the Month Ending September 30  | 
||||
| 
 Dough  | 
 Tomato  | 
 Cheese  | 
 Total  | 
|
| 
 Units required for production:  | 
||||
| 
 12" pizza  | 
 13770  | 
 9180  | 
 12240  | 
 35190  | 
| 
 16" pizza  | 
 32550  | 
 21700  | 
 28210  | 
 82460  | 
| 
 Add: Desired ending Inventory  | 
 620  | 
 210  | 
 330  | 
 1160  | 
| 
 Total units available  | 
 590  | 
 220  | 
 300  | 
 1110  | 
| 
 Total units to be purchased  | 
 46350  | 
 30870  | 
 40480  | 
 117700  | 
| 
 Unit Price  | 
 $ 1.10  | 
 $ 2.30  | 
 $ 3.10  | 
|
| 
 Total direct materials to be purchased  | 
 $ 50,985.00  | 
 $ 71,001.00  | 
 $ 125,488.00  | 
 $247,474.00  | 
Working
| 
 Romano’s Frozen Pizza Inc.  | 
|||||
| 
 Direct Materials Purchases Budget  | 
|||||
| 
 For the Month Ending September 30  | 
|||||
| 
 Dough  | 
 Tomato  | 
 Cheese  | 
 Total  | 
||
| 
 Units required for production:  | 
|||||
| 
 A  | 
 12" pizza  | 
 13770  | 
 9180  | 
 12240  | 
 35190  | 
| 
 B  | 
 16" pizza  | 
 32550  | 
 21700  | 
 28210  | 
 82460  | 
| 
 C  | 
 Add: Desired ending Inventory  | 
 620  | 
 210  | 
 330  | 
 1160  | 
| 
 D  | 
 Total units available  | 
 590  | 
 220  | 
 300  | 
 1110  | 
| 
 E=A+B+C-D  | 
 Total units to be purchased  | 
 46350  | 
 30870  | 
 40480  | 
 117700  | 
| 
 F  | 
 Unit Price  | 
 $ 1.10  | 
 $ 2.30  | 
 $ 3.10  | 
|
| 
 G=E x F  | 
 Total direct materials to be purchased  | 
 $ 50,985.00  | 
 $ 71,001.00  | 
 $ 125,488.00  | 
 $247,474.00  |