Question
Dell & Company makes and sells computer components. Sales in October, November and December 2019 were $1,600,000, $1,800,000 and $1,400,000 respectively. All sales are on
Dell & Company makes and sells computer components.
Sales in October, November and December 2019 were $1,600,000, $1,800,000 and
$1,400,000 respectively. All sales are on credit. Collections from debtors are as follows: 40% in the month following the sale, 30% in the second month following the sale, and 20% in the third month following the sale. The remaining 10% are uncollectable.
The data below relates to the production and sales of its product for January, February and March 2020:
| January | February | March |
Direct labour hours per unit | 6.0 | 5.5 | 5.5 |
Direct labour hourly rate | $ 9 | $ 10 | $ 10 |
Direct materials cost per unit | $ 15 | $ 16 | $ 16 |
Estimated sales | 15,000 units | 16,000 units | 18,000 units |
Selling price per unit | $ 100 | $ 120 | $ 120 |
Dell expects to have 5,000 units in inventory on 31 December 2019, and has a policy of carrying 25% of the following months projected sales in inventory.
Required:
- Prepare the following budgets for Dell & Company for January and February 2020. Show all workings and calculations:
- Production Budget (in units)
- Direct Labour Budget (in hours)
- Budget (in dollars)
- Sales Budget (in dollars)
- Calculate the budgeted Contribution Margin for January and February 2020. Show all workings and calculations.
- Calculate the budgeted receipts (collections) from debtors for January and February 2020. Show all workings and calculations.
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