Question: Cost Worksheet Direct Materials Ingredient Estimated Quantity Actual Quantity Unit Cost Total Actual Cost Unsalted Butter 8 Tsp 8 Tsp $0.80 $3.19 Sugar Cup Cup
Cost Worksheet
Direct Materials
| Ingredient | Estimated Quantity | Actual Quantity | Unit Cost | Total Actual Cost |
| Unsalted Butter | 8 Tsp | 8 Tsp | $0.80 | $3.19 |
| Sugar | Cup | Cup | $0.50 | $1.75 |
| Brown Sugar | Cup | Cup | $0.24 | $1.89 |
| Flour | 1 Cup | 1 Cup | $0.17 | $5.98 |
| Vanilla | 1 Tsp | 1 Tsp | $0.81 | $9.77 |
| Salt | Tsp | Tsp | $0.01 | $0.55 |
| Large Egg | 1 Egg | 1 Egg | $0.08 | $0.99 |
| Baking Soda | Tsp | Tsp | $0.01 | $0.55 |
| Oats | 1 Cup | 1 Cup | $0.95 | $1.89 |
| Warm Water | 1 Tsp | 1 Tsp | $0.00 | $0.00 |
| Total Cost of Direct Materials Used | $26.56 |
Direct Labor
| Process Stage | Estimated Time | Actual Time | Hourly Rate | Total Actual Cost |
| Prepping | 20 Min | 20 Min | $10.00 | $3.33 |
| Baking | 10 Min | 10 Min | $10.00 | $1.67 |
| Cooling Time | 30 Min | 30 Min | $8.00 | $4.00 |
| Total Cost of Direct Labor Used | $9.00 |
Manufacturing Overhead
| Overhead Item | Estimated Time | Actual Time | Hourly Rate | Total Actual Cost |
| Rent, Factory (apartment) | 1 Hour | 1 Hour | $5.00 | $5.00 |
| Electricity, Factory (apartment) | 1 Hour | 1 Hour | $6.00 | $6.00 |
| Depreciation - Appliances | 1 Hour | 1 Hour | $0.50 | $0.50 |
| Total Overhead Cost Incurred | $11.50 |
ii) Calculate Cost of Goods Manufactured (Type Calculations to show proof)
Cost of Goods Manufactured= Beginning WIP Inventory+Total Manufacturing Cost - Ending WIP Inventory
iii) Identifying any non-value-added costs.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
