Question
I am stuck on question 7 and 8 - Budget Finished goods inventory and cost of goods sold The SmartProduct Corporation manufactures and sells three
I am stuck on question 7 and 8 - Budget Finished goods inventory and cost of goods sold
The SmartProduct Corporation manufactures and sells three products: ExcelWidget, GoodWidget, and FairWidget. In June 2020, SmartProducts Budget Department gathered the following data in order to prepare budgets for 2021:
2021 Projected Sales
Product | Units | Price |
ExcelWidget | 32,000 | $270 |
GoodWidget | 28,000 | $190 |
FairWidget | 65,000 | $145 |
Expected Target Inventories
Product | January 1, 2021 | December 31, 2021 |
ExcelWidget | 24,000 | 27,000 |
GoodWidget | 15,000 | 20,000 |
FairWidget | 17,000 | 14,000 |
The following direct materials are expected to be used in the three products:
|
| Amount Used Per Unit | ||
Direct Material | Unit | ExcelWidget | GoodWidget | FairWidget |
X1 | pound | 6 | 4 | 1 |
X2 | pound | 3 | 2 | 3 |
Projected data for 2021 with respect to direct materials are as follows:
Direct Materials | Expected Purchase Price | Expected Inventories (January 1, 2021) | Target Inventories (December 31, 2021) |
X1 | $16 | 64,000 lb | 51,000 lb |
X2 | $12 | 86,000 lb | 64,000 lb |
Projected direct manufacturing labor requirements and rates for 2021 are as follows:
Product | Hours Per Unit | Rate Per Hour |
ExcelWidget | 3.5 | $14 |
GoodWidget | 3 | $13 |
FairWidget | 2.5 | $9 |
Manufacturing overhead is allocated at the rate of $15 per direct manufacturing labor-hour.
Required: Based on the preceding projections and budget requirements for ExcelWidget, GoodWidget, and FairWidget, prepare the following budgets for SmartProduct for 2021. Show breakups where appropriate.
- Revenues budget (in dollars)
- Production budget (in units)
- Direct Materials purchases budget (in quantities)
- Direct Materials purchases budget (in dollars)
- Manufacturing Direct Labor budget (in dollars)
- Manufacturing Overhead budget (in dollars)
- Budgeted Finished Goods inventory (in dollars)
- Cost of Goods Sold budget (in dollars)
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