Take A Seat manufactures sofas. Each sofa requires 20 linear feet of lumber and 100 square feet
Question:
Take A Seat manufactures sofas. Each sofa requires 20 linear feet of lumber and 100 square feet of material and cushioning to manufacture. There is currently 150 linear feet of lumber, 500 square feet of materials and 10 finished sofas in inventory. Lumber sells for $1.50 per linear foot and materials sell for $3.50 per square foot. For the upcoming month of April, 2020, Take A Seat plans to sell 50 sofas.
At the end of the month, Take A Seat would like to have 100 linear feet of lumber, 300 square feet of materials and 5 sofas in inventory.
Create production and purchases budget for the month of April.
Do not enter dollar signs or commas in the input boxes.
Round all answers to the nearest whole number.
Use the negative sign for any values that must be subtracted.
Take A Seat | |||||
Production Budget | |||||
For the Month of April, 2020 | |||||
Sofa | Lumber | Material | |||
Budgeted Sales Volume | Answer | Budgeted Production Units | Answer | Budgeted Production Units | Answer |
Budgeted Ending Inventory | Answer | Lumber per Sofa | Answer | Materials per Sofa | Answer |
Budgeted Beginning Inventory | Answer | Budgeted Lumber to be Used (ft) | Answer | Budgeted Material to be Used (sq ft) | Answer |
Budgeted Production Units | Answer | ||||
Budgeted Lumber to be Used (ft) | Answer | Budgeted Materials to be Used (sq ft) | Answer | ||
Budgeted Ending Inventory | Answer | Budgeted Ending Inventory | Answer | ||
Budgeted Beginning Inventory | Answer | Budgeted Beginning Inventory | Answer | ||
Lumber to be Purchased (ft) | Answer | Materials to be Purchased (sq ft) | Answer |
Take A Seat | ||
Purchasing Budget | ||
For the Month of April, 2020 | ||
Lumber to be Purchased (ft) | Answer | |
Budgeted Lumber Cost (per ft) | Answer | |
Budgeted Lumber Cost | Answer | |
Materials to be Purchased (sq ft) | Answer | |
Budgeted Material Cost (per sq ft) | Answer | |
Budgeted Materials Cost | Answer | |
Total Budgeted Purchase Cost | Answer |