In: Accounting
Direct Materials Purchases Budget
Marino's Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 12'' and 16'' frozen pizzas for June 2016:
| 
 Units  | 
||||
| 
 12" Pizza  | 
 16" Pizza  | 
|||
| 
 Budgeted production volume  | 
 14,100  | 
 20,500  | 
||
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, Marino's has determined the following information about each material:
| 
 Dough  | 
 Tomato  | 
 Cheese  | 
||||
| 
 Estimated inventory, June 1, 2016  | 
 610  | 
 lbs.  | 
 230  | 
 lbs.  | 
 320  | 
 lbs.  | 
| 
 Desired inventory, June 30, 2016  | 
 640  | 
 lbs.  | 
 220  | 
 lbs.  | 
 350  | 
 lbs.  | 
| 
 Price per pound  | 
 $1.3  | 
 $2.1  | 
 $3.3  | 
|||
Prepare June's direct materials purchases budget for Marino's Frozen Pizza Inc. When required, enter unit prices to the nearest cent.
| 
 Marino's Frozen Pizza Inc.  | 
||||
| 
 Direct Materials Purchases Budget  | 
||||
| 
 For the Month Ending June 30, 2016  | 
||||
| 
 Dough  | 
 Tomato  | 
 Cheese  | 
 Total  | 
|
| 
 Units required for production:  | 
||||
| 
 12" pizza  | 
||||
| 
 16" pizza  | 
||||
| 
 Total  | 
||||
| 
 Total units to be purchased  | 
||||
| 
 Unit price  | 
 x $  | 
 x $  | 
 x $  | 
|
| 
 Total direct materials to be purchased  | 
 $  | 
 $  | 
 $  | 
 $  | 
| Marino's Frozen Pizza Inc. | ||||||||
| Direct Materials Purchases Budget | ||||||||
| For the Month Ending June 30, 2016 | ||||||||
| Dough | Tomato | Cheese | Total | |||||
| Units required for production: | ||||||||
| 12" pizza (14,100) | 12,690 | 8,460 | 11,280 | 32,430 | ||||
| 16" pizza (20,500) | 30,750 | 20,500 | 26,650 | 77,900 | ||||
| Total | 43,440 | 28,960 | 37,930 | |||||
| Total units to be purchased | 43,470 | 28,950 | 26,680 | 99,100 | ||||
| Unit price | $ 1.30 | $ 2.10 | $ 3.30 | |||||
| Total direct materials to be purchased | $ 56,511 | $ 60,795 | $ 88,044 | 205,350 | ||||
| Working Note: | ||||||||
| 1) | Calculation for total units to be purchased: | |||||||
| Dough | Tomato | Cheese | ||||||
| Desired inventory, June 30, 2016 | 640 | 220 | 350 | |||||
| Add: Units required for production | 43,440 | 28,960 | 26,650 | |||||
| 44,080 | 29,180 | 27,000 | ||||||
| Less: Estimated inventory, June 1, 2016 | 610 | 230 | 320 | |||||
| Total direct material to be purchased | 43,470 | 28,950 | 26,680 | |||||