Question
Tyson Chandler Companys sales budget projects unit sales of part 198Z of 9,900 units in January, 11,700 units in February, and 13,200 units in March.
Tyson Chandler Companys sales budget projects unit sales of part 198Z of 9,900 units in January, 11,700 units in February, and 13,200 units in March. Each unit of part 198Z requires 2 kg of materials, which cost $3 per kilogram. Tyson Chandler Company wants its ending raw materials inventory to equal 40% of the next months production requirements, and its ending finished goods inventory to equal 25% of the next month's expected unit sales. These goals were met at December 31, 2019.
Prepare a production budget for January and February 2020.
TYSON CHANDLER COMPANY Production Budget-198Z For the Two Months Ending February 29, 2020 | |||||||
Month | |||||||
Jan | Feb | Total | |||||
Total Required UnitsBeginning Finished Goods InventoryDesired Ending Finished GoodsExpected Unit SalesRequired Productions In Units | |||||||
AddLess: Required Productions In UnitsTotal Required UnitsBeginning Finished Goods InventoryExpected Unit SalesDesired Ending Finished Goods | |||||||
Expected Unit SalesDesired Ending Finished GoodsTotal Required UnitsBeginning Finished Goods InventoryRequired Productions In Units | |||||||
AddLess: Total Required UnitsDesired Ending Finished GoodsBeginning Finished Goods InventoryRequired Productions In UnitsExpected Unit Sales | |||||||
Beginning Finished Goods InventoryDesired Ending Finished GoodsExpected Unit SalesRequired Productions In UnitsTotal Required Units |
Prepare a direct materials budget for January 2020.
TYSON CHANDLER COMPANY Direct Materials Budget (kgs) For the Month Ending January 31, 2020 | |||
Total | |||
Beginning InventoryTotal Cost Of Materials PurchasesTotal Materials RequiredMaterials Purchases In UnitsDirect Materials Per Unit (kg)Units To Be ProducedDesired Ending InventoryCost Per KilogramTotal Required For Production | |||
Materials Purchases In UnitsTotal Required For ProductionDirect Materials Per Unit (kg)Total Cost Of Materials PurchasesCost Per KilogramDesired Ending InventoryBeginning InventoryUnits To Be ProducedTotal Materials Required | |||
Total Materials RequiredTotal Cost Of Materials PurchasesDirect Materials Per Unit (kg)Desired Ending InventoryBeginning InventoryCost Per KilogramUnits To Be ProducedMaterials Purchases In UnitsTotal Required For Production | |||
AddLess: Total Materials RequiredTotal Cost Of Materials PurchasesCost Per KilogramUnits To Be ProducedBeginning InventoryDesired Ending InventoryDirect Materials Per Unit (kg)Materials Purchases In UnitsTotal Required For Production | |||
Total Cost Of Materials PurchasesBeginning InventoryCost Per KilogramTotal Materials RequiredMaterials Purchases In UnitsDirect Materials Per Unit (kg)Units To Be ProducedDesired Ending InventoryTotal Required For Production | |||
AddLess: Beginning InventoryCost Per KilogramDirect materials purchasesTotal Cost Of Materials PurchasesDirect Materials Per Unit (kg)Total Materials RequiredDesired Ending InventoryUnits To Be ProducedTotal Required For Production | |||
Desired Ending InventoryTotal Required For ProductionUnits To Be ProducedTotal Cost Of Materials PurchasesDirect Materials Per Unit (kg)Beginning InventoryMaterials Purchases In UnitsCost Per KilogramTotal Materials Required | |||
Total Materials RequiredDirect Materials Per Unit (kg)Materials Purchases In UnitsUnits To Be ProducedTotal Cost Of Materials PurchasesCost Per KilogramDesired Ending InventoryBeginning InventoryTotal Required For Production | $ | ||
Units To Be ProducedDesired Ending InventoryDirect Materials Per Unit (kg)Materials Purchases In UnitsTotal Materials RequiredTotal Required For ProductionTotal Cost Of Materials PurchasesBeginning InventoryCost Per Kilogram | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started