- 1 Sales budget Quarter Ending 2021
- Production budget Quarter Ending 2021
- Direct Material (s) budget quarter
- ending 2021
- Direct Labor Budget quarter ending 2021
- Manufacturing Overhead Budget quarter ending 2021
- Actual-Flexible-Planning Income Statement with Variances
- Direct materials price & quantity variances
- Direct labor rate & efficiency variances
- Variable Overhead rate & efficiency variances
- Net Present Value Analysis
- Make or Buy Analysis
General and Administrative Budget: Ending 12-31-2021 Officers Salaries Office Salaries Payroll Tax Indirect Labor Rent Utilities Depreciation Selling & Aministrative Selling & Administrive Fixed Interest Expense Insurance Office Supplies 15,250.00 1,850.00 6,840.00 32,500.00 $ 6,250.00 $ 1,875.00 ? $3 per unit 8,500.00 ? 9,250.00 1,850.00 ta ta Product Standards Standard Quantity or Hours Standard Price or Rate Standard Cost Direct Materials Fabric Metal Gromets Plastic Buckles Velcro 2.75 yards 12 13 1.5 yard ta ta ta ta 3.50 $ 0.50 $ 0.75 $ 0.85 $ 6.25 6.00 21.00 0.75 $ Total Standard Cost Per Unit Of Material $ 34.00 Direct Labor 5.5 hours $ 17.50 $ 81.00 Variable Manufacturing Overhead 4.5 hours $ 3.50 11.25 Total Unit Product Costs $ 126.25 Actual General & Administrative Costs were as follows: Tony discussed the sales with the group. In discussions with potential customers, he realized they were cash strapped themselves. They would gladly take the goods on consignment, but if Great Adventures required a sale, they would need at least 30 days pas the month of sale to pay. Tony didn't want to get into a consignment arrangement, so he agreed to the terms. Things were coming together. The actual products cost data for three months ending 12-31-2021 was as follows: Actual Sales in Units October November December 800 1200 2500 Equipment List: 3 Heavy Duty Sewing Machine 2 Cutting Machines 1 Gromet Fastening Machine 1 Crimping Machine $2,500 per machine $1,500 per machine $ 1,200 per machine $ 800 per machine The machines have a four-year life and no salvage value General and Administrative Budget: Ending 12-31-2021 Officers Salaries Office Salaries Payroll Tax Indirect Labor Rent Utilities Depreciation Selling & Aministrative Selling & Administrive Fixed Interest Expense Insurance Office Supplies $ 18,750.00 $ 3,000.00 $ 8,700.00 $ 37,500.00 $ 6,250.00 $ 1,375.00 ? $3 per unit $ 7,000.00 ? $ 9,000.00 $ 1,250.00 a Andrea looked at the sales figures and started getting a bit nervous. There was a lot of work to do! Its worse than that said Tony. In order for us to maintain a steady flow of sales we need some inventory on hand to meet our lead times. Tony advised Andrea that we would need 10 percent of the following months sales in ending inventory to ensure they did not have a stock out. Tony knew that delays in order would have a detrimental effect on the new company's reputation as being unreliable. I see said Suzie; in that case we better build an ending inventory into our raw material budgets as well. We would need a 20% ending inventory based on the next months cost of goods sold. a Tony spent the next week crunching the numbers, looking at market demographics and where he believed their catchment area would be and determine that he could sell the pack at 1.50 percent above product costs. He put together a three-month sales forecast for 2021 as follows: Budgeted Sales in Units October November December 1000 1500 1500 a Tony also indicated he expects that sales will grow at a modest 5% through 2022 Product Standards Standard Quantity Standard or Hours Price or Rate Standard Cost Direct Materials $ $ 6.00 Fabric Metal Gromets Plastic Buckles Velcro 2.5 yards 12 14 1 yard 2.50 $ 6.25 0.50 $ 1.50 $ 21.00 0.75 $ 0.75 $ $ Total Standard Cost Per Unit Of Material $ 34.00 Direct Labor 4.5 hours $ 18.00 $ 81.00 Variable Manufacturing Overhead 4.5 hours $ 2.50 11.25 Total Unit Product Costs $ 126.25 General and Administrative Budget: Ending 12-31-2021 Officers Salaries Office Salaries Payroll Tax Indirect Labor Rent Utilities Depreciation Selling & Aministrative Selling & Administrive Fixed Interest Expense Insurance Office Supplies 15,250.00 1,850.00 6,840.00 32,500.00 $ 6,250.00 $ 1,875.00 ? $3 per unit 8,500.00 ? 9,250.00 1,850.00 ta ta Product Standards Standard Quantity or Hours Standard Price or Rate Standard Cost Direct Materials Fabric Metal Gromets Plastic Buckles Velcro 2.75 yards 12 13 1.5 yard ta ta ta ta 3.50 $ 0.50 $ 0.75 $ 0.85 $ 6.25 6.00 21.00 0.75 $ Total Standard Cost Per Unit Of Material $ 34.00 Direct Labor 5.5 hours $ 17.50 $ 81.00 Variable Manufacturing Overhead 4.5 hours $ 3.50 11.25 Total Unit Product Costs $ 126.25 Actual General & Administrative Costs were as follows: Tony discussed the sales with the group. In discussions with potential customers, he realized they were cash strapped themselves. They would gladly take the goods on consignment, but if Great Adventures required a sale, they would need at least 30 days pas the month of sale to pay. Tony didn't want to get into a consignment arrangement, so he agreed to the terms. Things were coming together. The actual products cost data for three months ending 12-31-2021 was as follows: Actual Sales in Units October November December 800 1200 2500 Equipment List: 3 Heavy Duty Sewing Machine 2 Cutting Machines 1 Gromet Fastening Machine 1 Crimping Machine $2,500 per machine $1,500 per machine $ 1,200 per machine $ 800 per machine The machines have a four-year life and no salvage value General and Administrative Budget: Ending 12-31-2021 Officers Salaries Office Salaries Payroll Tax Indirect Labor Rent Utilities Depreciation Selling & Aministrative Selling & Administrive Fixed Interest Expense Insurance Office Supplies $ 18,750.00 $ 3,000.00 $ 8,700.00 $ 37,500.00 $ 6,250.00 $ 1,375.00 ? $3 per unit $ 7,000.00 ? $ 9,000.00 $ 1,250.00 a Andrea looked at the sales figures and started getting a bit nervous. There was a lot of work to do! Its worse than that said Tony. In order for us to maintain a steady flow of sales we need some inventory on hand to meet our lead times. Tony advised Andrea that we would need 10 percent of the following months sales in ending inventory to ensure they did not have a stock out. Tony knew that delays in order would have a detrimental effect on the new company's reputation as being unreliable. I see said Suzie; in that case we better build an ending inventory into our raw material budgets as well. We would need a 20% ending inventory based on the next months cost of goods sold. a Tony spent the next week crunching the numbers, looking at market demographics and where he believed their catchment area would be and determine that he could sell the pack at 1.50 percent above product costs. He put together a three-month sales forecast for 2021 as follows: Budgeted Sales in Units October November December 1000 1500 1500 a Tony also indicated he expects that sales will grow at a modest 5% through 2022 Product Standards Standard Quantity Standard or Hours Price or Rate Standard Cost Direct Materials $ $ 6.00 Fabric Metal Gromets Plastic Buckles Velcro 2.5 yards 12 14 1 yard 2.50 $ 6.25 0.50 $ 1.50 $ 21.00 0.75 $ 0.75 $ $ Total Standard Cost Per Unit Of Material $ 34.00 Direct Labor 4.5 hours $ 18.00 $ 81.00 Variable Manufacturing Overhead 4.5 hours $ 2.50 11.25 Total Unit Product Costs $ 126.25