Solution
BreadMaster
Breadmaster |
||||
Direct Materials Budget |
||||
For the Months of July through September |
||||
July |
August |
September |
Quarter |
|
Units to be produced |
1,540 |
1,820 |
1,660 |
5,020 |
flour needed in pounds |
0.5 |
0.5 |
0.5 |
0.5 |
Quantity needed for production (pounds) |
770 |
910 |
830 |
2,510 |
add: desired ending inventory of direct materials |
182 |
166 |
146 |
|
total quantity needed (pounds) |
952 |
1,076 |
976 |
|
Less: beginning inventory of direct materials |
154 |
182 |
166 |
|
total quantity needed to produce (pounds) |
798 |
894 |
810 |
2,502 |
cost per pounds |
$2 |
$2 |
$2 |
$2 |
Total cost of direct material purchases |
$1,596 |
$1,788 |
$1,620 |
$5,004 |
Computations:
July = 1,540 loaves x 0.5 pounds = 770 pounds
August = 1,820 loaves x 0.5 pounds = 910 pounds
September = 1,660 loaves x 0.5 pounds = 830 pounds
July = 20% x August’s needs = 0.2 x 910 = 182pounds
August = 20% x Sept’s needs = 0.2 x 830 = 166 pounds
September = 20% x October’s needs = 20% x (1,460 loaves x 0.5 pounds) = 146 pounds
July = 20% of July needs = 0.2 x 770 = 154 pounds
August = ending inventory of July = 182 pounds
September = ending inventory of August = 166 pounds
Breadmaster produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a...
The Bakery on the Riverbank produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a pound of flour. The bakery pays $3.00 per pound of the organic flour used in its loaves. The bakery expects to produce the following number of loaves in each of the upcoming four months: E(Click the icon to view the units to be produced.) The bakery has a policy that it will have 20% of the following month's flour needs...
The Bakery at the Lake produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a pound of flour. The bakery pays $2.00 per pound of the organic flour used in its loaves. The bakery expects to produce the following number of loaves in each of the upcoming four months: E: (Click the icon to view the units to be produced.) The bakery has a policy that it will have 20% of the following month's flour...
The Bakery with a View produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a pound of flour. The bakery pays $3.00 per pound of the organic flour used in its loaves. The bakery expects to produce the following number of loaves in each of the upcoming four months: 2 (Click the icon to view the units to be produced.) The bakery has a policy that it will have 20% of the following month's flour...
The Bakery with a View produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a pound of flour. The bakery pays $3.00 per pound of the organic flour used in its loaves. The bakery expects to produce the following number of loaves in each of the upcoming four months: EEE (Click the icon to view the units to be produced.) bakery has a policy that it will have 20% of the follow ng month's flour...
The Bakery with a View produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a pound of flour. The bakery pays $3.00 per pound of the organic flour used in its loaves. The bakery expects to produce the following number of loaves in each of the upcoming four months: E: (Click the icon to view the units to be produced.) The bakery has a policy that it will have 20% of the following month's flour...
The Bakery at the Ocean produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a pound of flour. The bakery pays $3.50 per pound of the organic flour used in its loaves. The bakery expects to produce the following number of loaves in each of the upcoming four months: EEB Click the icon to view the units to be produced.) The bakery has a policy that it will have 20% of the following month's flour...
Answer in excel Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products. Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The...
Managerial Accounting Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products, Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July, August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. b. The finished goods...
Managerial Accounting: Operating budgets 1. Abe Toys, LLC manufactures and distributes a number or products to retailers. One of these products, Playclay, requires three pounds of materials A135 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July, August, and September. Peak sales of Playclay occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The finished...
Need completed in excel format Managerial Accounting: Operating budgets 1. Abe Toys, LLC manufactures and distributes a number or products to retailers. One of these products, Playclay, requires three pounds of materials A135 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July, August, and September. Peak sales of Playclay occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following...