a) Sales budget
July | August | September | Total | |
Sales | 40000 | 50000 | 70000 | 160000 |
b) Production budget
July | August | September | Total | |
Sales | 40000 | 50000 | 70000 | 160000 |
+ closing stock | 20000 | 26000 | 15500 | 61500 |
- opening stock | -17000 | -20000 | -26000 | -63000 |
production | 43000 | 56000 | 59500 | 158500 |
working notes
July | August | September | October | November | |
Sales | 40000 | 50000 | 70000 | 35000 | 20000 |
+ closing stock | 20000 | 26000 | 15500 | 11000 | 8000 |
- opening stock | -17000 | -20000 | -26000 | -15500 | -11000 |
production | 43000 | 56000 | 59500 | 30500 | 17000 |
c) Direct material budget
July | August | September | total | |
production (in pounds) | 129000 | 168000 | 178500 | 475500 |
+ closing inventory | 84000 | 89250 | 45750 | 219000 |
- opening inventory | -64500 | -84000 | -89250 | -237750 |
raw material required | 148500 | 173250 | 135000 | 456750 |
cost($) | 742500 | 866250 | 675000 | 2283750 |
notes
July | August | September | October | |
production (in pounds) | 129000 | 168000 | 178500 | 91500 |
+ closing inventory | 84000 | 89250 | 45750 | 25500 |
- opening inventory | -64500 | -84000 | -89250 | -45750 |
raw material required | 148500 | 173250 | 135000 | 71250 |
cost($) | 742500 | 866250 | 675000 | 356250 |
Need completed in excel format Managerial Accounting: Operating budgets 1. Abe Toys, LLC manufactures and distributes...
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...
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...
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...
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company's products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following Inventory requirements: a. The finished goods Inventory on hand at the end of...
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout Southeast Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company's products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each...
Franklin Products Limited manufactures and distributes a number of products to retailers. One of these products, SuperStick, requires five kilograms of material D236 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 SuperStick 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 goods inventory on hand at the end...
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company's products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of...
Toddler Toys manufactures and distributes a product called Playclay that requires three pounds of material A135 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter. To keep production and shipments moving smoothly, the company has the following inventory requirements: 1. The raw materials inventory on hand at the end of each month must be equal to 5,000 pounds plus one- half of the following month's production needs for raw materials. The...
Daisy Products Limited of Shenzhen, China, manufactures and distributes toys throughout Southeast Asia Three cubic centimetres (CC) of solvent Q80 are required to manufacture each unit of Fineclay, one of the company's products. The company is now planning raw materials needs for the third quarter, the quarter in which peak sales of Fineclay occur. To keep production and sales moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each...
Daisy Products Limited of Shenzhen, China, manufactures and distributes toys throughout Southeast Asia Three cubic centimetres (CC) of solvent Q80 are required to manufacture each unit of Fineclay, one of the company's products. The company is now planning raw materials needs for the third quarter, the quarter in which peak sales of Fineclay occur. To keep production and sales moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each...