In: Accounting
Lorenzo’s Frozen Pizza Inc. has determined from its A budget of estimated unit production.production budget the following estimated production volumes for 12'' and 16'' frozen pizzas for September:
| Units | ||||
| 12" Pizza | 16" Pizza | |||
| Budgeted production volume | 13,300 | 23,500 | ||
Three direct materials are 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.80 | lb. per unit | 1.50 | lb. per unit | |
| Tomato | 0.50 | 0.70 | |||
| Cheese | 0.70 | 1.30 | |||
In addition, Lorenzo’s has determined the following information about each material:
| Dough | Tomato | Cheese | ||||
| Estimated inventory, September 1 | 530 | lb. | 220 | lb. | 320 | lb. |
| Desired inventory, September 30 | 560 | lb. | 210 | lb. | 350 | lb. |
| Price per pound | $1.30 | $2.60 | $3.00 | |||
Prepare September's direct materials purchases budget for Lorenzo’s Frozen Pizza Inc. When required, enter unit prices to the nearest cent.
| Lorenzo’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 pounds required | ||||
|
||||
| Total units to be purchased | ||||
| Unit price | x $ | x $ | x $ | |
| Total direct materials to be purchased | $ | $ | $ | $ |
|
Direct Materials Purchases Budget |
||||
|
For the Month Ending September 30 |
||||
|
Dough |
Tomato |
Cheese |
Total |
|
|
Units required for production: |
||||
|
12" pizza |
10,640 |
6,650 |
9,310 |
26,600 |
|
16" pizza |
35,250 |
16,450 |
30,550 |
82,250 |
|
Desired inventory, Sept 30 |
560 |
210 |
350 |
|
|
Total units available |
46,450 |
23,310 |
40,210 |
109,970 |
|
Less: Estimated inventory, Sept 1 |
530 |
220 |
320 |
|
|
Total units to be purchased |
45,920 |
23,090 |
39,890 |
108,900 |
|
Unit Price |
$ 1.30 |
$ 2.60 |
$ 3.00 |
|
|
Total direct materials to be purchased |
$ 59,696.00 |
$ 60,034.00 |
$ 119,670.00 |
$ 239,400.00 |